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;
}
