示例#1
0
        /// <summary>
        /// 根据仓库和商品获取原账面数量
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnAccountNumberOld_Click(object sender, EventArgs e)
        {
            if (DropDownList_WHCode.SelectedIndex == 0 || tbxCargoCode.Text == "")
            {
                ScriptManager.RegisterClientScriptBlock(this.Page, Page.GetType(), "btnAccountNumberOld_Click_WH", "alert('请先选择仓库和商品!');", true);
                return;
            }
            if (tbxCargoCode.Text.Trim() != "")
            {
                using (GoldEntities context = new GoldEntities())
                {
                    Cargos existModel = (from r in context.Cargos where r.CargoCode == tbxCargoCode.Text.Trim() select r).FirstOrDefault();
                    if (existModel == null)
                    {
                        ScriptManager.RegisterClientScriptBlock(this.Page, Page.GetType(), "btnAccountNumberOld_Click_Cargos", "alert('商品编码[" + tbxCargoCode.Text.Trim() + "]在系统中不存在,请先选择正确的商品!');", true);
                        return;
                    }
                }
            }
            string whCode    = DropDownList_WHCode.SelectedItem.Value.ToString();
            string cargoCode = tbxCargoCode.Text.Trim();


            using (GoldEntities context = new GoldEntities())
            {
                //获取之前的余额
                StorePickAccount lastExistModel = null;
                if (ViewState["EditType"].ToString() == "1")//新增
                {
                    lastExistModel = (from r in context.StorePickAccount
                                      orderby r.StockPickAccountID descending
                                      where r.WHCode == whCode && r.CargoCode == cargoCode
                                      select r).FirstOrDefault();
                }
                else //编辑
                {
                    int storePickAccountID = int.Parse(ViewState["EditID"].ToString());
                    lastExistModel = (from r in context.StorePickAccount
                                      orderby r.StockPickAccountID descending
                                      where r.WHCode == whCode && r.CargoCode == cargoCode && r.StockPickAccountID != storePickAccountID
                                      select r).FirstOrDefault();
                }

                if (lastExistModel == null)
                {
                    tbxAccountNumberOld.Text   = "0";
                    tbxFactCheckNumberOld.Text = "0";
                    tbxIsProfitOrLostOld.Text  = "0";
                }
                else
                {
                    tbxAccountNumberOld.Text   = lastExistModel.AccountNumber.ToString();
                    tbxFactCheckNumberOld.Text = lastExistModel.FactCheckNumber.ToString();
                    tbxIsProfitOrLostOld.Text  = lastExistModel.IsProfitOrLoss.ToString();
                }
            }
        }
示例#2
0
 protected void btnSave_Click(object sender, EventArgs e)
 {
     try
     {
         lblSaveMsg.Text = "";
         string outMsg = "";
         if (ViewState["EditType"].ToString() == "1")//新增Insert
         {
             DAL.StorePickAccount newModel = new StorePickAccount();
             bool getNewOK = GetNewModel(out newModel, out outMsg);
             if (getNewOK == false)
             {
                 lblSaveMsg.Text = "新增失败![" + outMsg + "]";
                 return;
             }
             using (GoldEntities context = new GoldEntities())
             {
                 context.StorePickAccount.AddObject(newModel);
                 int AffectRowsCount = context.SaveChanges();
                 lblSaveMsg.Text  = "保存成功";
                 btnSave.Enabled  = false;
                 btnSave.CssClass = "ButtonImageStyleEnableFalse";
             }
         }
         else//更新Update
         {
             using (GoldEntities context = new GoldEntities())
             {
                 int EditID = int.Parse(ViewState["EditID"].ToString());
                 DAL.StorePickAccount updateModel = (from r in context.StorePickAccount where r.StockPickAccountID == EditID select r).FirstOrDefault();
                 bool getUpdateOK = GetUpdateModel(ref updateModel, out outMsg);
                 if (getUpdateOK == false)
                 {
                     lblSaveMsg.Text = "更新失败![" + outMsg + "]";
                     return;
                 }
                 //context.WareHouse.Attach(updateModel);
                 int AffectRowsCount = context.SaveChanges();
                 lblSaveMsg.Text  = "保存成功";
                 btnSave.Enabled  = false;
                 btnSave.CssClass = "ButtonImageStyleEnableFalse";
             }
         }
     }
     catch (Exception ex)
     {
         lblSaveMsg.Text = "更新失败![" + Utility.LogHelper.GetExceptionMsg(ex) + "]";
     }
 }
