public void DooYes()
{
DataTable dt = BG_BudgetAllocationManager.GetAllBG_BudgetAllocation();
if (dt.Rows.Count > 0)
{
if (BG_BudgetAllocationLogic.DelByYear(CurrentYear))
{
Windows.Show();
btnDivde.Hide();
btnsave.Show();
StoreSelectIncomeBind();
DtDataBind();
}
}
else
{
Windows.Show();
btnDivde.Hide();
btnsave.Show();
StoreSelectIncomeBind();
DtDataBind();
}
}
//protected void GetSelect_DirectClick(object sender, DirectEventArgs e)
//{
// string Strincome = Hidselector.Value.ToString();
// string[] income = Strincome.Split(',');
// DataTable dt = null;
// dt.Columns.Add();
// for (int i = 0; i < income.Count(); i++)
// {
// }
//}
protected void RemoteEdit(object sender, RemoteEditEventArgs e)
{
if (ParToDecimal.ParToDel(HidSupp.Text.ToString()) < 0 || ParToDecimal.ParToDel(HidBAA.Text.ToString()) < 0)
{
if (ParToDecimal.ParToDel(HidSupp.Text) < 0)
{
X.Msg.Alert("提示", "超过追加余额，请核实后修改数据！").Show(); return;
}
if (ParToDecimal.ParToDel(HidBAA.Text) < 0)
{
X.Msg.Alert("提示", "超过总余额，请核实后修改数据！").Show(); return;
}
}
e.Accept = true;
string[] idStrArr = HidSlist.Text.ToString().TrimEnd('&').Split('&');
List <int> slist = new List <int>();
foreach (string item in idStrArr)
{
int IntId = common.IntSafeConvert(item);
if (!slist.Contains(IntId))
{
slist.Add(IntId);
}
}
int piid = common.IntSafeConvert(e.NodeID);
RowChanges rc = e.Changes[0];
//if (rc.Value<float>() <= 0 && rc.OldValue<float>() <= 0)
//{
// X.Msg.Alert("提示", "填写数字不能为0").Show();
// return;
//}
if (e.Json == null)
{
return;
}
if (!slist.Contains(piid))
{
X.Msg.Alert("提示", "此处不可填写,请填写到正确位置").Show();
return;
}
else
{
int year = common.IntSafeConvert(CurrentYear);
decimal baamon = 0;
decimal suppmon = 0;
BG_BudgetAllocation bg = BG_BudgetAllocationLogic.GetMonDT(year, piid, depid);
if (bg == null)
{
BG_BudgetAllocation bgadd = new BG_BudgetAllocation();
foreach (RowChanges change in e.Changes)
{
if (change.Field == "BAAMon" && change.IsDirty <float>())
{
bgadd.BAAMon = ParToDecimal.ParToDel(change.Value <float>().ToString());
baamon = ParToDecimal.ParToDel(HidBAA.Text.ToString()) - bgadd.BAAMon;
if (baamon < 0)
{
X.Msg.Alert("提示", "超过总余额，请核实后修改数据！").Show();
rc.SetValue(rc.OldValue <float>());
return;
}
}
else if (change.Field == "SuppMon" && change.IsDirty <float>())
{
bgadd.SuppMon = ParToDecimal.ParToDel(change.Value <float>().ToString());
suppmon = ParToDecimal.ParToDel(HidSupp.Text) - bgadd.SuppMon;
if (suppmon < 0)
{
X.Msg.Alert("提示", "超过追加余额，请核实后修改数据！").Show();
rc.SetValue(rc.OldValue <float>());
return;
}
}
}
bgadd.PIID = piid;
bgadd.BAAYear = year;
bgadd.DepID = depid;
if (BG_BudgetAllocationManager.AddBG_BudgetAllocation(bgadd).BAAID > 0)
{
BG_BudgetAllocationHis bgBudgetAllocationHis = new BG_BudgetAllocationHis();
bgBudgetAllocationHis.BAAID = bgadd.BAAID;
bgBudgetAllocationHis.NewBAAMon = bgadd.BAAMon;
bgBudgetAllocationHis.Crtime = DateTime.Now;
bgBudgetAllocationHis.DepID = bgadd.DepID;
bgBudgetAllocationHis.PIID = bgadd.PIID;
bgBudgetAllocationHis.NewSuppMon = bgadd.SuppMon;
bgBudgetAllocationHis.UserOp = UserName;
bgBudgetAllocationHis.OldBAAMon = rc.Field == "BAAMon" && rc.IsDirty <float>()
? (decimal)rc.OldValue <float>()
: bgadd.BAAMon;
bgBudgetAllocationHis.OldSuppMon = rc.Field == "SuppMon" && rc.IsDirty <float>()
? (decimal)rc.OldValue <float>()
: bgadd.SuppMon;
bgBudgetAllocationHis.AddBAAMon = bgBudgetAllocationHis.NewBAAMon - bgBudgetAllocationHis.OldBAAMon;
bgBudgetAllocationHis.AddSuppMon = bgBudgetAllocationHis.NewSuppMon - bgBudgetAllocationHis.OldSuppMon;
bgBudgetAllocationHis.DepName = BG_DepartmentManager.GetBG_DepartmentByDepID(bgadd.DepID).DepName;
BG_BudgetAllocationHisManager.AddBG_BudgetAllocationHis(bgBudgetAllocationHis);
}
DtDataBind();
//if (baamon < 0 || suppmon < 0)
//{
// if (baamon > 0)
// {
// X.Msg.Alert("提示", "超过追加余额，请核实后修改数据！").Show();
// rc.SetValue(rc.OldValue<float>());
// }
// else if (suppmon > 0)
// {
// X.Msg.Alert("提示", "超过总余额，请核实后修改数据！").Show();
// rc.SetValue(rc.OldValue<float>());
// }
// else
// {
// X.Msg.Alert("提示", "追加余额或总余额不足，请核实后修改数据！").Show();
// rc.SetValue(rc.OldValue<float>());
// }
//}
//else
//{
// BG_BudgetAllocationManager.AddBG_BudgetAllocation(bgadd);
// DtDataBind();
//}
}
else
{
decimal Mon = BG_MonPayPlanGenerateLogic.GetMonPayYear(piid, depid, year);
decimal UseMon = BG_ApplyReimburLogic.GetARUseMon(piid, depid, year);
//if (ParToDecimal.ParToDel(rc.OldValue<float>().ToString()) - ParToDecimal.ParToDel(rc.Value<float>().ToString())-(Mon - UseMon) > 0)
//{
if (Mon > 0)
{
X.Msg.Alert("提示", "分配金额小于期初分配金额，会影响月度用款申请及预算执行！").Show();
}
foreach (RowChanges change in e.Changes)
{
if (change.Field == "BAAMon" && change.IsDirty <float>())
{
bg.BAAMon = ParToDecimal.ParToDel(change.Value <float>().ToString());
baamon = ParToDecimal.ParToDel(HidBAA.Text.ToString()) + ParToDecimal.ParToDel(change.OldValue <float>().ToString()) - bg.BAAMon;
if (baamon < 0)
{
X.Msg.Alert("提示", "超过总余额，请核实后修改数据！").Show();
rc.SetValue(rc.OldValue <float>());
return;
}
}
else if (change.Field == "SuppMon" && change.IsDirty <float>())
{
bg.SuppMon = ParToDecimal.ParToDel(change.Value <float>().ToString());
suppmon = ParToDecimal.ParToDel(HidSupp.Text.ToString()) + ParToDecimal.ParToDel(change.OldValue <float>().ToString()) - bg.SuppMon;
if (suppmon < 0)
{
X.Msg.Alert("提示", "超过追加余额，请核实后修改数据！").Show();
rc.SetValue(rc.OldValue <float>());
return;
}
}
}
//}
if (BG_BudgetAllocationManager.ModifyBG_BudgetAllocation(bg))
{
BG_BudgetAllocationHis bgBudgetAllocationHis = new BG_BudgetAllocationHis();
bgBudgetAllocationHis.BAAID = bg.BAAID;
bgBudgetAllocationHis.NewBAAMon = bg.BAAMon;
bgBudgetAllocationHis.Crtime = DateTime.Now;
bgBudgetAllocationHis.DepID = bg.DepID;
bgBudgetAllocationHis.PIID = bg.PIID;
bgBudgetAllocationHis.NewSuppMon = bg.SuppMon;
bgBudgetAllocationHis.UserOp = UserName;
bgBudgetAllocationHis.OldBAAMon = rc.Field == "BAAMon" && rc.IsDirty <float>()
? (decimal)rc.OldValue <float>()
: bg.BAAMon;
bgBudgetAllocationHis.OldSuppMon = rc.Field == "SuppMon" && rc.IsDirty <float>()
? (decimal)rc.OldValue <float>()
: bg.SuppMon;
bgBudgetAllocationHis.AddBAAMon = bgBudgetAllocationHis.NewBAAMon - bgBudgetAllocationHis.OldBAAMon;
bgBudgetAllocationHis.AddSuppMon = bgBudgetAllocationHis.NewSuppMon - bgBudgetAllocationHis.OldSuppMon;
bgBudgetAllocationHis.DepName = BG_DepartmentManager.GetBG_DepartmentByDepID(bg.DepID).DepName;
BG_BudgetAllocationHisManager.AddBG_BudgetAllocationHis(bgBudgetAllocationHis);
}
DtDataBind();
//if (baamon < 0 || suppmon < 0)
//{
// if (baamon > 0)
// {
// X.Msg.Alert("提示", "超过追加余额，请核实后修改数据！").Show();
// rc.SetValue(rc.OldValue<float>());
// }
// else if (suppmon > 0)
// {
// X.Msg.Alert("提示", "超过总余额，请核实后修改数据！").Show();
// rc.SetValue(rc.OldValue<float>());
// }
// else
// {
// X.Msg.Alert("提示", "追加余额或总余额不足，请核实后修改数据！").Show();
// rc.SetValue(rc.OldValue<float>());
// }
//}
//else
//{
// BG_BudgetAllocationManager.ModifyBG_BudgetAllocation(bg);
// DtDataBind();
//}
#region 8-8 修改后总分配额不能少于已经审核通过的金额
//if (Mon - ParToDecimal.ParToDel(rc.OldValue<float>().ToString()) + ParToDecimal.ParToDel(rc.Value<float>().ToString()) - UseMon < 0)
//{
// X.Msg.Alert("提示", "修改后总分配额不能少于已经审核通过的金额").Show();
// rc.SetValue(rc.OldValue<float>());
//}
//else
//{
// foreach (RowChanges change in e.Changes)
// {
// if (change.Field == "BAAMon" && change.IsDirty<float>())
// {
// bg.BAAMon = ParToDecimal.ParToDel(change.Value<float>().ToString());
// baamon = ParToDecimal.ParToDel(HidBAA.Text.ToString()) + ParToDecimal.ParToDel(change.OldValue<float>().ToString()) - bg.BAAMon;
// }
// else if (change.Field == "SuppMon" && change.IsDirty<float>())
// {
// bg.SuppMon = ParToDecimal.ParToDel(change.Value<float>().ToString());
// suppmon = ParToDecimal.ParToDel(HidSupp.Text.ToString()) + ParToDecimal.ParToDel(change.OldValue<float>().ToString()) - bg.SuppMon;
// }
// }
// if (baamon < 0 || suppmon < 0)
// {
// if (baamon > 0)
// {
// X.Msg.Alert("提示", "超过追加余额，请核实后修改数据！").Show();
// rc.SetValue(rc.OldValue<float>());
// }
// else if (suppmon > 0)
// {
// X.Msg.Alert("提示", "超过总余额，请核实后修改数据！").Show();
// rc.SetValue(rc.OldValue<float>());
// }
// else
// {
// X.Msg.Alert("提示", "追加余额或总余额不足，请核实后修改数据！").Show();
// rc.SetValue(rc.OldValue<float>());
// }
// }
// else
// {
// BG_BudgetAllocationManager.ModifyBG_BudgetAllocation(bg);
// DtDataBind();
// }
//}
#endregion
}
}
HidBind();
TPPayIncome.Listeners.AddScript("GetTotal();");
}
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);
}
