Beispiel #1
0
    private void repTraBind(int budid, int pageIndex)
    {
        int       RecordCount = 0;
        int       PageSize    = TraPager.PageSize;
        DataTable dt          = BGBudItemHisManage.GetDtBIHisByBudid(budid, PageSize, pageIndex, out RecordCount);

        TraPager.RecordCount      = RecordCount;
        TraPager.CurrentPageIndex = pageIndex + 1;
        repTra.DataSource         = dt;
        repTra.DataBind();
    }
    /// <summary>
    /// 绑定数据
    /// </summary>
    private DataTable Bind()
    {
        depId = common.IntSafeConvert(cbDepment.SelectedItem.Value);
        int       year = common.IntSafeConvert(cmbyear.SelectedItem.Value);
        DataTable dt   = BGBudItemsManager.GetApplyReimburByDepID(depId, year, "提交");

        dt.Columns.Add("ReportNum");
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            dt.Rows[i]["ReportNum"] = BGBudItemHisManage.GetBIReportNumByBudid(common.IntSafeConvert(dt.Rows[i]["BudID"]));
        }
        stBudget.DataSource = getnew(dt);
        stBudget.DataBind();
        return(dt);
    }
Beispiel #3
0
    protected void btnSure_Click(object sender, EventArgs e)
    {
        BG_BudItems bi = new BG_BudItems();

        bi.BIAppConMon     = 0;// decimal.Parse(txtBudConNumber.Text.Trim());审批控制金额,应该是预算控制数
        bi.BIAppReaCon     = txtBIAppReaCon1.Text.Trim();
        bi.BIAttr          = ddlProProper1.SelectedValue;
        bi.BIBudSta        = "等下对接";                     //Session[Constant.UserName].ToString();
        bi.BICause         = "";                         //退回原因
        bi.BICharger       = txtBICharger1.Text.Trim();
        bi.BICode          = txtItemNumber1.Text.Trim(); //项目编号
        bi.BIEndTime       = DateTime.Parse(txtBIEndTime1.Text.Trim());
        bi.BIExpGistExp    = txtBIExpGistExp1.Text.Trim();
        bi.BIFinAllo       = 0;                                        // decimal.Parse(txtBudConNumber.Text.Trim());财政拨款
        bi.BIFunSub        = ddlFunSub1.Text.Trim();
        bi.BILastYearCarry = 0;                                        // decimal.Parse(txtBudConNumber.Text.Trim());上年结账
        bi.BILongGoal      = txtBILongGoal1.Text.Trim();
        bi.BIMon           = common.IntSafeConvert(HidMonTotal.Value); //GetBIMon(coll.GetValues("txt4"));
        bi.BIMonSou        = "";                                       //资金来源
        bi.BIOthExpProb    = txtBIOthExpProb1.Text.Trim();
        bi.BIOthFun        = 0;                                        // decimal.Parse(txtBudConNumber.Text.Trim());其他资金
        bi.BIPlanHz        = ddlBIPlanHz1.SelectedValue;               //项目频度
        bi.BIProType       = ddlPayProType1.SelectedItem.Text;
        bi.BIStaTime       = DateTime.Parse(txtBIStaTime1.Text.Trim());
        bi.BIYearGoal      = txtBIYearGoal1.Text.Trim();
        bi.PPID            = common.IntSafeConvert(ddlPayProType1.SelectedValue);       //
        bi.BudSta          = "未提交";                                                     //
        bi.PIID            = BG_PayProjectManager.GetBG_PayProjectByPPID(bi.PPID).PIID; //common.IntSafeConvert(ddlFunSub.SelectedValue);//yj
        bi.BIProName       = txtProName1.Text.Trim();
        bi.BIReportTime    = ParseUtil.ToDateTime(txtBITime1.Text.Trim(), DateTime.Now);
        bi.BIConNum        = 0;//预算控制数
        bi.BIProDescrip    = txtProDesc1.Text.Trim();
        bi.DepID           = common.IntSafeConvert(Hiddepid.Value);
        bi.BIProCategory   = ddlProType1.SelectedItem.Text;
        bi.BIYear          = common.IntSafeConvert(txtyear.Text);
        int buid = BG_BudItemsManager.AddBG_BudItems(bi).BudID;//yj

        if (buid > 0)
        {
            BG_BudItemHis hisbi = new BG_BudItemHis();
            hisbi.BudID           = buid;
            hisbi.BIAppConMon     = 0;// decimal.Parse(txtBudConNumber.Text.Trim());审批控制金额,应该是预算控制数
            hisbi.BIAppReaCon     = txtBIAppReaCon.Text.Trim();
            hisbi.BIAttr          = ddlProProper.SelectedValue;
            hisbi.BIBudSta        = "等下对接";                    //Session[Constant.UserName].ToString();
            hisbi.BICause         = "";                        //退回原因
            hisbi.BICharger       = txtBICharger.Text.Trim();
            hisbi.BICode          = txtItemNumber.Text.Trim(); //项目编号
            hisbi.BIEndTime       = DateTime.Parse(txtBIEndTime.Text.Trim());
            hisbi.BIExpGistExp    = txtBIExpGistExp.Text.Trim();
            hisbi.BIFinAllo       = 0;                                        // decimal.Parse(txtBudConNumber.Text.Trim());财政拨款
            hisbi.BIFunSub        = ddlFunSub.Text.Trim();
            hisbi.BILastYearCarry = 0;                                        // decimal.Parse(txtBudConNumber.Text.Trim());上年结账
            hisbi.BILongGoal      = txtBILongGoal.Text.Trim();
            hisbi.BIMon           = common.IntSafeConvert(HidMonTotal.Value); //GetBIMon(coll.GetValues("txt4"));
            hisbi.BIMonSou        = "";                                       //资金来源
            hisbi.BIOthExpProb    = txtBIOthExpProb.Text.Trim();
            hisbi.BIOthFun        = 0;                                        // decimal.Parse(txtBudConNumber.Text.Trim());其他资金
            hisbi.BIPlanHz        = ddlBIPlanHz.SelectedValue;                //项目频度
            hisbi.BIProType       = ddlPayProType.SelectedItem.Text;
            hisbi.BIStaTime       = DateTime.Parse(txtBIStaTime.Text.Trim());
            hisbi.BIYearGoal      = txtBIYearGoal.Text.Trim();
            hisbi.PPID            = common.IntSafeConvert(ddlPayProType.SelectedValue);        //
            hisbi.BudSta          = "未提交";                                                     //
            hisbi.PIID            = BG_PayProjectManager.GetBG_PayProjectByPPID(bi.PPID).PIID; //common.IntSafeConvert(ddlFunSub.SelectedValue);//yj
            hisbi.BIProName       = txtProName.Text.Trim();
            hisbi.BIReportTime    = ParseUtil.ToDateTime(txtBITime.Text.Trim(), DateTime.Now);
            hisbi.BIConNum        = 0;//预算控制数
            hisbi.BIProDescrip    = txtProDesc.Text.Trim();
            hisbi.DepID           = common.IntSafeConvert(Hiddepid.Value);
            hisbi.BIProCategory   = ddlProType.SelectedItem.Text;
            hisbi.BIYear          = common.IntSafeConvert(txtyear.Text);
            int flaid = BG_BudItemHisManager.AddBG_BudItemHis(hisbi).BudHisID;



            NameValueCollection coll = Request.Form;
            string[]            txt1 = coll.GetValues("txt1");      //行号
            string[]            txt2 = coll.GetValues("txt2");      //当前年度
            string[]            txt3 = coll.GetValues("ddlIncome"); //经济科目
            string[]            txt4 = coll.GetValues("txt4");      //总计
            string[]            txt5 = coll.GetValues("txt5");      //小计(财政拨款)
            string[]            txt6 = coll.GetValues("txt6");      //小计(经费)
            string[]            txt7 = coll.GetValues("txt7");      //内部开支(经费)
            string[]            txt8 = coll.GetValues("txt8");      //外部拨款(经费)
            int  rowCount            = common.IntSafeConvert(HidRowCount.Value);
            bool flag = false;
            if (rowCount > 0 && flaid > 0)
            {
                for (int j = 0; j < rowCount; j++)
                {
                    BG_BudCostPro bcp = new BG_BudCostPro();
                    bcp.BudID       = buid;
                    bcp.BCPCurrYear = common.IntSafeConvert(txt2[j]);
                    bcp.BCPRemark   = "";
                    DataTable dtpiid = BG_PayIncomeLogic.GetBG_PayIncomeByname(txt3[j]);
                    int       piid   = common.IntSafeConvert(dtpiid.Rows[0]["PIID"]);
                    bcp.PIID           = piid;
                    bcp.BCPTotal       = ParseUtil.ToDecimal(txt4[j], 0);
                    bcp.BCPSubtFinAllo = ParseUtil.ToDecimal(txt5[j], 0);
                    bcp.BCPSubtExp     = ParseUtil.ToDecimal(txt6[j], 0);
                    bcp.BCInExpenses   = ParseUtil.ToDecimal(txt7[j], 0);
                    bcp.BCOutFunding   = ParseUtil.ToDecimal(txt8[j], 0);
                    flag = BGBudCostProManager.AddBGBudCostPro(bcp);//yj
                }
            }
            if (flag)
            {
                lblShowResult.Text = "添加成功";
                BGBudItemHisManage.InsertBudItemHis(bi);
                string PostUrl = "BudgetEditList.aspx?depid=" + Hiddepid.Value;
                Response.Write("<script language='javascript'>if(confirm('是否继续添加?')){window.location.reload();}else{window.location.href='" + PostUrl + "';}</script>");
            }
            else
            {
                lblShowResult.Text = "操作失败、请检查数据后重试";
            }
        }
        else
        {
            lblShowResult.Text = "操作失败、请检查数据后重试";
        }
    }