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); }
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 = "操作失败、请检查数据后重试"; } }