public static void ModifyT_BaseInfo(T_BaseInfo t_BaseInfo) { string sql = "UPDATE T_BaseInfo " + "SET " + "config_name = @config_name, " + "config_value = @config_value, " + "config_status = @config_status " + "WHERE Id = @Id"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Id", t_BaseInfo.Id), new SqlParameter("@config_name", DBHelper.GetValueByWhetherNull(t_BaseInfo.Config_name)), new SqlParameter("@config_value", DBHelper.GetValueByWhetherNull(t_BaseInfo.Config_value)), new SqlParameter("@config_status", DBHelper.GetValueByWhetherNull(t_BaseInfo.Config_status)) }; DBHelper.ExecuteCommand(sql, para); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static T_BaseInfo AddT_BaseInfo(T_BaseInfo t_BaseInfo) { string sql = "INSERT T_BaseInfo (config_name, config_value, config_status)" + "VALUES (@config_name, @config_value, @config_status)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@config_name", DBHelper.GetValueByWhetherNull(t_BaseInfo.Config_name)), new SqlParameter("@config_value", DBHelper.GetValueByWhetherNull(t_BaseInfo.Config_value)), new SqlParameter("@config_status", DBHelper.GetValueByWhetherNull(t_BaseInfo.Config_status)) }; int newId = DBHelper.GetScalar(sql, para); return(GetT_BaseInfoById(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static T_BaseInfo GetT_BaseInfoById(int id) { string sql = "SELECT * FROM T_BaseInfo WHERE Id = @Id"; try { SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@Id", id)); if (reader.Read()) { T_BaseInfo t_BaseInfo = new T_BaseInfo(); try{ t_BaseInfo.Id = (int)reader["Id"]; }catch {} try{ t_BaseInfo.Config_name = (string)reader["config_name"]; }catch {} try{ t_BaseInfo.Config_value = (string)reader["config_value"]; }catch {} try{ t_BaseInfo.Config_status = (bool)reader["config_status"]; }catch {} reader.Close(); return(t_BaseInfo); } else { reader.Close(); return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
private static List <T_BaseInfo> GetT_BaseInfosBySql(string sql, params SqlParameter[] values) { List <T_BaseInfo> list = new List <T_BaseInfo>(); try { DataTable table = DBHelper.GetDataSet(sql, values); foreach (DataRow row in table.Rows) { T_BaseInfo t_BaseInfo = new T_BaseInfo(); try{ t_BaseInfo.Id = (int)row["Id"]; }catch {} try{ t_BaseInfo.Config_name = (string)row["config_name"]; }catch {} try{ t_BaseInfo.Config_value = (string)row["config_value"]; }catch {} try{ t_BaseInfo.Config_status = (bool)row["config_status"]; }catch {} list.Add(t_BaseInfo); } return(list); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static void ModifyT_BaseInfo(T_BaseInfo t_BaseInfo) { T_BaseInfoService.ModifyT_BaseInfo(t_BaseInfo); }
public static void DeleteT_BaseInfo(T_BaseInfo t_BaseInfo) { T_BaseInfoService.DeleteT_BaseInfo(t_BaseInfo); }
public static T_BaseInfo AddT_BaseInfo(T_BaseInfo t_BaseInfo) { return(T_BaseInfoService.AddT_BaseInfo(t_BaseInfo)); }
public static void DeleteT_BaseInfo(T_BaseInfo t_BaseInfo) { DeleteT_BaseInfoById(t_BaseInfo.Id); }
public static void DeleteT_BaseInfo(T_BaseInfo t_BaseInfo) { DeleteT_BaseInfoByConfig_id(t_BaseInfo.Config_id); }