public override List <CompanyInformationType> GetPageList(SearchCompanyInformationType condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { Script.Select().ALL().From().Where(); if (!string.IsNullOrEmpty(condition.CpInforTypeName)) { Script.Like(CompanyInformationType.CompanyInformationName_FieldName, condition.CpInforTypeName); } if (condition.IsEnglish > 0) { Script.Where(CompanyInformationType.IsEnglish_FieldName, condition.IsEnglish); } Script.AddOrderBy().OrderBy(sortFieldName, sortEnum); Script.PageIndex = pagination.PageIndex; Script.PageSize = pagination.PageSize; List <CompanyInformationType> lists = Script.GetList <CompanyInformationType>(); pagination.RecordCount = Script.RecordCount; return(lists); }
public override System.Data.DataTable GetTable(SearchCompanyInformationType condition, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { throw new System.NotImplementedException(); }
public override List <SuccessStoriesType> GetList(SearchSuccessStoriesType condition, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { throw new System.NotImplementedException(); }
public override System.Data.DataTable GetPageTable(SearchSuccessStoriesType condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { throw new System.NotImplementedException(); }
public override List <JobDetail> GetList(SearchJobDetail condition, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { throw new System.NotImplementedException(); }
public override List <JobDetail> GetPageList(SearchJobDetail condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { Script.Select().ALL().From().Where(); if (condition.CpJobTypeID > 0) { Script.Where(JobDetail.JobTypeID_FieldName, condition.CpJobTypeID); } if (condition.IsEnglish > 0) { Script.Where(JobDetail.IsEnglish_FieldName, condition.IsEnglish); } Script.AddOrderBy().OrderBy(sortFieldName, sortEnum); Script.PageIndex = pagination.PageIndex; Script.PageSize = pagination.PageSize; List <JobDetail> lists = Script.GetList <JobDetail>(); pagination.RecordCount = Script.RecordCount; return(lists); }
public override System.Data.DataTable GetTable(SearchProductDetail condition, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { throw new System.NotImplementedException(); }
public override List <CompanyInformationDetails> GetList(SearchCompanyInformationDetails condition, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { throw new System.NotImplementedException(); }
public override List <ProductPicture> GetPageList(SearchProductPicture condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { throw new System.NotImplementedException(); }
public override List <SuccessStories> GetPageList(SearchSuccessStories condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { Script.Select().ALL().From().Where(); if (condition.SSType > 0) { Script.Where(SuccessStories.SSType_FieldName, condition.SSType); } if (condition.IsEnglish > 0) { Script.Where(SuccessStories.IsEnglish_FieldName, condition.IsEnglish); } Script.AddOrderBy().OrderBy(sortFieldName, sortEnum); Script.PageIndex = pagination.PageIndex; Script.PageSize = pagination.PageSize; List <SuccessStories> lists = Script.GetList <SuccessStories>(); pagination.RecordCount = Script.RecordCount; return(lists); }
public override List <DownLoad> GetPageList(SearchDownLoad condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { Script.Select().ALL().From().Where(); if (!string.IsNullOrEmpty(condition.CpDLName)) { Script.Where(DownLoad.DLName_FieldName, condition.CpDLName); } if (condition.IsEnglish > 0) { Script.Where(DownLoad.IsEnglish_FieldName, condition.IsEnglish); } Script.AddOrderBy().OrderBy(sortFieldName, sortEnum); Script.PageIndex = pagination.PageIndex; Script.PageSize = pagination.PageSize; List <DownLoad> lists = Script.GetList <DownLoad>(); pagination.RecordCount = Script.RecordCount; return(lists); }
private static void addChild(ScriptQuery script, DataRow dr, string flagID, string flagParentID, string condition, List <object> lists, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { script.Select().Select(flagID).From().Where(flagParentID, dr[flagID]); if (!string.IsNullOrEmpty(condition)) { script.AddSqlText(" and " + condition); } DataTable dt = script.AddOrderBy().OrderBy(sortFieldName, sortEnum). GetDataTable(); foreach (DataRow ddr in dt.Rows) { lists.Add(ddr[flagID]); addChild(script, ddr, flagID, flagParentID, condition, lists, sortFieldName, sortEnum); } }
/// <summary> /// 返回递归后的编号数组,该数组内包含指定参数编号及所有子类别的编号,异常则返回只包含指定参数的数组 /// </summary> /// <param name="dbCon">数据连接对象</param> /// <param name="tableName">数据表名</param> /// <param name="flagID">标记ID的字段名称,</param> /// <param name="flagIDValue">标记ID的值</param> /// <param name="flagParentID">父标记字段名称</param> /// <param name="condtion">条件(譬如:isdel=0 and nety_ischeck=1)可以为空</param> /// <param name="sortFieldName">排序字段</param> /// <param name="sortEnum">排序枚举</param> /// <returns></returns> public static object[] GetRecurArray(DBConnect dbCon, string tableName, string flagID, object flagIDValue, string flagParentID, string condtion, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { List <object> lists = new List <object>(); lists.Add(flagIDValue); bool needOpen = (dbCon.ConnState != ConnectionState.Open); try { if (needOpen) { dbCon.OpenConn(); } ScriptQuery script = new ScriptQuery(dbCon, tableName); script.Select().Select(flagID).From().Where(flagParentID, flagIDValue); if (!string.IsNullOrEmpty(condtion)) { script.AddSqlText(" and " + condtion); } DataTable dt = script.AddOrderBy().OrderBy(sortFieldName, sortEnum).GetDataTable(); foreach (DataRow dr in dt.Rows) { lists.Add(dr[flagID]); addChild(script, dr, flagID, flagParentID, condtion, lists, sortFieldName, sortEnum); } } catch (Exception ex) { Log.Error(ex.Message, ex); lists.Clear(); lists.Add(flagIDValue); } finally { if (needOpen) { dbCon.CloseConn(); } } return(lists.ToArray()); }
public override List <AdminUser> GetPageList(SearchAdminUser condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { Script.Select().ALL().From().Where(); if (!string.IsNullOrEmpty(condition.Account)) { Script.Like(AdminUser.Account_FieldName, condition.Account); } if (!string.IsNullOrEmpty(condition.TrueName)) { Script.Like(AdminUser.TrueName_FieldName, condition.TrueName); } Script.AddOrderBy().OrderBy(sortFieldName, sortEnum); Script.PageIndex = pagination.PageIndex; Script.PageSize = pagination.PageSize; List <AdminUser> lists = Script.GetList <AdminUser>(); pagination.RecordCount = Script.RecordCount; return(lists); }
public override List <ComBanner> GetPageList(SearchComBanner condition, DevNet.Common.Pagination pagination, string sortFieldName, DevNet.Common.ScriptQuery.SortEnum sortEnum) { Script.Select().ALL().From().Where(); Script.PageIndex = pagination.PageIndex; Script.PageSize = pagination.PageSize; List <ComBanner> lists = Script.GetList <ComBanner>(); pagination.RecordCount = Script.RecordCount; return(lists); }