protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { //int[] intCell = GridGoods.SelectedCell; //List<Dictionary<string, object>> newDict = GridGoods.GetNewAddedList(); //if (newDict.Count == 0) return; //if (e.ColumnID == "BZSL" || e.ColumnID == "HSJJ") //{ // string cell = string.Format("[{0},{1}]", e.RowIndex, intCell[1]); // PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(GetJObject(newDict[e.RowIndex]), cell)); // if (e.RowIndex != intCell[0]) // { // PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(GetJObject(newDict[intCell[0]]), string.Format("[{0},{1}]", intCell[0], intCell[1]))); // } // //计算合计数量 // decimal bzslTotal = 0, feeTotal = 0; // foreach (Dictionary<string, object> dic in newDict) // { // bzslTotal += Convert.ToDecimal(dic["BZSL"]); // feeTotal += Convert.ToDecimal(dic["HSJJ"]) * Convert.ToDecimal(dic["BZHL"]); // } // JObject summary = new JObject(); // summary.Add("GDNAME", "本页合计"); // summary.Add("BZSL", bzslTotal.ToString()); // summary.Add("HSJE", feeTotal.ToString("F2")); // GridGoods.SummaryData = summary; //} }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { if (e.ColumnID == "BARCODE") { PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference("~/ERPQuery/GoodsWindow.aspx", "商品信息查询")); } }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { string[] strCell = GridGoods.SelectedCell; List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList(); if (newDict.Count == 0) { return; } if (e.ColumnID == "BZSL" || e.ColumnID == "HSJJ") { PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(strCell[0], strCell[1], GetJObject(newDict[e.RowIndex]).ToString())); if (e.RowIndex != Convert.ToInt32(strCell[0])) { PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(strCell[0], strCell[1], GetJObject(newDict[Convert.ToInt32(strCell[0])]).ToString())); } //计算合计数量 decimal bzslTotal = 0, feeTotal = 0; foreach (Dictionary <string, object> dic in newDict) { bzslTotal += Convert.ToDecimal(dic["BZSL"]); feeTotal += Convert.ToDecimal(dic["HSJJ"]) * Convert.ToDecimal(dic["BZSL"]) * Convert.ToDecimal(dic["BZHL"]); } JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; } }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { string[] strCell = GridGoods.SelectedCell; int selectedRowIndex = GridGoods.SelectedRowIndex; List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList(); if (newDict.Count == 0) { return; } if (e.ColumnID == "BZSL" || e.ColumnID == "HSJJ") { if (!PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZHL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZSL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "HSJJ"))) { if (!PubFunc.isNumeric(newDict[e.RowIndex]["BZHL"].ToString()) || !PubFunc.isNumeric(newDict[e.RowIndex]["BZSL"].ToString()) || !PubFunc.isNumeric(newDict[e.RowIndex]["HSJJ"].ToString())) { Alert.Show("商品信息异常,请详细检查商品信息:包装含量或价格!", "异常信息", MessageBoxIcon.Warning); return; } } JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); //if (Convert.ToDecimal(Doc.GetGridInf(GridGoods, e.RowID, "BZSL")) > Convert.ToDecimal(Doc.GetGridInf(GridGoods, e.RowID, "NUM1"))) //{ // defaultObj["BZSL"] = "0"; // PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); // Alert.Show("申请数不能大于库存数量", "异常信息", MessageBoxIcon.Warning); // return; //} decimal hl = 0, rs = 0, jg = 0; decimal.TryParse((defaultObj["BZHL"] ?? "0").ToString(), out hl); decimal.TryParse((defaultObj["BZSL"] ?? "0").ToString(), out rs); decimal.TryParse((defaultObj["HSJJ"] ?? "0").ToString(), out jg); defaultObj["DHSL"] = rs * hl; defaultObj["HSJE"] = Math.Round(rs * jg, 2).ToString("F2"); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); //计算合计数量 decimal bzslTotal = 0, feeTotal = 0; foreach (Dictionary <string, object> dic in newDict) { if (dic["BZSL"].ToString().Length > 0 && dic["HSJJ"].ToString().Length > 0) { bzslTotal += Convert.ToDecimal(dic["BZSL"]); feeTotal += Convert.ToDecimal(dic["HSJJ"]) * Convert.ToDecimal(dic["BZSL"]) * Convert.ToDecimal(dic["BZHL"]); } } JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; } }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { if (hdfOper.Text == "audit" || (",M,N").IndexOf(docFLAG.SelectedValue) < 0) { return; } string[] strCell = GridGoods.SelectedCell; List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList(); if (newDict.Count == 0) { return; } #region 取消其他计算列 if (e.ColumnID == "BZSL") { if (!PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZHL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZSL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "HSJJ"))) { Alert.Show("商品信息异常,请详细检查商品信息:包装含量、价格或数量!", "异常信息", MessageBoxIcon.Warning); return; } JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); decimal hl = 0, rs = 0, jg = 0; decimal.TryParse((defaultObj["BZHL"] ?? "0").ToString(), out hl); decimal.TryParse((defaultObj["BZSL"] ?? "0").ToString(), out rs); decimal.TryParse((defaultObj["HSJJ"] ?? "0").ToString(), out jg); defaultObj["DHSL"] = rs * hl; defaultObj["HSJE"] = Math.Round(rs * jg, 2).ToString("F2"); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); //计算合计数量 decimal bzslTotal = 0, feeTotal = 0, dhslTotal = 0; foreach (Dictionary <string, object> dic in newDict) { if (dic["BZSL"] != null) { if (!PubFunc.StrIsEmpty(dic["BZSL"].ToString())) { bzslTotal += Convert.ToDecimal(dic["BZSL"]); feeTotal += Convert.ToDecimal(dic["HSJJ"]) * Convert.ToDecimal(dic["BZSL"]); dhslTotal += Convert.ToDecimal(dic["BZHL"]) * Convert.ToDecimal(dic["BZSL"]); } } } JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); summary.Add("DHSL", dhslTotal.ToString()); GridGoods.SummaryData = summary; } #endregion }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { if (e.ColumnID == "HSJJ") { JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); decimal hl = 0, jg = 0; decimal.TryParse((defaultObj["SL"] ?? "0").ToString(), out hl); decimal.TryParse((defaultObj["HSJJ"] ?? "0").ToString(), out jg); defaultObj["HSJE"] = Math.Round(hl * jg, 2).ToString("F2"); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); } }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList(); if (newDict.Count == 0) { return; } if (e.ColumnID == "DHS") { string[] strCell = GridGoods.SelectedCell; if (!PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "DHS"))) { Alert.Show("商品信息异常,请详细检查采购值!", "异常信息", MessageBoxIcon.Warning); return; } JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); decimal hl = 0, jg = 0; decimal.TryParse((defaultObj["DHS"] ?? "0").ToString(), out hl); decimal.TryParse((defaultObj["HSJJ"] ?? "0").ToString(), out jg); defaultObj["HSJE"] = Math.Round(hl * jg, 2).ToString("F2"); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); //计算合计数量 decimal bzslTotal = 0, feeTotal = 0; foreach (Dictionary <string, object> dic in newDict) { if ((dic["DHS"] ?? "0").ToString().Length > 0 && (dic["HSJJ"] ?? "0").ToString().Length > 0) { bzslTotal += Convert.ToDecimal(dic["DHS"] ?? "0"); feeTotal += Convert.ToDecimal(dic["HSJJ"] ?? "0") * Convert.ToDecimal(dic["DHS"] ?? "0"); } } JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("DHS", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; } }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { string[] strCell = GridGoods.SelectedCell; List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList(); if (newDict.Count == 0) { return; } if (e.ColumnID == "BZSL") { if (!PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZHL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZSL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "HSJJ"))) { Alert.Show("商品信息异常,请详细检查商品信息:包装含量、价格或数量!", "异常信息", MessageBoxIcon.Warning); return; } JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); decimal hl = 0, rs = 0, jg = 0; decimal.TryParse((defaultObj["BZHL"] ?? "0").ToString(), out hl); decimal.TryParse((defaultObj["BZSL"] ?? "0").ToString(), out rs); decimal.TryParse((defaultObj["HSJJ"] ?? "0").ToString(), out jg); defaultObj["DHSL"] = rs * hl; defaultObj["HSJE"] = Math.Round(rs * jg, 2).ToString("F2"); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); //计算合计数量 decimal bzslTotal = 0, feeTotal = 0; foreach (Dictionary <string, object> dic in newDict) { bzslTotal += Convert.ToDecimal(dic["BZSL"]); feeTotal += Convert.ToDecimal(dic["HSJJ"]) * Convert.ToDecimal(dic["BZSL"]); } JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; } else if (e.ColumnID == "PH") { String gdseq = Doc.GetGridInf(GridGoods, e.RowID, "GDSEQ"); if (gdseq.Length < 1) { Alert.Show("请先选择商品信息!", "异常信息", MessageBoxIcon.Question); return; } String ph = Doc.GetGridInf(GridGoods, e.RowID, "PH"); if (ph.Length < 1 && DbHelperOra.Exists(string.Format("SELECT 1 FROM DOC_GOODS WHERE GDSEQ = '{0}' AND ISLOT = '2'", gdseq))) { Alert.Show("请填写商品[" + gdseq + "]批次信息!", "异常信息", MessageBoxIcon.Warning); return; } if (ph.ToString() == "\\") { DataTable dtPH = Doc.GetGoodsPH_New(gdseq, docDEPTID.SelectedValue); if (dtPH != null && dtPH.Rows.Count > 0) { hfdRowIndex.Text = GridGoods.SelectedRowIndex.ToString(); GridLot.DataSource = dtPH; GridLot.DataBind(); WindowLot.Hidden = false; } else { Alert.Show("商品[" + gdseq + "]已无库存,请检查!", MessageBoxIcon.Warning); } } } }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { string[] strCell = GridGoods.SelectedCell; List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList(); if (e.ColumnID == "BZSL") { if (!PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZHL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZSL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "HSJJ"))) { if (Doc.GetGridInf(GridGoods, e.RowID, "BZHL") == "非赠品") { Alert.Show("商品信息异常,请详细检查商品信息:包装含量、价格或数量!", "异常信息", MessageBoxIcon.Warning); return; } } //处理返回jobject JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); decimal hl = 0, rs = 0, jg = 0; decimal.TryParse((defaultObj["BZHL"] ?? "0").ToString(), out hl); decimal.TryParse((defaultObj["BZSL"] ?? "0").ToString(), out rs); decimal.TryParse((defaultObj["HSJJ"] ?? "0").ToString(), out jg); defaultObj["XSSL"] = rs * hl; defaultObj["HSJE"] = Math.Round(rs * jg, 2).ToString("F2"); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); if (Convert.ToDecimal(Doc.GetGridInf(GridGoods, e.RowID, "BZSL")) * Convert.ToDecimal(Doc.GetGridInf(GridGoods, e.RowID, "BZHL")) > Convert.ToDecimal(Doc.GetGridInf(GridGoods, e.RowID, "DHSL")) && Doc.GetGridInf(GridGoods, e.RowID, "NUM1NAME") == "非赠品") { Alert.Show("拣货数量不能大于申领数量!", "异常信息", MessageBoxIcon.Warning); return; } //计算合计数量 decimal bzslTotal = 0, feeTotal = 0, dhslTotal = 0; foreach (Dictionary <string, object> dic in newDict) { bzslTotal += Convert.ToDecimal(dic["BZSL"] ?? "0"); feeTotal += Convert.ToDecimal(dic["HSJJ"] ?? "0") * Convert.ToDecimal(dic["BZSL"] ?? "0"); dhslTotal += Convert.ToDecimal(dic["DHSL"] ?? "0"); } JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); summary.Add("DHSL", dhslTotal.ToString()); GridGoods.SummaryData = summary; } else if (e.ColumnID == "PH") { String gdseq = Doc.GetGridInf(GridGoods, e.RowID, "GDSEQ"); if (gdseq.Length < 1) { Alert.Show("请先选择商品信息!", "异常信息", MessageBoxIcon.Warning); return; } DataTable dtPH = Doc.GetGoodsPHKC(gdseq, docDEPTOUT.SelectedValue); if (dtPH != null && dtPH.Rows.Count > 0) { if (dtPH.Rows.Count == 1) { JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); defaultObj["PH"] = dtPH.Rows[0]["PH"].ToString(); defaultObj["PZWH"] = dtPH.Rows[0]["PZWH"].ToString(); defaultObj["RQ_SC"] = dtPH.Rows[0]["RQ_SC"].ToString(); defaultObj["YXQZ"] = dtPH.Rows[0]["YXQZ"].ToString(); defaultObj["KCSL"] = dtPH.Rows[0]["KCSL"].ToString(); defaultObj["HWID"] = dtPH.Rows[0]["HWID"].ToString(); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); } else { GridLot.DataSource = dtPH; GridLot.DataBind(); WindowLot.Hidden = false; } } else { Alert.Show("请先维护商品批号!", MessageBoxIcon.Warning); } } }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { string[] strCell = GridGoods.SelectedCell; List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList(); if (newDict.Count == 0) { return; } if (e.ColumnID == "BZSL") { JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); decimal hl = 0, rs = 0, jg = 0; decimal.TryParse((defaultObj["BZHL"] ?? "0").ToString(), out hl); decimal.TryParse((defaultObj["BZSL"] ?? "0").ToString(), out rs); decimal.TryParse((defaultObj["HSJJ"] ?? "0").ToString(), out jg); defaultObj["DHSL"] = rs * hl; defaultObj["HSJE"] = Math.Round(rs * jg, 2).ToString("F2"); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); //计算合计数量 decimal bzslTotal = 0, feeTotal = 0; foreach (Dictionary <string, object> dic in newDict) { decimal.TryParse(dic["BZSL"].ToString(), out jg); bzslTotal += jg; feeTotal += Convert.ToDecimal(dic["HSJJ"] ?? "0") * Convert.ToDecimal(dic["BZSL"] ?? "0") * Convert.ToDecimal(dic["BZHL"]); } JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; } else if (e.ColumnID == "PH") { JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); String Sql = string.Format("SELECT SUM(A.KCSL),A.PH,A.YXQZ,A.RQ_SC,B.PIZNO PZWH FROM DAT_GOODSSTOCK A,DOC_GOODS B WHERE A.DEPTID = '{0}' AND A.GDSEQ ='{1}' AND A.GDSEQ=B.GDSEQ AND KCSL > LOCKSL GROUP BY PH,YXQZ,B.PIZNO,A.RQ_SC ", docDEPTOUT.SelectedValue, defaultObj["GDSEQ"].ToString()); if (defaultObj["PH"].ToString() != "\\") { Sql = string.Format("SELECT SUM(A.KCSL),A.PH,A.YXQZ,A.RQ_SC FROM DAT_GOODSSTOCK A WHERE A.DEPTID = '{0}' AND A.GDSEQ ='{1}'AND PH = '{2}' AND KCSL > LOCKSL GROUP BY PH,YXQZ,A.RQ_SC", docDEPTOUT.SelectedValue, defaultObj["GDSEQ"].ToString(), defaultObj["PH"]); } DataTable dtPH = DbHelperOra.Query(Sql).Tables[0]; if (dtPH != null && dtPH.Rows.Count > 0) { if (dtPH.Rows.Count == 1) { defaultObj["PH"] = dtPH.Rows[0]["PH"].ToString(); defaultObj["YXQZ"] = dtPH.Rows[0]["YXQZ"].ToString(); defaultObj["RQ_SC"] = dtPH.Rows[0]["RQ_SC"].ToString(); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(strCell[0], defaultObj)); } else { GridLot.DataSource = dtPH; GridLot.DataBind(); WindowLot.Hidden = false; } } //else //{ // Alert.Show("科室无可调出库存!", "提示信息", MessageBoxIcon.Warning); // return; //} } }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList(); if (newDict.Count == 0) { return; } //处理返回jobject JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); //string cell = string.Format("[{0},{1}]", e.RowIndex, intCell[1]); if (e.ColumnID == "BZSL") { if (!PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZHL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZSL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "HSJJ"))) { Alert.Show("商品信息异常,请详细检查商品信息:包装含量或价格!", "异常信息", MessageBoxIcon.Warning); return; } if ((Convert.ToInt32(defaultObj["BZSL"]) > Convert.ToInt32(defaultObj["KCSL"])) || (Convert.ToInt32(defaultObj["BZSL"]) * Convert.ToInt32(defaultObj["BZHL"]) > Convert.ToInt32(defaultObj["KCSL"]))) { Alert.Show("退货数量(最小包装)不能大于库存数量!", "异常信息", MessageBoxIcon.Warning); defaultObj["BZSL"] = "0"; } decimal hl = 0, rs = 0, jg = 0; decimal.TryParse((defaultObj["BZHL"] ?? "0").ToString(), out hl); decimal.TryParse((defaultObj["BZSL"] ?? "0").ToString(), out rs); decimal.TryParse((defaultObj["HSJJ"] ?? "0").ToString(), out jg); defaultObj["THSL"] = rs * hl; defaultObj["HSJE"] = Math.Round(rs * jg, 2).ToString("F2"); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); #region //计算合计数量 decimal bzslTotal = 0, feeTotal = 0, thslTotal = 0; foreach (Dictionary <string, object> dic in newDict) { if ((dic["BZSL"] ?? "0").ToString().Length > 0 && (dic["HSJJ"] ?? "0").ToString().Length > 0) { bzslTotal += Convert.ToDecimal(dic["BZSL"] ?? "0"); feeTotal += Convert.ToDecimal(dic["HSJJ"] ?? "0") * Convert.ToDecimal(dic["BZSL"] ?? "0"); thslTotal += Convert.ToDecimal(dic["BZHL"] ?? "0") * Convert.ToDecimal(dic["BZSL"] ?? "0"); } object objISFLAG5 = DbHelperOra.GetSingle(string.Format("SELECT ISFLAG5 FROM DOC_GOODS WHERE GDSEQ = '{0}'", dic["GDSEQ"])); if (objISFLAG5.ToString() == "N") { string str = Convert.ToString(Convert.ToDecimal(dic["BZSL"] ?? "0")); if (Convert.ToDecimal(dic["BZSL"]) != (int)Convert.ToDecimal(dic["BZSL"]) && Convert.ToDecimal(dic["BZHL"] ?? "0") == 1) { Alert.Show("当前商品不支持申领数为小数,请调整", "消息提示", MessageBoxIcon.Warning); } } } JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); summary.Add("THSL", thslTotal.ToString("F2")); GridGoods.SummaryData = summary; #endregion } }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { string[] strCell = GridGoods.SelectedCell; List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList(); if (newDict.Count == 0) { return; } if (e.ColumnID == "BZSL") { if (!PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZHL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "BZSL")) || !PubFunc.isNumeric(Doc.GetGridInf(GridGoods, e.RowID, "HSJJ"))) { Alert.Show("商品信息异常,请详细检查商品信息:包装含量、价格或数量!", "异常信息", MessageBoxIcon.Warning); return; } JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); decimal hl = 0, rs = 0, jg = 0; decimal.TryParse((defaultObj["BZHL"] ?? "0").ToString(), out hl); decimal.TryParse((defaultObj["BZSL"] ?? "0").ToString(), out rs); decimal.TryParse((defaultObj["HSJJ"] ?? "0").ToString(), out jg); defaultObj["DHSL"] = rs * hl; defaultObj["HSJE"] = Math.Round(rs * jg, 2).ToString("F2"); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); //计算合计数量 decimal bzslTotal = 0, feeTotal = 0; foreach (Dictionary <string, object> dic in newDict) { bzslTotal += Convert.ToDecimal(dic["BZSL"]); feeTotal += Convert.ToDecimal(dic["HSJJ"]) * Convert.ToDecimal(dic["BZSL"]); } JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; } else if (e.ColumnID == "PH") { //校验批次是否存在 JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); if (defaultObj["PH"].ToString().Length > 0) { DataTable dt = DbHelperOra.Query(String.Format(@"SELECT A.PH,A.YXQZ,A.RQ_SC FROM DAT_GOODSJXC A WHERE GDSEQ = '{0}' AND DEPTID = '{1}' AND PH = '{2}'", defaultObj["GDSEQ"], docDEPTID.Text, defaultObj["PH"])).Tables[0]; if (dt.Rows.Count > 0) { defaultObj["YXQZ"] = dt.Rows[0]["YXQZ"].ToString(); defaultObj["RQ_SC"] = dt.Rows[0]["RQ_SC"].ToString(); PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); } else { defaultObj["PH"] = ""; defaultObj["YXQZ"] = ""; defaultObj["RQ_SC"] = ""; PageContext.RegisterStartupScript(GridGoods.GetUpdateCellValueReference(e.RowID, defaultObj)); Alert.Show("输入的批次信息错误!", "提示信息", MessageBoxIcon.Warning); return; } } } }
protected void GridGoods_AfterEdit(object sender, FineUIPro.GridAfterEditEventArgs e) { }