/// <summary> /// ModifiedGrid /// </summary> 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 = StockOutDetailsService.Where(p => p.FId == datakey).FirstOrDefault(); //写入原始,通过存储过程完成明细复制 var parmsLog = new Dictionary <string, object>(); parmsLog.Clear(); parmsLog.Add("@fid", datakey); parmsLog.Add("@opr", CurrentUser.AccountName); parmsLog.Add("@companyId", CurrentUser.AccountComId); SqlService.ExecuteProcedureCommand("proc_StockOutDetails_Log", parmsLog); 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 = Convert.ToInt32(details.FQty); details.FAmount = details.FPrice * details.FQty; } if (key.Equals("FBottle")) { details.FBottle = value; } if (key.Equals("FBottleName")) { details.FBottle = value; } if (key.Equals("FRecycleQty")) { details.FRecycleQty = Convert.ToInt32(value); } if (key.Equals("FBottleQty")) { details.FBottleQty = Convert.ToInt32(value); } if (key.Equals("FMemo")) { details.FMemo = value; } var detailslog = new LHStockOutDetails_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, FRecycleQty = details.FRecycleQty, FStatus = "变更", FMemo = string.Format(@"时间:{0} 变更人:{1}", DateTime.Now, CurrentUser.AccountName) }; StockOutDetailsLogService.Add(detailslog); } } #endregion } StockOutDetailsService.SaveChanges(); } }
/// <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 (!string.IsNullOrEmpty(txtFCode.Text)) { } if (GetRequestEventArgument().Contains("reloadGrid:")) { #region Grid1 //查找所选商品代码,查访产品集合 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 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 LHStockOutDetails(); decimal price = GasHelper.GeSupplierPrice("", // 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.FCompanyId = CurrentUser.AccountComId; details.KeyId = txtKeyId.Text.Trim(); details.FCateId = Convert.ToInt32(table.Rows[i]["FId"].ToString()); details.FCostPrice = 0; details.FBalance = 0; //默认包装物 details.FBottle = table.Rows[i]["FBottle"].ToString(); StockOutDetailsService.AddEntity(details); //日志 switch (Actions) { case WebAction.Add: break; case WebAction.Edit: //记录一下当前新增人操作内容 var detailslog = new LHStockOutDetails_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) }; StockOutDetailsLogService.Add(detailslog); break; } } StockOutDetailsService.SaveChanges(); //重新绑定值 BindDataGrid(); } #endregion } #region 更新合计 if (Grid1.Rows.Count > 0) { if (GetRequestEventArgument() == "UPDATE_SUMMARY") { OutputSummaryData(); ModifiedGrid(); Grid1.CommitChanges(); } } #endregion } }
/// <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) { DataSet dataSet = GasHelper.GetSalesItem(firstOrDefault.ToString(), CurrentUser.AccountComId); DataTable table = dataSet.Tables[0]; if (table != null && table.Rows.Count > 0) { decimal price = GasHelper.GeSupplierPrice("",// table.Rows[0]["FItemCode"].ToString(), CurrentUser.AccountComId); table.Rows[0]["FPrice"] = price; var details = new LHStockOutDetails { 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 LHStockOutDetails_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) }; //detailslog.FCompanyId = CurrentUser.AccountComId; //detailslog.FCateId = Convert.ToInt32(table.Rows[0]["FId"].ToString()); StockOutDetailsLogService.Add(detailslog); break; } StockOutDetailsService.Add(details); } } } if (addList.Count > 0) { 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) { #region AddDetails 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 LHStockOutDetails { 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 LHStockOutDetails_Log { FUpdateBy = CurrentUser.AccountName, FUpdateDate = DateTime.Now, FItemCode = table.Rows[0]["FItemCode"].ToString(), FPrice = price, FQty = 1, FAmount = price, FBottleQty = 1, FCompanyId = CurrentUser.AccountComId, FBottleOweQty = 0, KeyId = txtKeyId.Text.Trim(), FBottle = table.Rows[0]["FBottleCode"].ToString(), FStatus = "新增", FMemo = string.Format(@"时间:{0} 新增人:{1}", DateTime.Now, CurrentUser.AccountName) }; StockOutDetailsLogService.Add(detailslog); break; } StockOutDetailsService.Add(details); } } #endregion } ////编辑行事件 //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 = StockOutDetailsService.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); // 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.FBottleQty = Convert.ToInt32(details.FQty); // 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 LHStockOutDetails_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) // }; // StockOutDetailsLogService.Add(detailslog); // } // StockOutDetailsService.SaveChanges(); // } // } //} if (addList.Count > 0) { BindDataGrid(); } }