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