private void BGProvBudItemsDataBind() { int year = Convert.ToInt32(HidYear.Value); DataTable dt = BG_BudItemsLogic.GetAllProPay(year); repBudConList.DataSource = dt; repBudConList.DataBind(); }
private void BGBudItemsDataBind() { int year = Convert.ToInt32(HidYear.Value); DataTable dt = BG_BudItemsLogic.GetBudItem(year); Repeater1.DataSource = dt; Repeater1.DataBind(); }
public void DelDepartment(string depID) { int DepID = StrToInt(depID); if (BG_BudItemsLogic.GetAllMonByDepID(DepID, CurrentYear)) { X.Msg.Alert("系统提示", "您已在该部门分配数据,无法删除此部门.").Show(); } else { BG_DepartmentManager.DeleteBG_DepartmentByID(DepID); } DtDataBind(); }
protected void btnSure_DirectClick(object sender, DirectEventArgs e) { string name = ""; try { name = ComboBox1.SelectedItem.Value; } catch { X.Msg.Alert("系统提示", "请选择科目名称。").Show(); return; } if (tfMon.Text == "") { X.Msg.Alert("系统提示", "请填写经费。").Show(); return; } string bgpi = BG_BudItemsLogic.GetBG_PayIncomeByname(name); int piid = common.IntSafeConvert(bgpi.Split(',')[0]); int year = Convert.ToInt32(HidYear.Value); int depid = Convert.ToInt32(HidDepid.Value); BG_EstimatesAllocation ba = new BG_EstimatesAllocation(); ba.DepID = depid; ba.PIID = piid; ba.BEAYear = year; ba.BEAMon = ParToDecimal.ParToDel(tfMon.Text); if (Convert.ToDecimal(tatal.Value) - ba.BEAMon > 0) { if (BGBudItemsService.Isba(year, piid, depid) > 0) { ba.BEAID = BGBudItemsService.IsBEAba(year, piid, depid); BG_EstimatesAllocationManager.ModifyBG_EstimatesAllocation(ba); } else { BG_EstimatesAllocationManager.AddBG_EstimatesAllocation(ba); } Window1.Hidden = true; AddDataBind(); DtDataBind(); } else { X.Msg.Alert("提示", "预算金额不足,无法分配!").Show(); } }
private void AddDataBind() { int year = Convert.ToInt32(HidYear.Value); int depid = Convert.ToInt32(HidDepid.Value); DataTable dt = BG_BudItemsLogic.GetBEA(depid, year); dt.Columns.Add("Name"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int piid = (int)dt.Rows[i]["PIID"]; BG_PayIncome pi = BG_PayIncomeManager.GetBG_PayIncomeByPIID(piid); dt.Rows[i]["Name"] = pi.PIEcoSubName; } } Store2.DataSource = dt; Store2.DataBind(); }
private DataTable Getquota(DataTable dt, string str) { if (dt == null || dt.Rows.Count == 0) { return(dt); } int pepnum = common.IntSafeConvert(str); dt.Columns.Add("StandardQuota"); dt.Columns.Add("StandardQuotacount"); for (int i = 0; i < dt.Rows.Count; i++) { int piid = 0; decimal qt = 0; string name = dt.Rows[i]["PSName"].ToString(); string bgpi = BG_BudItemsLogic.GetBG_PayIncomeByname(name); if (bgpi == "") { qt = 0; dt.Rows[i]["StandardQuota"] = 0; dt.Rows[i]["StandardQuotacount"] = 0; } else { string[] slist = bgpi.Split(','); for (int j = 0; j < slist.Count(); j++) { piid = common.IntSafeConvert(slist[j]); qt += BGQuotaLogic.GetBGQuotaByPIID(piid, common.IntSafeConvert(CurrentYear)); } dt.Rows[i]["StandardQuota"] = qt; dt.Rows[i]["StandardQuotacount"] = qt * pepnum; } } return(dt); }
protected void submit_DirectClick(object sender, DirectEventArgs e) { txtshow.Text = ""; int depid = common.IntSafeConvert(cmbDep.SelectedItem.Value); List <object> strlist = new List <object>(); string depname = ""; string name = ""; decimal mon = 0; if (depid == 0 && cmbPPA.SelectedItem.Value == "全部") { DataTable dt = BG_EstimatesAllocationLogic.GetALLEAMon(common.IntSafeConvert(CurrentYear)); //for (int i = 0; i < dt.Rows.Count; i++) //{ // depname = BG_DepartmentManager.GetBG_DepartmentByDepID(common.IntSafeConvert(dt.Rows[i]["depid"])).DepName; // name = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(dt.Rows[i]["PIID"])).PIEcoSubName; // strlist.Add(new { depname = depname, name = name, mon = mon }); //} if (dt.Rows.Count <= 0) { strlist.Clear(); string message = "没有查询到数据"; txtshow.Text = message; } else { for (int i = 0; i < dt.Rows.Count; i++) { depname = BG_DepartmentManager.GetBG_DepartmentByDepID(common.IntSafeConvert(dt.Rows[i]["DepID"])).DepName; name = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(dt.Rows[i]["PIID"])).PIEcoSubName; mon = ParToDecimal.ParToDel(dt.Rows[i]["BEAMon"].ToString()); strlist.Add(new { depname = depname, name = name, mon = mon }); } } } else if (depid == 0 && cmbPPA.SelectedItem.Value != "全部") { name = cmbPPA.SelectedItem.Value; string bgpi = BG_BudItemsLogic.GetBG_PayIncomeByname(name); string[] slist = bgpi.Split(','); DataTable dt1 = new DataTable(); for (int i = 0; i < slist.Count(); i++) { int piid = common.IntSafeConvert(slist[i]); dt1 = BG_EstimatesAllocationLogic.GetEAMonDTbyPIID(common.IntSafeConvert(CurrentYear), piid); if (dt1.Rows.Count > 0) { for (int j = 0; j < dt1.Rows.Count; j++) { depname = BG_DepartmentManager.GetBG_DepartmentByDepID(common.IntSafeConvert(dt1.Rows[j]["DepID"])).DepName; mon += ParToDecimal.ParToDel(dt1.Rows[j]["BEAMon"].ToString()); strlist.Add(new { depname = depname, name = name, mon = mon }); } } } if (strlist.Count <= 0) { strlist.Clear(); string message = "没有查询到数据"; txtshow.Text = message; } } else if (depid != 0 && cmbPPA.SelectedItem.Value == "全部") { depname = cmbDep.SelectedItem.Text; DataTable dt = BG_EstimatesAllocationLogic.GetEAMonDTbyDepID(common.IntSafeConvert(CurrentYear), common.IntSafeConvert(cmbDep.SelectedItem.Value)); if (dt.Rows.Count <= 0) { strlist.Clear(); string message = "没有查询到数据"; txtshow.Text = message; } else { for (int i = 0; i < dt.Rows.Count; i++) { name = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(dt.Rows[i]["PIID"])).PIEcoSubName; mon = ParToDecimal.ParToDel(dt.Rows[i]["BEAMon"].ToString()); strlist.Add(new { depname = depname, name = name, mon = mon }); } } } else { name = cmbPPA.SelectedItem.Value; string bgpi = BG_BudItemsLogic.GetBG_PayIncomeByname(name); string[] slist = bgpi.Split(','); DataTable dt1 = new DataTable(); for (int i = 0; i < slist.Count(); i++) { int piid = common.IntSafeConvert(slist[i]); mon += BG_EstimatesAllocationLogic.GetEAMon(depid, piid, common.IntSafeConvert(CurrentYear)); } if (mon <= 0) { strlist.Clear(); string message = "没有查询到数据"; txtshow.Text = message; } else { depname = cmbDep.SelectedItem.Text; strlist.Add(new { depname = depname, name = name, mon = mon }); } } DivideStore.DataSource = strlist; DivideStore.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; } } }
private void DtDataBind() { decimal txt = 0; decimal txt1 = 0; int year = Convert.ToInt32(HidYear.Value); decimal pbbase = BG_BudItemsLogic.GetTotal(year); Session["BaseMon"] = pbbase; 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()); } Session["TotalMon"] = (txt + premon).ToString("f8").TrimEnd('0').TrimEnd('.'); }
//public string GetXML() //{ // string str = ""; // string xmlPath = Server.MapPath("~/Settings/") + "Settings.xml"; // List<string> list = new List<string>(); // XmlDocument xmlDoc = new XmlDocument(); // xmlDoc.Load(xmlPath); // XmlNode xmlNode = xmlDoc.SelectSingleNode("UserInfo"); // foreach (XmlNode node in xmlNode) // { // //验证是否登录通过 // if (UserName.ToLower() == node.ChildNodes[1].InnerText.ToLower() && UserID.ToString().ToLower() == node.ChildNodes[0].InnerText.ToLower()) // { // str = node.ChildNodes[2].InnerText.ToLower(); // } // } // return str; //} private void DtDataBind() { decimal txt = 0; if (CurrentYear == "") { return; } int year = common.IntSafeConvert(CurrentYear); 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"]); } } //tatal.Value = txt.ToString(); //BAA.Text = txt.ToString(); } 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()); } BAA.Text = (txt + premon).ToString("f8").TrimEnd('0').TrimEnd('.'); 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 += ParToDecimal.ParToDel(dt.Rows[i]["SuppMon"].ToString()); } } if (dt6.Rows.Count <= 0) { SUPP.Text = "0.00"; } else { SUPP.Text = (ParToDecimal.ParToDel(dt6.Rows[0]["SuppMon"].ToString()) - sutxt).ToString("f8").TrimEnd('0').TrimEnd('.'); } HidBAA.Text = BAA.Text; HidSupp.Text = SUPP.Text; }
private void SetNode(int tem, NodeCollection node) { NodeCollection nodes = new NodeCollection(); DataTable dt = BG_PayIncomeLogic.GetDtPayIncomeByPIID(tem); int year = common.IntSafeConvert(CurrentYear); int depid = common.IntSafeConvert(HidDepid.Value); DataTable dti = BG_BudItemsLogic.GetBAA(depid, year); if (dt.Rows.Count > 0) { for (int j = 0; j < dt.Rows.Count; j++) { int piid = common.IntSafeConvert(dt.Rows[j]["PIID"].ToString()); Node nodeN = new Node(); nodeN.NodeID = piid.ToString(); nodeN.Text = dt.Rows[j]["PIEcoSubName"].ToString(); string sql = string.Format("PIID='{0}'", piid); DataRow[] dr = dti.Select(sql); decimal Baamon = 0; decimal Suppmon = 0; if (dr.Length > 0) { for (int i = 0; i < dr.Length; i++) { Baamon += ParToDecimal.ParToDel(dr[i]["BAAMon"].ToString()); Suppmon += ParToDecimal.ParToDel(dr[i]["SuppMon"].ToString()); } } if (BG_PayIncomeLogic.GetBoolPayIncomeByPIID(tem)) { if (!BG_PayIncomeLogic.GetBoolPayIncomeByPIID(common.IntSafeConvert(piid))) { nodeN.Icon = Icon.Anchor; node.Add(nodeN); nodeN.Leaf = true; nodeN.CustomAttributes.Add(new ConfigItem("BAAMon", Baamon.ToString(), ParameterMode.Value)); nodeN.CustomAttributes.Add(new ConfigItem("SuppMon", Suppmon.ToString(), ParameterMode.Value)); listpiid.Add(common.IntSafeConvert(nodeN.NodeID)); SaveListIdStrs(listpiid); } else { if (BG_PayIncomeLogic.GetLever(3)) { nodeN.Icon = Icon.Anchor; node.Add(nodeN); nodeN.Leaf = true; nodeN.CustomAttributes.Add(new ConfigItem("BAAMon", Baamon.ToString(), ParameterMode.Value)); nodeN.CustomAttributes.Add(new ConfigItem("SuppMon", Suppmon.ToString(), ParameterMode.Value)); listpiid.Add(common.IntSafeConvert(nodeN.NodeID)); SaveListIdStrs(listpiid); } else { nodeN.Icon = Icon.Folder; node.Add(nodeN); listpiid.Add(common.IntSafeConvert(nodeN.NodeID)); SaveListIdStrs(listpiid); } } // Session["slist"] = listpiid; //node.CustomAttributes.Add(new ConfigItem("BAAMon", CountBaamon.ToString(), ParameterMode.Value)); //node.CustomAttributes.Add(new ConfigItem("SuppMon", CountSuppmon.ToString(), ParameterMode.Value)); //nodeN.Checked = false; } else { if (SingleNode(piid.ToString()) == 0) { break; } else if (BG_PayIncomeLogic.ISSign(piid)) { nodeN.Leaf = true; nodeN.Icon = Icon.Anchor; node.Add(nodeN); nodeN.CustomAttributes.Add(new ConfigItem("BAAMon", Baamon.ToString(), ParameterMode.Value)); nodeN.CustomAttributes.Add(new ConfigItem("SuppMon", Suppmon.ToString(), ParameterMode.Value)); listpiid.Add(common.IntSafeConvert(nodeN.NodeID)); SaveListIdStrs(listpiid); //Session["slist"] = listpiid; } else { nodeN.Icon = Icon.Folder; node.Add(nodeN); listpiid.Add(common.IntSafeConvert(nodeN.NodeID)); SaveListIdStrs(listpiid); } //nodeN.Expanded = true; //nodeN.CustomAttributes.Add(new ConfigItem("BAAMon", CountBaamon.ToString(), ParameterMode.Value)); //nodeN.CustomAttributes.Add(new ConfigItem("SuppMon", CountSuppmon.ToString(), ParameterMode.Value)); //CountBaamon = 0; //CountSuppmon = 0; } //SetNode(piid, ftype, incomeinfo, nodeN); //node.Children.Add(nodeN); //SetNode(piid, ftype, incomeinfo, nodeN); } } }
private List <object> GetListStr() { txtshow.Text = ""; int depid = common.IntSafeConvert(cmbDep.SelectedItem.Value); List <object> strlist = new List <object>(); int piidflag = 0; string depname = ""; string name = ""; decimal mon = 0; decimal supp = 0; if (depid == 0 && DropDownFieldDv.Text.ToString() == "全部") { DataTable dt = BG_BudgetAllocationLogic.GetALLAAMon(common.IntSafeConvert(CurrentYear)); //for (int i = 0; i < dt.Rows.Count; i++) //{ // depname = BG_DepartmentManager.GetBG_DepartmentByDepID(common.IntSafeConvert(dt.Rows[i]["depid"])).DepName; // name = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(dt.Rows[i]["PIID"])).PIEcoSubName; // strlist.Add(new { depname = depname, name = name, mon = mon }); //} if (dt.Rows.Count <= 0) { strlist.Clear(); string message = "没有查询到数据"; txtshow.Text = message; } else { for (int i = 0; i < dt.Rows.Count; i++) { piidflag = common.IntSafeConvert(dt.Rows[i]["PIID"]); depname = BG_DepartmentManager.GetBG_DepartmentByDepID(common.IntSafeConvert(dt.Rows[i]["DepID"])).DepName; name = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(dt.Rows[i]["PIID"])).PIEcoSubName; mon = ParToDecimal.ParToDel(dt.Rows[i]["BAAMon"].ToString()); supp = ParToDecimal.ParToDel(dt.Rows[i]["SuppMon"].ToString()); strlist.Add(new { piidflag = piidflag, depname = depname, name = name, mon = mon, supp = supp }); } } } else if (depid == 0 && DropDownFieldDv.Text.ToString() != "全部") { name = DropDownFieldDv.Text.ToString(); DataTable dt = BGDepartmentManager.GetDepByfadepid(AreaDepID); string bgpi = BG_BudItemsLogic.GetBG_PayIncomeByname(name); if (name == "工资福利支出" || name == "商品和服务支出" || name == "对个人和家庭补助支出" || name == "其他资本性支出") { DataTable dta = BG_BudgetAllocationLogic.GetALLAAMon(common.IntSafeConvert(CurrentYear)); //for (int i = 0; i < dta.Rows.Count; i++) //{ // depname = BG_DepartmentManager.GetBG_DepartmentByDepID(common.IntSafeConvert(dta.Rows[i]["depid"])).DepName; // name = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(dta.Rows[i]["PIID"])).PIEcoSubName; // strlist.Add(new { depname = depname, name = name, mon = mon }); //} if (dta.Rows.Count <= 0) { strlist.Clear(); string message = "没有查询到数据"; txtshow.Text = message; } else { for (int i = 0; i < dta.Rows.Count; i++) { piidflag = common.IntSafeConvert(dta.Rows[i]["PIID"]); depname = BG_DepartmentManager.GetBG_DepartmentByDepID(common.IntSafeConvert(dta.Rows[i]["DepID"])).DepName; name = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(dta.Rows[i]["PIID"])).PIEcoSubName; mon = ParToDecimal.ParToDel(dta.Rows[i]["BAAMon"].ToString()); supp = ParToDecimal.ParToDel(dta.Rows[i]["SuppMon"].ToString()); strlist.Add(new { piidflag = piidflag, depname = depname, name = name, mon = mon, supp = supp }); } } } string[] slist = bgpi.Split(','); DataTable dt1 = new DataTable(); for (int i = 0; i < slist.Count(); i++) { int piid = common.IntSafeConvert(slist[i]); dt1 = BG_BudgetAllocationLogic.GetAAMonDTbyPIID(common.IntSafeConvert(CurrentYear), piid); if (dt1.Rows.Count > 0) { for (int j = 0; j < dt1.Rows.Count; j++) { depname = BG_DepartmentManager.GetBG_DepartmentByDepID(common.IntSafeConvert(dt1.Rows[j]["DepID"])).DepName; mon += ParToDecimal.ParToDel(dt1.Rows[j]["BAAMon"].ToString()); supp += ParToDecimal.ParToDel(dt1.Rows[j]["SuppMon"].ToString()); strlist.Add(new { piidflag = piid, depname = depname, name = name, mon = mon, supp = supp }); } } } if (strlist.Count <= 0) { strlist.Clear(); string message = "没有查询到数据"; txtshow.Text = message; } } else if (depid != 0 && DropDownFieldDv.Text.ToString() == "全部") { depname = cmbDep.SelectedItem.Text; DataTable dt = BG_BudgetAllocationLogic.GetAAMonDTbyDepID(common.IntSafeConvert(CurrentYear), common.IntSafeConvert(cmbDep.SelectedItem.Value)); if (dt.Rows.Count <= 0) { strlist.Clear(); string message = "没有查询到数据"; txtshow.Text = message; } else { for (int i = 0; i < dt.Rows.Count; i++) { piidflag = common.IntSafeConvert(dt.Rows[i]["PIID"]); name = BG_PayIncomeManager.GetBG_PayIncomeByPIID(piidflag).PIEcoSubName; mon = ParToDecimal.ParToDel(dt.Rows[i]["BAAMon"].ToString()); supp = ParToDecimal.ParToDel(dt.Rows[i]["SuppMon"].ToString()); strlist.Add(new { piidflag = piidflag, depname = depname, name = name, mon = mon, supp = supp }); } } } else { name = DropDownFieldDv.Text.ToString(); if (name == "工资福利支出" || name == "商品和服务支出" || name == "对个人和家庭补助支出" || name == "其他资本性支出") { depname = cmbDep.SelectedItem.Text; DataTable dta = BG_BudgetAllocationLogic.GetAAMonDTbyDepID(common.IntSafeConvert(CurrentYear), common.IntSafeConvert(cmbDep.SelectedItem.Value)); if (dta.Rows.Count <= 0) { strlist.Clear(); string message = "没有查询到数据"; txtshow.Text = message; } else { for (int i = 0; i < dta.Rows.Count; i++) { piidflag = common.IntSafeConvert(dta.Rows[i]["PIID"]); name = BG_PayIncomeManager.GetBG_PayIncomeByPIID(piidflag).PIEcoSubName; mon = ParToDecimal.ParToDel(dta.Rows[i]["BAAMon"].ToString()); supp = ParToDecimal.ParToDel(dta.Rows[i]["SuppMon"].ToString()); strlist.Add(new { piidflag = piidflag, depname = depname, name = name, mon = mon, supp = supp }); } } } string bgpi = BG_BudItemsLogic.GetBG_PayIncomeByname(name); string[] slist = bgpi.Split(','); DataTable dt = new DataTable(); for (int i = 0; i < slist.Count(); i++) { int piid = common.IntSafeConvert(slist[i]); dt = BG_BudgetAllocationLogic.GetAAMon(depid, piid, common.IntSafeConvert(CurrentYear)); if (dt.Rows.Count > 0) { mon += ParToDecimal.ParToDel(dt.Rows[0]["BAAMon"].ToString()); supp += ParToDecimal.ParToDel(dt.Rows[0]["SuppMon"].ToString()); } mon += 0; supp += 0; } if (dt.Rows.Count <= 0) { strlist.Clear(); string message = "没有查询到数据"; txtshow.Text = message; } else { depname = cmbDep.SelectedItem.Text; strlist.Add(new { piidflag = common.IntSafeConvert(slist[0]), depname = depname, name = name, mon = mon, supp = supp }); } } string str = ""; decimal summon = 0; decimal sumsupp = 0; for (int i = 0; i < strlist.Count; i++) { str = strlist[i].ToString(); summon += Getmon(str, "mon"); sumsupp += Getmon(str, "supp"); } strlist.Add(new { piidflag = 0, depname = "总计", name = "", mon = summon, supp = sumsupp }); return(strlist); }