C# UCVerify类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中UCVerify类的典型用法代码示例。如果您正苦于以下问题：C# UCVerify类的具体用法？C# UCVerify怎么用？C# UCVerify使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

UCVerify类属于命名空间，在下文中一共展示了UCVerify类的19个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: UCAccountVerificationAdd_VerifyEvent

        //审核
        void UCAccountVerificationAdd_VerifyEvent(object sender, EventArgs e)
        {
            if (!MessageBoxEx.ShowQuestion("确认要审核当前单据！"))
            {
                return;
            }
            UCVerify frmVerify = new UCVerify();
            if (frmVerify.ShowDialog() == DialogResult.OK)
            {
                SysSQLString sql = new SysSQLString();
                sql.cmdType = CommandType.Text;
                sql.sqlString = string.Format("update tb_account_verification set order_status='{0}',Verify_advice='{3}' where account_verification_id='{1}' and order_status='{2}';",
                    ((int)frmVerify.auditStatus), id, (int)DataSources.EnumAuditStatus.SUBMIT, frmVerify.Content);
                sql.Param = new Dictionary<string, string>();
                List<SysSQLString> listSql = new List<SysSQLString>();
                listSql.Add(sql);
                //如果是审核不通过，则将没有提交或审核状态的单据设为正常
                if (frmVerify.auditStatus == DataSources.EnumAuditStatus.NOTAUDIT)
                {
                    SysSQLString receivableSql = new SysSQLString();
                    receivableSql.cmdType = CommandType.Text;
                    receivableSql.sqlString = string.Format(@"update tb_parts_sale_billing set [email protected]_occupy where where sale_billing_id in (select order_id from tb_verificationn_documents where account_verification_id='{0}') and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =sale_billing_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=sale_billing_id
);
update tb_maintain_settlement_info set [email protected]_occupy where where settlement_id in (select order_id from tb_verificationn_documents where account_verification_id='{0}') and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =settlement_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=settlement_id
);
update tb_maintain_three_guaranty_settlement_yt set [email protected]_occupy where where st_id in (select order_id from tb_verificationn_documents where account_verification_id='{0}') and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =st_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=st_id
);
update tb_parts_purchase_billing set [email protected]_occupy where where purchase_billing_id in (select order_id from tb_verificationn_documents where account_verification_id='{0}') and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =purchase_billing_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=purchase_billing_id
);", id);
                    receivableSql.Param = new Dictionary<string, string>();
                    receivableSql.Param.Add("is_occupy", ((int)DataSources.EnumImportStaus.OPEN).ToString());
                    receivableSql.Param.Add("@id", id);
                }
                if (DBHelper.BatchExeSQLStringMultiByTrans("审核往来核销", listSql))
                {
                    MessageBoxEx.Show("审核成功！");
                    BindData();
                }
                else
                {
                    MessageBoxEx.Show("审核失败！");
                }
            }
        }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:65，代码来源:UCAccountVerificationAdd.cs

示例2: UCPurchasePlanOrderManager_VerifyEvent

        /// <summary>
        /// 审核事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void UCPurchasePlanOrderManager_VerifyEvent(object sender, EventArgs e)
        {
            List<string> listField = GetVerifyRecord();
            if (listField.Count == 0)
            {
                MessageBoxEx.Show("请选择要审核的数据!");
                return;
            }
            UCVerify UcVerify= new UCVerify();
            if (UcVerify.ShowDialog() == DialogResult.OK)
            {
                string Content = UcVerify.Content;
                SYSModel.DataSources.EnumAuditStatus UcVerifyStatus = UcVerify.auditStatus;

                Dictionary<string, string> purchasePlanField = new Dictionary<string, string>();
                if (UcVerifyStatus == DataSources.EnumAuditStatus.AUDIT)
                {
                    //获取采购计划单状态(已审核)
                    purchasePlanField.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.AUDIT).ToString());
                    purchasePlanField.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.AUDIT, true));

                    //生成预支付单
                }
                else if (UcVerifyStatus == DataSources.EnumAuditStatus.NOTAUDIT)
                {
                    //获取采购计划单状态(审核不通过)
                    purchasePlanField.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString());
                    purchasePlanField.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.NOTAUDIT, true));
                }
                bool flag = DBHelper.BatchUpdateDataByIn("批量审核采购计划单表", "tb_parts_purchase_plan", purchasePlanField, "plan_id", listField.ToArray());
                if (flag)
                {
                    BindgvPurchasePlanOrderList();
                    MessageBoxEx.Show("操作成功！");
                }
                else
                {
                    MessageBoxEx.Show("操作失败！");
                }
            }
        }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:46，代码来源:UCPurchasePlanOrderManager.cs

