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 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; }