public static BG_ProBasiPerPayOne AddBG_ProBasiPerPayOne(BG_ProBasiPerPayOne bG_ProBasiPerPayOne)
{
string sql =
"INSERT BG_ProBasiPerPayOne (DepID, POYear, POBS, POAS, POBonus, POPS, POSE, POOther, POTitol)" +
"VALUES (@DepID, @POYear, @POBS, @POAS, @POBonus, @POPS, @POSE, @POOther, @POTitol)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DepID", bG_ProBasiPerPayOne.DepID),
new SqlParameter("@POYear", bG_ProBasiPerPayOne.POYear),
new SqlParameter("@POBS", bG_ProBasiPerPayOne.POBS),
new SqlParameter("@POAS", bG_ProBasiPerPayOne.POAS),
new SqlParameter("@POBonus", bG_ProBasiPerPayOne.POBonus),
new SqlParameter("@POPS", bG_ProBasiPerPayOne.POPS),
new SqlParameter("@POSE", bG_ProBasiPerPayOne.POSE),
new SqlParameter("@POOther", bG_ProBasiPerPayOne.POOther),
new SqlParameter("@POTitol", bG_ProBasiPerPayOne.POTitol)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_ProBasiPerPayOneByPOID(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
private void IsnotBG_ProBasiPerPay()
{
byte[] bt;
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
DataTable dt3 = new DataTable();
DataTable dt4 = new DataTable();
if (FUFEXC.HasFile)
{
bt = FUFEXC.FileBytes;
dt1 = ImportFinaDataLogic.GetDTBySheetname("基人一", bt, 9, 10);
dt2 = ImportFinaDataLogic.GetDTBySheetname("基人二", bt, 10, 12);
dt3 = ImportFinaDataLogic.GetDTBySheetname("基公", bt, 9, 21);
dt4 = ImportFinaDataLogic.GetDTBySheetname("项目支出", bt, 9, 15);
}
else
{
Response.Write("没有数据");
}
bt = null;
DateTime dtime = Convert.ToDateTime(CurrentYear + "-" + "01-" + "01");
BG_ProBasiPerPayOne PBPPOM = new BG_ProBasiPerPayOne();
PBPPOM.POBS = ParToDecimal.ParToDel(dt1.Rows[0][4].ToString());
PBPPOM.POAS = ParToDecimal.ParToDel(dt1.Rows[0][5].ToString());
PBPPOM.POBonus = ParToDecimal.ParToDel(dt1.Rows[0][6].ToString());
PBPPOM.POPS = ParToDecimal.ParToDel(dt1.Rows[0][7].ToString());
PBPPOM.POSE = ParToDecimal.ParToDel(dt1.Rows[0][8].ToString());
PBPPOM.POOther = ParToDecimal.ParToDel(dt1.Rows[0][9].ToString());
PBPPOM.POTitol = ParToDecimal.ParToDel(dt1.Rows[0][3].ToString());
PBPPOM.POYear = dtime;
PBPPOM.DepID = AreaDepID;
BG_ProBasiPerPayOneManager.AddBG_ProBasiPerPayOne(PBPPOM);
BG_ProBasiPerPayTwo PBPPT = new BG_ProBasiPerPayTwo();
PBPPT.RetiredPerP = ParToDecimal.ParToDel(dt2.Rows[0][5].ToString());
PBPPT.RetiredPubP = ParToDecimal.ParToDel(dt2.Rows[0][6].ToString());
PBPPT.RetirementPerP = ParToDecimal.ParToDel(dt2.Rows[0][9].ToString());
PBPPT.RetirementPubP = ParToDecimal.ParToDel(dt2.Rows[0][8].ToString());
PBPPT.PTME = ParToDecimal.ParToDel(dt2.Rows[0][10].ToString());
PBPPT.PTOther = ParToDecimal.ParToDel(dt2.Rows[0][11].ToString());
PBPPT.PTTitol = ParToDecimal.ParToDel(dt2.Rows[0][3].ToString());
PBPPT.PTYear = dtime;
PBPPT.DepID = AreaDepID;
BG_ProBasiPerPayTwoManager.AddBG_ProBasiPerPayTwo(PBPPT);
BG_ProBasiPubPay PBPP = new BG_ProBasiPubPay();
PBPP.PBOE = ParToDecimal.ParToDel(dt3.Rows[0][5].ToString());
PBPP.PBUtilities = ParToDecimal.ParToDel(dt3.Rows[0][6].ToString());
PBPP.PBPF = ParToDecimal.ParToDel(dt3.Rows[0][7].ToString());
PBPP.OBCFE = ParToDecimal.ParToDel(dt3.Rows[0][8].ToString());
PBPP.PBTravelE = ParToDecimal.ParToDel(dt3.Rows[0][9].ToString());
PBPP.PBRE = ParToDecimal.ParToDel(dt3.Rows[0][10].ToString());
PBPP.PBME = ParToDecimal.ParToDel(dt3.Rows[0][11].ToString());
PBPP.PBTrainE = ParToDecimal.ParToDel(dt3.Rows[0][12].ToString());
PBPP.OBRE = ParToDecimal.ParToDel(dt3.Rows[0][13].ToString());
PBPP.PBAE = ParToDecimal.ParToDel(dt3.Rows[0][14].ToString());
PBPP.LUMD = ParToDecimal.ParToDel(dt3.Rows[0][15].ToString());
PBPP.PBWE = ParToDecimal.ParToDel(dt3.Rows[0][16].ToString());
PBPP.PBOCE = ParToDecimal.ParToDel(dt3.Rows[0][17].ToString());
PBPP.OCASE = ParToDecimal.ParToDel(dt3.Rows[0][19].ToString());
PBPP.PBIDTitol = ParToDecimal.ParToDel(dt3.Rows[0][3].ToString());
PBPP.PBYear = dtime;
PBPP.DepID = AreaDepID;
BG_ProBasiPubPayManager.AddBG_ProBasiPubPay(PBPP);
for (int i = 0; i < dt4.Rows.Count; i++)
{
if (string.IsNullOrEmpty(dt4.Rows[i][3].ToString()))
{
return;
}
BG_ProPay PP = new BG_ProPay();
PP.PPID = dt4.Rows[i][3].ToString().Trim();
PP.ProPA0M = ParToDecimal.ParToDel(dt4.Rows[i][4].ToString());
PP.ProPYear = dtime;
PP.DepID = AreaDepID;
BG_ProPayManager.AddBG_ProPay(PP);
}
X.Msg.Alert("提示", "导入成功.").Show();
}
public static bool DeleteBG_ProBasiPerPayOne(BG_ProBasiPerPayOne bG_ProBasiPerPayOne)
{
return DeleteBG_ProBasiPerPayOneByPOID( bG_ProBasiPerPayOne.POID );
}
public static bool ModifyBG_ProBasiPerPayOne(BG_ProBasiPerPayOne bG_ProBasiPerPayOne)
{
string sql =
"UPDATE BG_ProBasiPerPayOne " +
"SET " +
"DepID = @DepID, " +
"POYear = @POYear, " +
"POBS = @POBS, " +
"POAS = @POAS, " +
"POBonus = @POBonus, " +
"POPS = @POPS, " +
"POSE = @POSE, " +
"POOther = @POOther, " +
"POTitol = @POTitol " +
"WHERE POID = @POID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@POID", bG_ProBasiPerPayOne.POID),
new SqlParameter("@DepID", bG_ProBasiPerPayOne.DepID),
new SqlParameter("@POYear", bG_ProBasiPerPayOne.POYear),
new SqlParameter("@POBS", bG_ProBasiPerPayOne.POBS),
new SqlParameter("@POAS", bG_ProBasiPerPayOne.POAS),
new SqlParameter("@POBonus", bG_ProBasiPerPayOne.POBonus),
new SqlParameter("@POPS", bG_ProBasiPerPayOne.POPS),
new SqlParameter("@POSE", bG_ProBasiPerPayOne.POSE),
new SqlParameter("@POOther", bG_ProBasiPerPayOne.POOther),
new SqlParameter("@POTitol", bG_ProBasiPerPayOne.POTitol)
};
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 BG_ProBasiPerPayOne GetBG_ProBasiPerPayOneByPOID(int pOID)
{
string sql = "SELECT * FROM BG_ProBasiPerPayOne WHERE POID = @POID";
try
{
SqlParameter para = new SqlParameter("@POID", pOID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_ProBasiPerPayOne bG_ProBasiPerPayOne = new BG_ProBasiPerPayOne();
bG_ProBasiPerPayOne.POID = dt.Rows[0]["POID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["POID"];
bG_ProBasiPerPayOne.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_ProBasiPerPayOne.POYear = dt.Rows[0]["POYear"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["POYear"];
bG_ProBasiPerPayOne.POBS = dt.Rows[0]["POBS"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POBS"];
bG_ProBasiPerPayOne.POAS = dt.Rows[0]["POAS"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POAS"];
bG_ProBasiPerPayOne.POBonus = dt.Rows[0]["POBonus"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POBonus"];
bG_ProBasiPerPayOne.POPS = dt.Rows[0]["POPS"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POPS"];
bG_ProBasiPerPayOne.POSE = dt.Rows[0]["POSE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POSE"];
bG_ProBasiPerPayOne.POOther = dt.Rows[0]["POOther"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POOther"];
bG_ProBasiPerPayOne.POTitol = dt.Rows[0]["POTitol"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POTitol"];
return bG_ProBasiPerPayOne;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool ModifyBG_ProBasiPerPayOne(BG_ProBasiPerPayOne bG_ProBasiPerPayOne)
{
return BG_ProBasiPerPayOneService.ModifyBG_ProBasiPerPayOne(bG_ProBasiPerPayOne);
}
public static bool DeleteBG_ProBasiPerPayOne(BG_ProBasiPerPayOne bG_ProBasiPerPayOne)
{
return BG_ProBasiPerPayOneService.DeleteBG_ProBasiPerPayOne(bG_ProBasiPerPayOne);
}
public static BG_ProBasiPerPayOne AddBG_ProBasiPerPayOne(BG_ProBasiPerPayOne bG_ProBasiPerPayOne)
{
return BG_ProBasiPerPayOneService.AddBG_ProBasiPerPayOne(bG_ProBasiPerPayOne);
}