示例#3
0
        private void LoadInfo(string ItemID)
        {
            using (GoldEntities context = new GoldEntities())
            {
                //绑定存提状态
                List <NameValueModel> ListPickOrStore = Gold.Utility.EnumData.GetEnumsList(typeof(Gold.Utility.EnumData.PickOrStore));
                DropDownList_StorePickType.Items.Clear();
                DropDownList_StorePickType.DataTextField  = "Name";
                DropDownList_StorePickType.DataValueField = "Value";
                DropDownList_StorePickType.DataSource     = ListPickOrStore;
                DropDownList_StorePickType.DataBind();
                DropDownList_StorePickType.Items.Insert(0, new ListItem("", ""));

                //绑定包装
                var result = (from r in context.Packages select new { r.PackageId, r.PackageName }).OrderBy(r => r.PackageName).ToList();
                DropDownList_PackageName.Items.Clear();
                DropDownList_PackageName.DataTextField  = "PackageName";
                DropDownList_PackageName.DataValueField = "PackageId";
                DropDownList_PackageName.DataSource     = result;
                DropDownList_PackageName.DataBind();
                DropDownList_PackageName.Items.Insert(0, new ListItem("", ""));

                //绑定仓库
                var resultWH = (from r in context.WareHouse select new { r.WHCode, r.WHName }).OrderBy(r => r.WHCode).ToList();
                DropDownList_WHCode.Items.Clear();
                DropDownList_WHCode.DataTextField  = "WHName";
                DropDownList_WHCode.DataValueField = "WHCode";
                DropDownList_WHCode.DataSource     = resultWH;
                DropDownList_WHCode.DataBind();
                DropDownList_WHCode.Items.Insert(0, new ListItem("", ""));


                //编辑状态下进入此页面时
                if (ItemID != "-1")
                {
                    tbxCargoCode.Enabled               = false;
                    tbxCargoName.Enabled               = false;
                    btnSelectCargo1.Enabled            = false;
                    btnSelectCargo2.Enabled            = false;
                    DropDownList_WHCode.Enabled        = false;
                    DropDownList_StorePickType.Enabled = false;
                    btnAccountNumberOld.Visible        = false;
                    btnComputeNewNumber.Visible        = false;
                    tbxStorePickNumber.Enabled         = false;
                    tbxAccountNumberNew.Enabled        = false;
                    tbxFactCheckNumberNew.Enabled      = false;
                    tbxIsProfitOrLostNew.Enabled       = false;

                    int ItemIDInt = int.Parse(ItemID);

                    StorePickAccount existModel = (from r in context.StorePickAccount where r.StockPickAccountID == ItemIDInt select r).FirstOrDefault();
                    if (existModel != null)
                    {
                        string storePickType = existModel.StorePickType;
                        DropDownList_StorePickType.SelectedIndex = DropDownList_StorePickType.Items.IndexOf(DropDownList_StorePickType.Items.FindByValue(storePickType));
                        tbxStorePickNumber.Text           = existModel.StorePickNumber.ToString();
                        DropDownList_WHCode.SelectedIndex = DropDownList_WHCode.Items.IndexOf(DropDownList_WHCode.Items.FindByValue(existModel.WHCode));
                        tbxCargoCode.Text = existModel.CargoCode;
                        tbxCargoName.Text = existModel.CargoName;

                        tbxStorePickNumber.Text    = existModel.StorePickNumber.ToString();
                        tbxAccountNumberOld.Text   = existModel.AccountNumber.ToString();
                        tbxFactCheckNumberOld.Text = existModel.FactCheckNumber.ToString();
                        tbxIsProfitOrLostOld.Text  = existModel.IsProfitOrLoss.ToString();
                        //编辑时数据一致
                        tbxAccountNumberNew.Text   = existModel.AccountNumber.ToString();
                        tbxFactCheckNumberNew.Text = existModel.FactCheckNumber.ToString();
                        tbxIsProfitOrLostNew.Text  = existModel.IsProfitOrLoss.ToString();

                        DropDownList_PackageName.SelectedIndex = DropDownList_PackageName.Items.IndexOf(DropDownList_PackageName.Items.FindByText(existModel.PackageName));
                        tbxPackageCount.Text         = existModel.PackageCount.Value.ToString();
                        tbxStandardCountEachBag.Text = existModel.StandardCountEachBag.Value.ToString();
                        tbxPackageNoStart.Text       = existModel.PackageNoStart;
                        tbxPackageNoEnd.Text         = existModel.PackageNoEnd;
                        tbxStoreDescription.Text     = existModel.StoreDescription;
                        tbxRemark.Text         = existModel.Remark;
                        tbxPackageLockNo.Text  = existModel.PackageLockNo;
                        tbxPackageShareNo.Text = existModel.PackageShareNo;
                        tbxRecordDetail.Text   = existModel.RecordDetail;
                        lblRecordTime.Text     = existModel.RecordTime.ToString();
                        lblRecordMonth.Text    = existModel.RecordMonth;
                    }
                }
            }
        }
