/*
* 获取最后一个页面
*/
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);
}