protected override void billOpen(string strBillno) { string StrSql = strDocSql + " AND A.SEQNO = '{0}'"; DataTable dtDoc = DbHelperOra.Query(string.Format(StrSql, strBillno)).Tables[0]; PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; if (dtBill != null && dtBill.Rows.Count > 0) { Doc.GridRowAdd(GridGoods, dtBill); } PubFunc.FormLock(FormDoc, true, ""); TabStrip1.ActiveTabIndex = 1; if (docFLAG.SelectedValue == "M") { //初始化按钮 btnDel.Enabled = true; btnSave.Enabled = true; btnAudit.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; docMEMO.Enabled = true; tbxREASON.Enabled = true; btnPrint.Enabled = false; ButSubmit.Enabled = true; } else if (docFLAG.SelectedValue == "N") { btnDel.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = true; btnDelRow.Enabled = false; btnGoods.Enabled = false; btnPrint.Enabled = false; ButSubmit.Enabled = false; } else if (docFLAG.SelectedValue == "Y") { //初始化按钮 btnDel.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = false; btnDelRow.Enabled = false; btnGoods.Enabled = false; btnPrint.Enabled = true; ButSubmit.Enabled = false; } }
protected void cxsj(String strCode) { string strSql = string.Format("select * from DOC_SUPPLIER where SUPID='{0}'", strCode); DataTable dtProducer = DbHelperOra.Query(strSql).Tables[0]; if (dtProducer.Rows.Count > 0) { PubFunc.FormDataSet(FormProducer, dtProducer.Rows[0]); tbxSUPPWD.Text = ""; if (dtProducer.Rows[0]["STR1"].ToString() == "Y") { chkSTR1.Checked = true; } else { chkSTR1.Checked = false; } } if (ddlFLAG.SelectedValue == "Y") { PubFunc.FormLock(FormProducer, true); btnDelete.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = false; btnUnAudit.Enabled = true; } else { PubFunc.FormLock(FormProducer, false); btnUnAudit.Enabled = false; btnAudit.Enabled = true; btnDelete.Enabled = true; tbxSUPID.Enabled = false; btnSave.Enabled = true; hfdIsNew.Text = "N"; } if (strCode == "00001" || strCode == "00002") { chkISDG.Enabled = false; } else { chkISDG.Enabled = true; } ddlFLAG.Enabled = false; chkSTR1.Enabled = false; }
protected override void billOpen(string strBillno) { DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0]; PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); decimal bzslTotal = 0, feeTotal = 0; DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; if (dtBill != null && dtBill.Rows.Count > 0) { foreach (DataRow row in dtBill.Rows) { bzslTotal += Convert.ToDecimal(row["BZSL"]); feeTotal += Convert.ToDecimal(row["HSJJ"]) * Convert.ToDecimal(row["BZSL"]); } } Doc.GridRowAdd(GridGoods, dtBill); //计算合计数量 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; PubFunc.FormLock(FormDoc, true, ""); TabStrip1.ActiveTabIndex = 1; //判断按钮状态 if (docFLAG.SelectedValue == "N") { tbxBARCODE.Enabled = true; btnExtraction.Enabled = true; btnSave.Enabled = true; btnAudit.Enabled = true; btnPrint.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; } else { btnExtraction.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = false; btnPrint.Enabled = true; btnDelRow.Enabled = false; btnGoods.Enabled = false; } }
protected override void billDelRow() { if (docFLAG.SelectedValue != "N") { Alert.Show("非新增单据不能删除!"); return; } if (GridGoods.SelectedCell == null) { return; } GridGoods.DeleteSelectedRows(); PubFunc.FormLock(FormDoc, true, ""); tbxINSERT.Enabled = true; }
protected override void billDelRow() { if (docFLAG.SelectedValue != "N") { Alert.Show("非『新增』单据不能删行!", "消息提示", MessageBoxIcon.Warning); return; } if (GridGoods.SelectedRowID == null) { Alert.Show("当前未选中单元行,无法进行操作!", "消息提示", MessageBoxIcon.Warning); return; } PageContext.RegisterStartupScript(GridGoods.GetDeleteRowReference(GridGoods.SelectedRowID)); PubFunc.FormLock(FormDoc, true, ""); }
protected override void billNew() { GridGoods.DataSource = null; GridGoods.DataBind(); PubFunc.FormLock(FormDoc, false); docSEQNO.Text = string.Empty; tgbCKDH.Text = string.Empty; docSEQNO.Enabled = false; docFLAG.Enabled = false; docLRY.Enabled = false; tbxYJJJ.Enabled = false; Bill_create.Enabled = true; tbxMEMO.Text = string.Empty; tbxYJJJ.Text = string.Empty; }
protected override void billDelRow() { if (docFLAG.SelectedValue != "N") { Alert.Show("非新增单据不能删除!"); return; } if (GridGoods.SelectedCell == null) { return; } GridGoods.DeleteSelectedRows(); PubFunc.FormLock(FormDoc, true, ""); trbBARCODE.Enabled = true; //Alert.Show("【删行】操作成功,请点击【保存】按钮使【删行】操作生效!"); }
protected override void billDelRow() { if (docFLAG.SelectedValue != "N") { Alert.Show("非新增单据不能删除!"); return; } if (GridGoods.SelectedCell == null) { return; } int rowIndex = GridGoods.SelectedRowIndex; PageContext.RegisterStartupScript(GridGoods.GetDeleteRowReference(rowIndex)); PubFunc.FormLock(FormDoc, true, ""); }
protected void btnGoods_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(docDEPTOUT.SelectedValue) || string.IsNullOrWhiteSpace(docDEPTID.SelectedValue)) { Alert.Show("表单字段为空,请补充完整后再追加商品!"); return; } if (docDEPTOUT.SelectedValue == docDEPTID.SelectedValue) { Alert.Show("调出科室和调入科室不能为同一个,请重新选择!"); return; } PubFunc.FormLock(FormDoc, true, ""); WindowGoods.Hidden = false; DataSearch(); }
protected override void billGoods() { if (PubFunc.FormDataCheck(FormDoc).Length > 1) { return; } if (docFLAG.SelectedValue != "N") { Alert.Show("非新单据不允许操作"); return; } //参数说明:cx-查询内容,bm-商品配置部门,su-供应商 string url = "~/ERPApply/Contant_GoodsWindow_His.aspx?bm=" + docDEPTID.SelectedValue + "&cx=" + docDEPTOUT.SelectedValue + "&su="; PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "可出定数商品信息查询")); PubFunc.FormLock(FormDoc, true, ""); }
protected override void billGoods() { if (PubFunc.FormDataCheck(FormDoc).Length > 1) { return; } if ((",M,N").IndexOf(docFLAG.SelectedValue) < 0) { return; } PubFunc.FormLock(FormDoc, true, ""); docMEMO.Enabled = true; //参数说明:cx-查询内容,bm-商品配置部门,su-供应商 string url = "~/ERPQuery/GoodsWindow_New.aspx?Deptout=" + docDEPTOUT.SelectedValue + "&DeptIn=" + docDEPTID.SelectedValue + "&GoodsState=YT"; PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "商品信息查询")); }
private void DataInit() { PubFunc.DdlDataGet("DDL_DOC_SUPPLIERNULL", ddlSUPID); PubFunc.DdlDataGet("DDL_BILL_STATUSJSD", docFLAG, lstFLAG); PubFunc.DdlDataGet("DDL_USER", ddlFKY); PubFunc.DdlDataGet("DDL_SYS_DEPT", ddlDEPTID); ddlFKY.SelectedValue = UserAction.UserID; lstLRRQ1.SelectedDate = DateTime.Now; lstLRRQ2.SelectedDate = DateTime.Now; dpkFKRQ.SelectedDate = DateTime.Now; PubFunc.FormLock(FormDoc, true); nbxJSJE.Enabled = true; tgbFPHM.Enabled = true; tbxMEMO.Enabled = true; ddlFKY.Enabled = true; dpkFKRQ.Enabled = true; //docFPJE.Enabled = true; }
protected override void billDelRow() { if (docFLAG.SelectedValue != "N") { Alert.Show("非新增单据不能删除!"); return; } if (GridGoods.SelectedCell == null) { return; } //string rowIndex = GridGoods.SelectedRowID; // GridGoods.SelectedRowIndex动态行不能删除行索引,只能删除行ID //PageContext.RegisterStartupScript(GridGoods.GetDeleteRowReference(rowIndex)); GridGoods.DeleteSelectedRows(); PubFunc.FormLock(FormDoc, true, ""); //tbxINSERT.Enabled = true; }
protected override void billNew() { PubFunc.FormDataClear(Formlis); ddlYHY.SelectedValue = UserAction.UserID; ddlLRY.SelectedValue = UserAction.UserID; dpkYHRQ.SelectedDate = DateTime.Now; dpkLRRQ.SelectedDate = DateTime.Now; PubFunc.FormLock(Formlis, false); ddlLRY.Enabled = false; dpkLRRQ.Enabled = false; ddlSHR.Enabled = false; dpkSHRQ.Enabled = false; docFLAG.Enabled = false; GridLis.SummaryData = null; PageContext.RegisterStartupScript(GridLis.GetRejectChangesReference()); }
protected void btnAudit_Click(object sender, EventArgs e) { int[] rows = GridSupplier.SelectedRowIndexArray; if (rows.Length > 0 && !string.IsNullOrEmpty(tbxSUPID.Text)) { if (PubFunc.FormDataCheck(FormProducer).Length > 1) { return; //存在为空的非空列则返回! } else { saveExec(); string strFLAG = ddlFLAG.SelectedValue.ToString(); if (strFLAG == "Y") { Alert.Show("已经审核通过,无需再审!"); } else { string strSUPID = ""; foreach (int index in rows) { strSUPID += PubFunc.GridDataGet(GridSupplier, index)["SUPID"].ToString() + ","; } strSUPID = strSUPID.TrimEnd(',').Replace(",", "','"); DbHelperOra.ExecuteSql("UPDATE DOC_SUPPLIER SET FLAG = 'Y' WHERE SUPID IN ('" + strSUPID + "')"); Alert.Show("供应商资料 审核通过!"); OperLog("供应商资料", "审核供应商【" + strSUPID + "】"); ERPUtility.CacheClear("DOC_SUPPLIER"); } } } else { Alert.Show("请选择需要审核的供应商!"); return; } String strSUPID1 = tbxSUPID.Text.ToString(); cxsj(strSUPID1); PubFunc.FormLock(FormProducer, true); dataSearch(); }
protected override void billOpen(string strBillno) { string StrSql = strDocSql + " AND A.SEQNO = '{0}'"; DataTable dtDoc = DbHelperOra.Query(string.Format(StrSql, strBillno)).Tables[0]; PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; decimal bzslTotal = 0, xsslTotal = 0, feeTotal = 0; if (dtBill != null && dtBill.Rows.Count > 0) { foreach (DataRow row in dtBill.Rows) { bzslTotal += Convert.ToDecimal(row["BZSL"]); xsslTotal += Convert.ToDecimal((row["XSSL"] ?? "0")); feeTotal += Convert.ToDecimal((row["XSSL"] ?? "0")) * Convert.ToDecimal(row["HSJJ"]); LoadGridRow(row, false, "OLD"); } } //增加合计 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("XSSL", xsslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; PubFunc.FormLock(FormDoc, true, ""); GridGoods.AllowCellEditing = false; if (docFLAG.SelectedValue.Equals("W")) { btnAudit.Enabled = true; } else { btnAudit.Enabled = false; } TabStrip1.ActiveTabIndex = 1; }
protected void goodsRow_DoubleClick(object sender, GridRowClickEventArgs e) { DataTable dtnew = DbHelperOra.Query("SELECT * FROM DOC_SUPPLIERTEMP t where t.supid='" + GridGoods.Rows[e.RowIndex].DataKeys[2] + "'").Tables[0]; if (dtnew.Rows.Count > 0) { //GridGoods.Rows[e.RowIndex] } if (hfdOper.Text == "sq") { PubFunc.FormDataSet(FormProducer, dtnew.Rows[0]); if (tbxSEQNO.Text.Length > 0) { if (DbHelperOra.GetSingle("SELECT T.FLAG FROM DAT_TZSUP_DOC T WHERE T.SEQNO='" + tbxSEQNO.Text + "'").ToString() != "M") { PubFunc.FormLock(FormProducer, true); } } } if (hfdOper.Text == "zj") { PubFunc.FormDataSet(FormProducer, dtnew.Rows[0]); PubFunc.FormLock(FormProducer, true); } if (ddlType.SelectedValue == "M") { DataTable dt = DbHelperOra.Query("SELECT * FROM DOC_SUPPLIER T WHERE T.SUPID = '" + GridGoods.Rows[e.RowIndex].DataKeys[2] + "' ORDER BY T.SUPID desc").Tables[0]; if (dt != null && dt.Rows.Count > 0) { formGet(Form3, dt.Rows[0]); } else { PubFunc.FormDataSet(Form3, GridGoods.Rows[e.RowIndex]); } PubFunc.FormLock(Form3, true); Panel4.Hidden = false; } WindowGoods.Hidden = false; GridSupplier.Hidden = true; }
protected override void billGoods() { if (ddlTYPE.SelectedValue.Trim().Length < 1) { Alert.Show("请选择【调整类型】!", "提示信息", MessageBoxIcon.Warning); return; } if (tbxGDNAME_OLD.Text.Length < 1 || tbxGDNAME.Text.Length < 1) { Alert.Show("请输入商品编码后,按回车键进行确认!", "提示信息", MessageBoxIcon.Warning); return; } if (!CheckInfo()) { Alert.Show("商品编码与商品名称不符,请检查!", "提示信息", MessageBoxIcon.Warning); return; } WindowGoods.Hidden = false; btnExlSch_Click(null, null); PubFunc.FormLock(FormDoc, true, ""); }
private void DataInit() { if (Request.QueryString["oper"].ToString() == "ck" || Request.QueryString["oper"].ToString() == "xs") { PubFunc.DdlDataGet("DDL_SYS_DEPT", lstDEPTOUT, ddlDEPTID); } else { PubFunc.DdlDataGet("DDL_SYS_DEPOT", lstDEPTOUT, ddlDEPTID); } PubFunc.DdlDataGet("DDL_USER", lstJSY); PubFunc.DdlDataGet("DDL_DOC_SHS", ddlsup, ddlSUPID); PubFunc.FormLock(Formlis, true); //lstLRRQ1默认为上次结算日期 //lstLRRQ1.SelectedDate = DateTime.Now; lstLRRQ2.SelectedDate = DateTime.Now; //默认为威高 ddlsup.SelectedValue = PubFunc.DbGetPara("SUPPLIER"); lstJSY.SelectedValue = UserAction.UserID; }
protected override void billOpen(string strBillno) { DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0]; PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; decimal bzslTotal = 0, feeTotal = 0; if (dtBill != null && dtBill.Rows.Count > 0) { foreach (DataRow row in dtBill.Rows) { //LoadGridRow(row, false, "DSC"); bzslTotal += Convert.ToDecimal(row["BZSL"] ?? "0"); feeTotal += Convert.ToDecimal(row["HSJJ"] ?? "0") * Convert.ToDecimal(row["BZHL"] ?? "0"); } /* * 修 改 人 :袁鹏 修改时间:2015-04-13 * 信息说明:这种加载方法比LoadGridRow(row, false, "DSC")更高效 * 研发组织:威高讯通信息科技有限公司 */ PubFunc.GridRowAdd(GridGoods, dtBill); } trbEditorGDSEQ.Enabled = false; PubFunc.FormLock(FormDoc, true, ""); //计算合计数量 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F6")); GridGoods.SummaryData = summary; TabStrip1.ActiveTabIndex = 1; }
protected void btnDelRow_Click(object sender, EventArgs e) { //201509211429 6448版本缺失 add by zhanghaicheng if (docFLAG.SelectedValue != "M") { Alert.Show("非『新增』单据不能删行!", "消息提示", MessageBoxIcon.Warning); return; } if (CheckFlagForM() && docBILLNO.Text.Length > 0) { Alert.Show("此单据已经被别人操作,请等待操作!"); return; } if (GridGoods.SelectedCell == null) { Alert.Show("当前未选中单元行,无法进行操作!", "消息提示", MessageBoxIcon.Warning); return; } GridGoods.DeleteSelectedRows(); PubFunc.FormLock(FormDoc, true, ""); docMEMO.Enabled = true; }
protected override void billDelRow() { if (docFLAG.SelectedValue != "M") { Alert.Show("非新增单据不能删除!"); return; } string strBillno = docSEQNO.Text; if (!Doc.getFlag(strBillno, "M", BillType)) { Alert.Show("此单据已被其他人处理,请刷新页面更新单据状态!", "警告提示", MessageBoxIcon.Warning); return; } if (GridGoods.SelectedCell == null) { return; } GridGoods.DeleteSelectedRows(); //int rowIndex = GridGoods.SelectedRowIndex; //PageContext.RegisterStartupScript(GridGoods.GetDeleteRowReference(rowIndex)); PubFunc.FormLock(FormDoc, true, ""); }
protected override void billDelRow() { if (docFLAG.SelectedValue != "N" && docFLAG.SelectedValue != "R") { Alert.Show("非『新增』单据不能删行!", "消息提示", MessageBoxIcon.Warning); return; } string strBillno = docSEQNO.Text; if (!Doc.getFlag(strBillno, "N", BillType) && !Doc.getFlag(strBillno, "R", BillType)) { Alert.Show("此单据已被其他人处理,请刷新页面更新单据状态!", "警告提示", MessageBoxIcon.Warning); return; } if (GridGoods.SelectedRowID == null) { Alert.Show("当前未选中单元行,无法进行操作!", "消息提示", MessageBoxIcon.Warning); return; } //PageContext.RegisterStartupScript(GridGoods.GetDeleteRowReference(GridGoods.SelectedRowID)); GridGoods.DeleteSelectedRows(); PubFunc.FormLock(FormDoc, true, ""); }
protected override void billAddRow() { if (PubFunc.FormDataCheck(FormDoc).Length > 1) { return; } string strBillno = docSEQNO.Text; // 新增数据初始值 JObject defaultObj = new JObject(); defaultObj.Add("GDSEQ", ""); defaultObj.Add("BARCODE", ""); defaultObj.Add("GDNAME", ""); defaultObj.Add("GDSPEC", ""); defaultObj.Add("UNIT", ""); defaultObj.Add("UNITNAME", ""); defaultObj.Add("BZHL", ""); defaultObj.Add("BZSL", ""); defaultObj.Add("DHSL", ""); defaultObj.Add("XSSL", ""); defaultObj.Add("JXTAX", ""); defaultObj.Add("HSJJ", ""); defaultObj.Add("HSJE", ""); defaultObj.Add("ZPBH", ""); defaultObj.Add("PRODUCER", ""); defaultObj.Add("PRODUCERNAME", ""); defaultObj.Add("HWID", ""); defaultObj.Add("PH", ""); defaultObj.Add("PZWH", ""); defaultObj.Add("RQ_SC", ""); defaultObj.Add("YXQZ", ""); defaultObj.Add("MEMO", ""); PubFunc.FormLock(FormDoc, true, ""); trbEditorGDSEQ.Enabled = true; PageContext.RegisterStartupScript(GridGoods.GetAddNewRecordReference(defaultObj, true)); }
protected override void billOpen(string strBillno) { DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0]; PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; GridGoods.DataSource = dtBill; GridGoods.DataBind(); PubFunc.FormLock(FormDoc, true, ""); TabStrip1.ActiveTabIndex = 1; //屏蔽不需要的操作按钮 if (ddlFLAG.SelectedValue == "N") { btnTJ.Enabled = false; btnAddRow.Enabled = false; btnUpdate.Enabled = false; btnDelect.Enabled = false; btnDelRow.Enabled = false; btnSave.Enabled = false; btnPrint.Enabled = true; btnCancel.Enabled = true; btnAudit.Enabled = true; btnGoods.Enabled = false; btnDel.Enabled = false; } if (ddlFLAG.SelectedValue == "R") { btnAddRow.Enabled = false; btnUpdate.Enabled = false; btnDelect.Enabled = false; btnDelRow.Enabled = false; btnSave.Enabled = false; btnPrint.Enabled = true; btnCancel.Enabled = true; btnAudit.Enabled = false; btnGoods.Enabled = true; string flag = DbHelperOra.GetSingle("select XGTYPE from DAT_TZSUP_DOC t where t.billno='" + strBillno + "'").ToString(); if (flag == "N") { btnAddRow.Enabled = true; } else if (flag == "M") { btnUpdate.Enabled = true; } else if (flag == "D") { btnDelect.Enabled = true; } btnDelRow.Enabled = true; btnSave.Enabled = true; btnCancel.Enabled = false; btnDel.Enabled = true; } if (ddlFLAG.SelectedValue == "M") { btnAddRow.Enabled = false; btnUpdate.Enabled = false; btnDelect.Enabled = false; btnTJ.Enabled = true; btnGoods.Enabled = true; string flag = DbHelperOra.GetSingle("select XGTYPE from DAT_TZSUP_DOC t where t.billno='" + strBillno + "'").ToString(); if (flag == "N") { btnAddRow.Enabled = true; } else if (flag == "M") { btnUpdate.Enabled = true; } else if (flag == "D") { btnDelect.Enabled = true; } btnDelRow.Enabled = true; btnSave.Enabled = true; btnDel.Enabled = true; } else if (ddlFLAG.SelectedValue == "Y") { btnAddRow.Enabled = false; btnUpdate.Enabled = false; btnDelect.Enabled = false; btnDelRow.Enabled = false; btnSave.Enabled = false; btnTJ.Enabled = false; btnAudit.Enabled = false; btnPrint.Enabled = true; btnCancel.Enabled = false; btnUpdate.Enabled = false; btnDelect.Enabled = false; btnGoods.Enabled = false; btnDel.Enabled = false; } }
protected override void billOpen(string strBillno) { DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0]; PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); //decimal bzslTotal = 0, feeTotal = 0; DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; if (dtBill != null && dtBill.Rows.Count > 0) { Doc.GridRowAdd(GridGoods, dtBill); } //计算合计数量 //JObject summary = new JObject(); //summary.Add("GDNAME", "本页合计"); //summary.Add("BZSL", bzslTotal.ToString()); //summary.Add("HSJE", feeTotal.ToString("F2")); //GridGoods.SummaryData = summary; PubFunc.FormLock(FormDoc, true, ""); if ((",M,R").IndexOf(docFLAG.SelectedValue) > 0) { btnPrint.Enabled = false; btnDel.Enabled = true; btnSave.Enabled = true; btnDelRow.Enabled = true; btnGoods.Enabled = true; btnAudit.Enabled = true; btnCancel.Enabled = true; } else if (docFLAG.SelectedValue == "N") { btnPrint.Enabled = true; btnDel.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = true; btnDelRow.Enabled = false; btnCancel.Enabled = true; btnGoods.Enabled = false; } else if (docFLAG.SelectedValue == "Y") { btnPrint.Enabled = true; btnDel.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = false; btnDelRow.Enabled = false; btnCancel.Enabled = false; btnGoods.Enabled = false; } else { btnPrint.Enabled = false; btnDel.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = false; btnDelRow.Enabled = false; btnCancel.Enabled = false; btnGoods.Enabled = false; } TabStrip1.ActiveTabIndex = 1; }
protected override void billOpen(string strBillno) { DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0]; if (dtDoc != null && dtDoc.Rows.Count > 0) { PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]); } else { Alert.Show("单据信息获取失败!!!", "消息提示", MessageBoxIcon.Warning); return; } if (docLRY.SelectedValue == null) { docLRY.SelectedValue = UserAction.UserID; } PageContext.RegisterStartupScript(GridCom.GetRejectChangesReference()); DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; if (dtBill != null && dtBill.Rows.Count > 0) { decimal ddslTotal = 0, bzslTotal = 0, feeTotal = 0; foreach (DataRow row in dtBill.Rows) { ddslTotal += Convert.ToDecimal(string.IsNullOrWhiteSpace(row["DDSL"].ToString()) ? "0" : row["DDSL"].ToString()); if (!PubFunc.StrIsEmpty(Convert.ToString(row["BZSL"] ?? "0"))) { bzslTotal += Convert.ToDecimal(row["BZSL"] ?? "0"); feeTotal += Convert.ToDecimal(row["HSJJ"]) * Convert.ToDecimal(row["BZSL"] ?? "0"); } row["HSJE"] = Convert.ToDecimal(row["HSJE"]).ToString("F2"); //处理订货单位 //DataTable dtGoods = DbHelperOra.QueryForTable(string.Format("select F_GETUNITNAME(UNIT_DABZ) UNIT_DABZNAME,F_GETUNITNAME(UNIT_ZHONGBZ) UNIT_ZHONGBZNAME,UNIT_ORDER,PIZNO from doc_goods where gdseq='{0}'", row["GDSEQ"].ToString())); //if (dtGoods != null && dtGoods.Rows.Count > 0) //{ // if ("Z".Equals(dtGoods.Rows[0]["UNIT_ORDER"].ToString())) // { // row["UNITNAME"] = dtGoods.Rows[0]["UNIT_ZHONGBZNAME"].ToString(); // } // if ("D".Equals(dtGoods.Rows[0]["UNIT_ORDER"].ToString())) // { // row["UNITNAME"] = dtGoods.Rows[0]["UNIT_DABZNAME"].ToString(); // } // row["PZWH"] = dtGoods.Rows[0]["PIZNO"].ToString(); //} } /* * 修 改 人 :袁鹏 修改时间:2015-03-20 * 信息说明:这种加载方法比LoadGridRow(row, false, "OLD")更高效 */ PubFunc.GridRowAdd(GridCom, dtBill); //计算合计数量 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("DDSL", ddslTotal.ToString()); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridCom.SummaryData = summary; } PubFunc.FormLock(FormDoc, true, ""); if (docDHRQ.Text == "") { docDHRQ.SelectedDate = DateTime.Now; } if (docFLAG.SelectedValue == "M") { docDHRQ.Enabled = true; } TabStrip1.ActiveTabIndex = 1; //增加按钮控制 if (docFLAG.SelectedValue == "M") { btnDel.Enabled = true; btnSave.Enabled = true; btnCommit.Enabled = true; btnAudit.Enabled = false; btnCancel.Enabled = false; btnPrint.Enabled = false; btnPrint.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; tbxMEMO.Enabled = true; } else if (docFLAG.SelectedValue == "N") { btnDel.Enabled = false; btnSave.Enabled = false; btnCommit.Enabled = false; btnAudit.Enabled = true; btnCancel.Enabled = true; btnPrint.Enabled = false; btnPrint.Enabled = false; btnDelRow.Enabled = false; btnGoods.Enabled = false; tbxMEMO.Enabled = false; } else { btnDel.Enabled = false; btnSave.Enabled = false; btnCommit.Enabled = false; btnAudit.Enabled = false; btnCancel.Enabled = false; btnPrint.Enabled = true; btnPrint.Enabled = true; btnDelRow.Enabled = false; btnGoods.Enabled = false; tbxMEMO.Enabled = false; } }
protected override void billOpen(string strBillno) { DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0]; if (dtDoc != null && dtDoc.Rows.Count > 0) { PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]); } else { Alert.Show("单据信息获取失败!!!", "警告提示", MessageBoxIcon.Warning); return; } PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; decimal bzslTotal = 0, feeTotal = 0; if (dtBill != null && dtBill.Rows.Count > 0) { foreach (DataRow row in dtBill.Rows) { bzslTotal += Convert.ToDecimal(row["YSSL"] ?? "0"); feeTotal += Convert.ToDecimal(row["YSSL"] ?? "0") * Convert.ToDecimal(row["HSJJ"] ?? "0"); } Doc.GridRowAdd(GridGoods, dtBill); } //增加合计 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("YSSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; PubFunc.FormLock(FormDoc, true, ""); TabStrip1.ActiveTabIndex = 1; //按钮状态转换 if (docFLAG.SelectedValue == "N") { //提交 btnNew.Enabled = true; btnGenerate.Enabled = false; btnSave.Enabled = false; btnSumbit.Enabled = false; btnAudit.Enabled = true; btnCancel.Enabled = true; btnPrint.Enabled = true; btnExport.Enabled = true; btnDelRow.Enabled = false; } else if (docFLAG.SelectedValue.Equals("R")) { btnSave.Enabled = true; btnSumbit.Enabled = true; btnDelRow.Enabled = true; btnGenerate.Enabled = false; // dpkRQSJ1.Enabled = true; // dpkRQSJ2.Enabled = true; // ddlDEPTID.Enabled = true; // nbxYSSL.Enabled = true; docMEMO.Enabled = true; } else if (docFLAG.SelectedValue.Equals("M")) { btnSave.Enabled = true; btnSumbit.Enabled = true; btnDelRow.Enabled = true; btnGenerate.Enabled = false; btnExport.Enabled = false; btnPrint.Enabled = false; btnCancel.Enabled = false; btnAudit.Enabled = false; // dpkRQSJ1.Enabled = true; // dpkRQSJ2.Enabled = true; // ddlDEPTID.Enabled = true; // nbxYSSL.Enabled = true; docMEMO.Enabled = true; } else { //审核 btnNew.Enabled = true; btnGenerate.Enabled = false; btnSave.Enabled = false; btnSumbit.Enabled = false; btnAudit.Enabled = false; btnPrint.Enabled = true; btnExport.Enabled = true; btnDelRow.Enabled = false; } }
protected override void billOpen(string strBillno) { //表头进行赋值 DataTable dtDoc = DbHelperOra.Query(strDocSql + string.Format(" AND SEQNO='{0}'", strBillno)).Tables[0]; PubFunc.FormDataSet(Formlis, dtDoc.Rows[0]); PubFunc.FormLock(Formlis, true); string strFlag = DbHelperOra.GetSingle(string.Format(@"SELECT flag FROM DAT_YH_DOC WHERE SEQNO = '{0}'", strBillno)).ToString(); hfdOper.Text = strFlag; if (strFlag == "M") { tbxMEMO.Enabled = false; btnDelRow.Enabled = true; btnDel.Enabled = true; btnSave.Enabled = false; btnTJ.Enabled = true; btnAudit.Enabled = false; btnPrint.Enabled = false; } else if (strFlag == "N") { tbxMEMO.Enabled = true; btnDelRow.Enabled = false; btnDel.Enabled = false; btnSave.Enabled = true; btnTJ.Enabled = false; btnAudit.Enabled = true; btnPrint.Enabled = true; } else { tbxMEMO.Enabled = false; btnDelRow.Enabled = false; btnDel.Enabled = false; btnSave.Enabled = false; btnTJ.Enabled = false; btnAudit.Enabled = false; btnPrint.Enabled = false; } //表体赋值 PageContext.RegisterStartupScript(GridLis.GetRejectChangesReference()); decimal bzslTotal = 0, feeTotal = 0; string sql = strComSql + string.Format(" AND SEQNO='{0}'", strBillno); DataTable dtBill = DbHelperOra.Query(sql).Tables[0]; if (dtBill != null && dtBill.Rows.Count > 0) { foreach (DataRow row in dtBill.Rows) { bzslTotal += Convert.ToDecimal(row["KCSL"] ?? "0"); feeTotal += Convert.ToDecimal(row["HSJE"] ?? "0"); } Doc.GridRowAdd(GridLis, dtBill); } //计算合计数量 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("KCSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridLis.SummaryData = summary; TabStrip1.ActiveTabIndex = 2; }
protected override void billAddRow() { if (docFLAG.SelectedValue != "N") { Alert.Show("非『新增』单据不能增行!", "消息提示", MessageBoxIcon.Warning); return; } if (PubFunc.FormDataCheck(FormDoc).Length > 1) { return; } List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList(); if (newDict.Count == 0) { if (Doc.DbGetSysPara("ISAUTOAPPLY") == "Y") { string sql = @"SELECT A.*, A.ZGKC - A.KCSL DHSL, (A.ZGKC - A.KCSL) / A.BZHL BZSL, ((A.ZGKC - A.KCSL) / A.BZHL) * A.HSJJ HSJE,A.KCSL NUM1 FROM (SELECT G.GDSEQ, G.BARCODE, G.GDNAME, G.GDSPEC, G.UNIT, F_GETUNITNAME(G.UNIT) UNITNAME, G.BZHL, G.JXTAX, G.HSJJ, G.ZPBH, G.PRODUCER, F_GETPRODUCERNAME(G.PRODUCER) PRODUCERNAME, PZ.HJCODE1, '自动生成' MEMO, G.ISLOT, G.ISGZ, PZ.ZDKC, PZ.ZGKC, (SELECT NVL(SUM(KCSL), 0) FROM DAT_GOODSSTOCK WHERE GDSEQ = G.GDSEQ) KCSL FROM DOC_GOODSCFG PZ, DOC_GOODS G WHERE PZ.GDSEQ = G.GDSEQ AND PZ.ZDKC > 0 AND PZ.ZGKC > 0 AND PZ.DEPTID = '{0}') A WHERE KCSL < ZDKC"; DataTable dt = DbHelperOra.Query(string.Format(sql, docDEPTID.SelectedValue)).Tables[0]; decimal bzslTotal = 0, feeTotal = 0; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { bzslTotal += Convert.ToDecimal(row["BZSL"]); feeTotal += Convert.ToDecimal(row["BZSL"]) * Convert.ToDecimal(row["HSJJ"]) * Convert.ToDecimal(row["BZHL"]); LoadGridRow(row, false, "OLD"); } } else { PubFunc.GridRowAdd(GridGoods, "INIT"); } //增加合计 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; } else { PubFunc.GridRowAdd(GridGoods, "INIT"); } } else { PubFunc.GridRowAdd(GridGoods, "INIT"); } PubFunc.FormLock(FormDoc, true, ""); }