示例#4
0
        /// <summary>
        /// 根据界面数据填充更新的对象
        /// </summary>
        /// <param name="updateModel"></param>
        /// <param name="msg"></param>
        /// <returns></returns>
        private bool GetUpdateModel(ref StorePickAccount updateModel, out string msg)
        {
            msg = "";

            try
            {
                //updateModel.RecordTime = DateTime.Now;
                //updateModel.RecordMonth = DateTime.Now.ToString("yyyy-MM");
                updateModel.Remark += DateTime.Now.ToString("yyyy-MM-dd") + "编辑1次 ";

                if (DropDownList_WHCode.SelectedIndex == 0 || DropDownList_StorePickType.SelectedIndex == 0)
                {
                    msg = "仓库和存提类型不能为空,请选择!";
                    return(false);
                }
                updateModel.WHCode        = DropDownList_WHCode.SelectedItem.Value;
                updateModel.StorePickType = DropDownList_StorePickType.SelectedItem.Value;

                string cargoCode = tbxCargoCode.Text.Trim();
                using (DAL.GoldEntities context = new GoldEntities())
                {
                    Cargos cargoExist = context.Cargos.Where(r => r.CargoCode == cargoCode).FirstOrDefault <Cargos>();
                    if (cargoExist == null)
                    {
                        msg = "商品编码错误,请重新选择商品编码";
                        return(false);
                    }
                    else
                    {
                        updateModel.CargoCode   = cargoExist.CargoCode;
                        updateModel.CargoName   = cargoExist.CargoName;
                        updateModel.CargoModel  = cargoExist.CargoModel;
                        updateModel.CargoSpec   = cargoExist.CargoSpec;
                        updateModel.CargoUnits  = cargoExist.CargoUnits;
                        updateModel.ReleaseYear = cargoExist.ProduceYear;
                    }
                }

                double AccountNumber = 0, FactCheckNumber = 0, StorePickNumber = 0;
                int    IsProfitOrLoss = 0, PackageCount = 0, StandardCountEachBag = 0;

                double.TryParse(tbxStorePickNumber.Text.Trim(), out StorePickNumber);
                double.TryParse(tbxAccountNumberNew.Text.Trim(), out AccountNumber);
                double.TryParse(tbxFactCheckNumberNew.Text.Trim(), out FactCheckNumber);
                int.TryParse(tbxIsProfitOrLostNew.Text.Trim(), out IsProfitOrLoss);
                int.TryParse(tbxPackageCount.Text.Trim(), out PackageCount);
                int.TryParse(tbxStandardCountEachBag.Text.Trim(), out StandardCountEachBag);

                updateModel.StorePickNumber = StorePickNumber;
                updateModel.AccountNumber   = AccountNumber;
                updateModel.FactCheckNumber = FactCheckNumber;
                updateModel.IsProfitOrLoss  = IsProfitOrLoss;

                if (DropDownList_PackageName.SelectedIndex != 0)
                {
                    updateModel.PackageId   = int.Parse(DropDownList_PackageName.SelectedItem.Value.ToString());
                    updateModel.PackageName = DropDownList_PackageName.SelectedItem.Text;
                }
                else
                {
                    updateModel.PackageId   = 0;
                    updateModel.PackageName = "";
                }

                updateModel.PackageCount         = PackageCount;
                updateModel.StandardCountEachBag = StandardCountEachBag;
                updateModel.PackageNoStart       = tbxPackageNoStart.Text;
                updateModel.PackageNoEnd         = tbxPackageNoEnd.Text;
                updateModel.StoreDescription     = tbxStoreDescription.Text;
                updateModel.Remark         = tbxRemark.Text;
                updateModel.PackageLockNo  = tbxPackageLockNo.Text;
                updateModel.PackageShareNo = tbxPackageShareNo.Text;
                updateModel.RecordDetail   = tbxRecordDetail.Text;
                updateModel.BadRate        = tbxBadRate.Text;

                return(true);
            }
            catch (Exception ex)
            {
                msg = ex.Message.ToString();
                return(false);
            }
        }