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