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);
}
