/// <summary>
/// 添加一条【工资福利支出】记录 BG_PayWelExpen
/// </summary>
/// <param name="dpb">BGPayWelExpen</param>
/// <returns>bool</returns>
public static bool AddPWE(BG_PayWelExpen pwe)
{
bool falg = false;
try
{
string sqlStr = @"insert into BG_PayWelExpen(PWEYear,DepID,PWESubTotal,PWEBasWage,PWEAlloSub,PWEPrize,PWEPerWage,PWESafePay,PWEOth)
values(@PWEYear,@DepID,@PWESubTotal,@PWEBasWage,@PWEAlloSub,@PWEPrize,@PWEPerWage,@PWESafePay,@PWEOth)";
SqlParameter[] Pars = new SqlParameter[] {
new SqlParameter("@PWEYear", pwe.PWEYear),
new SqlParameter("@DepID", pwe.DepID),
new SqlParameter("@PWESubTotal", pwe.PWESubTotal),
new SqlParameter("@PWEBasWage", pwe.PWEBasWage),
new SqlParameter("@PWEAlloSub", pwe.PWEAlloSub),
new SqlParameter("@PWEPrize", pwe.PWEPrize),
new SqlParameter("@PWEPerWage", pwe.PWEPerWage),
new SqlParameter("@PWEOth", pwe.PWEOth),
new SqlParameter("@PWESafePay", pwe.PWESafePay)
};
falg = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0;
}
catch (Exception ex)
{
falg = false;
Log.WriteLog(ex.Message, "BGPayWelSupplyService--AddPWS");
}
return(falg);
}
public static BG_PayWelExpen AddBG_PayWelExpen(BG_PayWelExpen bG_PayWelExpen)
{
string sql =
"INSERT BG_PayWelExpen (PWEYear, DepID, PWESubTotal, PWEBasWage, PWEAlloSub, PWEPrize, PWEPerWage, PWESafePay, PWEOth)" +
"VALUES (@PWEYear, @DepID, @PWESubTotal, @PWEBasWage, @PWEAlloSub, @PWEPrize, @PWEPerWage, @PWESafePay, @PWEOth)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PWEYear", bG_PayWelExpen.PWEYear),
new SqlParameter("@DepID", bG_PayWelExpen.DepID),
new SqlParameter("@PWESubTotal", bG_PayWelExpen.PWESubTotal),
new SqlParameter("@PWEBasWage", bG_PayWelExpen.PWEBasWage),
new SqlParameter("@PWEAlloSub", bG_PayWelExpen.PWEAlloSub),
new SqlParameter("@PWEPrize", bG_PayWelExpen.PWEPrize),
new SqlParameter("@PWEPerWage", bG_PayWelExpen.PWEPerWage),
new SqlParameter("@PWESafePay", bG_PayWelExpen.PWESafePay),
new SqlParameter("@PWEOth", bG_PayWelExpen.PWEOth)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return(GetBG_PayWelExpenByPWEID(newId));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool ModifyBG_PayWelExpen(BG_PayWelExpen bG_PayWelExpen)
{
string sql =
"UPDATE BG_PayWelExpen " +
"SET " +
"PWEYear = @PWEYear, " +
"DepID = @DepID, " +
"PWESubTotal = @PWESubTotal, " +
"PWEBasWage = @PWEBasWage, " +
"PWEAlloSub = @PWEAlloSub, " +
"PWEPrize = @PWEPrize, " +
"PWEPerWage = @PWEPerWage, " +
"PWESafePay = @PWESafePay, " +
"PWEOth = @PWEOth " +
"WHERE PWEID = @PWEID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PWEID", bG_PayWelExpen.PWEID),
new SqlParameter("@PWEYear", bG_PayWelExpen.PWEYear),
new SqlParameter("@DepID", bG_PayWelExpen.DepID),
new SqlParameter("@PWESubTotal", bG_PayWelExpen.PWESubTotal),
new SqlParameter("@PWEBasWage", bG_PayWelExpen.PWEBasWage),
new SqlParameter("@PWEAlloSub", bG_PayWelExpen.PWEAlloSub),
new SqlParameter("@PWEPrize", bG_PayWelExpen.PWEPrize),
new SqlParameter("@PWEPerWage", bG_PayWelExpen.PWEPerWage),
new SqlParameter("@PWESafePay", bG_PayWelExpen.PWESafePay),
new SqlParameter("@PWEOth", bG_PayWelExpen.PWEOth)
};
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_PayWelExpen GetBG_PayWelExpenByPWEID(int pWEID)
{
string sql = "SELECT * FROM BG_PayWelExpen WHERE PWEID = @PWEID";
try
{
SqlParameter para = new SqlParameter("@PWEID", pWEID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_PayWelExpen bG_PayWelExpen = new BG_PayWelExpen();
bG_PayWelExpen.PWEID = dt.Rows[0]["PWEID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PWEID"];
bG_PayWelExpen.PWEYear = dt.Rows[0]["PWEYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PWEYear"];
bG_PayWelExpen.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_PayWelExpen.PWESubTotal = dt.Rows[0]["PWESubTotal"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWESubTotal"];
bG_PayWelExpen.PWEBasWage = dt.Rows[0]["PWEBasWage"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWEBasWage"];
bG_PayWelExpen.PWEAlloSub = dt.Rows[0]["PWEAlloSub"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWEAlloSub"];
bG_PayWelExpen.PWEPrize = dt.Rows[0]["PWEPrize"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWEPrize"];
bG_PayWelExpen.PWEPerWage = dt.Rows[0]["PWEPerWage"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWEPerWage"];
bG_PayWelExpen.PWESafePay = dt.Rows[0]["PWESafePay"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWESafePay"];
bG_PayWelExpen.PWEOth = dt.Rows[0]["PWEOth"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWEOth"];
return(bG_PayWelExpen);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 添加一条【工资福利支出】记录 BG_PayWelExpen
/// </summary>
/// <param name="dpb">BGPayWelExpen</param>
/// <returns>bool</returns>
public static bool AddPWE(BG_PayWelExpen pwe)
{
return(BGPayWelExpenService.AddPWE(pwe));
}
public static bool ModifyBG_PayWelExpen(BG_PayWelExpen bG_PayWelExpen)
{
return(BG_PayWelExpenService.ModifyBG_PayWelExpen(bG_PayWelExpen));
}
public static bool DeleteBG_PayWelExpen(BG_PayWelExpen bG_PayWelExpen)
{
return(BG_PayWelExpenService.DeleteBG_PayWelExpen(bG_PayWelExpen));
}
public static BG_PayWelExpen AddBG_PayWelExpen(BG_PayWelExpen bG_PayWelExpen)
{
return(BG_PayWelExpenService.AddBG_PayWelExpen(bG_PayWelExpen));
}
public static bool DeleteBG_PayWelExpen(BG_PayWelExpen bG_PayWelExpen)
{
return(DeleteBG_PayWelExpenByPWEID(bG_PayWelExpen.PWEID));
}