public virtual IList <DanhMucItemData> GetDanhMucItemPaging(System.String whereCondition, System.Int32 pageSize, System.Int32 currentPage, System.String sortByColumns) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUCITEM_SELECT_PAGING, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[] { dao.CreateParameter("@WhereCondition", whereCondition), dao.CreateParameter("@PageSize", pageSize), dao.CreateParameter("@CurrentPage", currentPage), dao.CreateParameter("@SortByColumns", sortByColumns) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { IList <DanhMucItemData> list = new List <DanhMucItemData>(table.Rows.Count); foreach (DataRow row in table.Rows) { list.Add(Convert(row)); } return(list); } return(new List <DanhMucItemData>()); }
public virtual System.Int32 GetDanhMucItemCount(System.String whereCondition) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUCITEM_SELECT_COUNT, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[] { dao.CreateParameter("@WhereCondition", whereCondition) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { return(System.Int32.Parse(table.Rows[0][0].ToString())); } return(0); }
public virtual SysGroupData GetSysGroupByID(System.Int32 ID) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSGROUP_SELECT_BY_ID, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[] { dao.CreateParameter("@ID", ID) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { return(Convert(table.Rows[0])); } return(default(SysGroupData)); }
public virtual DanhMucData GetDanhMucByID(System.String maLoaiDanhMuc) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUC_SELECT_BY_ID, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[] { dao.CreateParameter("@MaLoaiDanhMuc", maLoaiDanhMuc) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { return(Convert(table.Rows[0])); } return(default(DanhMucData)); }
public virtual IList <DanhMucItemData> GetDanhMucItems() { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUCITEM_SELECT_ALL, CommandType.StoredProcedure); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { IList <DanhMucItemData> list = new List <DanhMucItemData>(table.Rows.Count); foreach (DataRow row in table.Rows) { list.Add(Convert(row)); } return(list); } return(new List <DanhMucItemData>()); }
public virtual IList <DanhMucItemData> GetDanhMucItems(System.String whereCondition) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUCITEM_SELECT_DYNAMIC, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[] { dao.CreateParameter("@WhereCondition", whereCondition) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { IList <DanhMucItemData> list = new List <DanhMucItemData>(table.Rows.Count); foreach (DataRow row in table.Rows) { list.Add(Convert(row)); } return(list); } return(new List <DanhMucItemData>()); }
public virtual IList <SysGroupData> GetSysGroups(System.Int32 size, System.String whereCondition) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSGROUP_SELECT_TOP_DYNAMIC, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[] { dao.CreateParameter("@Size", size), dao.CreateParameter("@WhereCondition", whereCondition) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { IList <SysGroupData> list = new List <SysGroupData>(table.Rows.Count); foreach (DataRow row in table.Rows) { list.Add(Convert(row)); } return(list); } return(new List <SysGroupData>()); }
public virtual SysGroupData GetSysGroupByID(System.Int32 ID) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSGROUP_SELECT_BY_ID, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[]{ dao.CreateParameter("@ID", ID) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { return Convert(table.Rows[0]); } return default(SysGroupData); }
public virtual IList<SysGroupData> GetSysGroups(System.Int32 size, System.String whereCondition) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSGROUP_SELECT_TOP_DYNAMIC, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[]{ dao.CreateParameter("@Size", size), dao.CreateParameter("@WhereCondition", whereCondition) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { IList<SysGroupData> list = new List<SysGroupData>(table.Rows.Count); foreach (DataRow row in table.Rows) { list.Add(Convert(row)); } return list; } return new List<SysGroupData>(); }
public virtual IList<SysGroupData> GetSysGroups() { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSGROUP_SELECT_ALL, CommandType.StoredProcedure); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { IList<SysGroupData> list = new List<SysGroupData>(table.Rows.Count); foreach (DataRow row in table.Rows) { list.Add(Convert(row)); } return list; } return new List<SysGroupData>(); }
public virtual IList<SysGroupData> GetSysGroupPaging(System.String whereCondition, System.Int32 pageSize, System.Int32 currentPage, System.String sortByColumns) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSGROUP_SELECT_PAGING, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[]{ dao.CreateParameter("@WhereCondition", whereCondition), dao.CreateParameter("@PageSize", pageSize), dao.CreateParameter("@CurrentPage", currentPage), dao.CreateParameter("@SortByColumns", sortByColumns) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { IList<SysGroupData> list = new List<SysGroupData>(table.Rows.Count); foreach (DataRow row in table.Rows) { list.Add(Convert(row)); } return list; } return new List<SysGroupData>(); }
public virtual System.Int32 GetSysGroupCount(System.String whereCondition) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_SYSGROUP_SELECT_COUNT, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[]{ dao.CreateParameter("@WhereCondition", whereCondition) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { return System.Int32.Parse(table.Rows[0][0].ToString()); } return 0; }
public virtual IList<DanhMucItemData> GetDanhMucItems(System.String whereCondition) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUCITEM_SELECT_DYNAMIC, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[]{ dao.CreateParameter("@WhereCondition", whereCondition) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { IList<DanhMucItemData> list = new List<DanhMucItemData>(table.Rows.Count); foreach (DataRow row in table.Rows) { list.Add(Convert(row)); } return list; } return new List<DanhMucItemData>(); }
public virtual DanhMucItemData GetDanhMucItemByID(System.Int32 ID, System.String MaLoaiDanhMuc) { JDataAccess dao = new JDataAccess(ConnectionString); dao.SetCommandText(SP_DANHMUCITEM_SELECT_BY_ID, CommandType.StoredProcedure); dao.SetParameters(new IDataParameter[]{ dao.CreateParameter("@ID", ID), dao.CreateParameter("@MaLoaiDanhMuc", MaLoaiDanhMuc) }); DataTable table = dao.ExecuteQuery(); if (table != null && table.Rows.Count > 0) { return Convert(table.Rows[0]); } return default(DanhMucItemData); }