public static BG_OutlayCK AddBG_OutlayCK(BG_OutlayCK bG_OutlayCK)
{
string sql =
"INSERT BG_OutlayCK (PIID, PPID, DepID, OACkMon, OATime, OACkType)" +
"VALUES (@PIID, @PPID, @DepID, @OACkMon, @OATime, @OACkType)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PIID", bG_OutlayCK.PIID),
new SqlParameter("@PPID", bG_OutlayCK.PPID),
new SqlParameter("@DepID", bG_OutlayCK.DepID),
new SqlParameter("@OACkMon", bG_OutlayCK.OACkMon),
new SqlParameter("@OATime", bG_OutlayCK.OATime),
new SqlParameter("@OACkType", bG_OutlayCK.OACkType)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_OutlayCKByOAID(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool ModifyBG_OutlayCK(BG_OutlayCK bG_OutlayCK)
{
return BG_OutlayCKService.ModifyBG_OutlayCK(bG_OutlayCK);
}
public static bool DeleteBG_OutlayCK(BG_OutlayCK bG_OutlayCK)
{
return BG_OutlayCKService.DeleteBG_OutlayCK(bG_OutlayCK);
}
public static BG_OutlayCK AddBG_OutlayCK(BG_OutlayCK bG_OutlayCK)
{
return BG_OutlayCKService.AddBG_OutlayCK(bG_OutlayCK);
}
public static BG_OutlayCK GetBG_OutlayCKByOAID(int oAID)
{
string sql = "SELECT * FROM BG_OutlayCK WHERE OAID = @OAID";
try
{
SqlParameter para = new SqlParameter("@OAID", oAID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_OutlayCK bG_OutlayCK = new BG_OutlayCK();
bG_OutlayCK.OAID = dt.Rows[0]["OAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["OAID"];
bG_OutlayCK.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_OutlayCK.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"];
bG_OutlayCK.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_OutlayCK.OACkMon = dt.Rows[0]["OACkMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["OACkMon"];
bG_OutlayCK.OATime = dt.Rows[0]["OATime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["OATime"];
bG_OutlayCK.OACkType = dt.Rows[0]["OACkType"] == DBNull.Value ? "" : (string)dt.Rows[0]["OACkType"];
return bG_OutlayCK;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool DeleteBG_OutlayCK(BG_OutlayCK bG_OutlayCK)
{
return DeleteBG_OutlayCKByOAID( bG_OutlayCK.OAID );
}
public static bool ModifyBG_OutlayCK(BG_OutlayCK bG_OutlayCK)
{
string sql =
"UPDATE BG_OutlayCK " +
"SET " +
"PIID = @PIID, " +
"PPID = @PPID, " +
"DepID = @DepID, " +
"OACkMon = @OACkMon, " +
"OATime = @OATime, " +
"OACkType = @OACkType " +
"WHERE OAID = @OAID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@OAID", bG_OutlayCK.OAID),
new SqlParameter("@PIID", bG_OutlayCK.PIID),
new SqlParameter("@PPID", bG_OutlayCK.PPID),
new SqlParameter("@DepID", bG_OutlayCK.DepID),
new SqlParameter("@OACkMon", bG_OutlayCK.OACkMon),
new SqlParameter("@OATime", bG_OutlayCK.OATime),
new SqlParameter("@OACkType", bG_OutlayCK.OACkType)
};
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;
}
}
