public static bool ModifyBG_FixedAssets(BG_FixedAssets bG_FixedAssets)
{
string sql =
"UPDATE BG_FixedAssets " +
"SET " +
"FACode = @FACode, " +
"FAMon = @FAMon, " +
"FAYear = @FAYear, " +
"FAMonth = @FAMonth " +
"WHERE FAID = @FAID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@FAID", bG_FixedAssets.FAID),
new SqlParameter("@FACode", bG_FixedAssets.FACode),
new SqlParameter("@FAMon", bG_FixedAssets.FAMon),
new SqlParameter("@FAYear", bG_FixedAssets.FAYear),
new SqlParameter("@FAMonth", bG_FixedAssets.FAMonth)
};
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 ModifyBG_FixedAssets(BG_FixedAssets bG_FixedAssets)
{
return(BG_FixedAssetsService.ModifyBG_FixedAssets(bG_FixedAssets));
}
public static bool DeleteBG_FixedAssets(BG_FixedAssets bG_FixedAssets)
{
return(BG_FixedAssetsService.DeleteBG_FixedAssets(bG_FixedAssets));
}
public static BG_FixedAssets AddBG_FixedAssets(BG_FixedAssets bG_FixedAssets)
{
return(BG_FixedAssetsService.AddBG_FixedAssets(bG_FixedAssets));
}
public static bool DeleteBG_FixedAssets(BG_FixedAssets bG_FixedAssets)
{
return(DeleteBG_FixedAssetsByFAID(bG_FixedAssets.FAID));
}