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 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 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)
{
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));
}
