public static BG_PreviewDevide AddBG_PreviewDevide(BG_PreviewDevide bG_PreviewDevide) { string sql = "INSERT BG_PreviewDevide (DepID, PSID, DevMon)" + "VALUES (@DepID, @PSID, @DevMon)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@DepID", bG_PreviewDevide.DepID), new SqlParameter("@PSID", bG_PreviewDevide.PSID), new SqlParameter("@DevMon", bG_PreviewDevide.DevMon) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_PreviewDevideByPDID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_PreviewDevide GetBG_PreviewDevideByPDID(int pDID) { string sql = "SELECT * FROM BG_PreviewDevide WHERE PDID = @PDID"; try { SqlParameter para = new SqlParameter("@PDID", pDID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_PreviewDevide bG_PreviewDevide = new BG_PreviewDevide(); bG_PreviewDevide.PDID = dt.Rows[0]["PDID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PDID"]; bG_PreviewDevide.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_PreviewDevide.PSID = dt.Rows[0]["PSID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PSID"]; bG_PreviewDevide.DevMon = dt.Rows[0]["DevMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DevMon"]; return(bG_PreviewDevide); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool ModifyBG_PreviewDevide(BG_PreviewDevide bG_PreviewDevide) { string sql = "UPDATE BG_PreviewDevide " + "SET " + "DepID = @DepID, " + "PSID = @PSID, " + "DevMon = @DevMon " + "WHERE PDID = @PDID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PDID", bG_PreviewDevide.PDID), new SqlParameter("@DepID", bG_PreviewDevide.DepID), new SqlParameter("@PSID", bG_PreviewDevide.PSID), new SqlParameter("@DevMon", bG_PreviewDevide.DevMon) }; 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 DeleteBG_PreviewDevide(BG_PreviewDevide bG_PreviewDevide) { return(DeleteBG_PreviewDevideByPDID(bG_PreviewDevide.PDID)); }
public static bool ModifyBG_PreviewDevide(BG_PreviewDevide bG_PreviewDevide) { return(BG_PreviewDevideService.ModifyBG_PreviewDevide(bG_PreviewDevide)); }
public static bool DeleteBG_PreviewDevide(BG_PreviewDevide bG_PreviewDevide) { return(BG_PreviewDevideService.DeleteBG_PreviewDevide(bG_PreviewDevide)); }
public static BG_PreviewDevide AddBG_PreviewDevide(BG_PreviewDevide bG_PreviewDevide) { return(BG_PreviewDevideService.AddBG_PreviewDevide(bG_PreviewDevide)); }