示例3: UCRequisitionManager_VerifyEvent

        /// <summary>
        /// 审核操作
        /// </summary>
        /// <param name="send"></param>
        /// <param name="e"></param>
        private void UCRequisitionManager_VerifyEvent(object send, EventArgs e)
        {
            try
            {
                List<string> listField = GetVerifyRecord();//获取需要核实的记录行
                if (listField.Count == 0 && gvAllotBillList.SelectedRows.Count==0)
                {
                    MessageBoxEx.Show("请选择符合审核条件的单据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

                UCVerify UcVerify = new UCVerify();
                UcVerify.ShowDialog();
                string Content = UcVerify.Content;
                DataSources.EnumAuditStatus UcVerifyStatus = UcVerify.auditStatus;//获取审核状态

                Dictionary<string, string> AllocBillField = new Dictionary<string, string>();
                if (UcVerifyStatus == DataSources.EnumAuditStatus.AUDIT)
                {
                    //获取调拨单单状态(已审核)
                    AllocBillField.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.AUDIT).ToString());
                    AllocBillField.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.AUDIT, true));
                }
                else if (UcVerifyStatus == DataSources.EnumAuditStatus.NOTAUDIT)
                {
                    //获取调拨单单状态(审核不通过)
                    AllocBillField.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString());
                    AllocBillField.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.NOTAUDIT, true));
                }
                bool flag = DBHelper.BatchUpdateDataByIn(AllotVerifyLogMsg, AllotBillTable, AllocBillField, AllotBillID, listField.ToArray());//批量审核获取的调拨单记录
                if (flag)
                {
                    MessageBoxEx.Show("审核成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    long StartDate = Common.LocalDateTimeToUtcLong(Convert.ToDateTime(DateTime.Now.AddMonths(-6).ToShortDateString()));//获取当前日期的半年前的日期
                    long EndDate = Common.LocalDateTimeToUtcLong(Convert.ToDateTime(DateTime.Now.ToShortDateString()));//获取当前日期
                    string DefaultWhere = " enable_flag=1 and order_status_name='已审核通过' and BillTb.order_date between  " + StartDate + " and " + EndDate;//默认查询条件
                    GetAllotBillList(DefaultWhere);//刷新调拨单列表

                }
                else
                {
                    MessageBoxEx.Show("审核失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            catch (Exception ex)
            {
                MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
            }
        }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:54，代码来源:UCRequisitionManager.cs

示例4: UCYTManager_VerifyEvent

        void UCYTManager_VerifyEvent(object sender, EventArgs e)
        {
            List<string> listField = GetVerifyRecord();
            if (listField.Count == 0)
            {
                MessageBoxEx.Show("请选择要审核的数据!");
                return;
            }
            UCVerify UcVerify = new UCVerify();
            UcVerify.ShowDialog();
            string Content = UcVerify.Content;
            SYSModel.DataSources.EnumAuditStatus UcVerifyStatus = UcVerify.auditStatus;

            Dictionary<string, string> purchasePlanField = new Dictionary<string, string>();
            if (UcVerifyStatus == DataSources.EnumAuditStatus.AUDIT)
            {
                //获取宇通采购订单状态(已审核)
                purchasePlanField.Add("apply_date_time", Common.LocalDateTimeToUtcLong(DateTime.Now).ToString());
                purchasePlanField.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.AUDIT).ToString());
                purchasePlanField.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.AUDIT, true));
            }
            else if (UcVerifyStatus == DataSources.EnumAuditStatus.NOTAUDIT)
            {
                //获取宇通采购订单状态(审核不通过)
                purchasePlanField.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString());
                purchasePlanField.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.NOTAUDIT, true));
            }
            bool flag = DBHelper.BatchUpdateDataByIn("批量审核宇通采购订单表", "tb_parts_purchase_order_2", purchasePlanField, "purchase_order_yt_id", listField.ToArray());
            if (flag)
            {
                if (UcVerifyStatus == DataSources.EnumAuditStatus.AUDIT)
                {
                    DealPurascherToYT(listField);
                }
                BindgvYTPurchaseOrderList();
                MessageBoxEx.Show("操作成功！");
            }
            else
            {
                MessageBoxEx.Show("操作失败！");
            }
        }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:42，代码来源:UCYTManager.cs

