private void Store1Bind() { int depid = common.IntSafeConvert(cmbdept.SelectedItem.Value); int Month = common.IntSafeConvert(cmbmon.SelectedItem.Value); DataTable dtTable = IncomeContrastpayLogic.GetICPStDTByDepID_Time(depid, Month); if (dtTable.Rows.Count == 0) { if (InComeSouce == null) { return; } foreach (var inComeSouce in InComeSouce) { DataRow dr = dtTable.NewRow(); dr["InComeSouce"] = inComeSouce; dr["InComeMon"] = 0; dr["ICPTime"] = Convert.ToDateTime(CurrentYear + "-" + cmbmon.SelectedItem.Text + "-01"); dr["DepID"] = depid; dr["DepName"] = cmbdept.SelectedItem.Text; dtTable.Rows.Add(dr); } } Store1.DataSource = dtTable; Store1.DataBind(); }
private void DepDataBind() { DepID = ((UserLimStr == "审核员" || UserLimStr == "出纳员") ? AreaDepID : DepID); if (DepID == AreaDepID) { DataTable dt = IncomeContrastpayLogic.GetDepByfadepid(AreaDepID); if (dt == null) { return; } for (int i = 0; i < dt.Rows.Count; i++) { // cmbDepnaem.Items.Add(new Ext.Net.ListItem(depTable.Rows[i]["depName"].ToString(), depTable.Rows[i]["depID"].ToString())); { cmbdept.Items.Add(new Ext.Net.ListItem(dt.Rows[i]["DepName"].ToString(), dt.Rows[i]["DepID"].ToString())); } } } else { cmbdept.Items.Add(new Ext.Net.ListItem(DepName, DepID.ToString())); } cmbdept.Items.Add(new Ext.Net.ListItem("科室业务费", "科室业务费")); cmbdept.Items.Add(new Ext.Net.ListItem("局长基金", "局长基金")); cmbdept.Items.Insert(0, new Ext.Net.ListItem("全部", "0")); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hidRecordCount.Value = IncomeContrastpayLogic.GetRecordCount().ToString(); } ele9.InnerText = IncomeContrastpayLogic.GetUnitByUnitCode(); }
private void DepDataBind() { DataTable dt = IncomeContrastpayLogic.GetDepByfadepid(AreaDepID); if (dt == null) { return; } for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["DepName"].ToString() != "局长基金") { cmbdept.Items.Add(new ListItem(dt.Rows[i]["DepName"].ToString(), dt.Rows[i]["DepID"].ToString())); } } cmbdept.Items.Add(new Ext.Net.ListItem("科室业务费", "科室业务费")); cmbdept.Items.Add(new Ext.Net.ListItem("局长基金", "局长基金")); }
//private void repBudConDataBind(string depname) //{ // DataTable dt = VApplyPayDepartManager.GetVApplyPayDepartByDepName(depname); // repBudCon.DataSource = dt; // repBudCon.DataBind(); //} protected void btnInq_Click(object sender, EventArgs e) { lanotice.Text = ""; string ARTime = ddlyear.Text.Trim() + "-" + DropDownList1.Text.Trim(); string BAAYear = ddlyear.Text.Trim(); DataTable dt2 = IncomeContrastpayLogic.GetARMonByBAAYear(BAAYear); if (dt2.Rows.Count < 1) { lanotice.Text = "查询结果为空!"; repBudCon.DataBind(); } else { DataTable dt = new DataTable(); dt.Columns.Add("DepName"); dt.Columns.Add("ARMon"); dt.Columns.Add("ChangeMon"); dt.Columns.Add("UserMon"); dt.Columns.Add("Pecent"); //dt.Columns.Add(""); for (int i = 0; i < dt2.Rows.Count; i++) { dt.Rows.Add(""); dt.Rows[i]["DepName"] = IncomeContrastpayLogic.GetDepBydepid(dt2.Rows[i]["DepID"].ToString()); dt.Rows[i]["ARMon"] = Convert.ToDecimal(dt2.Rows[i]["BAAMon"]).ToString("f2").TrimEnd('0').TrimEnd('.'); int depid = common.IntSafeConvert(dt2.Rows[i]["DepID"]); DataTable dtsupp = IncomeContrastpayLogic.GetBG_SupplementaryDivide(depid, common.IntSafeConvert(ddlyear.Text.Trim())); dt.Rows[i]["ChangeMon"] = Convert.ToDecimal(dtsupp.Rows[0]["SuppMon"]).ToString("f2").TrimEnd('0').TrimEnd('.'); //DataTable dt1 = BG_ApplyReimburLogic.GetARMonByARTime(ARTime, int.Parse(dt2.Rows[i]["DepID"].ToString())); DataTable dt1 = IncomeContrastpayLogic.GetZXMonByZXTime(ARTime, int.Parse(dt2.Rows[i]["DepID"].ToString())); if (dt1 != null && dt1.Rows.Count > 0 && dt1.Rows[0][0].ToString() != "") { //dt.Rows[i]["Balance"] = (Convert.ToInt32(dt2.Rows[0]["BAAMon"]) - Convert.ToInt32(dt1.Rows[0]["ARMon"])).ToString(); dt.Rows[i]["UserMon"] = ParToDecimal.ParToDel((dt1.Rows[0][0]).ToString()).ToString("f2").TrimEnd('0').TrimEnd('.'); } else { //dt.Rows[i]["Balance"] = dt2.Rows[i]["BAAMon"].ToString(); dt.Rows[i]["UserMon"] = "0"; } if (ParseUtil.ToDecimal(dt.Rows[i]["ARMon"].ToString(), 0) != 0) { decimal usermon = ParseUtil.ToDecimal(dt.Rows[i]["UserMon"].ToString(), 0); decimal armon = ParseUtil.ToDecimal(dt.Rows[i]["ARMon"].ToString(), 0) + ParseUtil.ToDecimal(dt.Rows[i]["ChangeMon"].ToString(), 0); dt.Rows[i]["Pecent"] = ((usermon / armon) * 100).ToString("f2").TrimEnd('0') + "%"; } else { dt.Rows[i]["Pecent"] = "0%"; } } decimal k1 = IncomeContrastpayLogic.GetARmon(ARTime, "科室业务费"); decimal k2 = IncomeContrastpayLogic.GetUserMon(ARTime, "科室业务费"); decimal zj1 = IncomeContrastpayLogic.GetARmonZJ(ARTime, "科室业务费"); decimal j1 = IncomeContrastpayLogic.GetARmon(ARTime, "局长基金"); decimal j2 = IncomeContrastpayLogic.GetUserMon(ARTime, "局长基金"); decimal zj2 = IncomeContrastpayLogic.GetARmonZJ(ARTime, "局长基金"); DataRow dr = dt.NewRow(); dr["DepName"] = "科室业务费"; dr["ARMon"] = k1.ToString("f2"); dr["ChangeMon"] = zj1.ToString("f2"); dr["UserMon"] = k2.ToString("f2"); if (k2 == 0) { dr["Pecent"] = "0.00%"; } else { dr["Pecent"] = k1 + zj1 / k2 * 100 + "%"; } DataRow dr1 = dt.NewRow(); dr1["DepName"] = "局长基金"; dr1["ARMon"] = j1.ToString("f2"); dr1["ChangeMon"] = zj2.ToString("f2"); dr1["UserMon"] = j2.ToString("f2"); if (j2 == 0) { dr1["Pecent"] = "0.00%"; } else { dr1["Pecent"] = j1 + zj2 / j2 * 100 + "%"; } dt.Rows.Add(dr); dt.Rows.Add(dr1); repBudCon.DataSource = dt; repBudCon.DataBind(); } }
private void Store1Bind() { int depid = 0; int Month = 0; DataTable dtTable = new DataTable(); try { depid = common.IntSafeConvert(cmbdept.SelectedItem.Value); Month = common.IntSafeConvert(cmbmon.SelectedItem.Value); } catch { return; } if (cmbdept.SelectedItem.Text == "科室业务费" || cmbdept.SelectedItem.Text == "局长基金") { dtTable = IncomeContrastpayLogic.GetICPDTByDepID_TimeUnit(cmbdept.SelectedItem.Text, Month); } else { dtTable = IncomeContrastpayLogic.GetICPDTByDepID_Time(depid, Month); } dtTable.Columns.Add("PayMon"); for (int i = 0; i < dtTable.Rows.Count; i++) { if (dtTable.Rows[i]["InComeSouce"].ToString() == "财政拨款") { dtTable.Rows[i]["PayMon"] = dtTable.Rows[i]["GKZC"]; } else if (dtTable.Rows[i]["InComeSouce"].ToString() == "地方财政") { dtTable.Rows[i]["PayMon"] = dtTable.Rows[i]["QTZJ"]; } else if (dtTable.Rows[i]["InComeSouce"].ToString() == "其他") { dtTable.Rows[i]["PayMon"] = dtTable.Rows[i]["XJZC"]; } } if (dtTable.Rows.Count == 0) { if (InComeSouce == null) { return; } foreach (var inComeSouce in InComeSouce) { DataRow dr = dtTable.NewRow(); dr["InComeSouce"] = inComeSouce; dr["InComeMon"] = 0; dr["PayMon"] = 0; //dr["BalanceMon"] = 0; dr["ICPTime"] = Convert.ToDateTime(CurrentYear + "-" + cmbmon.SelectedItem.Text + "-01"); dr["DepID"] = depid; dr["DepName"] = cmbdept.SelectedItem.Text; dtTable.Rows.Add(dr); } } Store1.DataSource = GetNewdt(dtTable); Store1.DataBind(); }
/// <summary> /// 绑定数据 /// </summary> private void DtDataBind() { decimal txt = 0; decimal txt1 = 0; int year = Convert.ToInt32(HidYear.Value); int bgmonid = BG_MonLogic.GEtIDisEditMon(common.IntSafeConvert(CurrentYear)); BG_Mon bgMon = BG_MonManager.GetBG_MonByBGID(bgmonid); if (bgMon != null && bgMon.IsEditMon == 1) { txt = bgMon.BGMon; } else { DataTable dt1 = BG_BudItemsLogic.GetPayOne(year); if (dt1.Rows.Count > 0) { txt += ParToDecimal.ParToDel(dt1.Rows[0]["POTitol"].ToString()); } DataTable dt2 = BG_BudItemsLogic.GetPayTwo(year); if (dt1.Rows.Count > 0) { if (dt2.Rows.Count > 0) { txt += ParToDecimal.ParToDel(dt2.Rows[0]["PTTitol"].ToString()); } } DataTable dt3 = BG_BudItemsLogic.GetPubPay(year); if (dt1.Rows.Count > 0) { if (dt3.Rows.Count > 0) { txt += ParToDecimal.ParToDel(dt3.Rows[0]["PBIDTitol"].ToString()); } } DataTable dt4 = BG_BudItemsLogic.GetProPay(year); if (dt4.Rows.Count > 0) { for (int i = 0; i < dt4.Rows.Count; i++) { txt += Convert.ToDecimal(dt4.Rows[i]["ProPA0M"]); } } } txt1 = txt; DataTable dt5 = BG_BudItemsLogic.GetBudgetAllocation(year); if (dt5.Rows.Count > 0) { for (int i = 0; i < dt5.Rows.Count; i++) { txt -= ParToDecimal.ParToDel(dt5.Rows[i]["BAAMon"].ToString()); } } DataTable dtpre = BG_PreLogic.GetBG_PreByyear(common.IntSafeConvert(CurrentYear)); decimal premon = 0; if (dtpre == null || dtpre.Rows.Count == 0) { premon = 0; } else { premon = ParToDecimal.ParToDel(dtpre.Rows[0]["PreMon"].ToString()); } //YTDProvinceMon.Text = (txt1 + premon).ToString("f8").TrimEnd('0').TrimEnd('.'); ////tatal.Value = txt.ToString(); ////YTDProvinceMon.Text = txt.ToString(); //Deserved.Text = (txt1 - txt).ToString("f8").TrimEnd('0').TrimEnd('.'); //ResidualMon.Text = (txt + premon).ToString("f8").TrimEnd('0').TrimEnd('.'); baa.Value = txt.ToString(); DataTable dt = BG_DepartmentLogic.GetAllBG_DepartmentMon(year, DepID); DataTable dt6 = BG_SupplementaryLogic.GetBG_SupplementaryByyear(year); decimal sutxt = 0; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { sutxt += ParToDel(dt.Rows[i]["SuppMon"].ToString()); } } decimal SuppMontotal = 0; if (dt6 == null) { SuppMontotal = 0; ResidualSuppMon.Text = "0"; } else if (dt6.Rows.Count == 0) { SuppMontotal = 0; ResidualSuppMon.Text = "0"; } else { SuppMontotal = ParToDecimal.ParToDel(dt6.Rows[0]["SuppMon"].ToString()); ResidualSuppMon.Text = (SuppMontotal - sutxt).ToString("f8").TrimEnd('0').TrimEnd('.'); } supp.Value = Convert.ToDecimal(ResidualSuppMon.Text); YTDProvinceMon.Text = (txt1 + premon).ToString("f8").TrimEnd('0').TrimEnd('.'); //tatal.Value = txt.ToString(); //YTDProvinceMon.Text = txt.ToString(); Deserved.Text = (txt1 - txt).ToString("f8").TrimEnd('0').TrimEnd('.'); ResidualMon.Text = (txt + premon).ToString("f8").TrimEnd('0').TrimEnd('.'); SuppMon.Text = SuppMontotal.ToString(); BudgetTatol.Text = (txt1 + premon + SuppMontotal).ToString("f8").TrimEnd('0').TrimEnd('.'); YTDDeserved.Text = ((txt1 - txt) + SuppMontotal - ParToDecimal.ParToDel(ResidualSuppMon.Text)).ToString("f8").TrimEnd('0').TrimEnd('.'); YTDResidualMon.Text = (txt + premon + SuppMontotal).ToString("f8").TrimEnd('0').TrimEnd('.'); DataTable dtIc = IncomeContrastpayLogic.GetAllocation(year); if (dtIc.Rows.Count > 0) { for (int i = 0; i < dtIc.Rows.Count; i++) { DataRow dr = dt.NewRow(); for (int j = 0; j < dtIc.Columns.Count; j++) { dr[j] = dtIc.Rows[i][j]; } dt.Rows.Add(dr); } } else { DataRow dr = dt.NewRow(); dr["DepName"] = "科室业务费"; dr["DepID"] = 1; dt.Rows.Add(dr); DataRow dr1 = dt.NewRow(); dr1["DepName"] = "局长基金"; dr1["DepID"] = 0; dt.Rows.Add(dr1); } dt.Columns.Add("DepNum"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["DepNum"] = (i + 1).ToString(); } Store1.DataSource = dt; Store1.DataBind(); } else { ExtNet.Msg.Show(new MessageBoxConfig { Title = "提示", Message = "本年度还没有添加预算,请先添加预算。", Width = 300, Buttons = MessageBox.Button.OK, //Multiline = true, //AnimEl = this.Button3.ClientID, //Fn = new JFunction { Fn = "showResultText" } }); Store1.DataSource = dt; Store1.DataBind(); } if ((txt1 - txt) == 0 && sutxt == 0) { } DataTable bgmp = BG_MonPayPlanManager.GetAllBG_MonPayPlan(); DataView dv = bgmp.DefaultView; dv.RowFilter = string.Format("convert(MPTime,'System.String') LIKE '{0}%'", CurrentYear); DataTable newbgmp = dv.ToTable(true); if (newbgmp != null) { if (newbgmp.Rows.Count == 0) { BtnSettingPayIncome.Hidden = false; } } }