/// <summary>分页获取数据列表
///
/// </summary>
/// <param name="strFields">字段</param>
/// <param name="strOrder">排序</param>
/// <param name="strOrderType">排序类型</param>
/// <param name="intPageSize">每页大小</param>
/// <param name="intPageIndex">当前第N页</param>
/// <param name="strWhere">条件</param>
/// <returns>返回符合条件的对象集合</returns>
public List <Nikita.Assist.CodeMaker.Model.Bse_ControlType> GetListArray(string strFields, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere)
{
SQLiteHelper h = GlobalHelp.GetSQLiteHelper();
DataTable dt = h.FengYe("Bse_ControlType", strFields, strOrder, strOrderType, strWhere, intPageSize, intPageIndex);
List <Nikita.Assist.CodeMaker.Model.Bse_ControlType> list = new List <Nikita.Assist.CodeMaker.Model.Bse_ControlType>();
foreach (DataRow row in dt.Rows)
{
list.Add(new Model.Bse_ControlType()
{
Ctl_Id = int.Parse(row["Ctl_Id"].ToString()),
ControlType = row["ControlType"].ToString(),
Ctl_Simple = row["Ctl_Simple"].ToString(),
Ctl_Name = row["Ctl_Name"].ToString(),
Ctl_NameSpace = row["Ctl_NameSpace"].ToString(),
Ctl_Width = int.Parse(row["Ctl_Width"].ToString()),
Ctl_Height = int.Parse(row["Ctl_Height"].ToString()),
Ctl_Type = row["Ctl_Type"].ToString(),
State = row["State"].ToString(),
Sort = int.Parse(row["Sort"].ToString()),
Type = row["Type"].ToString(),
IsSelf = row["IsSelf"].ToString(),
});
}
return(list);
}
/// <summary>分页获取数据列表
///
/// </summary>
/// <param name="strFields">字段</param>
/// <param name="strOrder">排序</param>
/// <param name="strOrderType">排序类型</param>
/// <param name="intPageSize">每页大小</param>
/// <param name="intPageIndex">当前第N页</param>
/// <param name="strWhere">条件</param>
/// <returns>返回符合条件的DataSet数据集</returns>
public DataSet GetList(string strFields, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere)
{
SQLiteHelper h = GlobalHelp.GetSQLiteHelper();
DataTable dt = h.FengYe("Bse_UI", strFields, strOrder, strOrderType, strWhere, intPageSize, intPageIndex);
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
/// <summary>分页获取数据列表
///
/// </summary>
public DataSet GetList(string fileds, string order, string ordertype, int intPageSize, int intPageIndex, string strWhere)
{
SQLiteHelper h = GlobalHelp.GetSQLiteHelper();
DataTable dt = h.FengYe("Tb_Set", fileds, order, ordertype, strWhere, intPageSize, intPageIndex);
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
/// <summary>分页获取数据列表
///
/// </summary>
/// <param name="strFields">字段</param>
/// <param name="strOrder">排序</param>
/// <param name="strOrderType">排序类型</param>
/// <param name="intPageSize">每页大小</param>
/// <param name="intPageIndex">当前第N页</param>
/// <param name="strWhere">条件</param>
/// <returns>返回符合条件的对象集合</returns>
public List <Nikita.Assist.CodeMaker.Model.Bse_UI> GetListArray(string strFields, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere)
{
SQLiteHelper h = GlobalHelp.GetSQLiteHelper();
DataTable dt = h.FengYe("Bse_UI", strFields, strOrder, strOrderType, strWhere, intPageSize, intPageIndex);
List <Nikita.Assist.CodeMaker.Model.Bse_UI> list = new List <Nikita.Assist.CodeMaker.Model.Bse_UI>();
foreach (DataRow row in dt.Rows)
{
list.Add(new Model.Bse_UI()
{
Ui_Id = int.Parse(row["Ui_Id"].ToString()), TableName = row["TableName"].ToString(), PanelName = row["PanelName"].ToString(), ColumnName = row["ColumnName"].ToString(), ColumnType = row["ColumnType"].ToString(), FrmNameSpace = row["FrmNameSpace"].ToString(), ControlNameSpace = row["ControlNameSpace"].ToString(), ControlType = row["ControlType"].ToString(), Ctl_Simple = row["Ctl_Simple"].ToString(), ControlName = row["ControlName"].ToString(), GridSpeicalCtlName = row["GridSpeicalCtlName"].ToString(), ControlSort = row["ControlSort"].ToString(), DefaultValue = row["DefaultValue"].ToString(), IsAddLable = row["IsAddLable"].ToString(), LabelName = row["LabelName"].ToString(), LabelText = row["LabelText"].ToString(), IsNeed = row["IsNeed"].ToString(), IsReadonly = row["IsReadonly"].ToString(), FiledText = row["FiledText"].ToString(), FiledValue = row["FiledValue"].ToString(), DataSourse = row["DataSourse"].ToString(), DefaultFiledText = row["DefaultFiledText"].ToString(), DefaultFiledValue = row["DefaultFiledValue"].ToString(), DefaultDataSourse = row["DefaultDataSourse"].ToString(), Remark = row["Remark"].ToString(), State = int.Parse(row["State"].ToString()), CreateDate = DateTime.Parse(row["CreateDate"].ToString()), CreateUserId = int.Parse(row["CreateUserId"].ToString()),
});
}
return(list);
}
/// <summary>分页获取数据列表
///
/// </summary>
public List <Model.SetOrd> GetListArray(string fileds, string order, string ordertype, int intPageSize, int intPageIndex, string strWhere)
{
SQLiteHelper h = GlobalHelp.GetSQLiteHelper();
DataTable dt = h.FengYe("Tb_SetOrd", fileds, order, ordertype, strWhere, intPageSize, intPageIndex);
return((from DataRow row in dt.Rows
select new Model.SetOrd()
{
Id = int.Parse(row["id"].ToString()),
SetOrdText = row["SetOrdText"].ToString(),
SetOrdKey = row["SetOrdKey"].ToString(),
State = int.Parse(row["State"].ToString()),
Remark = row["Remark"].ToString(),
}).ToList());
}