public static BG_ProBasiPubPay AddBG_ProBasiPubPay(BG_ProBasiPubPay bG_ProBasiPubPay)
{
string sql =
"INSERT BG_ProBasiPubPay (DepID, PBYear, PBOE, PBUtilities, PBPF, OBCFE, PBTravelE, PBRE, PBME, PBTrainE, OBRE, PBAE, LUMD, PBWE, PBOCE, OOPE, OCASE, PBIDTitol)" +
"VALUES (@DepID, @PBYear, @PBOE, @PBUtilities, @PBPF, @OBCFE, @PBTravelE, @PBRE, @PBME, @PBTrainE, @OBRE, @PBAE, @LUMD, @PBWE, @PBOCE, @OOPE, @OCASE, @PBIDTitol)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DepID", bG_ProBasiPubPay.DepID),
new SqlParameter("@PBYear", bG_ProBasiPubPay.PBYear),
new SqlParameter("@PBOE", bG_ProBasiPubPay.PBOE),
new SqlParameter("@PBUtilities", bG_ProBasiPubPay.PBUtilities),
new SqlParameter("@PBPF", bG_ProBasiPubPay.PBPF),
new SqlParameter("@OBCFE", bG_ProBasiPubPay.OBCFE),
new SqlParameter("@PBTravelE", bG_ProBasiPubPay.PBTravelE),
new SqlParameter("@PBRE", bG_ProBasiPubPay.PBRE),
new SqlParameter("@PBME", bG_ProBasiPubPay.PBME),
new SqlParameter("@PBTrainE", bG_ProBasiPubPay.PBTrainE),
new SqlParameter("@OBRE", bG_ProBasiPubPay.OBRE),
new SqlParameter("@PBAE", bG_ProBasiPubPay.PBAE),
new SqlParameter("@LUMD", bG_ProBasiPubPay.LUMD),
new SqlParameter("@PBWE", bG_ProBasiPubPay.PBWE),
new SqlParameter("@PBOCE", bG_ProBasiPubPay.PBOCE),
new SqlParameter("@OOPE", bG_ProBasiPubPay.OOPE),
new SqlParameter("@OCASE", bG_ProBasiPubPay.OCASE),
new SqlParameter("@PBIDTitol", bG_ProBasiPubPay.PBIDTitol)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_ProBasiPubPayByPBID(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 ModifyBG_ProBasiPubPay(BG_ProBasiPubPay bG_ProBasiPubPay)
{
return BG_ProBasiPubPayService.ModifyBG_ProBasiPubPay(bG_ProBasiPubPay);
}
public static bool DeleteBG_ProBasiPubPay(BG_ProBasiPubPay bG_ProBasiPubPay)
{
return BG_ProBasiPubPayService.DeleteBG_ProBasiPubPay(bG_ProBasiPubPay);
}
public static BG_ProBasiPubPay AddBG_ProBasiPubPay(BG_ProBasiPubPay bG_ProBasiPubPay)
{
return BG_ProBasiPubPayService.AddBG_ProBasiPubPay(bG_ProBasiPubPay);
}
public static bool DeleteBG_ProBasiPubPay(BG_ProBasiPubPay bG_ProBasiPubPay)
{
return DeleteBG_ProBasiPubPayByPBID( bG_ProBasiPubPay.PBID );
}
public static bool ModifyBG_ProBasiPubPay(BG_ProBasiPubPay bG_ProBasiPubPay)
{
string sql =
"UPDATE BG_ProBasiPubPay " +
"SET " +
"DepID = @DepID, " +
"PBYear = @PBYear, " +
"PBOE = @PBOE, " +
"PBUtilities = @PBUtilities, " +
"PBPF = @PBPF, " +
"OBCFE = @OBCFE, " +
"PBTravelE = @PBTravelE, " +
"PBRE = @PBRE, " +
"PBME = @PBME, " +
"PBTrainE = @PBTrainE, " +
"OBRE = @OBRE, " +
"PBAE = @PBAE, " +
"LUMD = @LUMD, " +
"PBWE = @PBWE, " +
"PBOCE = @PBOCE, " +
"OOPE = @OOPE, " +
"OCASE = @OCASE, " +
"PBIDTitol = @PBIDTitol " +
"WHERE PBID = @PBID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PBID", bG_ProBasiPubPay.PBID),
new SqlParameter("@DepID", bG_ProBasiPubPay.DepID),
new SqlParameter("@PBYear", bG_ProBasiPubPay.PBYear),
new SqlParameter("@PBOE", bG_ProBasiPubPay.PBOE),
new SqlParameter("@PBUtilities", bG_ProBasiPubPay.PBUtilities),
new SqlParameter("@PBPF", bG_ProBasiPubPay.PBPF),
new SqlParameter("@OBCFE", bG_ProBasiPubPay.OBCFE),
new SqlParameter("@PBTravelE", bG_ProBasiPubPay.PBTravelE),
new SqlParameter("@PBRE", bG_ProBasiPubPay.PBRE),
new SqlParameter("@PBME", bG_ProBasiPubPay.PBME),
new SqlParameter("@PBTrainE", bG_ProBasiPubPay.PBTrainE),
new SqlParameter("@OBRE", bG_ProBasiPubPay.OBRE),
new SqlParameter("@PBAE", bG_ProBasiPubPay.PBAE),
new SqlParameter("@LUMD", bG_ProBasiPubPay.LUMD),
new SqlParameter("@PBWE", bG_ProBasiPubPay.PBWE),
new SqlParameter("@PBOCE", bG_ProBasiPubPay.PBOCE),
new SqlParameter("@OOPE", bG_ProBasiPubPay.OOPE),
new SqlParameter("@OCASE", bG_ProBasiPubPay.OCASE),
new SqlParameter("@PBIDTitol", bG_ProBasiPubPay.PBIDTitol)
};
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_ProBasiPubPay GetBG_ProBasiPubPayByPBID(int pBID)
{
string sql = "SELECT * FROM BG_ProBasiPubPay WHERE PBID = @PBID";
try
{
SqlParameter para = new SqlParameter("@PBID", pBID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_ProBasiPubPay bG_ProBasiPubPay = new BG_ProBasiPubPay();
bG_ProBasiPubPay.PBID = dt.Rows[0]["PBID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PBID"];
bG_ProBasiPubPay.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_ProBasiPubPay.PBYear = dt.Rows[0]["PBYear"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["PBYear"];
bG_ProBasiPubPay.PBOE = dt.Rows[0]["PBOE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBOE"];
bG_ProBasiPubPay.PBUtilities = dt.Rows[0]["PBUtilities"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBUtilities"];
bG_ProBasiPubPay.PBPF = dt.Rows[0]["PBPF"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBPF"];
bG_ProBasiPubPay.OBCFE = dt.Rows[0]["OBCFE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["OBCFE"];
bG_ProBasiPubPay.PBTravelE = dt.Rows[0]["PBTravelE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBTravelE"];
bG_ProBasiPubPay.PBRE = dt.Rows[0]["PBRE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBRE"];
bG_ProBasiPubPay.PBME = dt.Rows[0]["PBME"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBME"];
bG_ProBasiPubPay.PBTrainE = dt.Rows[0]["PBTrainE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBTrainE"];
bG_ProBasiPubPay.OBRE = dt.Rows[0]["OBRE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["OBRE"];
bG_ProBasiPubPay.PBAE = dt.Rows[0]["PBAE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBAE"];
bG_ProBasiPubPay.LUMD = dt.Rows[0]["LUMD"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["LUMD"];
bG_ProBasiPubPay.PBWE = dt.Rows[0]["PBWE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBWE"];
bG_ProBasiPubPay.PBOCE = dt.Rows[0]["PBOCE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBOCE"];
bG_ProBasiPubPay.OOPE = dt.Rows[0]["OOPE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["OOPE"];
bG_ProBasiPubPay.OCASE = dt.Rows[0]["OCASE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["OCASE"];
bG_ProBasiPubPay.PBIDTitol = dt.Rows[0]["PBIDTitol"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PBIDTitol"];
return bG_ProBasiPubPay;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}