private void AuditorDataBind(int depID, string yearmonth)
    {
        DataTable dt = null;

        if (depID == 0)
        {
            dt = BGApplyReimburManager.GetApplyReimburAll(yearmonth);
        }
        else
        {
            dt = BGApplyReimburManager.GetApplyReimburSByDepID(depID, yearmonth);
        }
        if (dt.Rows.Count > 0)
        {
            btnexport.Enabled = true;
        }
        else
        {
            string message = "没有查询到数据";
            Response.Write("<script language=javascript>alert(\"" + message.Trim() + "\");window.top.close();</script>");
            btnexport.Enabled = false;
        }
        RepLeaderQuery.DataSource = dt;
        RepLeaderQuery.DataBind();
    }
예제 #2
0
    protected void repReiStaQue_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        string arid = e.CommandArgument.ToString();

        if (e.CommandName == "AltPro")
        {
            //修改
            Response.Redirect("ApplyAlter.aspx?arid=" + arid, true);
        }
        else if (e.CommandName == "DelPro")
        {
            //删除
            BGApplyReimburManager.DelApplyReimbur(arid);
            string yearmonth = ddlYear.Text.Trim() + "-" + ddlMonth.Text.Trim();
            BGApplyReimburDataBind(depID, yearmonth);
        }
        else if (e.CommandName == "lbtnTJ")
        {
            ////提交
            //if (BGApplyReimburManager.UpdApplication("退回", txtReason.Text, idStrs))
            //{
            //    int year = Utils.IntSafeConvert(ddlYear.SelectedValue);
            //    BGApplyReimburDataBind(depID, year);
            //}
            if (BGApplyReimburManager.UpdApplicationStatus("提交", arid))
            {
                string yearmonth = ddlYear.Text.Trim() + "-" + ddlMonth.Text.Trim();
                BGApplyReimburDataBind(depID, yearmonth);
            }
        }
    }
    protected void btnexport_Click(object sender, EventArgs e)
    {
        string yearmonth = ddlyear.Text.Trim() + "-" + ddlmonth.Text.Trim();

        depID = Utils.IntSafeConvert(ddlDep.SelectedValue);
        DataTable dt;

        if (depID == 0)
        {
            dt = BGApplyReimburManager.GetApplyReimburAllExport(yearmonth);
        }
        else
        {
            dt = BGApplyReimburManager.GetApplyReimburSByDepID(depID, yearmonth);
        }
        if (dt != null && dt.Rows.Count > 0)
        {
            MemoryStream ms = ExcelRender.RenderToExcelSetHead(dt, "申请时间#报销单号#上报单位#经办人#金额#事由#申请单状态");
            Response.ContentType = "application/xls";
            Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("报销单历史查询.xls", System.Text.Encoding.UTF8));
            Response.BinaryWrite(ms.ToArray());
            Response.End();
        }
        else
        {
            this.Response.Write("<script>alert('无数据不允许导出')</script>");
        }
    }
예제 #4
0
    private void BGApplyReimburDataBind(int depID, string yearmonth)
    {
        lbshow.Text = "";
        DataTable dt = BGApplyReimburManager.GetByDepID(depID, yearmonth);

        if (dt.Rows.Count == 0)
        {
            lbshow.Text = "该月没查询到数据。";
        }
        repReiStaQue.DataSource = dt;
        repReiStaQue.DataBind();
    }
 protected void btnReturn_Click(object sender, EventArgs e)
 {
     txtReason.Enabled = true;
     //string idStrs = null;
     //if()
     if (BGApplyReimburManager.UpdApplication("退回", txtReason.Text, arid))
     {
         Response.Redirect("ReimApproval.aspx", true);
     }
     else
     {
     }
 }
예제 #6
0
    protected void btnApp_Click(object sender, EventArgs e)
    {
        string idStrs = GetDelIDList(repReimAppList, "chkArid");

        if (BGApplyReimburManager.UpdApplicationStatus("审核通过", idStrs))
        {
            //int year = Utils.IntSafeConvert(ddlyear.SelectedValue);
            repReimAppListBind();
            //BGApplyReimburDataBind(depID,year);
        }
        else
        {
        }
    }
예제 #7
0
    private void AuditorDataBind(int depID, string yearmonth)
    {
        DataTable dt = BGApplyReimburManager.GetApplyReimburSByDepID(depID, yearmonth);

        if (dt.Rows.Count <= 0)
        {
            string message = "没有查询到数据";
            Response.Write("<script language=javascript>alert(\"" + message.Trim() + "\");window.top.close();</script>");
        }
        else
        {
            repReiStaQue.DataSource = dt;
            repReiStaQue.DataBind();
        }
    }
    protected void btnAudit_Click(object sender, EventArgs e)
    {
        int Subcoding = 0;

        string artype = "";

        if (rdBase.Checked == true)
        {
            artype = "基本支出";
        }
        else
        {
            artype = "项目支出";
        }
        if (ddlType.SelectedItem.Value == "财政拨款")
        {
            if (artype == "基本支出")
            {
                Subcoding = 50010101;
            }
            else
            {
                Subcoding = 50010102;
            }
        }
        else if (ddlType.SelectedItem.Value == "其他资金")
        {
            if (artype == "基本支出")
            {
                Subcoding = 50010201;
            }
            else
            {
                Subcoding = 50010202;
            }
        }
        string ARExpSub = ddlARExpSub.SelectedItem.Text.ToString();
        int    PIID     = BG_PayIncomeLogic.GetPIIDbycoding(Subcoding, ARExpSub);

        if (BGApplyReimburManager.UpdApplicationStatus1(PIID, "审核通过", artype, arid))
        {
            Response.Redirect("ReimApproval.aspx", true);
        }
        else
        {
        }
    }
