/* * 获取最后一个页面 */ public DPage getLastPage() { String sql = "select * from dPage order by id desc limit 0,1"; SQLiteParameter[] parameters = { }; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); DPage entity = DataToEntity <DPage> .FillModel(dt.Rows[0]); return(entity); }
/* * 获取最后一个文件夹 */ public StorageImageFolder getLastFolder() { String sql = "select * from storageImageFolder order by id desc limit 0,1"; SQLiteParameter[] parameters = { }; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); StorageImageFolder entity = DataToEntity <StorageImageFolder> .FillModel(dt.Rows[0]); return(entity); }
/* * 获取所有 */ public List <ScreenCfg> findAll() { String sql = "select * from screenCfg order by id asc"; SQLiteParameter[] parameters = { }; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); List <ScreenCfg> list = DataToEntity <ScreenCfg> .FillModel(dt); return(list); }
/* * 获取所有 */ public List <ScreenCfgDto> findAllWithPageName() { String sql = "select screenCfg.*,name pageName from screenCfg left join dPage on screenCfg.indexPageId=dPage.id order by id asc"; SQLiteParameter[] parameters = { }; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); List <ScreenCfgDto> list = DataToEntity <ScreenCfgDto> .FillModel(dt); return(list); }
public List <DControlEvent> getByTurnPictureImagesId(int turnPictureImagesId) { String sql = "select * from dControlEvent where turnPictureImagesId=@turnPictureImagesId order by id asc"; SQLiteParameter[] parameters = { new SQLiteParameter("@turnPictureImagesId", DbType.Int32, 4) }; parameters[0].Value = turnPictureImagesId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); List <DControlEvent> list = DataToEntity <DControlEvent> .FillModel(dt); return(list); }
//通过id获取cfg public ScreenCfg get(int id) { String sql = "select * from screenCfg where id=@id"; SQLiteParameter[] parameters = { new SQLiteParameter("@id", DbType.Int32, 4) }; parameters[0].Value = id; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); ScreenCfg screenCfg = DataToEntity <ScreenCfg> .FillModel(dt.Rows[0]); return(screenCfg); }
//通过id获取cfg public Cfg2 get(int id) { String sql = "select * from cfg2 where id=@id"; SQLiteParameter[] parameters = { new SQLiteParameter("@id", DbType.Int32, 4) }; parameters[0].Value = id; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters, Common.SQLiteHelper.connectionString_reg); Cfg2 cfg = DataToEntity <Cfg2> .FillModel(dt.Rows[0]); return(cfg); }
/* * 获取最大排序的那个页面 */ public DPage getMaxIdxByParentId(Int32 parentId) { String sql = "select max(idx) as idx from dPage where parentId=@parentId"; SQLiteParameter[] parameters = { new SQLiteParameter("@parentId", DbType.Int32, 4) }; parameters[0].Value = parentId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); DPage entity = DataToEntity <DPage> .FillModel(dt.Rows[0]); return(entity); }
/* * 获取控件下所有动画 */ public List <DControlAnimation> getByDControlId(int dControlId) { String sql = "select * from dControlAnimation where dControlId=@dControlId order by id asc"; SQLiteParameter[] parameters = { new SQLiteParameter("@dControlId", DbType.Int32, 4) }; parameters[0].Value = dControlId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); List <DControlAnimation> list = DataToEntity <DControlAnimation> .FillModel(dt); return(list); }
public TurnPictureImages get(int id) { String sql = "select * from turnPictureImages where id=@id"; SQLiteParameter[] parameters = { new SQLiteParameter("@id", DbType.Int32, 4) }; parameters[0].Value = id; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); TurnPictureImages entity = DataToEntity <TurnPictureImages> .FillModel(dt.Rows[0]); return(entity); }
/* * 获取子文件夹 */ public List <StorageImageFolder> getByParentId(int parentId) { String sql = "select * from storageImageFolder where parentId=@parentId order by idx asc"; SQLiteParameter[] parameters = { new SQLiteParameter("@parentId", DbType.Int32, 4) }; parameters[0].Value = parentId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); List <StorageImageFolder> list = DataToEntity <StorageImageFolder> .FillModel(dt); return(list); }
/* * 获取父栏目中最大的排序号 */ public StorageImageFolder getMaxIdxByParentId(int parentId) { String sql = "select max(idx) as idx from storageImageFolder where parentId=@parentId"; SQLiteParameter[] parameters = { new SQLiteParameter("@parentId", DbType.Int32, 4) }; parameters[0].Value = parentId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); StorageImageFolder entity = DataToEntity <StorageImageFolder> .FillModel(dt.Rows[0]); return(entity); }
/* * 获取页面下的所有CFrame控件 */ public List <DControl> getCFrameByPageId(int pageId) { String sql = "select * from dControl where pageId=@pageId and name='CFrame' order by idx asc"; SQLiteParameter[] parameters = { new SQLiteParameter("@pageId", DbType.Int32, 4) }; parameters[0].Value = pageId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); List <DControl> list = DataToEntity <DControl> .FillModel(dt); return(list); }
/* * 获取文件夹下所有图片 */ public List <StorageFile> getByFolderId(int folderId) { String sql = "select * from storageFile where folderId=@folderId order by id desc"; SQLiteParameter[] parameters = { new SQLiteParameter("@folderId", DbType.Int32, 4) }; parameters[0].Value = folderId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); List <StorageFile> list = DataToEntity <StorageFile> .FillModel(dt); return(list); }
public List <StorageImage> getNextPage2(int currPage, int pageSize) { int start = (currPage - 1) * pageSize; int end = currPage * pageSize; String sql = "select * from storageImage order by id desc limit @start,@end"; SQLiteParameter[] parameters = new SQLiteParameter[2]; parameters[0] = new SQLiteParameter("@start", DbType.Int32, 4); parameters[1] = new SQLiteParameter("@end", DbType.Int32, 4); parameters[0].Value = start; parameters[1].Value = end; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); List <StorageImage> list = DataToEntity <StorageImage> .FillModel(dt); return(list); }
public List <StorageFile> getNextPageOfWord(int currPage, int pageSize, int folderId) { int start = (currPage - 1) * pageSize; String sql = "select * from storageFile where folderId=@folderId order by id desc limit @start,@pageSize"; SQLiteParameter[] parameters = { new SQLiteParameter("@start", DbType.Int32, 4), new SQLiteParameter("@pageSize", DbType.Int32, 4), new SQLiteParameter("@folderId", DbType.Int32, 4) }; parameters[0].Value = start; parameters[1].Value = pageSize; parameters[2].Value = folderId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); List <StorageFile> list = DataToEntity <StorageFile> .FillModel(dt); return(list); }
//获取图片列表 public List <TurnPictureImagesDto> getByDControlId(int dControlId) { String sql = "select a.*,b.url from turnPictureImages a left join storageImage b on a.storageImageId=b.id where a.dControlId=@dControlId order by a.id asc"; SQLiteParameter[] parameters = { new SQLiteParameter("@dControlId", DbType.Int32, 4) }; parameters[0].Value = dControlId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); if (dt == null) { return(new List <TurnPictureImagesDto>()); } List <TurnPictureImagesDto> list = DataToEntity <TurnPictureImagesDto> .FillModel(dt); return(list); }
//获取文件 public StorageFile get(Int32 id) { String sql = "select * from storageFile where id=@id"; SQLiteParameter[] parameters = { new SQLiteParameter("@id", DbType.Int32, 4) }; parameters[0].Value = id; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); if (dt == null || dt.Rows.Count == 0) { return(null); } StorageFile storageFile = DataToEntity <StorageFile> .FillModel(dt.Rows[0]); return(storageFile); }
/* * 获取控件 */ public DControl get(int id) { String sql = "select * from dControl where id=@id"; SQLiteParameter[] parameters = { new SQLiteParameter("@id", DbType.Int32, 4) }; parameters[0].Value = id; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); if (dt == null) { return(null); } DControl dControl = DataToEntity <DControl> .FillModel(dt.Rows[0]); return(dControl); }
/* * 获取轮播图片在某个屏幕对应的跳转 */ public DControlEvent getByTurnPictureImagesIdScreenCfgId(int turnPictureImagesId, int screenCfgId) { String sql = "select * from dControlEvent where turnPictureImagesId=@turnPictureImagesId and screenCfgId=@screenCfgId "; SQLiteParameter[] parameters = { new SQLiteParameter("@turnPictureImagesId", DbType.Int32, 4), new SQLiteParameter("@screenCfgId", DbType.Int32, 4) }; parameters[0].Value = turnPictureImagesId; parameters[1].Value = screenCfgId; DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters); if (dt == null || dt.Rows.Count <= 0) { return(null); } DControlEvent entity = DataToEntity <DControlEvent> .FillModel(dt.Rows[0]); return(entity); }