public static BG_MonPayPlan AddBG_MonPayPlan(BG_MonPayPlan bG_MonPayPlan)
{
string sql =
"INSERT BG_MonPayPlan (PIID, MPFunding, DeptID, MPTime, MPRemark, MPFundingAdd, MPFundingAddTimes)" +
"VALUES (@PIID, @MPFunding, @DeptID, @MPTime, @MPRemark, @MPFundingAdd, @MPFundingAddTimes)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PIID", bG_MonPayPlan.PIID),
new SqlParameter("@MPFunding", bG_MonPayPlan.MPFunding),
new SqlParameter("@DeptID", bG_MonPayPlan.DeptID),
new SqlParameter("@MPTime", bG_MonPayPlan.MPTime),
new SqlParameter("@MPRemark", bG_MonPayPlan.MPRemark),
new SqlParameter("@MPFundingAdd", bG_MonPayPlan.MPFundingAdd),
new SqlParameter("@MPFundingAddTimes", bG_MonPayPlan.MPFundingAddTimes)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return(GetBG_MonPayPlanByCPID(newId));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_MonPayPlan GetBG_MonPayPlanByCPID(int cPID)
{
string sql = "SELECT * FROM BG_MonPayPlan WHERE CPID = @CPID";
try
{
SqlParameter para = new SqlParameter("@CPID", cPID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_MonPayPlan bG_MonPayPlan = new BG_MonPayPlan();
bG_MonPayPlan.CPID = dt.Rows[0]["CPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPID"];
bG_MonPayPlan.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_MonPayPlan.MPFunding = dt.Rows[0]["MPFunding"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFunding"];
bG_MonPayPlan.DeptID = dt.Rows[0]["DeptID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DeptID"];
bG_MonPayPlan.MPTime = dt.Rows[0]["MPTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MPTime"];
bG_MonPayPlan.MPRemark = dt.Rows[0]["MPRemark"] == DBNull.Value ? "" : (string)dt.Rows[0]["MPRemark"];
bG_MonPayPlan.MPFundingAdd = dt.Rows[0]["MPFundingAdd"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFundingAdd"];
bG_MonPayPlan.MPFundingAddTimes = dt.Rows[0]["MPFundingAddTimes"] == DBNull.Value ? 0 : (int)dt.Rows[0]["MPFundingAddTimes"];
return(bG_MonPayPlan);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool ModifyBG_MonPayPlan(BG_MonPayPlan bG_MonPayPlan)
{
string sql =
"UPDATE BG_MonPayPlan " +
"SET " +
"PIID = @PIID, " +
"MPFunding = @MPFunding, " +
"DeptID = @DeptID, " +
"MPTime = @MPTime, " +
"MPRemark = @MPRemark, " +
"MPFundingAdd = @MPFundingAdd, " +
"MPFundingAddTimes = @MPFundingAddTimes " +
"WHERE CPID = @CPID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CPID", bG_MonPayPlan.CPID),
new SqlParameter("@PIID", bG_MonPayPlan.PIID),
new SqlParameter("@MPFunding", bG_MonPayPlan.MPFunding),
new SqlParameter("@DeptID", bG_MonPayPlan.DeptID),
new SqlParameter("@MPTime", bG_MonPayPlan.MPTime),
new SqlParameter("@MPRemark", bG_MonPayPlan.MPRemark),
new SqlParameter("@MPFundingAdd", bG_MonPayPlan.MPFundingAdd),
new SqlParameter("@MPFundingAddTimes", bG_MonPayPlan.MPFundingAddTimes)
};
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 bool DeleteBG_MonPayPlan(BG_MonPayPlan bG_MonPayPlan)
{
return(DeleteBG_MonPayPlanByCPID(bG_MonPayPlan.CPID));
}
public static bool ModifyBG_MonPayPlan(BG_MonPayPlan bG_MonPayPlan)
{
return(BG_MonPayPlanService.ModifyBG_MonPayPlan(bG_MonPayPlan));
}
public static bool DeleteBG_MonPayPlan(BG_MonPayPlan bG_MonPayPlan)
{
return(BG_MonPayPlanService.DeleteBG_MonPayPlan(bG_MonPayPlan));
}
public static BG_MonPayPlan AddBG_MonPayPlan(BG_MonPayPlan bG_MonPayPlan)
{
return(BG_MonPayPlanService.AddBG_MonPayPlan(bG_MonPayPlan));
}