示例5: UCAllocationBillManager_VerifyEvent

        /// <summary>
        /// 审核操作
        /// </summary>
        /// <param name="send"></param>
        /// <param name="e"></param>
        private void UCAllocationBillManager_VerifyEvent(object send, EventArgs e)
        {
            try
            {

                Dictionary<string,long> OrderIDDateDic = GetVerifyRecord();//获取需要核实的记录行
                if (InoutIDValuelist.Count == 0)
                {
                    MessageBoxEx.Show("请选择符合审核条件的单据!","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
                    return;
                }

                UCVerify UcVerify = new UCVerify();
                UcVerify.ShowDialog();
                string Content = UcVerify.Content;
                DataSources.EnumAuditStatus UcVerifyStatus = UcVerify.auditStatus;//获取审核状态

                Dictionary<string, string> AllocBillField = new Dictionary<string, string>();
                if (UcVerifyStatus == DataSources.EnumAuditStatus.AUDIT)
                {
                    //获取出入库单状态(已审核)
                    AllocBillField.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.AUDIT).ToString());
                    AllocBillField.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.AUDIT, true));
                }
                else if (UcVerifyStatus == DataSources.EnumAuditStatus.NOTAUDIT)
                {
                    //获取出入库单状态(审核不通过)
                    AllocBillField.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString());
                    AllocBillField.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.NOTAUDIT, true));
                }
                bool flag = DBHelper.BatchUpdateDataByIn(InOutVerifyLogMsg, InOutTable, AllocBillField, InOutID, InoutIDValuelist.ToArray());//批量审核获取的出入库单记录
                if (flag)
                {
                    CommonFuncCall.StatisticStock(OrderIDDateDic, InOutID, PartCount, InOutPartTable);//同步更新实际库存
                    MessageBoxEx.Show("审核成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    string QueryWhere = " order_status_name='已审核通过' ";
                    GetInOutBillList(QueryWhere);//刷新出入库单列表
                    
                }
                else
                {
                    MessageBoxEx.Show("审核失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            catch (Exception ex)
            {
                MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
            }
        }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:54，代码来源:UCAllocationBillManager.cs

示例6: UCStockCheckManager_VerifyEvent

        /// <summary>
        /// 审核其它收货单
        /// </summary>
        /// <param name="send"></param>
        /// <param name="e"></param>
        private void UCStockCheckManager_VerifyEvent(object send, EventArgs e)
        {
            try
            {
                List<string> listField = GetVerifyRecord();//获取需要核实的记录行

                if (listField.Count == 0 && gvCheckBillList.SelectedRows.Count == 0)
                {
                    MessageBoxEx.Show("请选择符合审核条件的单据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

                UCVerify UcVerify = new UCVerify();
                UcVerify.ShowDialog();
                string Content = UcVerify.Content;
                DataSources.EnumAuditStatus UcVerifyStatus = UcVerify.auditStatus;//获取审核状态

                Dictionary<string, string> CheckBillField = new Dictionary<string, string>();
                if (UcVerifyStatus == DataSources.EnumAuditStatus.AUDIT)
                {
                    //获取其它收货单状态(已审核)
                    CheckBillField.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.AUDIT).ToString());
                    CheckBillField.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.AUDIT, true));
                }
                else if (UcVerifyStatus == DataSources.EnumAuditStatus.NOTAUDIT)
                {
                    //获取其它收货单状态(审核不通过)
                    CheckBillField.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString());
                    CheckBillField.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.NOTAUDIT, true));
                }
                bool flag = DBHelper.BatchUpdateDataByIn(CheckVerifyLogMsg, CheckTable, CheckBillField, CheckID, listField.ToArray());//批量审核获取的盘点单记录
                if (flag)
                {
                    MessageBoxEx.Show("审核成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    string QueryWhere = " order_status_name='已审核通过' ";
                    GetCheckBillList(QueryWhere);//刷新盘点单列表

                }
                else
                {
                    MessageBoxEx.Show("审核失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            catch (Exception ex)
            {
                MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
            }
        }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:53，代码来源:UCStockCheckManager.cs

示例7: VerifyData

        //审核
        void VerifyData()
        {
            string files = string.Empty;
            foreach (DataGridViewRow dgvr in dgvVerification.Rows)
            {
                if (Convert.ToBoolean(dgvr.Cells[colChk.Name].EditedFormattedValue))
                {
                    files += string.Format("'{0}',", dgvr.Cells[colAccountVerificationID.Name].Value);
                }
            }
            if (files.Length == 0)
            {
                MessageBoxEx.Show("请选择要审核的数据！");
                return;
            }
            UCVerify frmVerify = new UCVerify();
            if (frmVerify.ShowDialog() == DialogResult.OK)
            {
                files = files.TrimEnd(',');
                SysSQLString sql = new SysSQLString();
                sql.cmdType = CommandType.Text;
                sql.sqlString = string.Format("update tb_account_verification set order_status='{0}',Verify_advice='{3}' where account_verification_id in ({1}) and order_status='{2}';",
                    ((int)frmVerify.auditStatus), files, (int)DataSources.EnumAuditStatus.SUBMIT, frmVerify.Content);
                sql.Param = new Dictionary<string, string>();
                List<SysSQLString> listSql = new List<SysSQLString>();
                listSql.Add(sql);
                //如果是审核不通过，则将没有提交或审核状态的单据设为正常
                if (frmVerify.auditStatus == DataSources.EnumAuditStatus.NOTAUDIT)
                {
                    SysSQLString receivableSql = new SysSQLString();
                    receivableSql.cmdType = CommandType.Text;
                    receivableSql.sqlString = string.Format(@"update tb_parts_sale_billing set [email protected]_occupy where where sale_billing_id in (select order_id from tb_verificationn_documents where account_verification_id in ({0})) and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =sale_billing_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=sale_billing_id
);
update tb_maintain_settlement_info set [email protected]_occupy where where settlement_id in (select order_id from tb_verificationn_documents where account_verification_id in ({0})) and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =settlement_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=settlement_id
);
update tb_maintain_three_guaranty_settlement_yt set [email protected]_occupy where where st_id in (select order_id from tb_verificationn_documents where account_verification_id in ({0})) and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =st_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=st_id
);
update tb_parts_purchase_billing set [email protected]_occupy where where purchase_billing_id in (select order_id from tb_verificationn_documents where account_verification_id in ({0})) and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =purchase_billing_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=purchase_billing_id
);", files);
                    receivableSql.Param = new Dictionary<string, string>();
                    receivableSql.Param.Add("is_occupy", ((int)DataSources.EnumImportStaus.OPEN).ToString());
                    receivableSql.Param.Add("@id", files);
                }
                if (DBHelper.BatchExeSQLStringMultiByTrans("审核往来核销", listSql))
                {
                    MessageBoxEx.Show("审核成功！");
                    BindData();
                }
                else
                {
                    MessageBoxEx.Show("审核失败！");
                }
            }
        }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:75，代码来源:UCAccountVerificationManage.cs

