/// <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(); #region AddRow foreach (var add in addList) { var dictValues = add.Values; //商品代码 var firstOrDefault = dictValues.First(); if (firstOrDefault != null && !string.IsNullOrEmpty(firstOrDefault.ToString())) { DataSet dataSet = GasHelper.GetSalesItem(firstOrDefault.ToString(), CurrentUser.AccountComId); DataTable table = dataSet.Tables[0]; if (table != null && table.Rows.Count > 0) { //decimal price = GasHelper.GeCustomerPrice(txtFCode.Text.Trim(),// // table.Rows[0]["FItemCode"].ToString(), CurrentUser.AccountComId); table.Rows[0]["FPrice"] = 0; var details = new LHPassCardDetails { FItemCode = table.Rows[0]["FItemCode"].ToString(), FPrice = 0, FQty = 1, FAmount = 0, FBottleQty = 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()) }; StockOutDetailsService.Add(details); } } } #endregion if (addList.Count > 0) { BindDataGrid(); } }
/// <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> /// AddListGrid /// </summary> private void AddListGrid() { //新增行事件 var dictList = Grid1.GetNewAddedList(); foreach (var rowKey in dictList) { var sKeys = new StringBuilder(); var sValues = new StringBuilder(); foreach (var key in rowKey.Keys) { sKeys.AppendFormat("{0},", key); } foreach (var dictValue in rowKey.Values) { sValues.AppendFormat("{0},", dictValue); } var keys = sKeys.ToString().Split(','); var values = sValues.ToString().Split(','); var details = new LHDispatchCommissionDetails(); 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("KeyId")) { details.KeyId = value; } if (key.Equals("FDate")) { details.FDate = Convert.ToDateTime(value); } if (key.Equals("FCode")) { details.FCode = value; } if (key.Equals("FName")) { details.FName = value; } if (key.Equals("FArea")) { details.FArea = value; } if (key.Equals("FItemName")) { details.FItemName = value; } if (key.Equals("FQty")) { details.FQty = Convert.ToInt32(value); } if (key.Equals("FPrice")) { details.FPrice = Convert.ToDecimal(value); } if (key.Equals("FDriver")) { details.FDriver = value; } if (key.Equals("FDriverPrice")) { details.FDriverPrice = Convert.ToDecimal(value); } if (key.Equals("FSupercargo")) { details.FSupercargo = value; } if (key.Equals("FSupercargoPrice")) { details.FSupercargoPrice = Convert.ToDecimal(value); } if (key.Equals("FVehicleNum")) { details.FVehicleNum = value; } if (key.Equals("FMemo")) { details.FMemo = value; } } } #endregion } details.FCompanyId = CurrentUser.AccountComId; StockOutDetailsService.Add(details); } Grid1.CommitChanges(); }
/// <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(); } }
/// <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(); #region AddRow foreach (var add in addList) { var dictValues = add.Values; //商品代码 var firstOrDefault = dictValues.First(); if (firstOrDefault != null && !string.IsNullOrEmpty(firstOrDefault.ToString())) { DataSet dataSet = GasHelper.GetSalesItem(firstOrDefault.ToString(), CurrentUser.AccountComId); DataTable table = dataSet.Tables[0]; if (table != null && table.Rows.Count > 0) { decimal price = GasHelper.GeCustomerPrice(txtFCode.Text.Trim(),// 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 = 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 LHStockOutDetails_Log //{ // FUpdateBy = CurrentUser.AccountName, // FUpdateDate = DateTime.Now, // FItemCode = table.Rows[0]["FItemCode"].ToString(), // FPrice = price, // FQty = 1, // FAmount = price, // FBottleQty = 0, // 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 if (addList.Count > 0) { BindDataGrid(); } }