public static BG_IncomeCK AddBG_IncomeCK(BG_IncomeCK bG_IncomeCK)
{
string sql =
"INSERT BG_IncomeCK (EIID, DepID, IACkMon, IATime)" +
"VALUES (@EIID, @DepID, @IACkMon, @IATime)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@EIID", bG_IncomeCK.EIID),
new SqlParameter("@DepID", bG_IncomeCK.DepID),
new SqlParameter("@IACkMon", bG_IncomeCK.IACkMon),
new SqlParameter("@IATime", bG_IncomeCK.IATime)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_IncomeCKByIKID(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool ModifyBG_IncomeCK(BG_IncomeCK bG_IncomeCK)
{
return BG_IncomeCKService.ModifyBG_IncomeCK(bG_IncomeCK);
}
public static bool DeleteBG_IncomeCK(BG_IncomeCK bG_IncomeCK)
{
return BG_IncomeCKService.DeleteBG_IncomeCK(bG_IncomeCK);
}
public static BG_IncomeCK AddBG_IncomeCK(BG_IncomeCK bG_IncomeCK)
{
return BG_IncomeCKService.AddBG_IncomeCK(bG_IncomeCK);
}
public static BG_IncomeCK GetBG_IncomeCKByIKID(int iKID)
{
string sql = "SELECT * FROM BG_IncomeCK WHERE IKID = @IKID";
try
{
SqlParameter para = new SqlParameter("@IKID", iKID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_IncomeCK bG_IncomeCK = new BG_IncomeCK();
bG_IncomeCK.IKID = dt.Rows[0]["IKID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["IKID"];
bG_IncomeCK.EIID = dt.Rows[0]["EIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["EIID"];
bG_IncomeCK.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_IncomeCK.IACkMon = dt.Rows[0]["IACkMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["IACkMon"];
bG_IncomeCK.IATime = dt.Rows[0]["IATime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["IATime"];
return bG_IncomeCK;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool DeleteBG_IncomeCK(BG_IncomeCK bG_IncomeCK)
{
return DeleteBG_IncomeCKByIKID( bG_IncomeCK.IKID );
}
public static bool ModifyBG_IncomeCK(BG_IncomeCK bG_IncomeCK)
{
string sql =
"UPDATE BG_IncomeCK " +
"SET " +
"EIID = @EIID, " +
"DepID = @DepID, " +
"IACkMon = @IACkMon, " +
"IATime = @IATime " +
"WHERE IKID = @IKID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@IKID", bG_IncomeCK.IKID),
new SqlParameter("@EIID", bG_IncomeCK.EIID),
new SqlParameter("@DepID", bG_IncomeCK.DepID),
new SqlParameter("@IACkMon", bG_IncomeCK.IACkMon),
new SqlParameter("@IATime", bG_IncomeCK.IATime)
};
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;
}
}
