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 void btnadd_Click(object sender, EventArgs e)
{
//if (PubFunc.FormDataCheck(FormDoc).Length > 1) return;
tgbDept.Text = "";
PubFunc.Form2Lock(FormDoc, true);
string sql = @"select SP.*,f_getusername(manager) managername from SYS_DEPT SP WHERE SP.FLAG='Y'
and F_CHK_DATARANGE(CODE, '{0}') = 'Y'
ORDER BY SP.CODE";
GridLot.DataSource = DbHelperOra.Query(String.Format(sql, UserAction.UserID)).Tables[0];
GridLot.DataBind();
WindowLot.Hidden = false;
}