示例8: UCReceiveView_VerifyEvent

 void UCReceiveView_VerifyEvent(object sender, EventArgs e)
 {
     if (MessageBoxEx.Show("确认要审核吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
     {
         return;
     }
     verify = new UCVerify(); 
     if (verify.ShowDialog() == DialogResult.OK)
     {
         List<SQLObj> listSql = new List<SQLObj>();
         SQLObj obj = new SQLObj();
         obj.cmdType = CommandType.Text;
         Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
         dicParam.Add("maintain_id", new ParamObj("maintain_id", strReceiveId, SysDbType.VarChar, 40));//单据ID
         dicParam.Add("info_status", new ParamObj("info_status", verify.auditStatus, SysDbType.VarChar, 40));//单据状态
         dicParam.Add("Verify_advice", new ParamObj("Verify_advice", verify.Content, SysDbType.VarChar, 200));//审核意见
         dicParam.Add("update_by", new ParamObj("update_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40));//修改人Id
         dicParam.Add("update_name", new ParamObj("update_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40));//修改人姓名
         dicParam.Add("update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt));//修改时间               
         obj.sqlString = "update tb_maintain_info set [email protected]_status,[email protected]_advice,[email protected]_by,[email protected]_name,[email protected]_time where [email protected]_id";
         obj.Param = dicParam;
         listSql.Add(obj);
         UpdateMaintainInfo(listSql, strBeforOrderId, strBeforSource, "0");
         if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为审核", listSql))
         {
             string strMsg = string.Empty;
             if (verify.auditStatus == DataSources.EnumAuditStatus.AUDIT)
             {
                 strMsg = "成功";
             }
             else
             {
                 strMsg = "不通过";
             }
             MessageBoxEx.Show("审核" + strMsg + "！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);                 
             uc.BindPageData();
             deleteMenuByTag(this.Tag.ToString(), uc.Name);
         }
     }
 }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:40，代码来源:UCReceiveView.cs

示例9: UCRepairRescueView_VerifyEvent

 void UCRepairRescueView_VerifyEvent(object sender, EventArgs e)
 {
     if (MessageBoxEx.Show("确认要审核吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
     {
         return;
     }
     verify = new UCVerify();
     if (verify.ShowDialog() == DialogResult.OK)
     {
         List<SQLObj> listSql = new List<SQLObj>();
         SQLObj obj = new SQLObj();
         obj.cmdType = CommandType.Text;
         Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
         dicParam.Add("rescue_id", new ParamObj("rescue_id", strRescueId, SysDbType.VarChar, 40));//单据ID
         dicParam.Add("document_status", new ParamObj("document_status", verify.auditStatus, SysDbType.VarChar, 40));//单据状态
         dicParam.Add("Verify_advice", new ParamObj("Verify_advice", verify.Content, SysDbType.VarChar, 200));//审核意见
         dicParam.Add("update_by", new ParamObj("update_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40));//修改人Id
         dicParam.Add("update_name", new ParamObj("update_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40));//修改人姓名
         dicParam.Add("update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt));//修改时间               
         obj.sqlString = "update tb_maintain_rescue_info set [email protected]_status,[email protected]_advice,[email protected]_by,[email protected]_name,[email protected]_time where [email protected]_id";
         obj.Param = dicParam;
         listSql.Add(obj);
         if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为审核", listSql))
         {
             MessageBoxEx.Show("审核成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
             uc.BindPageData();
             deleteMenuByTag(this.Tag.ToString(), "UCRepairRescueView");
         }
     }
 }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:30，代码来源:UCRepairRescueView.cs

示例10: VerifyData

        //审核
        void VerifyData()
        {
            string files = string.Empty;
            foreach (DataGridViewRow dgvr in dgvBillReceivable.Rows)
            {
                if (Convert.ToBoolean(dgvr.Cells[colCheck.Name].EditedFormattedValue))
                {
                    files += string.Format("'{0}',", dgvr.Cells[colPayableSingleID.Name].Value);
                }
            }
            if (files.Length == 0)
            {
                MessageBoxEx.Show("请选择要审核的数据！");
                return;
            }
            UCVerify frmVerify = new UCVerify();
            if (frmVerify.ShowDialog() == DialogResult.OK)
            {
                files = files.TrimEnd(',');
                SysSQLString sql = new SysSQLString();
                sql.cmdType = CommandType.Text;
                sql.sqlString = string.Format("update tb_bill_receivable set order_status='{0}',Verify_advice='{1}' where payable_single_id in ({2}) and order_status='{3}';",
                    (int)frmVerify.auditStatus, frmVerify.Content, files, (int)DataSources.EnumAuditStatus.SUBMIT);
                sql.Param = new Dictionary<string, string>();
                List<SysSQLString> listSql = new List<SysSQLString>();
                listSql.Add(sql);
                //如果是审核不通过，则将没有提交或审核状态的单据设为正常
                if (frmVerify.auditStatus == DataSources.EnumAuditStatus.NOTAUDIT)
                {
                    #region 将没有提交或审核状态的单据设为正常
                    if (orderType == DataSources.EnumOrderType.RECEIVABLE)
                    {
                        SysSQLString receivableSql = new SysSQLString();
                        receivableSql.cmdType = CommandType.Text;
                        receivableSql.sqlString = string.Format(@"update tb_parts_sale_billing set [email protected]_lock where sale_billing_id in (select documents_id from tb_balance_documents where order_id in ({0})) and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =sale_billing_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=sale_billing_id
);
update tb_parts_sale_order set [email protected]_lock where sale_order_id in (select documents_id from tb_balance_documents where order_id in ({0})) and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =sale_order_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=sale_order_id
);
update tb_maintain_settlement_info set [email protected]_lock where settlement_id in (select documents_id from tb_balance_documents where order_id in ({0})) and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =settlement_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=settlement_id
);
update tb_maintain_three_guaranty_settlement set [email protected]_lock where st_id in (select documents_id from tb_balance_documents where order_id in ({0})) and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =st_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=st_id
);", files);
                        receivableSql.Param = new Dictionary<string, string>();
                        receivableSql.Param.Add("is_lock", ((int)DataSources.EnumImportStaus.OPEN).ToString());
                        //receivableSql.Param.Add("@id", files);
                        listSql.Add(receivableSql);
                    }
                    else
                    {
                        SysSQLString purchaseBillingSql = new SysSQLString();
                        purchaseBillingSql.cmdType = CommandType.Text;
                        purchaseBillingSql.sqlString = string.Format(@"update tb_parts_purchase_billing set [email protected]_lock where purchase_billing_id in (select documents_id from tb_balance_documents where order_id in ({0})) and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =purchase_billing_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=purchase_billing_id
);
                                                  update tb_parts_purchase_order set [email protected]_lock where order_id in (select documents_id from tb_balance_documents where order_id in ({0})) and  exists (
select a.documents_id from tb_balance_documents a inner join tb_bill_receivable b on a.order_id=b.payable_single_id
where order_status in ('1','2') and a.documents_id =order_id
union all
select b.order_id from tb_account_verification a inner join tb_verificationn_documents b on a.account_verification_id=b.account_verification_id
where a.order_status in ('1','2') and b.order_id=order_id
);  ", files);
                        purchaseBillingSql.Param = new Dictionary<string, string>();
                        purchaseBillingSql.Param.Add("is_lock", ((int)DataSources.EnumImportStaus.OPEN).ToString());
                        //purchaseBillingSql.Param.Add("@id", files);
                        listSql.Add(purchaseBillingSql);
                    }
                    #endregion
                    //审核失败需重新计算已结算/预收付金额
                    foreach (DataGridViewRow dgvr in dgvBillReceivable.Rows)
                    {
                        if (Convert.ToBoolean(dgvr.Cells[colCheck.Name].EditedFormattedValue))
                        {
                            int strOrderType = Convert.ToInt32(dgvr.Cells[colOrderType.Name].Tag);
                            string order_id = dgvr.Cells[colPayableSingleID.Name].Value.ToString();
                            //如果是应收付,则计算已结算金额
//.........这里部分代码省略.........

开发者ID:caocf，项目名称:workspace-kepler，代码行数:101，代码来源:UCReceivableManage.cs

示例11: UCFetchMaterialManager_VerifyEvent

 void UCFetchMaterialManager_VerifyEvent(object sender, EventArgs e)
 {
     List<string> listField = new List<string>();
     foreach (DataGridViewRow dr in dgvRData.Rows)
     {
         object isCheck = dr.Cells["colCheck"].EditedFormattedValue;
         if (isCheck != null && (bool)isCheck)
         {
             listField.Add(dr.Cells["fetch_id"].Value.ToString());
         }
     }
     if (listField.Count <= 0)
     {
         MessageBoxEx.Show("请选择需要审核的记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     if (MessageBoxEx.Show("确认要审核吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
     {
         return;
     }
     Dictionary<string, long> OrderIDDateDic = new Dictionary<string, long>();//获取需要核实的记录行
     verify = new UCVerify();
     if (verify.ShowDialog() == DialogResult.OK)
     {
         List<SQLObj> listSql = new List<SQLObj>();
         foreach (DataGridViewRow dr in dgvRData.Rows)
         {
             object isCheck = dr.Cells["colCheck"].EditedFormattedValue;
             if (isCheck != null && (bool)isCheck)
             {
                 SQLObj obj = new SQLObj();
                 obj.cmdType = CommandType.Text;
                 Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
                 dicParam.Add("fetch_id", new ParamObj("fetch_id", dr.Cells["fetch_id"].Value, SysDbType.VarChar, 40));//单据ID
                 dicParam.Add("info_status", new ParamObj("info_status", verify.auditStatus, SysDbType.VarChar, 40));//单据状态
                 dicParam.Add("Verify_advice", new ParamObj("Verify_advice", verify.Content, SysDbType.VarChar, 200));//审核意见
                 dicParam.Add("update_by", new ParamObj("update_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40));//修改人Id
                 dicParam.Add("update_name", new ParamObj("update_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40));//修改人姓名
                 dicParam.Add("update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt));//修改时间               
                 obj.sqlString = "update tb_maintain_fetch_material set [email protected]_status,[email protected]_advice,[email protected]_by,[email protected]_name,[email protected]_time where [email protected]_id";
                 obj.Param = dicParam;
                 listSql.Add(obj);
                 long OrdeDate = (long)dr.Cells["fetch_time"].Value;
                 OrderIDDateDic.Add(dr.Cells["fetch_id"].Value.ToString(), OrdeDate);//添加已审核单据主键ID和单据日期键值对
             }
         }
        
         if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为审核", listSql))
         {                  
             string strMsg = string.Empty;
             if (verify.auditStatus == DataSources.EnumAuditStatus.AUDIT)
             {
                 strMsg = "成功";
                 CommonFuncCall.StatisticStock(GetInoutPart(OrderIDDateDic), "领料单明细数据表");//同步更新实际库存
             }
             else
             {
                 strMsg = "不通过";
             }
             MessageBoxEx.Show("审核" + strMsg + "！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
             BindPageData();
         }
     }
 }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:64，代码来源:UCFetchMaterialManager.cs

示例12: UC_VerifyEvent

 //审核事件
 void UC_VerifyEvent(object sender, EventArgs e)
 {
     bool flag = false;
     foreach (DataGridViewRow dr in dgvRecord.Rows)
     {
         object isCheck = dr.Cells[this.columnCheck.Name].EditedFormattedValue;
         if (isCheck != null && (bool)isCheck)
         {
             flag = true;
             break;
         }
     }
     if (!flag)
     {
         MessageBoxEx.Show("请选择需要审核的记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     if (MessageBoxEx.Show("确认要审核吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
     {
         return;
     }
     verify = new UCVerify();
     if (verify.ShowDialog() == DialogResult.OK)
     {
         List<SQLObj> listSql = new List<SQLObj>();               
         foreach (DataGridViewRow dr in dgvRecord.Rows)
         {
             object isCheck = dr.Cells[this.columnCheck.Name].EditedFormattedValue;
             if (isCheck != null && (bool)isCheck)
             {
                 SQLObj obj = new SQLObj();
                 obj.cmdType = CommandType.Text;
                 Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
                 dicParam.Add("announcement_id", new ParamObj("announcement_id", dr.Cells[this.columnId.Name].Value, SysDbType.VarChar, 40));//单据ID
                 dicParam.Add("status", new ParamObj("status", verify.auditStatus.ToString("d"), SysDbType.VarChar, 40));//单据状态
               
                 obj.sqlString = "update sys_announcement set [email protected] where [email protected]_id";
                 obj.Param = dicParam;
                 listSql.Add(obj);
             }
         }
         if (DBHelper.BatchExeSQLMultiByTrans("", listSql))
         {
             this.BindPageData();
             MessageBoxEx.Show("撤回成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);                    
         }
     }
 }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:49，代码来源:UCBulletinManage.cs

示例13: UCFetchMaterialView_VerifyEvent

 void UCFetchMaterialView_VerifyEvent(object sender, EventArgs e)
 {
     //if (MessageBoxEx.Show("确认要审核吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
     //{
     //    return;
     //}
     verify = new UCVerify();
     if (verify.ShowDialog() == DialogResult.OK)
     {
         Dictionary<string, long> OrderIDDateDic = new Dictionary<string, long>();//获取需要核实的记录行
         List<SQLObj> listSql = new List<SQLObj>();
         SQLObj obj = new SQLObj();
         obj.cmdType = CommandType.Text;
         Dictionary<string, ParamObj> dicParam = new Dictionary<string, ParamObj>();
         dicParam.Add("fetch_id", new ParamObj("fetch_id",strRescueId, SysDbType.VarChar, 40));//单据ID
         dicParam.Add("info_status", new ParamObj("info_status", verify.auditStatus, SysDbType.VarChar, 40));//单据状态
         dicParam.Add("Verify_advice", new ParamObj("Verify_advice", verify.Content, SysDbType.VarChar, 200));//审核意见
         dicParam.Add("update_by", new ParamObj("update_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40));//修改人Id
         dicParam.Add("update_name", new ParamObj("update_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40));//修改人姓名
         dicParam.Add("update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt));//修改时间               
         obj.sqlString = "update tb_maintain_fetch_material set [email protected]_status,[email protected]_advice,[email protected]_by,[email protected]_name,[email protected]_time where [email protected]_id";
         obj.Param = dicParam;
         listSql.Add(obj);
         long OrdeDate = (long)Convert.ToInt64(strFetchTime);
         OrderIDDateDic.Add(strRescueId, OrdeDate);//添加已审核单据主键ID和单据日期键值对
         if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为审核", listSql))
         {
             string strMsg = string.Empty;
             if (verify.auditStatus == DataSources.EnumAuditStatus.AUDIT)
             {
                 strMsg = "成功";
                 CommonFuncCall.StatisticStock(GetInoutPart(OrderIDDateDic), "领料单明细数据表");//同步更新实际库存
             }
             else
             {
                 strMsg = "不通过";
             }
             MessageBoxEx.Show("审核" + strMsg + "！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
             uc.BindPageData();
             deleteMenuByTag(this.Tag.ToString(), uc.Name);
         }
     }
 }

开发者ID:caocf，项目名称:workspace-kepler，代码行数:43，代码来源:UCFetchMaterialView.cs

示例14: UCPurchaseBillManang_VerifyEvent

        /// <summary> 审核事件 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void UCPurchaseBillManang_VerifyEvent(object sender, EventArgs e)
        {
            List<string> listField = GetVerifyRecord();
            if (listField.Count == 0)
            {
                MessageBoxEx.Show("请选择要审核的数据!");

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# UDPPacketBuffer类代码示例发布时间：2022-05-24

C# Types类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19166|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9981|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8321|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8690|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8634|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9650|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8617|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7994|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8648|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7531|2022-11-06

客服电话

电子邮件

C# UCVerify类代码示例

示例1: UCAccountVerificationAdd_VerifyEvent

示例2: UCPurchasePlanOrderManager_VerifyEvent

示例3: UCRequisitionManager_VerifyEvent

示例4: UCYTManager_VerifyEvent

示例5: UCAllocationBillManager_VerifyEvent

示例6: UCStockCheckManager_VerifyEvent

示例7: VerifyData

示例8: UCReceiveView_VerifyEvent

示例9: UCRepairRescueView_VerifyEvent

示例10: VerifyData

示例11: UCFetchMaterialManager_VerifyEvent

示例12: UC_VerifyEvent

示例13: UCFetchMaterialView_VerifyEvent

示例14: UCPurchaseBillManang_VerifyEvent

请发表评论

全部评论

上一篇：

下一篇：

solegalli/feature-selection-for-machine-

tianli/matlab_offscreen: Matlab offscree

win7系统重装系统初始设置的操作方法

これがマストドンだ！使い方からインスタ

CVE-2020-36553

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053

客服电话

电子邮件

C# UCVerify类代码示例

示例1: UCAccountVerificationAdd_VerifyEvent

示例2: UCPurchasePlanOrderManager_VerifyEvent

示例3: UCRequisitionManager_VerifyEvent

示例4: UCYTManager_VerifyEvent

示例5: UCAllocationBillManager_VerifyEvent

示例6: UCStockCheckManager_VerifyEvent

示例7: VerifyData

示例8: UCReceiveView_VerifyEvent

示例9: UCRepairRescueView_VerifyEvent

示例10: VerifyData

示例11: UCFetchMaterialManager_VerifyEvent

示例12: UC_VerifyEvent

示例13: UCFetchMaterialView_VerifyEvent

示例14: UCPurchaseBillManang_VerifyEvent

请发表评论

全部评论

上一篇：

下一篇：

solegalli/feature-selection-for-machine-

tianli/matlab_offscreen: Matlab offscree

win7系统重装系统初始设置的操作方法

これがマストドンだ！ 使い方からインスタ

CVE-2020-36553

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053

これがマストドンだ！使い方からインスタ