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