protected override void billNew() { string strDept = docDEPTID.SelectedValue; string strDeptOut = docDEPTOUT.SelectedValue; PubFunc.FormDataClear(FormDoc); if (PubFunc.StrIsEmpty(strDept)) { if (docDEPTID.Items.Count > 2) { strDept = docDEPTID.Items[1].Value; } } if (PubFunc.StrIsEmpty(strDeptOut)) { if (docDEPTOUT.Items.Count > 2) { strDeptOut = docDEPTOUT.Items[1].Value; } } docFLAG.SelectedValue = "N"; docSLR.SelectedValue = UserAction.UserID; docLRY.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; docDEPTID.SelectedValue = strDept; docDEPTOUT.SelectedValue = strDeptOut; billLockDoc(false); GridGoods.SummaryData = null; PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); }
protected override void billNew() { //原单据保存判断 string strDept = docDEPTID.SelectedValue; PubFunc.FormDataClear(FormDoc); docFLAG.SelectedValue = "N"; docLRY.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; docDEPTID.SelectedValue = strDept; if (docDEPTID.SelectedValue.Length < 1) { docDEPTID.SelectedIndex = 1; } tbxNUM.Text = "0"; billLockDoc(false); tbxBARCODE.Enabled = true; btnAudit.Enabled = false; btnExtraction.Enabled = true; btnSave.Enabled = true; btnPrint.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); tbxBARCODE.Focus(); }
protected override void billNew() { PubFunc.FormDataClear(FormDoc); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); docFLAG.SelectedValue = "N"; docSLR.SelectedValue = UserAction.UserID; docLRY.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; docDEPTOUT.SelectedValue = ""; docDEPTID.SelectedValue = ""; btnDel.Enabled = false; docDEPTOUT.Enabled = true; docSLR.Enabled = true; docDEPTID.Enabled = true; docXSRQ.Enabled = true; docMEMO.Enabled = true; docSLR.Enabled = true; //tbxINSERT.Enabled = true; //改变按钮状态 btnPrint.Enabled = false; btnSave.Enabled = true; btnAudit.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; //tbxINSERT.Focus(); JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", "0"); summary.Add("HSJE", "0"); GridGoods.SummaryData = summary; }
protected override void billNew() { PubFunc.FormDataClear(FormDoc); // 20150919 modify by zhanghaicheng // dpkRQSJ1.SelectedDate = DateTime.Now.AddDays(-30); // dpkRQSJ2.SelectedDate = DateTime.Now; docLRY.SelectedValue = UserAction.UserID; //docSHR.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; nbxYSSL.Text = "1"; docFLAG.SelectedValue = "M";; ddlDEPTID.Enabled = true; nbxYSSL.Enabled = true; docMEMO.Enabled = true; btnGenerate.Enabled = true; btnSave.Enabled = false; btnSumbit.Enabled = false; btnAudit.Enabled = false; btnCancel.Enabled = false; btnPrint.Enabled = false; btnExport.Enabled = false; btnDelRow.Enabled = false; JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("DHS", "0"); summary.Add("HSJE", "0"); GridGoods.SummaryData = summary; //20150919 modify by zhanghaicheng docYSRQ.Text = DateTime.Now.AddMonths(1).ToString("yyyy-MM"); //Convert.ToDateTime(dpkRQSJ2.Text).Year.ToString() + "-" + Convert.ToDateTime(dpkRQSJ2.Text).AddMonths(1).Month.ToString(); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); }
protected override void billNew() { //原单据保存判断 string strDept = docDEPTGROUP.SelectedValue; string strDept2 = docDEPTID.Text; PubFunc.FormDataClear(FormDoc); docFLAG.SelectedValue = "M"; docLRY.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; docDEPTGROUP.SelectedValue = strDept; docDEPTID.Text = strDept2; tbxNUM.Text = "0"; billLockDoc(false); tbxBARCODE.Enabled = true; btnAudit.Enabled = false; btnSave.Enabled = true; btnPrint.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; docDEPTGROUP.Enabled = true; //清空Grid行 PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); }
protected override void billNew() { PubFunc.FormDataClear(FormDoc); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); docFLAG.SelectedValue = "N"; docSLR.SelectedValue = UserAction.UserID; docLRY.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; btnDel.Enabled = false; docDEPTOUT.Enabled = true; docSLR.Enabled = true; docDEPTID.Enabled = true; docXSRQ.Enabled = true; docMEMO.Enabled = true; docSLR.Enabled = true; tbxINSERT.Enabled = true; //改变按钮状态 btnPrint.Enabled = false; btnSave.Enabled = true; btnAudit.Enabled = false; btnDelRow.Enabled = true; tbxINSERT.Focus(); }
protected override void billNew() { //原单据保存判断 string strDept = docDEPTID.SelectedValue; PubFunc.FormDataClear(FormDoc); docFLAG.SelectedValue = "M"; docLRY.SelectedValue = UserAction.UserID; docSLR.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; dpkTime1.SelectedDate = DateTime.Now.AddDays(-1); dpkTime2.SelectedDate = DateTime.Now; docDEPTID.SelectedValue = strDept; billLockDoc(false); docMEMO.Enabled = true; docDEPTOUT.Enabled = true; docSLR.Enabled = true; //清空Grid行 PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); btnDel.Enabled = false; btnSave.Enabled = true; btnCommit.Enabled = false; btnAudit.Enabled = false; btnCancel.Enabled = false; btnPrt.Enabled = false; btnPrint.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; }
protected override void billNew() { //原单据保存判断 string strDept = ddlDEPTID.SelectedValue; PubFunc.FormDataClear(FormDoc); ddlFLAG.SelectedValue = "M"; docLRY.SelectedValue = UserAction.UserID; dpkLRRQ.SelectedDate = DateTime.Now; ddlDEPTID.SelectedValue = strDept; ddlDEPTID.SelectedIndex = 1; billLockDoc(false); //btnAudit.Enabled = false; //btnSave.Enabled = true; //btnPrint.Enabled = false; //btnDelRow.Enabled = true; btnAddRow.Enabled = true; btnDelRow.Enabled = true; btnSave.Enabled = true; ddlDEPTID.Enabled = true; tbxLRYTEL.Enabled = true; tbxMEMO.Enabled = true; tbxBILLNO.Enabled = false; //docSUPID.Enabled = true; //清空Grid行 PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); }
protected override void billNew() { PubFunc.FormDataClear(FormDoc); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); docFLAG.SelectedValue = "N"; docSLR.SelectedValue = UserAction.UserID; docLRY.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; btnDel.Enabled = false; docDEPTOUT.Enabled = true; docSLR.Enabled = true; docDEPTID.Enabled = true; docXSRQ.Enabled = true; docMEMO.Enabled = true; docSLR.Enabled = true; trbBARCODE.Enabled = true; //改变按钮状态 btnPrint.Enabled = false; btnSave.Enabled = true; btnAudit.Enabled = false; btnDelRow.Enabled = true; trbBARCODE.Focus(); if (Request.QueryString["tp"] != null && Request.QueryString["tp"].ToString().Trim().Length > 0) { docDEPTOUT.SelectedValue = DbHelperOra.GetSingle("SELECT T.STR2 FROM DOC_GOODSTYPE T WHERE T.CODE=" + Request.QueryString["tp"].ToString()).ToString(); } else { docDEPTOUT.SelectedValue = DbHelperOra.GetSingle("SELECT T.STR2 FROM DOC_GOODSTYPE T WHERE T.CODE='2'").ToString(); } }
protected override void billNew() { tbxBILLNO.Text = String.Empty; tbxMEMO.Text = String.Empty; ddlFLAG.SelectedValue = "N"; dpkPDRQ.Enabled = true; tbxBILLNO.Enabled = true; tbxMEMO.Enabled = true; GridGoods.SummaryData = null; dpkSHRQ.SelectedDate = null; dpkSPRQ.SelectedDate = null; ddlSHR.SelectedValue = ""; ddlSPR.SelectedValue = ""; ddlPDTYPE.Enabled = true; ddlPDTYPE.SelectedValue = "1"; ddlISPH.Enabled = true; ddlISPH.SelectedValue = "Y"; ddlCZY.Enabled = true; lstLRRQ1.SelectedDate = DateTime.Now.AddDays(-1); lstLRRQ2.SelectedDate = DateTime.Now; dpkPDRQ.SelectedDate = DateTime.Now; dpkLRRQ.SelectedDate = DateTime.Now; ddlLRY.SelectedValue = UserAction.UserID; ddlCZY.SelectedValue = UserAction.UserID; PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); btnDel.Enabled = false; btnSave.Enabled = true; btnAudit.Enabled = false; btnDelRow.Enabled = true; btnPrint.Enabled = true; }
protected override void billOpen(string strBillno) { //表头进行赋值 DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0]; PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]); //表体赋值 DataTable dtBill = DbHelperOra.Query(string.Format(strLisSQL, strBillno)).Tables[0]; PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); decimal bzslTotal = 0, feeTotal = 0, ddslTotal = 0; if (dtBill != null && dtBill.Rows.Count > 0) { foreach (DataRow row in dtBill.Rows) { //PubFunc.GridRowAdd(GridGoods, row, false); ddslTotal += Convert.ToDecimal(row["SYSL"]); bzslTotal += Convert.ToDecimal(row["SYHSJE"]); feeTotal += Convert.ToDecimal(row["SYBHSJE"]); } Doc.GridRowAdd(GridGoods, dtBill); } TabStrip1.ActiveTabIndex = 1; PubFunc.Form2Lock(FormDoc, true); //增加合计 JObject summary = new JObject(); summary.Add("NAME", "本页合计"); summary.Add("SYSL", ddslTotal.ToString()); summary.Add("SYHSJE", bzslTotal.ToString("F2")); summary.Add("SYBHSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; //按钮状态判断 if (ddlFLAG.SelectedValue == "N") { btnDel.Enabled = true; btnSave.Enabled = true; btnAudit.Enabled = true; btnDelRow.Enabled = true; btnPrint.Enabled = true; } else if (ddlFLAG.SelectedValue == "Y") { btnDel.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = true; btnDelRow.Enabled = false; btnPrint.Enabled = false; } else { btnDel.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = false; btnDelRow.Enabled = false; btnPrint.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); } 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; } 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]; 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) { Doc.GridRowAdd(GridGoods, dtBill); foreach (DataRow row in dtBill.Rows) { bzslTotal += Convert.ToDecimal(row["BZSL"]); feeTotal += Convert.ToDecimal(row["HSJJ"]) * Convert.ToDecimal(row["BZSL"]) * Convert.ToDecimal(row["BZHL"]); } } //计算合计数量 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; TabStrip1.ActiveTabIndex = 1; //根据状态屏蔽按钮 if (docFLAG.SelectedValue == "N") { docMEMO.Enabled = true; btnPrint.Enabled = false; btnDel.Enabled = true; btnSave.Enabled = true; btnAudit.Enabled = true; btnDelRow.Enabled = true; btnGoods.Enabled = true; } else if (docFLAG.SelectedValue == "Y") { btnPrint.Enabled = true; btnDel.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = false; btnDelRow.Enabled = false; btnGoods.Enabled = false; } else { btnPrint.Enabled = false; btnDel.Enabled = false; btnSave.Enabled = false; btnAudit.Enabled = false; btnDelRow.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(string.Format("未在系统中查询到单据【{0}】!", strBillno), "消息提示", MessageBoxIcon.Warning); return; } 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) { //LoadGridRow(row, false, "OLD"); 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 == "M") { btnSave.Enabled = true; btnAudit.Enabled = true; btnPrint.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; tbxBARCODE.Enabled = true; } else { btnSave.Enabled = false; btnAudit.Enabled = false; btnPrint.Enabled = true; btnDelRow.Enabled = false; btnGoods.Enabled = false; } }
private void DataInit() { //docDEPTOUT.Enabled = true; //docCATID.Enabled = true; ddlTYPE.Enabled = true; docDEPTID.Enabled = true; docGROUPNAME.Enabled = true; PubFunc.FormDataClear(FormCond); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); }
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()); string deptout = DbHelperOra.GetSingle("select deptout from DAT_DB_DOC t where seqno = '" + strBillno + "'").ToString(); DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno, deptout)).Tables[0]; decimal bzslTotal = 0, feeTotal = 0; if (dtBill != null && dtBill.Rows.Count > 0) { foreach (DataRow row in dtBill.Rows) { bzslTotal += Convert.ToDecimal(row["BZSL"]); feeTotal += Convert.ToDecimal(row["BZSL"]) * Convert.ToDecimal(row["HSJJ"]) * Convert.ToDecimal(row["BZHL"]); //LoadGridRow(row, false, "OLD"); } /* * 修 改 人 :袁鹏 修改时间:2015-03-20 * 信息说明:这种加载方法比LoadGridRow(row, false, "OLD")更高效 * 研发组织:威高讯通信息科技有限公司 */ 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, ""); GridGoods.AllowCellEditing = false; if (docFLAG.SelectedValue == "N" || docFLAG.SelectedValue == "R") { btnSave.Enabled = true; btnDel.Enabled = true; btnAudit.Enabled = true; btnDelRow.Enabled = true; btnGoods.Enabled = true; } else { btnDel.Enabled = false; btnAudit.Enabled = false; btnDelRow.Enabled = false; btnGoods.Enabled = false; btnSave.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; } PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; decimal bzslTotal = 0, feeTotal = 0, dhslTotal = 0; if (dtBill != null && dtBill.Rows.Count > 0) { foreach (DataRow row in dtBill.Rows) { bzslTotal += Convert.ToDecimal(row["BZSL"] ?? "0"); feeTotal += Convert.ToDecimal(row["BZSL"] ?? "0") * Convert.ToDecimal(row["HSJJ"] ?? "0"); dhslTotal += Convert.ToDecimal(row["BZSL"] ?? "0") * Convert.ToDecimal(row["BZHL"] ?? "0"); //LoadGridRow(row, false, "OLD"); } /* * 修 改 人 :袁鹏 修改时间:2015-03-20 * 信息说明:这种加载方法比LoadGridRow(row, false, "OLD")更高效 * 研发组织:威高讯通信息科技有限公司 */ PubFunc.GridRowAdd(GridGoods, dtBill); } //增加合计 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; PubFunc.FormLock(FormDoc, true, ""); TabStrip1.ActiveTabIndex = 1; if (docFLAG.SelectedValue == "F") { btnCancel.Enabled = false; } else { btnCancel.Enabled = true; } }
protected override void billOpen(string strBillno) { string strDocSql = "SELECT A.*,F_GETUSERNAME(A.SQR) SQRCN,F_GETUSERNAME(A.LRY) LRYCN,F_GETUSERNAME(A.SHR) SHRCN FROM DAT_TJ_DOC A WHERE A.SEQNO ='{0}'"; string strComSql = @"SELECT A.*, F_GETUNITNAME(A.UNIT) UNITNAME,F_GETPRODUCERNAME(B.PRODUCER) PRODUCERNAME,F_GETUNITNAME(B.UNIT) UNITNAME FROM DAT_TJ_COM A,DOC_GOODS B WHERE SEQNO ='{0}' AND A.GDSEQ = B.GDSEQ ORDER BY ROWNO"; DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0]; if (dtDoc != null && dtDoc.Rows.Count > 0) { PubFunc.FormDataSet(FormPrice, dtDoc.Rows[0]); } else { Alert.Show("单据信息获取失败!!!", "警告提示", MessageBoxIcon.Warning); return; } PubFunc.FormLock(FormPrice, true, ""); if (docFLAG.SelectedValue == "M" || docFLAG.SelectedValue == "R") { btnSave.Enabled = true; btnSubmit.Enabled = true; btnDelRow.Enabled = true; btnGoods.Enabled = true; btnAudit.Enabled = false; doxMEMO.Enabled = true; } else if (docFLAG.SelectedValue == "N" || docFLAG.SelectedValue == "G") { btnSave.Enabled = false; btnSubmit.Enabled = false; btnDelRow.Enabled = false; btnGoods.Enabled = false; btnAudit.Enabled = true; } else { btnSave.Enabled = false; btnSubmit.Enabled = false; btnDelRow.Enabled = false; btnGoods.Enabled = false; btnAudit.Enabled = false; } 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); } 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 < 1) { return; } PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); decimal bzslTotal = 0, feeTotal = 0, dhslTotal = 0; DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; if (dtBill != null && dtBill.Rows.Count > 0) { foreach (DataRow row in dtBill.Rows) { //LoadGridRow(row, false, "OLD"); bzslTotal += Convert.ToDecimal(row["BZSL"] ?? "0"); feeTotal += Convert.ToDecimal(row["HSJJ"] ?? "0") * Convert.ToDecimal(row["BZSL"] ?? "0"); dhslTotal += Convert.ToDecimal(row["DHSL"] ?? "0"); } Doc.GridRowAdd(GridGoods, dtBill); } //计算合计数量 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; PubFunc.FormLock(FormDoc, true, ""); TabStrip1.ActiveTabIndex = 1; //按钮状态 if (docFLAG.SelectedValue == "S") { btnSave.Enabled = true; btnBill.Enabled = true; btnPrint.Enabled = false; btnGoods.Enabled = true; } else { btnSave.Enabled = false; btnBill.Enabled = true; btnPrint.Enabled = true; btnGoods.Enabled = false; } }
protected override void billNew() { string strDeptout = docDEPTOUT.SelectedValue; string strDeptid = docDEPTID.SelectedValue; PubFunc.FormDataClear(FormDoc); docFLAG.SelectedValue = "M"; docSLR.SelectedValue = UserAction.UserID; docLRY.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; docSHRQ.SelectedDate = DateTime.Now; docDEPTOUT.SelectedValue = strDeptout; docDEPTID.SelectedValue = strDeptid; docDEPTOUT.Enabled = true; docSLR.Enabled = true; docDEPTID.Enabled = true; docXSRQ.Enabled = true; docMEMO.Enabled = true; //改变按钮状态 BtnPrintJh.Enabled = false; btnPrint.Enabled = false; btnPrintBQ.Enabled = false; btnDel.Enabled = false; btnSave.Enabled = true; btnAudit.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; btnAudit2.Enabled = false; btnRtn.Enabled = false; PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); if (Request.QueryString["tp"] != null && Request.QueryString["tp"].ToString().Trim().Length > 0) { docDEPTOUT.SelectedValue = DbHelperOra.GetSingle("SELECT T.STR2 FROM DOC_GOODSTYPE T WHERE T.CODE=" + Request.QueryString["tp"].ToString()).ToString(); } else { docDEPTOUT.SelectedValue = DbHelperOra.GetSingle("SELECT T.STR2 FROM DOC_GOODSTYPE T WHERE T.CODE='2'").ToString(); } //处理 本页合计 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("CH", "0"); summary.Add("CHJE", "0"); GridGoods.SummaryData = summary; }
protected override void billNew() { ddlFLAG.SelectedValue = "N"; ddlLRY.SelectedValue = UserAction.UserID; dpkLRRQ.SelectedDate = DateTime.Now; ddlDEPTID.Enabled = true; ddlKCTYPE.Enabled = true; tbxBILLNO.Enabled = true; tbxBILLNO.Text = string.Empty; tbxMEMO.Enabled = true; tbxMEMO.Text = string.Empty; GridGoods.SummaryData = null; PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); }
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 override void billNew() { //原单据保存判断 string strDeptID = docDEPTID.SelectedValue; string strDeptOUT = docDEPTOUT.SelectedValue; PubFunc.FormDataClear(FormDoc); docFLAG.SelectedValue = "N"; docLRY.SelectedValue = UserAction.UserID; docSLR.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; docDEPTID.SelectedValue = strDeptID; docDEPTOUT.SelectedValue = strDeptOUT; billLockDoc(false); docMEMO.Enabled = true; docDEPTOUT.Enabled = true; docSLR.Enabled = true; //清空Grid行 PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); btnDel.Enabled = false; btnSave.Enabled = true; btnAudit.Enabled = false; btnCancel.Enabled = false; btnPrt.Enabled = false; btnPrint.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; trbBARCODE.Enabled = true; if (Request.QueryString["tp"] != null && Request.QueryString["tp"].ToString().Trim().Length > 0) { docDEPTOUT.SelectedValue = DbHelperOra.GetSingle("SELECT T.STR2 FROM DOC_GOODSTYPE T WHERE T.CODE=" + Request.QueryString["tp"].ToString()).ToString(); } else { docDEPTOUT.SelectedValue = DbHelperOra.GetSingle("SELECT T.STR2 FROM DOC_GOODSTYPE T WHERE T.CODE='2'").ToString(); } //计算合计数量 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", "0"); summary.Add("HSJE", "0"); summary.Add("DHSL", "0"); GridGoods.SummaryData = summary; }
protected void btnNew_Click(object sender, EventArgs e) { PubFunc.FormDataClear(FormDoc); //// 20150919 modify by zhanghaicheng ////20150921 6448版本缺少 add by zhanghaicheng //docLRY.SelectedValue = UserAction.UserID; ////docSHR.SelectedValue = UserAction.UserID; //docLRRQ.SelectedDate = DateTime.Now; //docSHRQ.SelectedDate = null; //nbxYSSL.Text = "1"; //docFLAG.SelectedValue = "M"; //// docYSRQ.Text = DateTime.Now.ToString("yyyy") + "-" + ddlMonth.SelectedValue + "-" + "01"; //// docYSRQ.Text = Convert.ToDateTime(docYSRQ.Text).AddMonths(1).ToString("YYYY-MM"); //docYSRQ.Text = DateTime.Now.AddMonths(1).ToString("yyyy-MM"); initData(); //20150919 modify by zhanghaicheng // dpkRQSJ1.Enabled = true; // dpkRQSJ2.Enabled = true; docMEMO.Enabled = true; btnGenerate.Enabled = true; btnSave.Enabled = false; btnSumbit.Enabled = false; btnAudit.Enabled = false; btnCancel.Enabled = false; btnPrint.Enabled = false; btnExport.Enabled = false; btnDelRow.Enabled = false; JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("DHS", "0"); summary.Add("HSJE", "0"); GridGoods.SummaryData = summary; //20150919 modify by zhanghaicheng //docYSRQ.Text = DateTime.Now.ToString("yyyy") + "-" + ddlMonth.SelectedValue.ToString(); //Convert.ToDateTime(dpkRQSJ2.Text).Year.ToString() + "-" + Convert.ToDateTime(dpkRQSJ2.Text).AddMonths(1).Month.ToString(); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); }
private void DetailSearch(string strBillno, string strBillType) { PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); DataTable dtBill = new DataTable(); if (strBillType == "RKD") { dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0]; } else { string th_sql = @"SELECT A.SEQNO,A.ROWNO,A.DEPTID,A.GDSEQ,A.BARCODE,A.GDNAME,A.UNIT,A.GDSPEC,A.GDMODE,A.CDID,'' SPLB,A.CATID,A.HWID,A.BZHL,A.BZSL, A.THSL DDSL,A.SSSL,A.JXTAX,A.HSJJ,A.BHSJJ,A.HSJE,A.BHSJE,A.LSJ,A.LSJE,B.ISGZ,A.ISLOT,A.PHID,A.PH, A.PZWH,TO_CHAR(A.RQ_SC,'YYYY-MM-DD') RQ_SC, TO_CHAR(A.YXQZ,'YYYY-MM-DD') YXQZ,A.KCSL,A.KCHSJE,A.SPZTSL,A.ERPAYXS,A.HLKC,A.ZPBH,A.STR1,A.STR2,A.STR3,A.NUM1,A.NUM2, A.NUM3,A.MEMO, F_GETUNITNAME(A.UNIT) UNITNAME,F_GETUNITNAME(B.UNIT) UNITSMALLNAME,'' MJRQ,'' MJPH,'' MJXQ, A.PRODUCER,f_getproducername(A.PRODUCER) PRODUCERNAME,A.SUPID,f_getsupname(a.supid) supname FROM DAT_TH_COM A, DOC_GOODS B WHERE SEQNO = '{0}' AND A.GDSEQ = B.GDSEQ ORDER BY A.ROWNO "; dtBill = DbHelperOra.Query(string.Format(th_sql, 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(Convert.ToString(row["HSJJ"])) * Convert.ToDecimal(Convert.ToString(row["BZSL"] ?? "0")) * Convert.ToDecimal(Convert.ToString(row["SSSL"] ?? "0")); feeTotal += Convert.ToDecimal(row["HSJJ"]) * Convert.ToDecimal(row["BZSL"] ?? "0"); } row["HSJE"] = Convert.ToDecimal(row["HSJE"]).ToString("F2"); } Doc.GridRowAdd(GridGoods, dtBill); //计算合计数量 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("DDSL", ddslTotal.ToString()); summary.Add("BZSL", bzslTotal.ToString()); summary.Add("HSJE", feeTotal.ToString("F2")); GridGoods.SummaryData = summary; } }
protected override void billNew() { PubFunc.FormDataClear(FormDoc); docFLAG.SelectedValue = "N"; docSLR.SelectedValue = UserAction.UserID; docLRY.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; docDEPTOUT.Enabled = true; docSLR.Enabled = true; docDEPTID.Enabled = true; docXSRQ.Enabled = true; docMEMO.Enabled = true; PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); }
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 override void billNew() { //原单据保存判断 string strDeptID = docDEPTID.SelectedValue; PubFunc.FormDataClear(FormDoc); docFLAG.SelectedValue = "M"; docLRY.SelectedValue = UserAction.UserID; docCGY.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docTHRQ.SelectedDate = DateTime.Now; docDEPTID.SelectedValue = strDeptID; billLockDoc(false); docMEMO.Enabled = true; docCGY.Enabled = true; //清空Grid行 PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); btnDel.Enabled = false; btnSave.Enabled = true; docPSSID.Enabled = true; docTHTYPE.Enabled = true; btnCommit.Enabled = false; btnAudit.Enabled = false; btnCancel.Enabled = false; btnPrt.Enabled = false; btnPrint.Enabled = false; btnDelRow.Enabled = true; btnGoods.Enabled = true; trbBARCODE.Enabled = true; //计算合计数量 JObject summary = new JObject(); summary.Add("GDNAME", "本页合计"); summary.Add("BZSL", "0"); summary.Add("HSJE", "0"); summary.Add("DHSL", "0"); GridGoods.SummaryData = summary; }
protected override void billNew() { string strDept = docDEPTID.SelectedValue; string strDeptOut = docDEPTOUT.SelectedValue; if (PubFunc.StrIsEmpty(strDept)) { if (docDEPTID.Items.Count > 2) { strDept = docDEPTID.Items[1].Value; } } if (PubFunc.StrIsEmpty(strDeptOut)) { if (docDEPTOUT.Items.Count > 2) { strDeptOut = docDEPTOUT.Items[1].Value; } } PubFunc.FormDataClear(FormDoc); docFLAG.SelectedValue = "N"; docSLR.SelectedValue = UserAction.UserID; docLRY.SelectedValue = UserAction.UserID; docLRRQ.SelectedDate = DateTime.Now; docXSRQ.SelectedDate = DateTime.Now; docDEPTID.SelectedValue = strDept; billLockDoc(false); btnSave.Enabled = true; btnDelRow.Enabled = true; btnGoods.Enabled = true; btnDel.Enabled = false; btnAudit.Enabled = false; GridGoods.SummaryData = null; docSEQNO.Enabled = true; docBILLNO.Text = string.Empty; PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); }
protected void btnDel_Click(object sender, EventArgs e) { if (GridStrategy.SelectedRowIndexArray.Length < 1) { Alert.Show("请选择要删除的模板信息!", "消息提示", MessageBoxIcon.Warning); return; } string ids = ""; foreach (int index in GridStrategy.SelectedRowIndexArray) { ids = ids + GridStrategy.Rows[index].DataKeys[2].ToString() + ","; } DbHelperOra.ExecuteSql("DELETE FROM DOC_GROUPDOC WHERE GROUPID IN ('" + ids.Trim(',').Replace(",", "','") + "')"); DbHelperOra.ExecuteSql("DELETE FROM DOC_GROUPCOM WHERE GROUPID IN ('" + ids.Trim(',').Replace(",", "','") + "')"); PubFunc.FormDataClear(FormCond); PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference()); DataQuery(); Alert.ShowInTop("模板删除成功!", "消息提示", MessageBoxIcon.Warning); }