public static IPageOfList <OrderAdminInfo> List(SearchSetting settings)
{
FastPaging fp = new FastPaging();
fp.PageIndex = settings.PageIndex;
fp.PageSize = settings.PageSize;
fp.TableName = "OrderAdmins";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
fp.OverOrderBy = " CreateDateTime DESC";
IList <OrderAdminInfo> list = new List <OrderAdminInfo>();
OrderAdminInfo model = null;
DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = Get(dr);
if (model != null)
{
list.Add(model);
}
}
}
int count = Count();
return(new PageOfList <OrderAdminInfo>(list, settings.PageIndex, settings.PageSize, count));
}
private static int Count(SearchSetting settings)
{
StringBuilder sbCondition = new StringBuilder(" SELECT COUNT(*) FROM Attachments WITH(NOLOCK) WHERE 1 = 1");
sbCondition.AppendFormat(" AND SiteId = @SiteId ");
if (!settings.ShowDeleted)
{
sbCondition.Append(" AND IsDeleted = 0 ");
}
if (settings.CategoryId > 0)
{
sbCondition.Append(@" AND EXISTS(
SELECT * FROM dbo.Categories AS AC WITH(NOLOCK)
WHERE (AC.ID = @CID OR CHARINDEX(','+CAST(@CID AS NVARCHAR(MAX))+',',','+AC.ParentIdList+',') >0) /*获取此分类下所有的子分类*/
AND SiteId = @SiteId
AND IsDeleted = 0
AND Attachments.CategoryId = AC.ID
)");
}
SqlParameter[] parms =
{
new SqlParameter("@SiteId", SqlDbType.Int),
new SqlParameter("@CID", SqlDbType.Int)
};
parms[0].Value = settings.SiteId;
parms[1].Value = settings.CategoryId;
return(Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text, sbCondition.ToString(), parms)));
}
public IActionResult GetSearchSetting()
{
string userJWTId = User.FindFirst("id")?.Value;
Client client = clientDB.GetCurrentClient(userJWTId);
if (client != null)
{
SearchSetting searchSetting = SearchSettingDB.GetEntity(client.Id);
if (searchSetting != null)
{
return(Ok(searchSetting));
}
SearchSetting defaultSearchSetting = new SearchSetting
{
SearchSettingId = client.Id,
Radius = 500,
WantedCost = 100
};
SearchSettingDB.Create(defaultSearchSetting);
return(Ok(defaultSearchSetting));
}
return(NotFound());
}
private static int CountForList(SearchSetting setting)
{
SqlParameter[] parms =
{
new SqlParameter("CID", SqlDbType.Int),
new SqlParameter("Title", SqlDbType.NVarChar),
new SqlParameter("PublishDate", SqlDbType.NVarChar)
};
parms[0].Value = setting.CategoryId;
parms[1].Value = setting.Title;
parms[2].Value = setting.PublishDate;
StringBuilder sbSQL = new StringBuilder();
sbSQL.Append(@"SELECT COUNT(*) AS c FROM Articles AS p WITH(NOLOCK)
WHERE EXISTS(
SELECT * FROM Categories AS AC WITH(NOLOCK)
WHERE (AC.ID = @CID OR CHARINDEX(','+CAST(@CID AS NVARCHAR(MAX))+',',','+AC.ParentIdList+',') >0)
AND p.CategoryId = AC.ID
)");
sbSQL.Append(" AND IsDeleted = 0 ");
if (!string.IsNullOrEmpty(setting.Title))
{
sbSQL.Append(" AND CONTAINS(Title,@Title) ");
}
if (Regex.IsMatch(setting.PublishDate, @"^\d{4}-\d{1,2}-\d{1,2}$", RegexOptions.IgnoreCase))
{
sbSQL.Append(" AND CONVERT(VARCHAR(10),PublishDateTime,120) = @PublishDate");
}
return(Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text, sbSQL.ToString(), parms)));
}
SearchSetting GetEntity(SearchSetting model)
{
var r = Provider.Get(new SearchSetting(Repository, model.Name));
r.Name = model.Name;
return(r);
}
/// <summary>
/// 列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList <ResumeInfo> List(SearchSetting setting)
{
FastPaging fp = new FastPaging();
fp.PageIndex = setting.PageIndex;
fp.PageSize = setting.PageSize;
fp.Ascending = false;
fp.TableName = "Resumes";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
fp.OverOrderBy = " CreateDateTime DESC";
fp.WithOptions = " WITH(NOLOCK)";
fp.Condition = " IsDeleted = 0";
IList <ResumeInfo> list = new List <ResumeInfo>();
ResumeInfo model = null;
DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = GetByRow(dr);
if (model != null)
{
list.Add(model);
}
}
}
int count = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL()));
return(new PageOfList <ResumeInfo>(list, setting.PageIndex, setting.PageSize, count));
}
/// <summary>
/// 列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList<MemberInfo> List(SearchSetting setting)
{
FastPaging fp = new FastPaging();
fp.PageIndex = setting.PageIndex;
fp.PageSize = setting.PageSize;
fp.Ascending = false;
fp.TableName = "Members";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
fp.OverOrderBy = " CreateDateTime DESC";
fp.WithOptions = " WITH(NOLOCK)";
IList<MemberInfo> list = new List<MemberInfo>();
DataTable dt = Goodspeed.Library.Data.SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
list.Add(GetByRow(dr));
}
}
int count = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL())); ;
return new PageOfList<MemberInfo>(list, setting.PageIndex, setting.PageSize, count);
}
public static IPageOfList <AttachmentInfo> List(SearchSetting settings)
{
FastPaging fp = new FastPaging();
fp.PageIndex = settings.PageIndex;
fp.PageSize = settings.PageSize;
fp.TableName = "Attachments";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
StringBuilder sbCondition = new StringBuilder();
sbCondition.AppendFormat(" SiteId = @SiteId ");
if (!settings.ShowDeleted)
{
sbCondition.Append(" AND IsDeleted = 0 ");
}
if (settings.CategoryId > 0)
{
sbCondition.Append(@" AND EXISTS(
SELECT * FROM dbo.Categories AS AC WITH(NOLOCK)
WHERE (AC.ID = @CID OR CHARINDEX(','+CAST(@CID AS NVARCHAR(MAX))+',',','+AC.ParentIdList+',') >0) /*获取此分类下所有的子分类*/
AND SiteId = @SiteId
AND IsDeleted = 0
AND p.CategoryId = AC.ID
)");
}
fp.Condition = sbCondition.ToString();
fp.OverOrderBy = "Sort ASC ,PublishDate DESC";
SqlParameter[] parms =
{
new SqlParameter("@SiteId", SqlDbType.Int),
new SqlParameter("@CID", SqlDbType.Int)
};
parms[0].Value = settings.SiteId;
parms[1].Value = settings.CategoryId;
IList <AttachmentInfo> list = new List <AttachmentInfo>();
AttachmentInfo model = null;
DataTable dt = Goodspeed.Library.Data.SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005(), parms);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = Get(dr);
if (model != null)
{
list.Add(model);
}
}
}
int count = Count(settings);
return(new PageOfList <AttachmentInfo>(list, settings.PageIndex, settings.PageSize, count));
}
public IActionResult UpdateSearchSetting([FromBody] SearchSetting searchSetting)
{
if (searchSetting == null)
{
return(BadRequest());
}
SearchSettingDB.Update(searchSetting);
return(Ok(searchSetting));
}
public IActionResult CreateEquipment([FromBody] SearchSetting searchSetting)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
SearchSettingDB.Create(searchSetting);
SearchSettingDB.Save();
return(Ok(searchSetting));
}
public static IPageOfList <ArticleInfo> List(SearchSetting setting, WebLanguage language = WebLanguage.zh_cn)
{
var list = ArticleManage.List(setting);
foreach (var item in list)
{
LoadExtensionInfo(item, language);
}
return(list);
}
private static int Count(SearchSetting settings)
{
StringBuilder sbCondition = new StringBuilder(" SELECT COUNT(*) FROM Admins WITH(NOLOCK) WHERE 1 = 1");
if (!settings.ShowDeleted)
{
sbCondition.Append(" AND IsDeleted = 0 ");
}
return(Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, sbCondition.ToString())));
}
public SearchWorkplaces(int clientId)
{
_workplaceParameterDB = new WorkplaceParameterRepository();
_searchSettingDB = new SearchSettingRepository();
_buildingDB = new BuildingRepository();
_workplaceDB = new WorkplaceRepository();
_workplaceEquipmentDB = new WorkplaceEquipmentRepository();
_workplaceParameters = _workplaceParameterDB.GetEntityListByClientId(clientId);
_idealMark = GetIdealMark();
_searchSetting = _searchSettingDB.GetEntity(clientId);
}
public IActionResult DeleteEquipment(int id)
{
SearchSetting searchSetting = SearchSettingDB.GetEntity(id);
if (searchSetting == null)
{
return(NotFound());
}
SearchSettingDB.Delete(id);
return(Ok(searchSetting));
}
public bool validStatus(RNGSearch.RNGResult result, SearchSetting setting)
{
for (int i = 0; i < 6; i++)
{
if (setting.Status[i] != 0 && setting.Status[i] != p_Status[i])
{
return(false);
}
}
return(true);
}
private static int Count(SearchSetting settings)
{
StringBuilder sbCondition = new StringBuilder(" SELECT COUNT(*) FROM Feedbacks WITH(NOLOCK) WHERE 1 = 1");
sbCondition.AppendFormat(" AND SiteId = @SiteId ");
SqlParameter[] parms =
{
new SqlParameter("@SiteId", SqlDbType.Int),
};
parms[0].Value = settings.SiteId;
return(Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text, sbCondition.ToString(), parms)));
}
public SearchWorkplaces(double latitude, double longitude, int clientId)
{
_workplaceParameterDB = new WorkplaceParameterRepository();
_searchSettingDB = new SearchSettingRepository();
_buildingDB = new BuildingRepository();
_workplaceDB = new WorkplaceRepository();
_workplaceEquipmentDB = new WorkplaceEquipmentRepository();
_latitude = latitude;
_longitude = longitude;
_workplaceParameters = _workplaceParameterDB.GetEntityListByClientId(clientId);
_idealMark = GetIdealMark();
_searchSetting = _searchSettingDB.GetEntity(clientId);
_buildingsInRadius = GetBuildingsInRadius();
}
public virtual ActionResult Edit(SearchSetting model, string @return)
{
var data = new JsonResultData(ModelState);
if (ModelState.IsValid)
{
data.RunWithTry((resultData) =>
{
model.Repository = Repository;
Provider.Update(model, model);
resultData.RedirectUrl = @return;
});
}
return(Json(data));
}
public virtual ActionResult Create(SearchSetting model)
{
var entry = new JsonResultEntry();
try
{
model.Repository = Repository;
Provider.Add(model);
entry.SetSuccess();
}
catch (Exception e)
{
entry.AddException(e);
}
return(Json(entry));
}
protected virtual string GenerateContentUrl(TextContent content, SearchSetting searchSetting)
{
if (Page_Context.Current.Initialized)
{
var routeValues = new RouteValueDictionary();
if (searchSetting.RouteValueFields != null && searchSetting.RouteValueFields.Count > 0)
{
foreach (var routeValue in searchSetting.RouteValueFields)
{
routeValues[routeValue.Key] = EvaluateStringFormulas(content, routeValue.Value);
}
}
return(Page_Context.Current.FrontUrl.PageUrl(searchSetting.LinkPage, routeValues).ToString());
}
return("");
}
public static IPageOfList <JobInfo> List(SearchSetting settings)
{
FastPaging fp = new FastPaging();
fp.PageIndex = settings.PageIndex;
fp.PageSize = settings.PageSize;
fp.TableName = "Jobs";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
StringBuilder sbCondition = new StringBuilder();
sbCondition.AppendFormat(" SiteId = @SiteId ");
if (!settings.ShowDeleted)
{
sbCondition.Append(" AND IsDeleted = 0 ");
}
fp.Condition = sbCondition.ToString();
fp.OverOrderBy = "Sort ASC , EndDateTime DESC";
SqlParameter[] parms =
{
new SqlParameter("@SiteId", SqlDbType.Int),
};
parms[0].Value = settings.SiteId;
IList <JobInfo> list = new List <JobInfo>();
JobInfo model = null;
DataTable dt = Goodspeed.Library.Data.SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005(), parms);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = Get(dr);
if (model != null)
{
list.Add(model);
}
}
}
int count = Count(settings);
return(new PageOfList <JobInfo>(list, settings.PageIndex, settings.PageSize, count));
}
public static IPageOfList <AttachmentInfo> List(SearchSetting setting)
{
FastPaging fp = new FastPaging();
fp.PageIndex = setting.PageIndex;
fp.PageSize = setting.PageSize;
fp.Ascending = false;
fp.TableName = "Attachments";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
fp.WithOptions = " WITH(NOLOCK)";
fp.OverOrderBy = " CreateDateTime DESC";
if (!setting.ShowDeleted)
{
fp.Condition += " IsDeleted = 0";
}
IList <AttachmentInfo> list = new List <AttachmentInfo>();
AttachmentInfo model = null;
DataTable dt = Goodspeed.Library.Data.SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = new AttachmentInfo()
{
Id = dr.Field <int>("ID"),
Title = dr.Field <string>("Title"),
CreateDateTime = dr.Field <DateTime>("CreateDateTime"),
FileType = dr.Field <string>("FileType"),
Size = dr.Field <int>("Size"),
Url = dr.Field <string>("Url"),
IsDeleted = dr.Field <bool>("IsDeleted")
};
list.Add(model);
}
}
int count = Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text, "SELECT COUNT(*) FROM Attachments"));
return(new PageOfList <AttachmentInfo>(list, setting.PageIndex, setting.PageSize, count));
}
/// <summary>
/// 列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList <AttachmentDownloadLogInfo> ListLog(int attachId, SearchSetting setting)
{
FastPaging fp = new FastPaging();
fp.PageIndex = setting.PageIndex;
fp.PageSize = setting.PageSize;
fp.Ascending = false;
fp.TableName = "AttachmentDownloadLog";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*,A.Title";
fp.OverOrderBy = " LastDownloadDateTime DESC";
fp.WithOptions = " WITH(NOLOCK)";
fp.JoinSQL = " INNER JOIN Attachment AS A WITH(NOLOCK) ON A.Id = P.AttachId";
if (attachId > 0)
{
fp.Condition = string.Format(" AttachId = {0}", attachId);
}
IList <AttachmentDownloadLogInfo> list = new List <AttachmentDownloadLogInfo>();
DataTable dt = Goodspeed.Library.Data.SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new AttachmentDownloadLogInfo()
{
Id = dr.Field <int>("Id"),
UserId = dr.Field <int>("UserId"),
UserName = dr.Field <string>("UserName"),
DownloadCount = dr.Field <int>("DownloadCount"),
LastDownloadDateTime = dr.Field <DateTime>("LastDownloadDateTime"),
AttachTitle = dr.Field <string>("Title")
});
}
}
int count = Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL()));;
return(new PageOfList <AttachmentDownloadLogInfo>(list, setting.PageIndex, setting.PageSize, count));
}
public void getStatus(RNGSearch.RNGResult result, SearchSetting setting)
{
setting.p_Status = new int[6];
int[] IV = new int[6];
for (int i = 0; i < 6; i++)
{
IV[i] = result.IVs[i];
}
p_Status[0] = (((BS[0] * 2 + IV[0]) * Lv) / 100) + Lv + 10;
for (int i = 1; i < 6; i++)
{
p_Status[i] = (int)(((((BS[i] * 2 + IV[i]) * Lv) / 100) + 5) * natures_mag[result.Nature, i]);
}
result.p_Status = setting.p_Status;
return;
}
public void it_should_call_search_service_once()
{
// setup
var givenRequest = new GetSearchPositionsQuery("google", "www.google.com");
var givenResponse = Task.FromResult("<div></div>");
var givenSetting = new SearchSetting {
ResultNumber = 1
};
var givenUrl = $"/search?num={givenSetting.ResultNumber}&q={givenRequest.Keyword}";
_mockSearchSetting.Setup(s => s.Value).Returns(givenSetting);
_mockGoogleSearchService.Setup(g => g.GetHtmlString(It.IsAny <string>())).Returns(givenResponse);
_mockHtmlProcessor.Setup(h => h.GetSearchPositions(givenResponse.Result, givenRequest.TargetUrl)).Returns(It.IsAny <IEnumerable <int> >());
// act
var result = _handler.Handle(givenRequest, CancellationToken.None);
// assert
_mockGoogleSearchService.Verify(g => g.GetHtmlString(givenUrl), Times.Exactly(1));
}
/// <summary>
/// 反馈列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList <FeedbackInfo> List(SearchSetting setting)
{
FastPaging fp = new FastPaging();
fp.PageIndex = setting.PageIndex;
fp.PageSize = setting.PageSize;
fp.Ascending = false;
fp.TableName = "Feedback";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
fp.OverOrderBy = "CreateDateTime DESC";
fp.Condition = " IsDeleted = 0";
IList <FeedbackInfo> list = new List <FeedbackInfo>();
DataTable dt = Goodspeed.Library.Data.SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new FeedbackInfo()
{
Id = dr.Field <int>("Id"),
Title = dr.Field <string>("Title"),
Content = dr.Field <string>("Content"),
Contact = dr.Field <string>("Contact"),
Email = dr.Field <string>("Email"),
Phone = dr.Field <string>("Phone"),
Address = dr.Field <string>("Address"),
Fax = dr.Field <string>("Fax"),
CreateDateTime = dr.Field <DateTime>("CreateDateTime")
});
}
}
int count = Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL()));;
return(new PageOfList <FeedbackInfo>(list, setting.PageIndex, setting.PageSize, count));
}
public virtual ActionResult Create(SearchSetting model, string @return)
{
var data = new JsonResultData(ModelState);
if (ModelState.IsValid)
{
data.RunWithTry((resultData) =>
{
model.Repository = Repository;
if (Provider.Get(model) != null)
{
resultData.AddErrorMessage("The item already exists.".Localize());
}
else
{
Provider.Add(model);
resultData.RedirectUrl = @return;
}
});
}
return(Json(data));
}
public static IPageOfList <AdminInfo> List(SearchSetting settings)
{
FastPaging fp = new FastPaging();
fp.PageIndex = settings.PageIndex;
fp.PageSize = settings.PageSize;
fp.TableName = "Admins";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
StringBuilder sbCondition = new StringBuilder();
if (!settings.ShowDeleted)
{
sbCondition.Append(" IsDeleted = 0 ");
}
fp.Condition = sbCondition.ToString();
fp.OverOrderBy = " CreateDateTime DESC";
IList <AdminInfo> list = new List <AdminInfo>();
AdminInfo model = null;
DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = Get(dr, true);
if (model != null)
{
list.Add(model);
}
}
}
int count = Count(settings);
return(new PageOfList <AdminInfo>(list, settings.PageIndex, settings.PageSize, count));
}
public virtual ActionResult Edit(SearchSetting model)
{
var entry = new JsonResultEntry();
try
{
if (ModelState.IsValid)
{
model.Repository = Repository;
Provider.Update(model, model);
entry.SetSuccess();
}
else
{
entry.AddModelState(ModelState).SetFailed();
}
}
catch (Exception e)
{
entry.AddException(e);
}
return(Json(entry));
}
public async Task <ProductSearchResult> GetProductsAsync(SearchSetting filter)
{
//todo : if where is not well formed, throw back bad request
string whereLine = filter.GetWhereLine();
var countTask = DbContext.Products.Where(whereLine).CountAsync();
var query = DbContext.Products.Where(whereLine);
if (!string.IsNullOrEmpty(filter.OrderColumn))
{
query = query.OrderBy(filter.OrderColumn + (filter.IsDesc ? " desc" : string.Empty));
}
var pageTask = query
.Skip(filter.PageIndex * filter.PageSize)
.Take(filter.PageSize)
.ToListAsync();
return(new ProductSearchResult()
{
Count = await countTask, PageData = await pageTask
});
}
/// <summary>
/// 反馈列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList<FeedbackInfo> List(SearchSetting setting)
{
FastPaging fp = new FastPaging();
fp.PageIndex = setting.PageIndex;
fp.PageSize = setting.PageSize;
fp.Ascending = false;
fp.TableName = "Feedback";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
fp.OverOrderBy = "CreateDateTime DESC";
fp.Condition = " IsDeleted = 0";
IList<FeedbackInfo> list = new List<FeedbackInfo>();
DataTable dt = Goodspeed.Library.Data.SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new FeedbackInfo(){
Id = dr.Field<int>("Id"),
Title = dr.Field<string>("Title"),
Content = dr.Field<string>("Content"),
Contact = dr.Field<string>("Contact"),
Email = dr.Field<string>("Email"),
Phone = dr.Field<string>("Phone"),
Address = dr.Field<string>("Address"),
Fax = dr.Field<string>("Fax"),
CreateDateTime = dr.Field<DateTime>("CreateDateTime")
});
}
}
int count = Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL())); ;
return new PageOfList<FeedbackInfo>(list, setting.PageIndex, setting.PageSize, count);
}
/// <summary>
/// 列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList<AttachmentDownloadLogInfo> ListLog(int attachId,SearchSetting setting)
{
FastPaging fp = new FastPaging();
fp.PageIndex = setting.PageIndex;
fp.PageSize = setting.PageSize;
fp.Ascending = false;
fp.TableName = "AttachmentDownloadLog";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*,A.Title";
fp.OverOrderBy = " LastDownloadDateTime DESC";
fp.WithOptions = " WITH(NOLOCK)";
fp.JoinSQL = " INNER JOIN Attachment AS A WITH(NOLOCK) ON A.Id = P.AttachId";
if(attachId>0){
fp.Condition = string.Format(" AttachId = {0}",attachId);
}
IList<AttachmentDownloadLogInfo> list = new List<AttachmentDownloadLogInfo>();
DataTable dt = Goodspeed.Library.Data.SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new AttachmentDownloadLogInfo() {
Id = dr.Field<int>("Id"),
UserId = dr.Field<int>("UserId"),
UserName = dr.Field<string>("UserName"),
DownloadCount = dr.Field<int>("DownloadCount"),
LastDownloadDateTime = dr.Field<DateTime>("LastDownloadDateTime"),
AttachTitle = dr.Field<string>("Title")
});
}
}
int count = Convert.ToInt32(Goodspeed.Library.Data.SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL())); ;
return new PageOfList<AttachmentDownloadLogInfo>(list, setting.PageIndex, setting.PageSize, count);
}
/// <summary>
/// 列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList<AttachmentDownloadLogInfo> ListLog(int attachId, SearchSetting setting) {
return AttachmentManage.ListLog(attachId,setting);
}
public static IPageOfList <JobInfo> List(SearchSetting settings)
{
return(JobManage.List(settings));
}
}/// <summary>
/// 列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList<MemberInfo> List(SearchSetting setting){
return MemberManage.List(setting);
}
/// <summary>
/// 列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList<ResumeInfo> List(SearchSetting setting) {
return ResumeManage.List(setting);
}
/// <summary>
/// 列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList<FeedbackInfo> List(SearchSetting setting) {
return FeedbackManage.List(setting);
}