protected void Grid1_RowDataBound(object sender, GridRowEventArgs e) { LHStockIn item = e.DataItem as LHStockIn; if (item != null) { if (item.FFlag == 0) { for (int i = 0; i < e.Values.Length; i++) { if (!e.Values[i].ToString().Contains("#@TPL@")) { e.Values[i] = string.Format("<span class=\"{0}\">{1}</span>", "colorred", e.Values[i].ToString().Contains("#@TPL@") ? "已作废" : e.Values[i]); } } } IQueryable <LHStockInDetails> stockInDetails = new StockInDetailsService().Where(p => p.KeyId == item.KeyId && p.FMemo != ""); IQueryable <string> fmeno = from x in stockInDetails select x.FMemo; if (!string.IsNullOrWhiteSpace(item.FMemo)) { e.Values[15] = item.FMemo + "," + string.Join(",", fmeno.ToList()); } else { e.Values[15] = string.Join(",", fmeno.ToList()); } } }
/// <summary> /// 提交编辑 /// </summary> private bool SubmintEdit() { if (StockIn != null) { ModifiedGrid(); StockIn.FCate = "内部"; StockIn.FCode = CurrentUser.AccountComId.ToString(CultureInfo.InvariantCulture); StockIn.FName = ""; StockIn.FMemo = txtFMemo.Text.Trim(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", StockIn.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]); StockIn.FAmount = amt; StockIn.FBatchNumber = txtFBatchNumber.Text.Trim(); StockIn.FSurveyor = !ddlFSurveyor.SelectedValue.Equals("-1") ? ddlFSurveyor.SelectedText : ""; StockIn.FProducer = !ddlFProducer.SelectedValue.Equals("-1") ? ddlFProducer.SelectedText : "";//GasHelper.GetDropDownListArrayString(ddlFProducer.SelectedItemArray); StockIn.FProductionWorkshop = ddlWorkShop.SelectedValue; StockIn.FDate = txtFDate.SelectedDate; StockIn.CreateBy = CurrentUser.AccountName; StockInService.SaveChanges(); var prod = StockInDetailsService.FirstOrDefault( p => p.KeyId == txtKeyId.Text && p.FCompanyId == CurrentUser.AccountComId); if (prod != null) { prod.FItemCode = txtFCode.Text; prod.FQty = Convert.ToDecimal(txtFQty.Text); prod.FBottle = tbxFBottle.SelectedValue; prod.FBottleQty = Convert.ToInt16(txtFBottleQty.Text); prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text); prod.FBalance = Convert.ToDecimal(txtFBalance.Text); prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text); prod.FBalance = Convert.ToDecimal(txtFBalance.Text); StockInDetailsService.SaveChanges(); } var orders = new Dictionary <string, object>(); orders.Clear(); orders.Add("@KeyId", StockIn.KeyId); orders.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_ProuctOrder", orders); return(true); } return(false); }
/// <summary> /// Grid1_RowCommand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Delete" || e.CommandName == "Add") { var datakey = Convert.ToInt32(Grid1.DataKeys[e.RowIndex][1]); StockInDetailsService.Delete(p => p.FId == datakey && p.FCompanyId == CurrentUser.AccountComId); BindDataGrid(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { bool isSucceed = false; try { switch (Actions) { case WebAction.Add: isSucceed = SubmintAdd(); break; case WebAction.Edit: isSucceed = SubmintEdit(); break; } tmsModel t = new tmsModel(); try { IQueryable <LHDispatchCenter> center = DispatchCenterService.Where(p => p.KeyId == lblKeyId.Text); if (center.Count() > 0) { t.dispatchCenterList = center.ToList(); } IQueryable <LHStockOut> iP = new StockOutService().Where(p => p.FDispatchNum == lblKeyId.Text); t.stockOutList = iP.ToList <LHStockOut>(); t.stockOutDetailsList = new List <LHStockOutDetails>(); foreach (LHStockOut item in iP) { IQueryable <LHStockOutDetails> li = new StockOutDetailsService().Where(p => p.KeyId == item.KeyId); foreach (LHStockOutDetails outDetails in li) { t.stockOutDetailsList.Add(outDetails); } } IQueryable <LHPassCard> lHPasses = PassCardService.Where(p => p.FDispatchNum == lblKeyId.Text); if (lHPasses != null) { t.passCardList = lHPasses.ToList(); } t.passCardDetailsList = new List <LHPassCardDetails>(); foreach (LHPassCard item in t.passCardList) { IQueryable <LHPassCardDetails> cardDetails = new PassCardDetailsService().Where(p => p.KeyId == item.KeyId); foreach (LHPassCardDetails details in cardDetails) { t.passCardDetailsList.Add(details); } } IQueryable <LHStockIn> skin = new StockInService().Where(p => p.FDispatchNum == lblKeyId.Text); if (skin != null && skin.Count() > 0) { t.stockInList = skin.ToList(); t.stockInDetailsList = new List <LHStockInDetails>(); foreach (LHStockIn item in skin) { IQueryable <LHStockInDetails> inDetails = new StockInDetailsService().Where(p => p.KeyId == item.KeyId); foreach (LHStockInDetails inDetail in inDetails) { t.stockInDetailsList.Add(inDetail); } } } new HttpRequest().httpRequest(t, "open/dbo/dboData"); } catch (Exception) { } } catch (DbEntityValidationException ex) { string msg = string.Empty; List <ICollection <DbValidationError> > errors = (from u in ex.EntityValidationErrors select u.ValidationErrors).ToList(); foreach (ICollection <DbValidationError> item in errors) { msg += item.FirstOrDefault().ErrorMessage; } isSucceed = false; } finally { if (isSucceed) { PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.Show("提交失败!", MessageBoxIcon.Error); } } }
/// <summary> /// 提交添加 /// </summary> private bool SubmintAdd() { var stock = StockInService.Where(p => p.KeyId == txtKeyId.Text.Trim() && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); if (stock != null) { ModifiedGrid(); var prod = StockInDetailsService.FirstOrDefault( p => p.KeyId == txtKeyId.Text && p.FCompanyId == CurrentUser.AccountComId); if (prod == null) { //生产产品入库 var product = new LHStockInDetails { KeyId = txtKeyId.Text, FItemCode = txtFCode.Text, FPrice = 0, FAmount = 0, FQty = Convert.ToDecimal(txtFQty.Text), FBottle = tbxFBottle.SelectedValue, FBottleQty = Convert.ToInt16(txtFBottleQty.Text), FBottleOweQty = 0, FCompanyId = CurrentUser.AccountComId, FCateId = 2000, FMemo = "生产入库", FCostPrice = Convert.ToDecimal(txtFCostPrice.Text), FBalance = Convert.ToDecimal(txtFBalance.Text), }; StockInDetailsService.Add(product); } else { prod.FItemCode = txtFCode.Text; prod.FQty = Convert.ToDecimal(txtFQty.Text); prod.FBottle = tbxFBottle.SelectedValue; prod.FBottleQty = Convert.ToInt32(txtFBottleQty.Text); prod.FCostPrice = Convert.ToDecimal(txtFCostPrice.Text); prod.FBalance = Convert.ToDecimal(txtFBalance.Text); StockInDetailsService.SaveChanges(); } //------------------------------------------------------------------- stock.FCompanyId = CurrentUser.AccountComId; stock.FFlag = 1; stock.FDeleteFlag = 0; stock.FMemo = txtFMemo.Text.Trim(); var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@keyID", stock.KeyId); parms.Add("@companyId", CurrentUser.AccountComId); var amt = Convert.ToDecimal(SqlService.ExecuteProcedureCommand("proc_PurchaseAmt", parms).Tables[0].Rows[0][0]); stock.FAmount = amt; stock.FSurveyor = !ddlFSurveyor.SelectedValue.Equals("-1") ? ddlFSurveyor.SelectedText : ""; stock.FProducer = !ddlFProducer.SelectedValue.Equals("-1") ? ddlFProducer.SelectedText : "";//GasHelper.GetDropDownListArrayString(ddlFProducer.SelectedItemArray); stock.FBatchNumber = txtFBatchNumber.Text.Trim(); stock.FProductionWorkshop = ddlWorkShop.SelectedValue; stock.FCate = "内部"; stock.FCode = CurrentUser.AccountComId.ToString(CultureInfo.InvariantCulture); stock.FName = ""; stock.FDate = txtFDate.SelectedDate; StockInService.SaveChanges(); if (txtKeyId.Text.Contains("TM")) { //单据号问题 string newKeyId = SequenceService.CreateSequence(Convert.ToDateTime(txtFDate.SelectedDate), "PR", CurrentUser.AccountComId); var orderParms = new Dictionary <string, object>(); orderParms.Clear(); orderParms.Add("@oldKeyId", txtKeyId.Text); orderParms.Add("@newKeyId", newKeyId); orderParms.Add("@Bill", "6"); orderParms.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_num", orderParms); txtKeyId.Text = newKeyId; var orders = new Dictionary <string, object>(); orders.Clear(); orders.Add("@KeyId", newKeyId); orders.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_ProuctOrder", orders); //新增日志 var billStatus = new LHBillStatus { KeyId = newKeyId, FCompanyId = CurrentUser.AccountComId, FActionName = "新增", FDate = DateTime.Now, FDeptId = CurrentUser.AccountOrgId, FOperator = CurrentUser.AccountName, FMemo = String.Format("单据号{0},{1}新增生产单据。", newKeyId, CurrentUser.AccountName) }; GasHelper.AddBillStatus(billStatus); } return(true); } return(false); }
/// <summary> /// 加载页面数据 /// </summary> private void LoadData() { switch (Actions) { case WebAction.Add: Region1.Title = "添加生产单"; txtKeyId.Text = SequenceService.CreateSequence("TM", CurrentUser.AccountComId); var temp = new LHStockIn { KeyId = txtKeyId.Text, FFlag = 1, FDeleteFlag = 1, //发货单 FType = Convert.ToInt32(GasEnumBill.Production), CreateBy = CurrentUser.AccountName, FDate = txtFDate.SelectedDate, FCompanyId = CurrentUser.AccountComId, FStatus = Convert.ToInt32(GasEnumBillStauts.Add), FProgress = Convert.ToInt32(GasEnumBillStauts.Add), }; //临时写入单据 StockInService.Add(temp); break; case WebAction.Edit: txtKeyId.Text = KeyId; Region1.Title = "编辑生产单"; if (StockIn != null) { txtFMemo.Text = StockIn.FMemo; ddlFProducer.SelectedValue = StockIn.FProducer; ddlFSurveyor.SelectedValue = StockIn.FSurveyor; ddlWorkShop.SelectedValue = StockIn.FProductionWorkshop; var product = StockInDetailsService.Where( p => p.KeyId == KeyId && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); if (product != null) { txtFCode.Text = product.FItemCode; txtFQty.Text = product.FQty.ToString(); tbxFBottle.SelectedValue = product.FBottle; txtFBottleQty.Text = product.FBottleQty.ToString(); txtFCostPrice.Text = product.FCostPrice.ToString(); txtFBalance.Text = product.FBalance.ToString(); // var item = new ItemsService().Where( p => p.FCode == txtFCode.Text && p.FCompanyId == CurrentUser.AccountComId) .FirstOrDefault(); if (item != null) { tbxFName.Text = item.FName; } } BindDataGrid(); } break; } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string backouts = context.Request["params"]; TmsReturnModel returnModel = new TmsReturnModel(); StockOutDetailsService service = new StockOutDetailsService(); DispatchCenterService centerService = new DispatchCenterService(); StockInDetailsService stockInDetails = new StockInDetailsService(); try { using (TransactionScope trans = new TransactionScope()) { tmsModel outs = JsonConvert.DeserializeObject <tmsModel>(backouts); if (outs.stockOutDetailsList != null) { foreach (LHStockOutDetails items in outs.stockOutDetailsList) { LHStockOutDetails details = service.Where(p => p.KeyId == items.KeyId && p.FId == items.FId).FirstOrDefault(); if (details != null) { details.FRecycleQty = items.FRecycleQty; details.FReturnQty = items.FReturnQty; details.FDevice = items.FDevice; details.FDeviceValue = string.IsNullOrEmpty(items.FDeviceValue.ToString()) ? 0 : Convert.ToDecimal(items.FDeviceValue); details.FInTemperature = string.IsNullOrEmpty(items.FInTemperature.ToString()) // ? 0 : Convert.ToDecimal(items.FInTemperature.ToString()); details.FInPressure = string.IsNullOrEmpty(items.FInPressure.ToString()) // ? 0 : Convert.ToDecimal(items.FInPressure.ToString()); details.FOutTemperature = string.IsNullOrEmpty(items.FOutTemperature.ToString()) // ? 0 : Convert.ToDecimal(items.FOutTemperature.ToString()); details.FOutPressure = string.IsNullOrEmpty(items.FOutPressure.ToString()) // ? 0 : Convert.ToDecimal(items.FOutPressure.ToString()); details.FPayTemperature = string.IsNullOrEmpty(items.FPayTemperature.ToString()) // ? 0 : Convert.ToDecimal(items.FPayTemperature.ToString()); details.FPayPressure = string.IsNullOrEmpty(items.FPayPressure.ToString()) // ? 0 : Convert.ToDecimal(items.FPayPressure.ToString()); details.FReceiveTemperature = string.IsNullOrEmpty(items.FReceiveTemperature.ToString()) // ? 0 : Convert.ToDecimal(items.FReceiveTemperature.ToString()); details.FReceivePressure = string.IsNullOrEmpty(items.FReceivePressure.ToString()) // ? 0 : Convert.ToDecimal(items.FReceivePressure.ToString()); //数量计算 LHStockOut StockOut = new StockOutService().Where(p => p.KeyId == items.KeyId).FirstOrDefault(); string FCode = StockOut.FCode; //计算公式 LHTubePrice v1 = new TubePriceService().Where(p => p.FBill == "销售" &&// p.FCode == FCode &&// p.FItemCode == details.FItemCode).FirstOrDefault(); if (v1 != null) { //< font color = "red" >$W1:进厂温度、$W2:出厂温度、$W3: 交付温度、$W4: 接收温度、$V: 水容积 </ font >< br /> //< font color = "red" >$Y1:进厂压力、$Y2:出厂压力、$Y3: 交付压力、$Y4: 接收压力 </ font >< br /> string inW = Convert.ToDecimal(details.FInTemperature).ToString(CultureInfo.InvariantCulture); string inY = Convert.ToDecimal(details.FInPressure).ToString(CultureInfo.InvariantCulture); string outW = Convert.ToDecimal(details.FOutTemperature).ToString(CultureInfo.InvariantCulture); string outY = Convert.ToDecimal(details.FOutPressure).ToString(CultureInfo.InvariantCulture);; string payW = Convert.ToDecimal(details.FPayTemperature).ToString(CultureInfo.InvariantCulture); string payY = Convert.ToDecimal(details.FPayPressure).ToString(CultureInfo.InvariantCulture); string recW = Convert.ToDecimal(details.FReceiveTemperature).ToString(CultureInfo.InvariantCulture); string recY = Convert.ToDecimal(details.FReceivePressure).ToString(CultureInfo.InvariantCulture); //水溶积 string v = Convert.ToDecimal(details.FDeviceValue).ToString(CultureInfo.InvariantCulture); //数量 string s1 = v1.FFormula.Replace("$W1", inW) // .Replace("$W2", outW) .Replace("$W3", payW) // .Replace("$W4", recW) // .Replace("$Y1", inY) // .Replace("$Y2", outY) // .Replace("$Y3", payY) // .Replace("$Y4", recY) // .Replace("$V", v); //数量 details.FQty = Convert.ToDecimal(FormulaCalculator.Eval(s1)); //金额 details.FAmount = details.FQty * details.FPrice; } service.SaveChanges(); } } } if (outs.dispatchCenterList != null) { foreach (LHDispatchCenter item in outs.dispatchCenterList) { LHDispatchCenter lH = centerService.Where(p => p.KeyId == item.KeyId & p.FAuditFlag == 0).FirstOrDefault(); if (lH != null) { lH.FDriver = item.FDriver; lH.FSupercargo = item.FSupercargo; lH.FMileage = item.FMileage; } centerService.SaveChanges(); } } trans.Complete(); } returnModel.code = "200"; returnModel.msg = "成功"; } catch (Exception ex) { returnModel.code = "500"; returnModel.msg = "失败"; returnModel.msg = ex.Message; } context.Response.Write(JsonConvert.SerializeObject(returnModel)); }
private void ModifiedGrid() { //编辑行事件 var dictModified = Grid1.GetModifiedDict(); foreach (var rowKey in dictModified.Keys) { int datakey = Convert.ToInt32(Grid1.DataKeys[rowKey][1].ToString()); var sKeys = new StringBuilder(); var sValues = new StringBuilder(); foreach (var key in dictModified[rowKey].Keys) { sKeys.AppendFormat("{0},", key); } foreach (var dictValue in dictModified[rowKey].Values) { sValues.AppendFormat("{0},", dictValue); } var details = StockInDetailsService.Where(p => p.FId == datakey && // p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault(); //写入原始,通过存储过程完成明细复制 var parms = new Dictionary <string, object>(); parms.Clear(); parms.Add("@fid", datakey); parms.Add("@opr", CurrentUser.AccountName); parms.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_StockOutDetails_Log", parms); var keys = sKeys.ToString().Split(','); var values = sValues.ToString().Split(','); for (int i = 0; i < keys.Count(); i++) { #region 修改内容 var key = keys[i]; var value = values[i]; if (!string.IsNullOrEmpty(key)) { if (details != null) { if (key.Equals("FPrice")) { details.FPrice = Convert.ToDecimal(value); details.FAmount = details.FPrice * details.FQty; } if (key.Equals("FQty")) { details.FQty = Convert.ToDecimal(value); details.FBottleQty = (Int32)(Convert.ToDecimal(value)); details.FAmount = details.FPrice * details.FQty; } if (key.Equals("FBottle")) { details.FBottle = value; } if (key.Equals("FBottleName")) { details.FBottle = value; } if (key.Equals("FBottleQty")) { int result = 0; int.TryParse(value, out result); details.FBottleQty = result; //details.FBottleQty = (Int32)(Convert.ToDecimal(value)); } if (key.Equals("FT6Warehouse")) { details.FT6WarehouseNum = GasHelper.GetWarehouseByName(value); } if (key.Equals("FReturnQty")) { details.FReturnQty = Convert.ToDecimal(value); } if (key.Equals("FRecycleQty")) { int result = 0; int.TryParse(value, out result); details.FRecycleQty = result; //details.FRecycleQty = (Int32)(Convert.ToDecimal(value)); } var detailslog = new LHStockInDetails_Log { FUpdateBy = CurrentUser.AccountName, FUpdateDate = DateTime.Now, FItemCode = details.FItemCode, FPrice = details.FPrice, FQty = details.FQty, FAmount = details.FAmount, FBottleQty = details.FBottleQty, FBottleOweQty = details.FBottleOweQty, KeyId = details.KeyId, FBottle = details.FBottle, FCompanyId = CurrentUser.AccountComId, FStatus = "变更", FMemo = string.Format(@"时间:{0} 变更人:{1}", DateTime.Now, CurrentUser.AccountName) }; StockInDetailsLogService.Add(detailslog); } } #endregion } StockInDetailsService.SaveChanges(); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e) { var addList = Grid1.GetNewAddedList(); foreach (var add in addList) { var dictValues = add.Values; //商品代码 var firstOrDefault = dictValues.First(); if (firstOrDefault != null && !string.IsNullOrEmpty(firstOrDefault.ToString())) { DataSet dataSet = GasHelper.GetPurchaseItem(firstOrDefault.ToString(), CurrentUser.AccountComId); DataTable table = dataSet.Tables[0]; if (table != null && table.Rows.Count > 0) { decimal price = GasHelper.GeSupplierPrice(txtFCode.Text.Trim(),// table.Rows[0]["FItemCode"].ToString(), CurrentUser.AccountComId); table.Rows[0]["FPrice"] = price; var details = new LHStockInDetails { FItemCode = table.Rows[0]["FItemCode"].ToString(), FPrice = price, FQty = 0, FAmount = price, FBottleQty = 0, FReturnQty = 0, FBottleOweQty = 0, FRecycleQty = 0, FCompanyId = CurrentUser.AccountComId, KeyId = txtKeyId.Text.Trim(), FBottle = table.Rows[0]["FBottleCode"].ToString(), FCateId = Convert.ToInt32(table.Rows[0]["FId"].ToString()) }; switch (Actions) { case WebAction.Add: break; case WebAction.Edit: //记录一下当前新增人操作内容 var detailslog = new LHStockInDetails_Log { FUpdateBy = CurrentUser.AccountName, FUpdateDate = DateTime.Now, FItemCode = table.Rows[0]["FItemCode"].ToString(), FPrice = price, FQty = 1, FAmount = price, FBottleQty = 1, FBottleOweQty = 0, KeyId = txtKeyId.Text.Trim(), FBottle = table.Rows[0]["FBottleCode"].ToString(), FStatus = "新增", FCompanyId = CurrentUser.AccountComId, FMemo = string.Format(@"时间:{0} 新增人:{1}", DateTime.Now, CurrentUser.AccountName) }; StockInDetailsLogService.Add(detailslog); break; } StockInDetailsService.Add(details); } } } //var dictModified = Grid1.GetModifiedDict(); //foreach (var index in dictModified.Keys) //{ // int datakey = Convert.ToInt32(Grid1.DataKeys[index][1].ToString()); // foreach (var dictValue in dictModified.Values) // { // foreach (KeyValuePair<string, object> keyValuePair in dictValue) // { // string key = keyValuePair.Key; // string value = keyValuePair.Value.ToString(); // var details = StockInDetailsService.Where(p => p.FId == datakey&&p.FCompanyId==CurrentUser.AccountComId).FirstOrDefault(); // //写入原始,通过存储过程完成明细复制 // var parms = new Dictionary<string, object>(); // parms.Clear(); // parms.Add("@fid", datakey); // parms.Add("@opr", CurrentUser.AccountName); // parms.Add("@companyId", CurrentUser.AccountComId); // SqlService.ExecuteProcedureCommand("proc_StockInDetails_Log", parms); // if (details != null) // { // switch (key) // { // case "FPrice": // details.FPrice = Convert.ToDecimal(value); // details.FAmount = details.FPrice * details.FQty; // break; // case "FQty": // details.FQty = Convert.ToDecimal(value); // details.FAmount = details.FPrice * details.FQty; // break; // case "FBottle": // details.FBottle = value; // break; // case "FBottleName": // details.FBottle = value; // break; // case "FBottleQty": // details.FBottleQty = Convert.ToInt32(value); // break; // case "FMemo": // details.FMemo = value; // break; // } // var detailslog = new LHStockInDetails_Log // { // FUpdateBy = CurrentUser.AccountName, // FUpdateDate = DateTime.Now, // FItemCode = details.FItemCode, // FPrice = details.FPrice, // FQty = details.FQty, // FAmount = details.FAmount, // FBottleQty = details.FBottleQty, // FBottleOweQty = details.FBottleOweQty, // KeyId = details.KeyId, // FBottle = details.FBottle, // FStatus = "变更", // FCompanyId = CurrentUser.AccountComId, // FMemo = string.Format(@"时间:{0} 变更人:{1}", DateTime.Now, CurrentUser.AccountName) // }; // StockInDetailsLogService.Add(detailslog); // } // StockInDetailsService.SaveChanges(); // } // } //} if (addList.Count > 0) { BindDataGrid(); } }
/// <summary> /// Page_Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //初始化控件数据 InitData(); //加载数据 LoadData(); } else { if (GetRequestEventArgument().Contains("reloadGrid:")) { //查找所选商品代码,查访产品集合 string keys = GetRequestEventArgument().Split(':')[1]; var values = keys.Split(','); string codes = String.Empty; for (int i = 0; i < values.Count(); i++) { codes += string.Format("'{0}',", values[i]); } var value = codes.Substring(0, codes.Length - 1); var data = SqlService.Where(string.Format("SELECT * FROM dbo.vm_PurchaseItem a WHERE a.FItemCode IN ({0}) and FCompanyId={1}", value, CurrentUser.AccountComId )); if (data != null && data.Tables.Count > 0 && data.Tables[0].Rows.Count > 0) { var table = data.Tables[0]; for (int i = 0; i < table.Rows.Count; i++) { var details = new LHStockInDetails(); decimal price = GasHelper.GeSupplierPrice(txtFCode.Text.Trim(), // table.Rows[i]["FItemCode"].ToString(), CurrentUser.AccountComId); details.FItemCode = table.Rows[i]["FItemCode"].ToString(); details.FPrice = price; details.FQty = 0; details.FAmount = price; details.FBottleQty = 0; details.FBottleOweQty = 0; details.FCompanyId = CurrentUser.AccountComId; details.KeyId = txtKeyId.Text.Trim(); details.FCateId = Convert.ToInt32(table.Rows[i]["FId"].ToString()); details.FNum = table.Rows[i]["FINum"].ToString();//U8代码 details.FReturnQty = 0; details.FRecycleQty = 0; //默认包装物 details.FBottle = table.Rows[i]["FBottle"].ToString(); StockInDetailsService.AddEntity(details); //日志 switch (Actions) { case WebAction.Add: break; case WebAction.Edit: ////记录一下当前新增人操作内容 //var detailslog = new LHStockInDetails_Log //{ // FUpdateBy = CurrentUser.AccountName, // FUpdateDate = DateTime.Now, // FItemCode = details.FItemCode, // FPrice = price, // FQty = 1, // FAmount = price, // FBottleQty = 1, // FBottleOweQty = 0, // FCompanyId = CurrentUser.AccountComId, // KeyId = txtKeyId.Text.Trim(), // FBottle = details.FBottle, // FStatus = "新增", // FMemo = string.Format(@"时间:{0} 操作人:{1}", DateTime.Now, CurrentUser.AccountName) //}; //StockInDetailsLogService.Add(detailslog); break; } } StockInDetailsService.SaveChanges(); //重新绑定值 BindDataGrid(); } } //更新合计 if (GetRequestEventArgument() == "UPDATE_SUMMARY") { // 页面要求重新计算合计行的值 OutputSummaryData(); // ModifiedGrid(); // 为了保持前后台上传,回发更新合计行值后,必须进行数据绑定或者提交更改 Grid1.CommitChanges(); } } }
/// <summary> /// Page_Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //初始化控件数据 InitData(); //加载数据 LoadData(); } else { if (GetRequestEventArgument().Contains("reloadGrid:")) { //查找所选商品代码,查访产品集合 string keys = GetRequestEventArgument().Split(':')[1]; var values = keys.Split(','); string codes = String.Empty; for (int i = 0; i < values.Count(); i++) { codes += string.Format("'{0}',", values[i]); } var value = codes.Substring(0, codes.Length - 1); var data = SqlService.Where(string.Format("SELECT * FROM dbo.vm_SalesItem a WHERE a.FItemCode IN ({0}) AND a.FCompanyId={1}", value, CurrentUser.AccountComId)); if (data != null && data.Tables.Count > 0 && data.Tables[0].Rows.Count > 0) { var table = data.Tables[0]; for (int i = 0; i < table.Rows.Count; i++) { var details = new LHStockInDetails(); decimal price = GasHelper.GeCustomerPrice(txtFCode.Text.Trim(), // table.Rows[i]["FItemCode"].ToString(), CurrentUser.AccountComId); details.FItemCode = table.Rows[i]["FItemCode"].ToString(); details.FPrice = price; details.FQty = 1; details.FAmount = price; details.FBottleQty = 1; details.FBottleOweQty = 0; details.FBottle = table.Rows[i]["FItemCode"].ToString(); details.FCompanyId = CurrentUser.AccountComId; details.KeyId = txtKeyId.Text.Trim(); details.FCateId = Convert.ToInt32(table.Rows[i]["FId"].ToString()); StockInDetailsService.AddEntity(details); //日志 switch (Actions) { case WebAction.Add: break; case WebAction.Edit: //记录一下当前新增人操作内容 var detailslog = new LHStockInDetails_Log { FUpdateBy = CurrentUser.AccountName, FUpdateDate = DateTime.Now, FItemCode = details.FItemCode, FPrice = price, FQty = 1, FAmount = price, FBottleQty = 1, FBottleOweQty = 0, KeyId = txtKeyId.Text.Trim(), FBottle = details.FBottle, FStatus = "新增", FCompanyId = CurrentUser.AccountComId, FMemo = string.Format(@"时间:{0} 操作人:{1}", DateTime.Now, CurrentUser.AccountName) }; StockInDetailsLogService.Add(detailslog); break; } } StockInDetailsService.SaveChanges(); //重新绑定值 BindDataGrid(); } } } }
/// <summary> /// 单元格编辑与修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_AfterEdit(object sender, GridAfterEditEventArgs e) { Window1.Hidden = true; Window2.Hidden = true; Window3.Hidden = true; //新增行事件 var addList = Grid1.GetNewAddedList(); foreach (var add in addList) { var dictValues = add.Values; //商品代码 var firstOrDefault = dictValues.First(); if (firstOrDefault != null) { DataSet dataSet = GasHelper.GetSalesItem(firstOrDefault.ToString(), CurrentUser.AccountComId); DataTable table = dataSet.Tables[0]; if (table != null && table.Rows.Count > 0) { decimal price = GasHelper.GeCustomerPrice("",// table.Rows[0]["FItemCode"].ToString(), CurrentUser.AccountComId); table.Rows[0]["FPrice"] = price; var details = new LHStockInDetails { FItemCode = table.Rows[0]["FItemCode"].ToString(), FPrice = price, FQty = 1, FAmount = price, FBottleQty = 1, FBottleOweQty = 0, FCompanyId = CurrentUser.AccountComId, KeyId = txtKeyId.Text.Trim(), FBottle = table.Rows[0]["FBottleCode"].ToString(), FCateId = Convert.ToInt32(table.Rows[0]["FId"].ToString()) }; switch (Actions) { case WebAction.Add: break; case WebAction.Edit: //记录一下当前新增人操作内容 var detailslog = new LHStockInDetails_Log { FUpdateBy = CurrentUser.AccountName, FUpdateDate = DateTime.Now, FItemCode = table.Rows[0]["FItemCode"].ToString(), FPrice = price, FQty = 1, FAmount = price, FBottleQty = 1, FBottleOweQty = 0, FCompanyId = CurrentUser.AccountComId, KeyId = txtKeyId.Text.Trim(), FBottle = table.Rows[0]["FBottleCode"].ToString(), FStatus = "新增", FMemo = string.Format(@"时间:{0} 新增人:{1}", DateTime.Now, CurrentUser.AccountName) }; StockInDetailsLogService.Add(detailslog); break; } StockInDetailsService.Add(details); } } } if (addList.Count > 0) { BindDataGrid(); } }