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