public static BG_MonPayPlanA AddBG_MonPayPlanA(BG_MonPayPlanA bG_MonPayPlanA)
{
string sql =
"INSERT BG_MonPayPlanA (CPID, MABasicExp, MAProExp, MATotal, MATime, MAFunding)" +
"VALUES (@CPID, @MABasicExp, @MAProExp, @MATotal, @MATime, @MAFunding)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CPID", bG_MonPayPlanA.CPID),
new SqlParameter("@MABasicExp", bG_MonPayPlanA.MABasicExp),
new SqlParameter("@MAProExp", bG_MonPayPlanA.MAProExp),
new SqlParameter("@MATotal", bG_MonPayPlanA.MATotal),
new SqlParameter("@MATime", bG_MonPayPlanA.MATime),
new SqlParameter("@MAFunding", bG_MonPayPlanA.MAFunding)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_MonPayPlanAByCAID(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_MonPayPlanA GetBG_MonPayPlanAByCAID(int cAID)
{
string sql = "SELECT * FROM BG_MonPayPlanA WHERE CAID = @CAID";
try
{
SqlParameter para = new SqlParameter("@CAID", cAID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_MonPayPlanA bG_MonPayPlanA = new BG_MonPayPlanA();
bG_MonPayPlanA.CAID = dt.Rows[0]["CAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CAID"];
bG_MonPayPlanA.CPID = dt.Rows[0]["CPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPID"];
bG_MonPayPlanA.MABasicExp = dt.Rows[0]["MABasicExp"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MABasicExp"];
bG_MonPayPlanA.MAProExp = dt.Rows[0]["MAProExp"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MAProExp"];
bG_MonPayPlanA.MATotal = dt.Rows[0]["MATotal"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MATotal"];
bG_MonPayPlanA.MATime = dt.Rows[0]["MATime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MATime"];
bG_MonPayPlanA.MAFunding = dt.Rows[0]["MAFunding"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MAFunding"];
return bG_MonPayPlanA;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool DeleteBG_MonPayPlanA(BG_MonPayPlanA bG_MonPayPlanA)
{
return DeleteBG_MonPayPlanAByCAID( bG_MonPayPlanA.CAID );
}
public static bool ModifyBG_MonPayPlanA(BG_MonPayPlanA bG_MonPayPlanA)
{
string sql =
"UPDATE BG_MonPayPlanA " +
"SET " +
"CPID = @CPID, " +
"MABasicExp = @MABasicExp, " +
"MAProExp = @MAProExp, " +
"MATotal = @MATotal, " +
"MATime = @MATime, " +
"MAFunding = @MAFunding " +
"WHERE CAID = @CAID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@CAID", bG_MonPayPlanA.CAID),
new SqlParameter("@CPID", bG_MonPayPlanA.CPID),
new SqlParameter("@MABasicExp", bG_MonPayPlanA.MABasicExp),
new SqlParameter("@MAProExp", bG_MonPayPlanA.MAProExp),
new SqlParameter("@MATotal", bG_MonPayPlanA.MATotal),
new SqlParameter("@MATime", bG_MonPayPlanA.MATime),
new SqlParameter("@MAFunding", bG_MonPayPlanA.MAFunding)
};
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;
}
}
