public Role GetById(object id) { DBHelper db = new DBHelper(); DbCommand cmd = db.GetSqlStringCommand("select * from Role where Role_Code='"+id.ToString()+"'"); DataTable dt = db.ExecuteDataTable(cmd); foreach (DataRow dataRow in dt.Rows) { return this.DataRowToBean(dataRow); } return null; }
public Model.BM_COMMON GetById(object id) { string sql = "select * from BM_COMMON where bg_id='"+id.ToString()+"'"; DBHelper db=new DBHelper(); DbCommand cmd = db.GetSqlStringCommand(sql); DataTable dt = db.ExecuteDataTable(cmd); foreach (DataRow row in dt.Rows) { return this.DataRowToBean(row); } return null; }
public IQueryable<Role> GetAll() { IList<Role> list=new List<Role>(); DBHelper db = new DBHelper(); DbCommand cmd = db.GetSqlStringCommand("select * from Role"); DataTable dt = db.ExecuteDataTable(cmd); foreach (DataRow dataRow in dt.Rows) { list.Add(this.DataRowToBean(dataRow)); } return list.AsQueryable(); }
public IQueryable<Model.BM_COMMON> GetAll() { IList<BM_COMMON> list=new List<BM_COMMON>(); string sql = "select * from BM_COMMON "; DBHelper db = new DBHelper(); DbCommand cmd = db.GetSqlStringCommand(sql); DataTable dt = db.ExecuteDataTable(cmd); foreach (DataRow row in dt.Rows) { list.Add(this.DataRowToBean(row)); } return list.AsQueryable(); }
public PageBean<BM_COMMON> GetPageList(int pageIndex, int pageSize, string sqlWhere, string order) { PageBean<BM_COMMON> pageBean = new PageBean<BM_COMMON>(); IList<BM_COMMON> list = new List<BM_COMMON>(); DBHelper db = new DBHelper(); string strSql = "select * from (select * ,ROW_NUMBER() over(order by " + order + ") num from Message where " + sqlWhere + ") Tabl where num BETWEEN " + (pageIndex - 1) * pageSize + " and " + (pageSize) * (pageIndex); DbCommand cmd = db.GetSqlStringCommand(strSql); DataTable dt = db.ExecuteDataTable(cmd); foreach (DataRow row in dt.Rows) { BM_COMMON ht = this.DataRowToBean(row); list.Add(ht); } pageBean.rows = list; pageBean.total = this.SelectCOMMONBeanPageCount(sqlWhere); return pageBean; }
public IQueryable<BM_COMMON> SearchFor(string sqlWhere) { IList<BM_COMMON> list = new List<BM_COMMON>(); DBHelper db = new DBHelper(); DbCommand cmd = db.GetSqlStringCommand("SELECT * FROM BM_COMMON where 1=1 and " + sqlWhere); DataTable dt = db.ExecuteDataTable(cmd); foreach (DataRow row in dt.Rows) { list.Add(this.DataRowToBean(row)); } return list.AsQueryable(); }
public Role SelectRole(string Role_Code) { DBHelper db = new DBHelper(); DbCommand cmd = db.GetSqlStringCommand("SELECT * FROM Role WHERE Role_Code = " + Role_Code); DataTable dt = db.ExecuteDataTable(cmd); foreach (DataRow row in dt.Rows) { return this.DataRowToBean(row); } return null; }