protected void btnListar_Click(object sender, EventArgs e)
{
DataSet dsReunion = proxy.WebLeerReunionds();
GridLis.DataSource = dsReunion.Tables[0];
GridLis.DataBind();
}
protected override void billDel()
{
if (string.IsNullOrWhiteSpace(docBILLNO.Text))
{
Alert.Show("单据为空，无法执行【删除操作】");
return;
}
string strFLAG = docFLAG.SelectedValue;
if (strFLAG != "M")
{
Alert.Show("单据号【" + docBILLNO.Text + "】状态不正确，无法执行【删除】操作。");
return;
}
DbHelperOra.Exists(string.Format("delete from dat_yh_doc where seqno = '{0}'", docBILLNO.Text));
DbHelperOra.Exists(string.Format("delete from dat_yh_com where seqno = '{0}'", docBILLNO.Text));
Alert.Show("单据号【" + docBILLNO.Text + "】删除成功");
OperLog("在库养护", "删除单据【" + docBILLNO.Text + "】");
//btnSear_Click(null, null);
PubFunc.FormDataClear(Formlis);
GridLis.DataSource = null;
GridLis.DataBind();
btnSear_Click(null, null);
}
protected void btnListar_Click(object sender, EventArgs e)
{
DataSet dsDocente = proxy.WebLeerDocentes();
GridLis.DataSource = dsDocente.Tables[0];
GridLis.DataBind();
}
protected void btnListar_Click(object sender, EventArgs e)
{
DataSet dsActividad = proxy.WebLeerActividadds();
GridLis.DataSource = dsActividad.Tables[0];
GridLis.DataBind();
}
protected void billOpen(string DEPTID, string Pssid, string datestart, string dateend)
{
//表头赋值
dpkBEGRQ.SelectedDate = Convert.ToDateTime(datestart);
ddlDEPTID.SelectedValue = DEPTID;
dpkENDRQ.SelectedDate = Convert.ToDateTime(dateend);
ddlSUPID.SelectedValue = Pssid;
string strComSql = "";
if (Request.QueryString["oper"].ToString() == "rk")
{
strComSql = @"SELECT A.*,f_getusername(NVL(B.LRY,C.LRY)) LRYNAME,f_getusername(NVL(B.SHR,C.SHR)) SHRNAME,NVL(B.LRRQ,C.LRRQ) LRRQ,NVL(B.SHRQ,C.SHRQ) SHRQ FROM
(SELECT A.BILLNO,A.BILLTYPE,F_GET_BILLTYPENAME(BILLTYPE) BILLTYPENAME,f_getdeptname(A.DEPTID) DEPTNAME,SUM(A.JSJE + A.THJE) JE,A.PSSID
FROM VIEW_JS A WHERE A.DEPTID = '{0}' AND A.RQSJ BETWEEN TO_DATE('{1}','yyyy-MM-dd') AND TO_DATE('{2}','yyyy-MM-dd') + 1 AND A.TYPE = 'RKJ' AND NVL(A.STR1,'#') = '#'
GROUP BY A.BILLNO,A.BILLTYPE,A.DEPTID,A.PSSID) A,DAT_RK_DOC B,DAT_TH_DOC C
WHERE A.BILLNO = B.SEQNO(+) AND A.BILLNO = C.SEQNO(+) AND A.PSSID = '{3}' ";
}
else if (Request.QueryString["oper"].ToString() == "ck")
{
strComSql = @"SELECT A.*,f_getusername(NVL(NVL(B.LRY,C.LRY),D.LRY)) LRYNAME,f_getusername(NVL(NVL(B.SHR,C.SHR),D.SHR)) SHRNAME,NVL(NVL(B.LRRQ,C.LRRQ),D.LRRQ) LRRQ,NVL(NVL(B.SHRQ,C.SHRQ),D.SHRQ) SHRQ FROM
(SELECT A.BILLNO,A.BILLTYPE,F_GET_BILLTYPENAME(BILLTYPE) BILLTYPENAME,f_getdeptname(A.DEPTID) DEPTNAME,SUM(A.JSJE + A.THJE) JE,A.PSSID
FROM VIEW_JS A WHERE A.DEPTID = '{0}' AND A.RQSJ BETWEEN TO_DATE('{1}','yyyy-MM-dd') AND TO_DATE('{2}','yyyy-MM-dd') + 1 AND A.TYPE = 'CKJ' AND NVL(A.STR1,'#') = '#'
GROUP BY A.BILLNO,A.BILLTYPE,A.DEPTID,A.PSSID) A,DAT_CK_DOC B,DAT_KD_DOC C,DAT_XS_DOC D
WHERE A.BILLNO = B.SEQNO(+) AND A.BILLNO = C.SEQNO(+) AND A.BILLNO = D.SEQNO(+) AND A.PSSID = '{3}' ";
}
else
{
strComSql = @"SELECT A.*,f_getusername(B.LRY) LRYNAME,f_getusername(B.SHR) SHRNAME,B.LRRQ LRRQ,B.SHRQ SHRQ FROM
(SELECT A.BILLNO,A.BILLTYPE,F_GET_BILLTYPENAME(BILLTYPE) BILLTYPENAME,f_getdeptname(A.DEPTID) DEPTNAME,SUM(A.JSJE + A.THJE) JE,A.PSSID
FROM VIEW_JS A WHERE A.DEPTID = '{0}' AND A.RQSJ BETWEEN TO_DATE('{1}','yyyy-MM-dd') AND TO_DATE('{2}','yyyy-MM-dd') + 1 AND A.TYPE = 'XSJ' AND NVL(A.STR1,'#') = '#'
GROUP BY A.BILLNO,A.BILLTYPE,A.DEPTID,A.PSSID) A,DAT_XS_DOC B
WHERE A.BILLNO = B.SEQNO(+) AND A.PSSID = '{3}' ";
}
//表体赋值
DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, DEPTID, datestart, dateend, Pssid)).Tables[0];
GridLis.DataSource = dtBill;
GridLis.DataBind();
//计算合计数量
decimal bzslTotal = 0;
foreach (DataRow row in dtBill.Rows)
{
bzslTotal += Convert.ToDecimal(row["JE"]);
}
JObject summary = new JObject();
summary.Add("BILLNO", "本页合计");
summary.Add("JE", bzslTotal.ToString("F2"));
GridLis.SummaryData = summary;
TabStrip1.ActiveTabIndex = 1;
}