Beispiel #1
0
        /// <summary>
        /// 数据保存/提交 方法
        /// </summary>
        /// <param name="HandleTypeName">保存/提交</param>
        private void SaveOrSubmitMethod(string HandleTypeName)
        {
            try
            {
                if (CheckListInfo())
                {
                    gvPartsMsgList.EndEdit();
                    string opName = "盘点单操作";
                    lblorder_num.Text = CommonUtility.GetNewNo(DataSources.EnumProjectType.ReceiptBill);//获取其它收货单编号
                    if (HandleTypeName == submit)
                    {
                        txtorder_status_name.Caption = DataSources.GetDescription(DataSources.EnumAuditStatus.SUBMIT, true);
                    }
                    else if (HandleTypeName == save)
                    {
                        txtorder_status_name.Caption = DataSources.GetDescription(DataSources.EnumAuditStatus.DRAFT, true);
                    }

                    List <SysSQLString> listSql = new List <SysSQLString>();
                    if (status == WindowStatus.Add || status == WindowStatus.Copy)
                    {
                        StockCheckId = Guid.NewGuid().ToString();
                        AddReceiptBillSql(listSql, CheckBillEntity, StockCheckId, HandleTypeName);
                        opName = "新增盘点单";
                        AddOrEditPartsListMsg(listSql, StockCheckId, WindowStatus.Add);
                    }
                    else if (status == WindowStatus.Edit)
                    {
                        EditReceiptBillSql(listSql, CheckBillEntity, StockCheckId, HandleTypeName);
                        opName = "修改盘点单";
                        AddOrEditPartsListMsg(listSql, StockCheckId, WindowStatus.Edit);
                    }


                    if (DBHelper.BatchExeSQLStringMultiByTrans(opName, listSql))
                    {
                        MessageBoxEx.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        string QueryWhere = " enable_flag=1 ";  //获取查询条件
                        UCCheckBM.GetCheckBillList(QueryWhere); //更新单据列表
                        deleteMenuByTag(this.Tag.ToString(), UCCheckBM.Name);
                    }
                    else
                    {
                        MessageBoxEx.Show("保存失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
            }
        }
Beispiel #2
0
        /// <summary>
        /// 数据保存/提交 方法
        /// </summary>
        /// <param name="HandleTypeName">保存/提交</param>
        private void SaveOrSubmitMethod(string HandleTypeName)
        {
            try
            {
                if (CheckListInfo())
                {
                    gvPartsMsgList.EndEdit();
                    string opName = "盘点单操作";
                    lblorder_num.Text = CommonUtility.GetNewNo(DataSources.EnumProjectType.ReceiptBill);//获取其它收货单编号
                    if (HandleTypeName == submit)
                    {
                        txtorder_status_name.Caption = DataSources.GetDescription(DataSources.EnumAuditStatus.SUBMIT, true);
                    }
                    else if (HandleTypeName == save)
                    {
                        txtorder_status_name.Caption = DataSources.GetDescription(DataSources.EnumAuditStatus.DRAFT, true);
                    }

                    List <SysSQLString> listSql = new List <SysSQLString>();
                    if (status == WindowStatus.Add || status == WindowStatus.Copy)
                    {
                        StockCheckId = Guid.NewGuid().ToString();
                        AddReceiptBillSql(listSql, CheckBillEntity, StockCheckId, HandleTypeName);
                        opName = "新增盘点单";
                        AddOrEditPartsListMsg(listSql, StockCheckId, WindowStatus.Add);
                    }
                    else if (status == WindowStatus.Edit)
                    {
                        EditReceiptBillSql(listSql, CheckBillEntity, StockCheckId, HandleTypeName);
                        opName = "修改盘点单";
                        AddOrEditPartsListMsg(listSql, StockCheckId, WindowStatus.Edit);
                    }


                    if (DBHelper.BatchExeSQLStringMultiByTrans(opName, listSql))
                    {
                        if (HandleTypeName == save)
                        {
                            MessageBoxEx.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                        else if (HandleTypeName == submit)
                        {
                            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 CkBillTb.create_time between  " + StartDate + " and " + EndDate;               //默认查询条件
                        UCCheckBM.GetCheckBillList(DefaultWhere);                                                                                //更新单据列表
                        deleteMenuByTag(this.Tag.ToString(), UCCheckBM.Name);
                    }
                    else
                    {
                        if (HandleTypeName == save)
                        {
                            MessageBoxEx.Show("保存失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                        else if (HandleTypeName == submit)
                        {
                            MessageBoxEx.Show("提交失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        }
                        return;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
            }
        }