public void Delete(BadwordInfo badword) { SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, "DELETE FROM " + Config.FilterTablePrefix + "BADWORDS WHERE B_ID=@BadwordId", new OleDbParameter("@BadwordId", OleDbType.Numeric) { Value = badword.Id }); }
public static void DeleteBadword(int Id) { IBadWordFilter dal = Factory <IBadWordFilter> .Create("BadWordFilter"); BadwordInfo badword = dal.GetById(Id); dal.Delete(badword); }
public static int AddBadword(string badword, string replace) { IBadWordFilter dal = Factory <IBadWordFilter> .Create("BadWordFilter"); BadwordInfo bw = new BadwordInfo(); bw.Badword = badword; bw.Replace = replace; return(dal.Add(bw)); }
public static void UpdateBadword(int Id, string badword, string replace) { IBadWordFilter dal = Factory <IBadWordFilter> .Create("BadWordFilter"); BadwordInfo bw = dal.GetById(Id); bw.Badword = badword; bw.Replace = replace; dal.Update(bw); }
public int Add(BadwordInfo badword) { string strSql = "INSERT INTO " + Config.FilterTablePrefix + "BADWORDS (B_BADWORD,B_REPLACE) VALUES (@Badword,@Replaceword)"; List <OleDbParameter> parms = new List <OleDbParameter> { new OleDbParameter("@Badword", OleDbType.VarChar) { Value = badword.Badword }, new OleDbParameter("@Replaceword", OleDbType.VarChar) { Value = badword.Replace } }; return(Convert.ToInt32(SqlHelper.ExecuteInsertQuery(SqlHelper.ConnString, CommandType.Text, SELECT + strSql, parms.ToArray()))); }
public int Add(BadwordInfo badword) { string strSql = "INSERT INTO " + Config.FilterTablePrefix + "BADWORDS (B_BADWORD,B_REPLACE) VALUES (@Badword,@Replaceword); SELECT SCOPE_IDENTITY();"; List <SqlParameter> parms = new List <SqlParameter> { new SqlParameter("@Badword", SqlDbType.NVarChar) { Value = badword.Badword }, new SqlParameter("@Replaceword", SqlDbType.NVarChar) { Value = badword.Replace } }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, SELECT + strSql, parms.ToArray()))); }
public BadwordInfo GetById(int id) { BadwordInfo badword = null; using (OleDbDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, SELECT + "WHERE B_ID=@BadwordId", new OleDbParameter("@BadwordId", OleDbType.Numeric) { Value = id })) { while (rdr.Read()) { badword = new BadwordInfo { Id = rdr.GetInt32(0), Badword = rdr.SafeGetString(1), Replace = rdr.SafeGetString(2) }; } } return(badword); }
public void Update(BadwordInfo badword) { string strSql = "UPDATE " + Config.FilterTablePrefix + "BADWORDS SET B_BADWORD=@Badword,B_REPLACE=@Replaceword WHERE B_ID=@BadwordId"; List <OleDbParameter> parms = new List <OleDbParameter> { new OleDbParameter("@BadwordId", OleDbType.Numeric) { Value = badword.Id }, new OleDbParameter("@Badword", OleDbType.VarChar) { Value = badword.Badword }, new OleDbParameter("@Replaceword", OleDbType.VarChar) { Value = badword.Replace } }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, parms.ToArray()); }