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