public static BG_PrjJonSub AddBG_PrjJonSub(BG_PrjJonSub bG_PrjJonSub)
{
string sql =
"INSERT BG_PrjJonSub (PPID, PIID)" +
"VALUES (@PPID, @PIID)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PPID", bG_PrjJonSub.PPID),
new SqlParameter("@PIID", bG_PrjJonSub.PIID)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_PrjJonSubByPSID(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PrjJonSub GetBG_PrjJonSubByPSID(int pSID)
{
string sql = "SELECT * FROM BG_PrjJonSub WHERE PSID = @PSID";
try
{
SqlParameter para = new SqlParameter("@PSID", pSID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_PrjJonSub bG_PrjJonSub = new BG_PrjJonSub();
bG_PrjJonSub.PSID = dt.Rows[0]["PSID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PSID"];
bG_PrjJonSub.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"];
bG_PrjJonSub.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
return bG_PrjJonSub;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool DeleteBG_PrjJonSub(BG_PrjJonSub bG_PrjJonSub)
{
return DeleteBG_PrjJonSubByPSID( bG_PrjJonSub.PSID );
}
public static bool ModifyBG_PrjJonSub(BG_PrjJonSub bG_PrjJonSub)
{
string sql =
"UPDATE BG_PrjJonSub " +
"SET " +
"PPID = @PPID, " +
"PIID = @PIID " +
"WHERE PSID = @PSID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PSID", bG_PrjJonSub.PSID),
new SqlParameter("@PPID", bG_PrjJonSub.PPID),
new SqlParameter("@PIID", bG_PrjJonSub.PIID)
};
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_PrjJonSub(BG_PrjJonSub bG_PrjJonSub)
{
return BG_PrjJonSubService.ModifyBG_PrjJonSub(bG_PrjJonSub);
}
public static bool DeleteBG_PrjJonSub(BG_PrjJonSub bG_PrjJonSub)
{
return BG_PrjJonSubService.DeleteBG_PrjJonSub(bG_PrjJonSub);
}
public static BG_PrjJonSub AddBG_PrjJonSub(BG_PrjJonSub bG_PrjJonSub)
{
return BG_PrjJonSubService.AddBG_PrjJonSub(bG_PrjJonSub);
}