예제 #9
0
    private void BGApplyReimburDataBind(int depID, string yearmonth)
    {
        DataTable dt = BGApplyReimburManager.GetApplyStateByDepID(depID, yearmonth);

        if (dt.Rows.Count > 0)
        {
            btnexport.Enabled = true;
        }
        else
        {
            btnexport.Enabled = false;
            string message = "没有查询到数据";
            Response.Write("<script language=javascript>alert(\"" + message.Trim() + "\");window.top.close();</script>");
        }
        repReiStaQue.DataSource = dt;
        repReiStaQue.DataBind();
    }
    private void ApplyAlterDataBind()
    {
        DataTable dt = BGApplyReimburManager.GetApplyReimbur(arid); //BGPayIncomeManager.GetPayIncomeListByPIID(arid)

        if (dt.Rows.Count > 0)
        {
            //string PiName = dt.Rows[0]["PIEcoSubName"].ToString();
            //txtPro.Text = PiName;
            //ddlDepart.Text = dt.Rows[0]["DepID"].ToString();
            //txtARReiSinNum.Text = dt.Rows[0]["ARReiSinNum"].ToString();
            //ddlARExpType.Text = dt.Rows[0]["ARExpType"].ToString();
            //ddlARExpPro.SelectedItem.Value = dt.Rows[0]["ARExpPro"].ToString();
            txtBITime.Text     = dt.Rows[0]["ARTime"].ToString();
            txtARRepDep.Text   = dt.Rows[0]["ARRepDep"].ToString();
            txtARAgent.Text    = dt.Rows[0]["ARAgent"].ToString();
            txtARMon.Text      = Convert.ToDecimal(dt.Rows[0]["ARMon"]).ToString("f8").TrimEnd('0').TrimEnd('.');
            txtARExcu.Text     = dt.Rows[0]["ARExcu"].ToString();
            txtreason.Text     = dt.Rows[0]["ARReason"].ToString();
            txtreason.ReadOnly = true;
            string name = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(dt.Rows[0]["PPID"].ToString())).PIEcoSubName;
            ddlARExpSub.SelectedItem.Text = name;
            Session["PIID"] = common.IntSafeConvert(dt.Rows[0]["PPID"].ToString());

            DataTable dt1    = BGReimDocumentsManager.GetReimDocuments(arid);
            string    RDType = string.Empty;
            if (dt1.Rows.Count > 0)
            {
                RDType        = dt1.Rows[0]["RDType"].ToString();
                lbRDType.Text = RDType;
            }

            //if (RDType == "")
            //{
            //    Response.Redirect("SearchTravelCost.aspx?arid=" + arid, true);
            //}
            //else if (RDType == "")
            //{
            //    Response.Redirect("SearchMediCost.aspx?arid=" + arid, true);
            //}
            //else if (RDType == "")
            //{
            //    Response.Redirect("SearchOtherCost.aspx?arid=" + arid, true);
            //}
        }
    }
예제 #11
0
    private void BGApplyReimburDataBind(int depID, string yearmonth)
    {
        DataTable dt = null;

        if (depID == 0)
        {
            dt = BGApplyReimburManager.GetApplyReimburByAll(yearmonth);
        }
        else
        {
            dt = BGApplyReimburManager.GetApplyReimburTByDepID(depID, yearmonth);
        }
        if (dt.Rows.Count <= 0)
        {
            string message = "没有查询到数据";
            Response.Write("<script language=javascript>alert(\"" + message.Trim() + "\");window.top.close();</script>");
        }
        else
        {
            repReimAppList.DataSource = GetSortDT(dt);
            repReimAppList.DataBind();
        }
    }
    protected void btnAlter_Click(object sender, EventArgs e)
    {
        BG_ApplyReimbur bt = new BG_ApplyReimbur();

        bt.ARID    = Utils.IntSafeConvert(arid);
        bt.ARAgent = txtARAgent.Text.Trim();                    //经办人
        bt.ARExcu  = txtARExcu.Text.Trim();                     //事由
        bt.PPID    = Utils.IntSafeConvert(Session["PIID"]);     //支出项目ID
        //bt.ARExpType = ddlARExpType.SelectedValue;                      //支出类型
        bt.ARListSta   = "未提交";                                 //申请表状态
        bt.ARMon       = decimal.Parse(txtARMon.Text.Trim());   //金额
        bt.ARReiSinNum = txtARReiSinNum.Text.Trim();            //报销单号
        bt.ARRepDep    = txtARRepDep.Text.Trim();               //上报部门
        bt.ARTime      = DateTime.Parse(txtBITime.Text.Trim()); //申请时间
        bt.DepID       = DepID;                                 //部门

        BGApplyReimburManager.UpdApplyReimbur(bt);
        string message = "修改成功!";

        Response.Write("<script language=javascript>alert(\"" + message.Trim() + "\");window.top.close();</script>");
        //Response.Redirect("ApplyList.aspx", true);
        btnAlter.Enabled = true;
    }