public int Delete(Model.BM_COMMON t,Trans trans) { DBHelper db = new DBHelper(); DbCommand cmd = db.GetSqlStringCommand("DELETE FROM BM_COMMON WHERE bg_id = " + t.bg_id); return db.ExecuteNonQuery(cmd,trans); }
public int Delete(Role Role_Code) { DBHelper db = new DBHelper(); DbCommand cmd = db.GetSqlStringCommand("DELETE FROM Role WHERE Role_Code = '" + Role_Code.Role_Code+"'"); return db.ExecuteNonQuery(cmd); }
public int Update(Model.BM_COMMON t,Trans trans) { DBHelper db = new DBHelper(); DbCommand cmd = db.GetStoredProcCommand("p_BM_COMMON_update"); db.AddInParameter(cmd, "@bg_id", DbType.Int32, t.bg_id); db.AddInParameter(cmd, "@bg_lx", DbType.String, t.bg_lx); db.AddInParameter(cmd, "@bg_lxmc", DbType.String, t.bg_lxmc); db.AddInParameter(cmd, "@bg_bm", DbType.String, t.bg_bm); db.AddInParameter(cmd, "@bg_mc", DbType.String, t.bg_mc); db.AddInParameter(cmd, "@bg_pysx", DbType.String, t.bg_pysx); db.AddInParameter(cmd, "@bg_xh", DbType.Int32, t.bg_xh); db.AddInParameter(cmd, "@bg_bz", DbType.String, t.bg_bz); return db.ExecuteNonQuery(cmd,trans); }
public int Update(Role Role) { DBHelper db = new DBHelper(); DbCommand cmd = db.GetStoredProcCommand("p_Role_update"); db.AddInParameter(cmd, "@Role_Code", DbType.Guid, Role.Role_Code); db.AddInParameter(cmd, "@Role_Name", DbType.String, Role.Role_Name); db.AddInParameter(cmd, "@DES", DbType.String, Role.DES); return db.ExecuteNonQuery(cmd); }