public static BG_PayIncome AddBG_PayIncome(BG_PayIncome bG_PayIncome)
{
string sql =
"INSERT BG_PayIncome (PIEcoSubCoding, PIEcoSubLev, PIEcoSubParID, PIEcoSubName, PIType, ISSign)" +
"VALUES (@PIEcoSubCoding, @PIEcoSubLev, @PIEcoSubParID, @PIEcoSubName, @PIType, @ISSign)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PIEcoSubCoding", bG_PayIncome.PIEcoSubCoding),
new SqlParameter("@PIEcoSubLev", bG_PayIncome.PIEcoSubLev),
new SqlParameter("@PIEcoSubParID", bG_PayIncome.PIEcoSubParID),
new SqlParameter("@PIEcoSubName", bG_PayIncome.PIEcoSubName),
new SqlParameter("@PIType", bG_PayIncome.PIType),
new SqlParameter("@ISSign", bG_PayIncome.ISSign)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return(GetBG_PayIncomeByPIID(newId));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PayIncome GetBG_PayIncomeByPIID(int pIID)
{
string sql = "SELECT * FROM BG_PayIncome WHERE PIID = @PIID";
try
{
SqlParameter para = new SqlParameter("@PIID", pIID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_PayIncome bG_PayIncome = new BG_PayIncome();
bG_PayIncome.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_PayIncome.PIEcoSubCoding = dt.Rows[0]["PIEcoSubCoding"] == DBNull.Value ? "" : (string)dt.Rows[0]["PIEcoSubCoding"];
bG_PayIncome.PIEcoSubLev = dt.Rows[0]["PIEcoSubLev"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIEcoSubLev"];
bG_PayIncome.PIEcoSubParID = dt.Rows[0]["PIEcoSubParID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIEcoSubParID"];
bG_PayIncome.PIEcoSubName = dt.Rows[0]["PIEcoSubName"] == DBNull.Value ? "" : (string)dt.Rows[0]["PIEcoSubName"];
bG_PayIncome.PIType = dt.Rows[0]["PIType"] == DBNull.Value ? "" : (string)dt.Rows[0]["PIType"];
bG_PayIncome.ISSign = dt.Rows[0]["ISSign"] == DBNull.Value ? 0 : (int)dt.Rows[0]["ISSign"];
return(bG_PayIncome);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
private static List <object> GetLeafList(List <object> strlist, int piid)
{
List <object> getleaf = new List <object>();
for (int i = 0; i < strlist.Count - 1; i++)
{
int piidtmpp = common.IntSafeConvert(strlist[i].ToString().Split(',')[0].Substring(12).Replace(" ", ""));
DataTable dttmp = BG_PayIncomeLogic.GetBG_PayIncomeByname(strlist[i].ToString().Split(',')[2].Substring(7).Replace(" ", ""));
BG_PayIncome pi = new BG_PayIncome();
if (dttmp.Rows.Count > 4)
{
pi = BG_PayIncomeManager.GetBG_PayIncomeByPIID(piidtmpp);
}
else
{
pi = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(dttmp.Rows[0]["PIID"]));
}
int psubtmp = pi.PIEcoSubParID;
if (psubtmp == piid)
{
getleaf.Add(strlist[i]);
}
}
//DataTable dt = new DataTable();
//dt.Columns.Add("name");
//dt.Columns.Add("mon");
//dt.Columns.Add("supp");
List <object> listTmp = new List <object>();
if (getleaf == null || getleaf.Count < 1)
{
return(listTmp);
}
DataTable dt = ListToDataTable <object>(getleaf);
var query = from t in dt.AsEnumerable()
group t by new { t1 = t.Field <string>("name") } into m
select new
{
name = m.Key.t1,
mon = m.Sum(n => n.Field <decimal>("mon")),
supp = m.Sum(n => n.Field <decimal>("supp"))
};
if (query.ToList().Count > 0)
{
query.ToList().ForEach(q =>
{
listTmp.Add(new { piidflag = 0, depname = "", name = q.name, mon = q.mon, supp = q.supp });
});
}
return(listTmp);
}
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();
}
public static bool ModifyBG_PayIncome(BG_PayIncome bG_PayIncome)
{
string sql =
"UPDATE BG_PayIncome " +
"SET " +
"PIEcoSubCoding = @PIEcoSubCoding, " +
"PIEcoSubLev = @PIEcoSubLev, " +
"PIEcoSubParID = @PIEcoSubParID, " +
"PIEcoSubName = @PIEcoSubName, " +
"PIType = @PIType, " +
"ISSign = @ISSign " +
"WHERE PIID = @PIID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PIID", bG_PayIncome.PIID),
new SqlParameter("@PIEcoSubCoding", bG_PayIncome.PIEcoSubCoding),
new SqlParameter("@PIEcoSubLev", bG_PayIncome.PIEcoSubLev),
new SqlParameter("@PIEcoSubParID", bG_PayIncome.PIEcoSubParID),
new SqlParameter("@PIEcoSubName", bG_PayIncome.PIEcoSubName),
new SqlParameter("@PIType", bG_PayIncome.PIType),
new SqlParameter("@ISSign", bG_PayIncome.ISSign)
};
int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, para);
if (t > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static List <BG_PayIncome> GetPIList()
{
List <BG_PayIncome> list = new List <BG_PayIncome>();
DataTable dt = GetDtAllPayIncome();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["PIEcoSubCoding"] != null && dt.Rows[i]["PIEcoSubName"] != null)
{
BG_PayIncome pi = new BG_PayIncome();
pi.PIEcoSubCoding = dt.Rows[i]["PIEcoSubCoding"].ToString().Trim();
pi.PIEcoSubName = dt.Rows[i]["PIEcoSubName"].ToString();
list.Add(pi);
}
}
}
return(list);
}
public void insertSign(string piid, string issign)
{
string pname = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(piid)).PIEcoSubName;
DataTable dtpiid = BG_PayIncomeLogic.GetBG_PayIncomeByname(pname);
int tempiid = 0;
for (int i = 0; i < dtpiid.Rows.Count; i++)
{
tempiid = common.IntSafeConvert(dtpiid.Rows[i]["PIID"]);
if (issign == "1")
{
BG_PayIncome ba = BG_PayIncomeManager.GetBG_PayIncomeByPIID(tempiid);
ba.ISSign = 0;
BG_PayIncomeManager.ModifyBG_PayIncome(ba);
}
else
{
BG_PayIncome ba = BG_PayIncomeManager.GetBG_PayIncomeByPIID(tempiid);
ba.ISSign = 1;
BG_PayIncomeManager.ModifyBG_PayIncome(ba);
}
}
}
public static bool ModifyBG_PayIncome(BG_PayIncome bG_PayIncome)
{
return(BG_PayIncomeService.ModifyBG_PayIncome(bG_PayIncome));
}
public static bool DeleteBG_PayIncome(BG_PayIncome bG_PayIncome)
{
return(BG_PayIncomeService.DeleteBG_PayIncome(bG_PayIncome));
}
public static BG_PayIncome AddBG_PayIncome(BG_PayIncome bG_PayIncome)
{
return(BG_PayIncomeService.AddBG_PayIncome(bG_PayIncome));
}
public static bool DeleteBG_PayIncome(BG_PayIncome bG_PayIncome)
{
return(DeleteBG_PayIncomeByPIID(bG_PayIncome.PIID));
}
private object GetNewList(List <object> strlist, int piid)
{
List <object> Listtmp = new List <object>();
int psub = 0;
decimal t1 = 0, t2 = 0, t3 = 0, t4 = 0;
decimal s1 = 0, s2 = 0, s3 = 0, s4 = 0;
for (int i = 0; i < strlist.Count - 1; i++)
{
DataTable dttmp = BG_PayIncomeLogic.GetBG_PayIncomeByname(strlist[i].ToString().Split(',')[2].Substring(7).Replace(" ", ""));
BG_PayIncome pi = BG_PayIncomeManager.GetBG_PayIncomeByPIID(common.IntSafeConvert(dttmp.Rows[0]["PIID"]));
psub = pi.PIEcoSubParID;
if (psub == 0)
{
if (strlist[i].ToString().Split(',')[2].Substring(7).Contains("工资福利支出"))
{
t1 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[3].Substring(6));
s1 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[4].Substring(7).Replace("}", ""));
//Listtmp.Add(new { depname = "", name = "工资福利支出", mon = t1, supp = s1 });
}
else if (strlist[i].ToString().Split(',')[2].Substring(7).Contains("商品和服务支出"))
{
t2 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[3].Substring(6));
s2 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[4].Substring(7).Replace("}", ""));
//Listtmp.Add(new { depname = "", name = "商品和服务支出", mon = t2, supp = s2 });
}
else if (strlist[i].ToString().Split(',')[2].Substring(7).Contains("对个人和家庭补助支出"))
{
t3 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[3].Substring(6));
s3 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[4].Substring(7).Replace("}", ""));
//Listtmp.Add(new { depname = "", name = "对个人和家庭补助支出", mon = t3, supp = s3 });
}
else if (strlist[i].ToString().Split(',')[2].Substring(7).Contains("其他资本性支出"))
{
t4 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[3].Substring(6));
s4 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[4].Substring(7).Replace("}", ""));
//Listtmp.Add(new { depname = "", name = "其他资本性支出", mon = t4, supp = s4 });
}
}
else
{
if (psub == 1000 || psub == 1015 || psub == 1051 || psub == 1065)
{
if (psub == 1000)
{
t1 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[3].Substring(6));
s1 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[4].Substring(7).Replace("}", ""));
}
if (psub == 1015)
{
t2 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[3].Substring(6));
s2 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[4].Substring(7).Replace("}", ""));
}
if (psub == 1051)
{
t3 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[3].Substring(6));
s3 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[4].Substring(7).Replace("}", ""));
}
if (psub == 1065)
{
t4 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[3].Substring(6));
s4 += ParToDecimal.ParToDel(strlist[i].ToString().Split(',')[4].Substring(7).Replace("}", ""));
}
}
}
}
if (DropDownFieldDv.Text.ToString() != "全部")
{
if (DropDownFieldDv.Value.ToString() == "1000")
{
Listtmp.Add(new { piidflag = DropDownFieldDv.Value.ToString(), depname = "", name = DropDownFieldDv.Text.ToString(), mon = t1, supp = s1 });
}
else if (DropDownFieldDv.Value.ToString() == "1015")
{
Listtmp.Add(new { piidflag = DropDownFieldDv.Value.ToString(), depname = "", name = DropDownFieldDv.Text.ToString(), mon = t2, supp = s2 });
}
else if (DropDownFieldDv.Value.ToString() == "1051")
{
Listtmp.Add(new { piidflag = DropDownFieldDv.Value.ToString(), depname = "", name = DropDownFieldDv.Text.ToString(), mon = t3, supp = s3 });
}
else
{
Listtmp.Add(new { piidflag = DropDownFieldDv.Value.ToString(), depname = "", name = DropDownFieldDv.Text.ToString(), mon = t4, supp = s4 });
}
}
else
{
Listtmp.Add(new { piidflag = 1000, depname = "", name = "工资福利支出", mon = t1, supp = s1 });
Listtmp.Add(new { piidflag = 1015, depname = "", name = "商品和服务支出", mon = t2, supp = s2 });
Listtmp.Add(new { piidflag = 1051, depname = "", name = "对个人和家庭补助支出", mon = t3, supp = s3 });
Listtmp.Add(new { piidflag = 1065, depname = "", name = "其他资本性支出", mon = t4, supp = s4 });
//Listtmp.Add(strlist[strlist.Count - 1]);
}
List <object> getleaf = GetLeafList(strlist, piid);
if (piid == 1000)
{
for (int i = 0; i < getleaf.Count; i++)
{
Listtmp.Insert(1 + i, getleaf[i]);
}
}
if (piid == 1015)
{
for (int i = 0; i < getleaf.Count; i++)
{
Listtmp.Insert(2 + i, getleaf[i]);
}
}
if (piid == 1051)
{
for (int i = 0; i < getleaf.Count; i++)
{
Listtmp.Insert(3 + i, getleaf[i]);
}
}
if (piid == 1065)
{
for (int i = 0; i < getleaf.Count; i++)
{
Listtmp.Insert(4 + i, getleaf[i]);
}
}
if (DropDownFieldDv.Text.ToString() == "全部")
{
Listtmp.Add(strlist[strlist.Count - 1]);
}
return(Listtmp);
}
