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