public static BG_UserPurview AddBG_UserPurview(BG_UserPurview bG_UserPurview) { string sql = "INSERT BG_UserPurview (UPName, Remark)" + "VALUES (@UPName, @Remark)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@UPName", bG_UserPurview.UPName), new SqlParameter("@Remark", bG_UserPurview.Remark) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return GetBG_UserPurviewByUPID(newId); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_UserPurview GetBG_UserPurviewByUPID(int uPID) { string sql = "SELECT * FROM BG_UserPurview WHERE UPID = @UPID"; try { SqlParameter para = new SqlParameter("@UPID", uPID); DataTable dt = DBUnity.AdapterToTab(sql, para); if(dt.Rows.Count > 0) { BG_UserPurview bG_UserPurview = new BG_UserPurview(); bG_UserPurview.UPID = dt.Rows[0]["UPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["UPID"]; bG_UserPurview.UPName = dt.Rows[0]["UPName"] == DBNull.Value ? "" : (string)dt.Rows[0]["UPName"]; bG_UserPurview.Remark = dt.Rows[0]["Remark"] == DBNull.Value ? "" : (string)dt.Rows[0]["Remark"]; return bG_UserPurview; } else { return null; } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool DeleteBG_UserPurview(BG_UserPurview bG_UserPurview) { return DeleteBG_UserPurviewByUPID( bG_UserPurview.UPID ); }
public static bool ModifyBG_UserPurview(BG_UserPurview bG_UserPurview) { string sql = "UPDATE BG_UserPurview " + "SET " + "UPName = @UPName, " + "Remark = @Remark " + "WHERE UPID = @UPID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@UPID", bG_UserPurview.UPID), new SqlParameter("@UPName", bG_UserPurview.UPName), new SqlParameter("@Remark", bG_UserPurview.Remark) }; 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_UserPurview(BG_UserPurview bG_UserPurview) { return BG_UserPurviewService.ModifyBG_UserPurview(bG_UserPurview); }
public static bool DeleteBG_UserPurview(BG_UserPurview bG_UserPurview) { return BG_UserPurviewService.DeleteBG_UserPurview(bG_UserPurview); }
public static BG_UserPurview AddBG_UserPurview(BG_UserPurview bG_UserPurview) { return BG_UserPurviewService.AddBG_UserPurview(bG_UserPurview); }