コード例 #1
0
    protected void btnListar_Click(object sender, EventArgs e)
    {
        DataSet dsReunion = proxy.WebLeerReunionds();

        GridLis.DataSource = dsReunion.Tables[0];
        GridLis.DataBind();
    }
コード例 #2
0
ファイル: LibraryMaintain.aspx.cs プロジェクト: cjllove/ERP
        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);
        }
コード例 #3
0
    protected void btnListar_Click(object sender, EventArgs e)
    {
        DataSet dsDocente = proxy.WebLeerDocentes();

        GridLis.DataSource = dsDocente.Tables[0];
        GridLis.DataBind();
    }
コード例 #4
0
    protected void btnListar_Click(object sender, EventArgs e)
    {
        DataSet dsActividad = proxy.WebLeerActividadds();

        GridLis.DataSource = dsActividad.Tables[0];
        GridLis.DataBind();
    }
コード例 #5
0
        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;
        }