public M_SysConfig GetSysConfig(int id, string tableName) { SQLiteHelper.InitialConnection("SysConfig"); string sql = "select * from " + tableName + " where RecNo = @RecNo"; M_SysConfig sysConfig = new M_SysConfig(); SQLiteParameter[] param = { new SQLiteParameter("@RecNo", id) }; using (SQLiteDataReader reader = SQLiteHelper.ExecuteReader(sql, param)) { if (reader.Read()) { sysConfig.ID = Convert.ToInt32(reader["ID"]); sysConfig.ParaType = Convert.ToInt32(reader["ParaType"]); sysConfig.ParaName = reader["ParaName"].ToString(); sysConfig.ParaValue = reader["ParaValue"].ToString(); sysConfig.Illustrate = reader["Illustrate"].ToString(); } } return(sysConfig); }
public void UpdateSysConfig(M_SysConfig sysConfig) { SQLiteHelper.InitialConnection("SysConfig"); string sql = "update " + sysConfig.TableName + " set ParaType = @ParaType,ParaName = @ParaName,ParaValue = @ParaValue,Illustrate = @Illustrate where ID = @ID"; SQLiteParameter[] param = { new SQLiteParameter("@ID", sysConfig.ID), new SQLiteParameter("@ParaType", sysConfig.ParaType), new SQLiteParameter("@ParaName", sysConfig.ParaName), new SQLiteParameter("@ParaValue", sysConfig.ParaValue), new SQLiteParameter("@Illustrate", sysConfig.Illustrate), }; SQLiteHelper.ExecuteNonQuery(sql, param); }
public void AddSysConfig(M_SysConfig sysConfig) { SQLiteHelper.InitialConnection("SysConfig"); string sql = "insert into " + sysConfig.TableName + " values(@ID,@ParaType,@ParaName,@ParaValue,@Illustrate)"; SQLiteParameter[] param = { new SQLiteParameter("@ID", null), new SQLiteParameter("@ParaType", sysConfig.ParaType), new SQLiteParameter("@ParaName", sysConfig.ParaName), new SQLiteParameter("@ParaValue", sysConfig.ParaValue), new SQLiteParameter("@Illustrate", sysConfig.Illustrate), }; SQLiteHelper.ExecuteNonQuery(sql, param); }
public List <M_SysConfig> GetSysConfig(string tableName) { SQLiteHelper.InitialConnection("SysConfig"); string sql = "select * from " + tableName; List <M_SysConfig> list = new List <M_SysConfig>(); using (SQLiteDataReader reader = SQLiteHelper.ExecuteReader(sql)) { while (reader.Read()) { M_SysConfig sysConfig = new M_SysConfig(); sysConfig.ID = Convert.ToInt32(reader["ID"]); sysConfig.ParaType = Convert.ToInt32(reader["ParaType"]); sysConfig.ParaName = reader["ParaName"].ToString(); sysConfig.ParaValue = reader["ParaValue"].ToString(); sysConfig.Illustrate = reader["Illustrate"].ToString(); list.Add(sysConfig); } } return(list); }
public void UpdateSysConfig(M_SysConfig sysConfig) { dal.UpdateSysConfig(sysConfig); }
public void AddSysConfig(M_SysConfig sysConfig) { dal.AddSysConfig(sysConfig); }