public static int AddNameFilter(string name) { NameFilterInfo namefilter = new NameFilterInfo(); namefilter.Name = name; INameFilter dal = Factory<INameFilter>.Create("NameFilter"); return dal.Add(namefilter); }
public void Update(NameFilterInfo filter) { string strSql = "UPDATE " + Config.FilterTablePrefix + "NAMEFILTER SET M_NAME=@Name WHERE N_ID=@Id"; List<OleDbParameter> parms = new List<OleDbParameter> { new OleDbParameter("@Id", OleDbType.Numeric) {Value = filter.Id}, new OleDbParameter("@NAme", OleDbType.VarChar) {Value = filter.Name} }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, parms.ToArray()); }
public NameFilterInfo GetById(int id) { string strSql = "SELECT N_ID,N_NAME FROM " + Config.FilterTablePrefix + "NAMEFILTER WHERE N_ID=@Id"; NameFilterInfo filter = null; using (OleDbDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, strSql, new OleDbParameter("@Id", OleDbType.Numeric) { Value = id })) { while (rdr.Read()) { filter = new NameFilterInfo { Id = rdr.GetInt32(0), Name = rdr.SafeGetString(1) }; } } return filter; }
public void Delete(NameFilterInfo filter) { string strSql = "DELETE FROM " + Config.FilterTablePrefix + "NAMEFILTER WHERE N_ID=@Id"; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, new OleDbParameter("@Id", OleDbType.VarChar) { Value = filter.Id }); }
public int Add(NameFilterInfo filter) { string strSql = "INSERT INTO " + Config.FilterTablePrefix + "NAMEFILTER (N_NAME) VALUES (@Name)"; return Convert.ToInt32(SqlHelper.ExecuteInsertQuery(SqlHelper.ConnString, CommandType.Text, strSql, new OleDbParameter("@Name", OleDbType.VarChar) { Value = filter.Name })); }