public DataTable Query(string where = "") { string sql = "select * from services where (DELETED<>1 or DELETED is null)"; if (!string.IsNullOrEmpty(where)) { sql += " and " + where; } return(OledbHelper.GetDataTable(sql)); }
public bool Delete(string id) { string sql = "update SERVICES set DELETED=1 where ID=?"; OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter("ID", OleDbType.VarChar) }; parms[0].Value = id; return(OledbHelper.ExecSql(sql, parms)); }
public bool Add(Service service) { string sql = "insert into SERVICES(ID, NAME, URL, REMARKS)VALUES(?,?,?,?)"; OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter("ID", OleDbType.VarChar), new OleDbParameter("NAME", OleDbType.VarChar), new OleDbParameter("PARAMS", OleDbType.VarChar), new OleDbParameter("URL", OleDbType.VarChar) }; parms[0].Value = service.ID; parms[1].Value = service.NAME; parms[2].Value = service.URL; parms[3].Value = service.PARAMS; return(OledbHelper.ExecSql(sql, parms)); }
public bool Edit(Service service) { string sql = "update SERVICES set NAME=?, URL=?, ContentType=?, PARAMS=? where ID=?"; OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter("ID", OleDbType.VarChar), new OleDbParameter("NAME", OleDbType.VarChar), new OleDbParameter("PARAMS", OleDbType.VarChar), new OleDbParameter("URL", OleDbType.VarChar) }; parms[0].Value = service.ID; parms[1].Value = service.NAME; parms[2].Value = service.URL; parms[3].Value = service.PARAMS; return(OledbHelper.ExecSql(sql, parms)); }