private static string GetList(HttpRequest Request)
{
string strreturn;
string strSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strSearch");
int pageindex = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pageindex", 1);
int pagesize = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pagesize", 20);
NetSchool.Common.Info.PageInfo pageInfo = new Common.Info.PageInfo();
pageInfo.PageSize = pagesize;
pageInfo.CurrentPageIndex = pageindex - 1;
pageInfo.IsPage = true;
pageInfo.SortField1 = "CreateTime";
pageInfo.SortType1 = NetSchool.Common.Enums.SortType.DESC;
bool isSearch = false;
if (strSearch != "")
{
isSearch = true;
}
var lawInfo = NetSchool.BLL.Law.SearchList <NetSchool.Model.Law>(IsSearchTitle: isSearch, Title: strSearch, pageInfo: pageInfo);
strreturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK", count = pageInfo.RecordCount, list = lawInfo }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(strreturn);
}
private static string GetList()
{
string strReturn;
string strSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strSearch");
int pageindex = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pageindex", 1);
int pagesize = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pagesize", 20);
NetSchool.Common.Info.PageInfo pageInfo = new Common.Info.PageInfo();
pageInfo.PageSize = pagesize;
pageInfo.CurrentPageIndex = pageindex - 1;
pageInfo.IsPage = true;
pageInfo.SortField1 = "RealName";
pageInfo.SortType1 = NetSchool.Common.Enums.SortType.DESC;
bool isSearch = false;
if (strSearch != "")
{
isSearch = true;
}
var peopleList = NetSchool.BLL.People.SearchList <PeopleWith>(IsSearchRealName: isSearch, RealName: strSearch, pageInfo: pageInfo);
PackingPeopleList(peopleList);
strReturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK", count = pageInfo.RecordCount, list = peopleList }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(strReturn);
}
private static string GetList()
{
string strreturn;
string serBeginTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serBeginTime");
string serEndTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serEndTime");
string strSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strSearch");
string strCompany = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strCompany");
int pageindex = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pageindex", 1);
int pagesize = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pagesize", 20);
NetSchool.Common.Info.PageInfo pageInfo = new Common.Info.PageInfo();
pageInfo.PageSize = pagesize;
pageInfo.CurrentPageIndex = pageindex - 1;
pageInfo.IsPage = true;
pageInfo.SortField1 = "createdTime";
pageInfo.SortType1 = NetSchool.Common.Enums.SortType.DESC;
bool isSearch = false;
if (strSearch != "")
{
isSearch = true;
}
bool isSearchCompany = false;
if (strCompany != "")
{
isSearchCompany = true;
}
Common.Enums.StampStruct stamp = new Common.Enums.StampStruct();
stamp.name = "统计时间";
if (string.IsNullOrEmpty(serBeginTime))
{
stamp.startTime = Common.Library.ChangeTime.GetStamp("1970-01-01 08:00:00");
}
else
{
stamp.startTime = Common.Library.ChangeTime.GetStamp(serBeginTime + " 00:00:00");
}
if (string.IsNullOrEmpty(serEndTime))
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(DateTime.Now.ToString());
}
else
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(serEndTime + " 23:59:59");
}
var eduCompanyList = NetSchool.BLL.EduCompany.Search(IsSearchCompany: isSearchCompany, company: strCompany, IsSearchTerritory: isSearch, territory: strSearch, startTime: stamp.startTime, endTime: stamp.endTime, pageInfo: pageInfo);
packageDatatable(eduCompanyList);
strreturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK", count = pageInfo.RecordCount, list = eduCompanyList }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(strreturn);
}
public DataTable SearchTerritory(string territory, Common.Info.PageInfo pageInfo)
{
StringBuilder strSql = new StringBuilder();
var parameters = new List <SqlParameter>();
strSql.Append("select distinct territory,count(territory)[Count] from eduCompany where 1=1");
if (!string.IsNullOrWhiteSpace(territory))
{
strSql.Append(" and territory like '%' +@Territory+'%'");
var para = new SqlParameter("@Territory", SqlDbType.NVarChar);
para.Value = territory;
parameters.Add(para);
}
strSql.Append(" group by territory");
var paraarry = parameters.ToArray();
string pageSql = SqlHelper.SqlHelper.DoPageInfo(strSql, paraarry, pageInfo);
return(SqlHelper.SqlHelper.ExecuteDataTable(pageSql, paraarry));
}
public static Dictionary <string, DataTable> GetAllInfo()
{
Dictionary <string, DataTable> dic = null;
Common.Info.PageInfo pageInfo = new Common.Info.PageInfo();
int pageindex = 1;
int pagesize = 5;
pageInfo.PageSize = pagesize;
pageInfo.CurrentPageIndex = pageindex - 1;
pageInfo.IsPage = true;
pageInfo.SortField1 = "CreateTime";
pageInfo.SortType1 = NetSchool.Common.Enums.SortType.DESC;
DataTable Law = BLL.Law.Search(pageInfo: pageInfo);
DataTable News = BLL.News.Search(pageInfo: pageInfo);
DataTable Notice = BLL.Notice.Search(pageInfo: pageInfo);
dic = new Dictionary <string, DataTable>();
dic.Add("Law", Law);
dic.Add("Notice", Notice);
dic.Add("News", News);
return(dic);
}
public static T[] SearchList <T>(Guid?Id = null, bool IsSearchCompany = false, string Company = null, bool IsSearchNickName = false, string NickName = null, bool IsSearchIdcard = false, string Idcard = null, bool IsSearchRoles = false, string Roles = null, bool IsSearchGender = false, string Gender = null, bool IsSearchCreatedTime = false, int?StartTime = null, int?EndTime = null, bool IsSearchCreateTime = false, DateTime?CreateTime = null, Common.Info.PageInfo pageInfo = null) where T : Model.EduUser, new()
{
return(dal.SearchList <T>(Id, IsSearchCompany, Company, IsSearchNickName, NickName, IsSearchIdcard, Idcard, IsSearchRoles, Roles, IsSearchGender, Gender, StartTime, EndTime, CreateTime, pageInfo));
}
public static DataTable Search(Guid?Id = null, bool IsSearchCompany = false, string Company = null, bool IsSearchNickName = false, string NickName = null, bool IsSearchIdcard = false, string Idcard = null, bool IsSearchRoles = false, string Roles = null, bool IsSearchGender = false, string Gender = null, int?StartTime = null, int?EndTime = null, DateTime?CreateTime = null, Common.Info.PageInfo pageInfo = null)
{
return(dal.Search(Id, IsSearchCompany, Company, IsSearchNickName, NickName, IsSearchIdcard, Idcard, IsSearchRoles, Roles, IsSearchGender, Gender, StartTime, EndTime, CreateTime, pageInfo));
}
public T[] SearchList <T>(bool IsSearchUserName, string UserName, bool IsSearchRealName, string RealName, bool IsSearchTelephone, string Telephone, bool IsSearchEmail, string Email, bool IsSearchPermission, string Permission, bool IsSearchPassword, string Password, Common.Info.PageInfo pageInfo) where T : Model.People, new()
{
var strSql = new StringBuilder();
var parameters = new List <SqlParameter>();
strSql.Append("select [UserName],[RealName],[Telephone],[Email],[Permission],[Password] FROM People where 1=1 ");
if (IsSearchUserName)
{
if (string.IsNullOrWhiteSpace(UserName))
{
strSql.Append(" and [UserName] is null ");
}
else
{
strSql.Append(" and [UserName] like '%'+@UserName+'%' ");
var para = new SqlParameter("@UserName", SqlDbType.NVarChar, 20);
para.Value = UserName;
parameters.Add(para);
}
}
if (IsSearchRealName)
{
if (string.IsNullOrWhiteSpace(RealName))
{
strSql.Append(" and [RealName] is null ");
}
else
{
strSql.Append(" and [RealName] like '%'+@RealName+'%' ");
var para = new SqlParameter("@RealName", SqlDbType.NVarChar, 20);
para.Value = RealName;
parameters.Add(para);
}
}
if (IsSearchTelephone)
{
if (string.IsNullOrWhiteSpace(Telephone))
{
strSql.Append(" and [Telephone] is null ");
}
else
{
strSql.Append(" and [Telephone] like '%'+@Telephone+'%' ");
var para = new SqlParameter("@Telephone", SqlDbType.NVarChar);
para.Value = Telephone;
parameters.Add(para);
}
}
if (IsSearchEmail)
{
if (string.IsNullOrWhiteSpace(Email))
{
strSql.Append(" and [Email] is null ");
}
else
{
strSql.Append(" and [Email] like '%'+@Email +'%'");
var para = new SqlParameter("@Email", SqlDbType.NVarChar, 50);
para.Value = Email;
parameters.Add(para);
}
}
if (IsSearchPermission)
{
if (string.IsNullOrWhiteSpace(Permission))
{
strSql.Append(" and [Permission] is null ");
}
else
{
strSql.Append(" and [Permission] like '%'+@Permission+'%' ");
var para = new SqlParameter("@Permission", SqlDbType.NVarChar, 10);
para.Value = Permission;
parameters.Add(para);
}
}
if (IsSearchPassword)
{
strSql.Append(" and [Password] = @Password ");
var para = new SqlParameter("@Password", SqlDbType.NVarChar, 100);
para.Value = Password;
parameters.Add(para);
}
var paraarray = parameters.ToArray();
string pageSql = NetSchool.DAL.SqlHelper.SqlHelper.DoPageInfo(strSql, paraarray, pageInfo);
var resulttable = NetSchool.DAL.SqlHelper.SqlHelper.ExecuteDataTable(pageSql, paraarray);
return(DataTableToArray <T>(resulttable));
}
public DataTable Search(Guid?Id, bool IsSearchCompany, string Company, bool IsSearchNickName, string NickName, bool IsSearchIdcard, string Idcard, bool IsSearchRoles, string Roles, bool IsSearchGender, string Gender, int?StartTime, int?EndTime, DateTime?CreateTime, Common.Info.PageInfo pageInfo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from EduUser");
strSql.Append(" where 1=1");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Company", SqlDbType.NVarChar),
new SqlParameter("@NickName", SqlDbType.NVarChar),
new SqlParameter("@Idcard", SqlDbType.NVarChar),
new SqlParameter("@Roles", SqlDbType.NVarChar),
new SqlParameter("@Gender", SqlDbType.NVarChar),
new SqlParameter("@StartTime", SqlDbType.Int, 10),
new SqlParameter("@EndTime", SqlDbType.Int, 10),
new SqlParameter("@CreateTime", SqlDbType.Date)
};
if (Id.HasValue)
{
strSql.Append(" and ID=@ID ");
parameters[0].Value = Id.Value;
}
else
{
parameters[0].Value = DBNull.Value;
}
if (IsSearchCompany)
{
if (string.IsNullOrWhiteSpace(Company))
{
strSql.Append(" and company is null ");
parameters[1].Value = DBNull.Value;
}
else
{
strSql.Append(" and company like '%'+@Company+'%' ");
parameters[1].Value = Company;
}
}
else
{
parameters[1].Value = DBNull.Value;
}
if (IsSearchNickName)
{
if (string.IsNullOrWhiteSpace(NickName))
{
strSql.Append(" and nickname is null ");
parameters[2].Value = DBNull.Value;
}
else
{
strSql.Append(" and nickname like '%'+@NickName+'%' ");
parameters[2].Value = NickName;
}
}
else
{
parameters[2].Value = DBNull.Value;
}
if (IsSearchIdcard)
{
if (string.IsNullOrWhiteSpace(Idcard))
{
strSql.Append(" and idcard is null ");
parameters[3].Value = DBNull.Value;
}
else
{
strSql.Append(" and idcard like '%'+@Idcard+'%' ");
parameters[3].Value = Idcard;
}
}
else
{
parameters[3].Value = DBNull.Value;
}
if (IsSearchRoles)
{
if (string.IsNullOrWhiteSpace(Roles) || Roles.Equals("null", StringComparison.CurrentCultureIgnoreCase))
{
strSql.Append(" and roles is null ");
parameters[4].Value = DBNull.Value;
}
else
{
strSql.Append(" and roles = @Roles ");
parameters[4].Value = Roles;
}
}
else
{
parameters[4].Value = DBNull.Value;
}
if (IsSearchGender)
{
if (string.IsNullOrWhiteSpace(Gender))
{
strSql.Append(" and gender is null ");
parameters[5].Value = DBNull.Value;
}
else
{
strSql.Append(" and gender =@Gender ");
parameters[5].Value = Gender;
}
}
else
{
parameters[5].Value = DBNull.Value;
}
if (StartTime.HasValue)
{
if (EndTime.HasValue)
{
strSql.Append(" and createdTime>@StartTime ");
strSql.Append(" and createdTime<@EndTime ");
parameters[6].Value = StartTime.Value;
parameters[7].Value = EndTime.Value;
}
else
{
parameters[6].Value = DBNull.Value;
parameters[7].Value = DBNull.Value;
}
}
else
{
parameters[6].Value = DBNull.Value;
parameters[7].Value = DBNull.Value;
}
if (CreateTime.HasValue)
{
strSql.Append(" and CreateTime=@CreateTime ");
parameters[8].Value = CreateTime.Value;
}
else
{
parameters[8].Value = DBNull.Value;
}
string pageSql = strSql.ToString();
if (pageInfo != null)
{
if (pageInfo.IsPage)
{
NetSchool.DAL.SqlHelper.SqlHelper.getCountInfo(pageSql, pageInfo, parameters);
pageSql = NetSchool.DAL.SqlHelper.SqlHelper.PreparePageCommand(pageSql, pageInfo, parameters);
}
else
{
pageSql = NetSchool.DAL.SqlHelper.SqlHelper.AppendSortString(pageSql, pageInfo);
}
}
return(NetSchool.DAL.SqlHelper.SqlHelper.ExecuteDataTable(pageSql, parameters));
}
public static DataTable SearchTerritory(string territory = null, Common.Info.PageInfo pageInfo = null)
{
return(dal.SearchTerritory(territory, pageInfo));
}
public static T[] SearchList <T>(Guid?ID = null, bool IsSearchCompany = false, string company = null, bool IsSearchTerritory = false, string territory = null, int?startTime = null, int?endTime = null, Common.Info.PageInfo pageInfo = null) where T : Model.EduCompany, new()
{
return(dal.SearchList <T>(ID, IsSearchCompany, company, IsSearchTerritory, territory, startTime, endTime, pageInfo));
}
public static DataTable Search(Guid?ID = null, bool IsSearchCompany = false, string company = null, bool IsSearchTerritory = false, string territory = null, int?startTime = null, int?endTime = null, Common.Info.PageInfo pageInfo = null)
{
return(dal.Search(ID, IsSearchCompany, company, IsSearchTerritory, territory, startTime, endTime, pageInfo));
}
public static DataTable SearchCount(bool IsCountByTerritory = true, bool IsCountByTime = true, Common.Enums.StatisticalTime countStyle = Common.Enums.StatisticalTime.Year, bool IsSearchTerritory = false, string territory = null, Common.Info.PageInfo pageInfo = null)
{
return(dal.SearchCount(IsCountByTerritory, IsCountByTime, countStyle, IsSearchTerritory, territory, pageInfo));
}
private static string GetList()
{
string strreturn;
string serBeginTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serBeginTime");
string serEndTime = NetSchool.Common.Library.GetPostBack.GetPostBackStr("serEndTime");
string strCompanySearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("searchCompanyTxt");
string strIdcardSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strIdcardSearch");
string strRolesSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strRolesSearch");
string strGenderSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strGenderSearch");
string strNicknameSearch = NetSchool.Common.Library.GetPostBack.GetPostBackStr("strNicknameSearch");
int pageindex = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pageindex", 1);
int pagesize = NetSchool.Common.Library.GetPostBack.GetPostBackInt("pagesize", 20);
NetSchool.Common.Info.PageInfo pageInfo = new Common.Info.PageInfo();
pageInfo.PageSize = pagesize;
pageInfo.CurrentPageIndex = pageindex - 1;
pageInfo.IsPage = true;
pageInfo.SortField1 = "createdTime";
pageInfo.SortType1 = NetSchool.Common.Enums.SortType.DESC;
bool isSearchByCompany = false;
bool isSearchByIdcard = false;
bool isSearchByGender = false;
bool isSearchByRoles = false;
bool isSearchByNickname = false;
if (!string.IsNullOrEmpty(strNicknameSearch))
{
isSearchByNickname = true;
}
if (!string.IsNullOrEmpty(strCompanySearch))
{
isSearchByCompany = true;
}
if (!string.IsNullOrEmpty(strIdcardSearch))
{
isSearchByIdcard = true;
}
if (!string.IsNullOrEmpty(strGenderSearch))
{
isSearchByGender = true;
}
if (!string.IsNullOrEmpty(strRolesSearch))
{
isSearchByRoles = true;
}
Common.Enums.StampStruct stamp = new Common.Enums.StampStruct();
stamp.name = "统计时间";
if (string.IsNullOrEmpty(serBeginTime))
{
stamp.startTime = Common.Library.ChangeTime.GetStamp("1970-01-01 08:00:00");
}
else
{
stamp.startTime = Common.Library.ChangeTime.GetStamp(serBeginTime + " 00:00:00");
}
if (string.IsNullOrEmpty(serEndTime))
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(DateTime.Now.ToString());
}
else
{
stamp.endTime = Common.Library.ChangeTime.GetStamp(serEndTime + " 23:59:59");
}
var allRoles = NetSchool.BLL.EduUser.GetALLRolesDistinct();
var eduUserList = NetSchool.BLL.EduUser.Search(IsSearchCompany: isSearchByCompany, Company: strCompanySearch, IsSearchNickName: isSearchByNickname, NickName: strNicknameSearch, IsSearchIdcard: isSearchByIdcard, Idcard: strIdcardSearch, IsSearchRoles: isSearchByRoles, Roles: strRolesSearch, IsSearchGender: isSearchByGender, Gender: strGenderSearch, StartTime: stamp.startTime, EndTime: stamp.endTime, pageInfo: pageInfo);
packageDatatable(eduUserList);
strreturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK", count = pageInfo.RecordCount, list = eduUserList, rolesList = allRoles }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
return(strreturn);
}
public DataTable Search(Guid?ID, bool IsSearchTitle, string Title, bool IsSearchContent, string Content, int?Type, bool IsSearchAuthor, string Author, DateTime?StartTime, DateTime?EndTime, Common.Info.PageInfo pageInfo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from News ");
strSql.Append(" where 1=1");
SqlParameter[] parameters =
{
new SqlParameter("@NewsID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Content", SqlDbType.NText),
new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@Author", SqlDbType.NVarChar),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime)
};
if (ID.HasValue)
{
strSql.Append(" and NewsID=@NewsID");
parameters[0].Value = ID.Value;
}
else
{
parameters[0].Value = DBNull.Value;
}
if (IsSearchTitle)
{
strSql.Append(" and Title like '%'+@Title+'%'");
parameters[1].Value = Title;
}
else
{
parameters[1].Value = DBNull.Value;
}
if (IsSearchContent)
{
strSql.Append(" and Content like '%'+@Content+'%'");
parameters[2].Value = Content;
}
else
{
parameters[2].Value = DBNull.Value;
}
if (Type.HasValue)
{
strSql.Append(" and Type=@Type");
parameters[3].Value = Type;
}
else
{
parameters[3].Value = DBNull.Value;
}
if (IsSearchAuthor)
{
strSql.Append(" and Author like '%'+@Author+'%'");
parameters[4].Value = Author;
}
else
{
parameters[4].Value = DBNull.Value;
}
if (StartTime.HasValue)
{
if (EndTime.HasValue)
{
strSql.Append(" and createdTime > @StartTime");
strSql.Append(" and createdTime < @EndTime");
parameters[5].Value = StartTime.Value;
parameters[6].Value = EndTime.Value;
}
else
{
parameters[5].Value = DBNull.Value;
parameters[6].Value = DBNull.Value;
}
}
else
{
parameters[5].Value = DBNull.Value;
parameters[6].Value = DBNull.Value;
}
string pageSql = strSql.ToString();
if (pageInfo != null)
{
if (pageInfo.IsPage)
{
SqlHelper.SqlHelper.getCountInfo(pageSql, pageInfo, parameters);
pageSql = SqlHelper.SqlHelper.PreparePageCommand(pageSql, pageInfo, parameters);
}
else
{
pageSql = SqlHelper.SqlHelper.AppendSortString(pageSql, pageInfo);
}
}
return(SqlHelper.SqlHelper.ExecuteDataTable(pageSql, parameters));
}
public T[] SearchList <T>(Guid?ID, bool IsSearchTitle, string Title, bool IsSearchContent, string Content, int?Type, bool IsSearchAuthor, string Author, DateTime?StartTime, DateTime?EndTime, Common.Info.PageInfo pageInfo) where T : Model.News, new()
{
StringBuilder strSql = new StringBuilder();
var parameters = new List <SqlParameter>();
strSql.Append("select [NewsID],[Title],[Content],[Type],[Author],[CreateTime],[ViewNum],[Editor],[EditTime],[Attachment] from News where 1=1");
if (ID.HasValue)
{
strSql.Append(" and NewsID=@NewsID");
var para = new SqlParameter("@NewsID", SqlDbType.UniqueIdentifier, 16);
para.Value = ID;
parameters.Add(para);
}
if (IsSearchTitle)
{
if (string.IsNullOrWhiteSpace(Title))
{
strSql.Append(" and [Title] is null ");
}
else
{
strSql.Append(" and Title like '%' + @Title + '%'");
var para = new SqlParameter("@Title", SqlDbType.NVarChar, 100);
para.Value = Title;
parameters.Add(para);
}
}
if (IsSearchContent)
{
if (string.IsNullOrWhiteSpace(Content))
{
strSql.Append(" and [Content] is null ");
}
else
{
strSql.Append(" and Content like '%'+@Content+'%'");
var para = new SqlParameter("@Content", SqlDbType.NText);
para.Value = Content;
parameters.Add(para);
}
}
if (IsSearchAuthor)
{
if (string.IsNullOrWhiteSpace(Author))
{
strSql.Append(" and [Author] is null ");
}
else
{
strSql.Append(" and Author like '%'+@Author+'%'");
var para = new SqlParameter("@Author", SqlDbType.NVarChar);
para.Value = Author;
parameters.Add(para);
}
}
if (StartTime.HasValue)
{
if (EndTime.HasValue)
{
strSql.Append(" and CreateTime > @StartTime");
strSql.Append(" and CreateTime < @EndTime");
var para = new SqlParameter("@StartTime", SqlDbType.Date);
para.Value = StartTime;
parameters.Add(para);
var para1 = new SqlParameter("@EndTime", SqlDbType.Date);
para1.Value = EndTime;
parameters.Add(para1);
}
}
var paraarry = parameters.ToArray();
string pageSql = SqlHelper.SqlHelper.DoPageInfo(strSql, paraarry, pageInfo);
return(DateTableToArray <T>(SqlHelper.SqlHelper.ExecuteDataTable(pageSql, paraarry)));
}
public static DataTable Search(Guid?ID = null, bool IsSearchTitle = false, string Title = null, bool IsSearchContent = false, string Content = null, int?Type = null, bool IsSearchAuthor = false, string Author = null, DateTime?StartTime = null, DateTime?EndTime = null, Common.Info.PageInfo pageInfo = null)
{
return(dal.Search(ID, IsSearchTitle, Title, IsSearchContent, Content, Type, IsSearchAuthor, Author, StartTime, EndTime, pageInfo));
}
public T[] SearchList <T>(Guid?Id, bool IsSearchCompany, string Company, bool IsSearchNickName, string NickName, bool IsSearchIdcard, string Idcard, bool IsSearchRoles, string Roles, bool IsSearchGender, string Gender, int?StartTime, int?EndTime, DateTime?CreateTime, Common.Info.PageInfo pageInfo) where T : Model.EduUser, new()
{
var strSql = new StringBuilder();
var parameters = new List <SqlParameter>();
strSql.Append("select [ID],[nickname],[idcard],[company],[roles],[gender],[createdTime],[CreateTime] FROM EduUser where 1=1 ");
if (Id.HasValue)
{
strSql.Append(" and [ID] = @ID ");
var para = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16);
para.Value = Id;
parameters.Add(para);
}
if (IsSearchCompany)
{
if (string.IsNullOrWhiteSpace(Company))
{
strSql.Append(" and [company] is null ");
}
else
{
strSql.Append(" and [company] like '%'+@Company+'%' ");
var para = new SqlParameter("@Company", SqlDbType.NVarChar);
para.Value = Company;
parameters.Add(para);
}
}
if (IsSearchNickName)
{
if (string.IsNullOrWhiteSpace(NickName))
{
strSql.Append(" and [nickname] is null ");
}
else
{
strSql.Append(" and [nickname] like '%'+@NickName+'%' ");
var para = new SqlParameter("@NickName", SqlDbType.NVarChar);
para.Value = NickName;
parameters.Add(para);
}
}
if (IsSearchIdcard)
{
if (string.IsNullOrWhiteSpace(Idcard))
{
strSql.Append(" and [idcard] is null ");
}
else
{
strSql.Append(" and [idcard] like '%'+@Idcard+'%' ");
var para = new SqlParameter("@Idcard", SqlDbType.NVarChar);
para.Value = Idcard;
parameters.Add(para);
}
}
if (IsSearchRoles)
{
if (string.IsNullOrWhiteSpace(Roles) || Roles.Equals("null", StringComparison.CurrentCultureIgnoreCase))
{
strSql.Append(" and [roles] is null ");
}
else
{
strSql.Append(" and [roles] = @Roles ");
var para = new SqlParameter("@Roles", SqlDbType.NVarChar);
para.Value = Roles;
parameters.Add(para);
}
}
if (IsSearchGender)
{
if (string.IsNullOrWhiteSpace(Gender))
{
strSql.Append(" and [gender] is null ");
}
else
{
strSql.Append(" and [gender] =@Gender ");
var para = new SqlParameter("@Gender", SqlDbType.NVarChar);
para.Value = Gender;
parameters.Add(para);
}
}
if (StartTime.HasValue)
{
if (EndTime.HasValue)
{
strSql.Append(" and [createdTime]> @StartTime ");
strSql.Append(" and [createdTime]< @EndTime ");
var para = new SqlParameter("@StartTime", SqlDbType.Int, 10);
para.Value = StartTime;
var para1 = new SqlParameter("@EndTime", SqlDbType.Int, 10);
para1.Value = EndTime;
parameters.Add(para);
parameters.Add(para1);
}
}
if (CreateTime.HasValue)
{
strSql.Append(" and [CreateTime] = @CreateTime ");
var para = new SqlParameter("@CreateTime", SqlDbType.DateTime);
para.Value = CreateTime;
parameters.Add(para);
}
var paraarray = parameters.ToArray();
string pageSql = NetSchool.DAL.SqlHelper.SqlHelper.DoPageInfo(strSql, paraarray, pageInfo);
var resulttable = NetSchool.DAL.SqlHelper.SqlHelper.ExecuteDataTable(pageSql, paraarray);
return(DataTableToArray <T>(resulttable));
}
public static T[] SearchList <T>(Guid?ID = null, bool IsSearchTitle = false, string Title = null, bool IsSearchContent = false, string Content = null, int?Type = null, bool IsSearchAuthor = false, string Author = null, DateTime?StartTime = null, DateTime?EndTime = null, Common.Info.PageInfo pageInfo = null) where T : Model.Notice, new()
{
return(dal.SearchList <T>(ID, IsSearchTitle, Title, IsSearchContent, Content, Type, IsSearchAuthor, Author, StartTime, EndTime, pageInfo));
}
public static DataTable Search(bool IsSearchUserName = false, string UserName = null, bool IsSearchRealName = false, string RealName = null, bool IsSearchTelephone = false, string Telephone = null, bool IsSearchEmail = false, string Email = null, bool IsSearchPermission = false, string Permission = null, bool IsSearchPassword = false, string Password = null, Common.Info.PageInfo pageInfo = null)
{
return(dal.Search(IsSearchUserName, UserName, IsSearchRealName, RealName, IsSearchTelephone, Telephone, IsSearchEmail, Email, IsSearchPermission, Permission, IsSearchPassword, Password, pageInfo));
}
public DataTable Search(bool IsSearchUserName, string UserName, bool IsSearchRealName, string RealName, bool IsSearchTelephone, string Telephone, bool IsSearchEmail, string Email, bool IsSearchPermission, string Permission, bool IsSearchPassword, string Password, Common.Info.PageInfo pageInfo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from People ");
strSql.Append(" where 1=1");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 20),
new SqlParameter("@RealName", SqlDbType.NVarChar, 20),
new SqlParameter("@Telephone", SqlDbType.NVarChar),
new SqlParameter("@Email", SqlDbType.NVarChar, 50),
new SqlParameter("@Permission", SqlDbType.NVarChar, 10),
new SqlParameter("@Password", SqlDbType.NVarChar, 100)
};
if (IsSearchUserName)
{
strSql.Append(" and UserName = @UserName");
parameters[0].Value = UserName;
}
else
{
parameters[0].Value = DBNull.Value;
}
if (IsSearchRealName)
{
strSql.Append(" and RealName like '%'+ @RealName+'%'");
parameters[1].Value = RealName;
}
else
{
parameters[1].Value = DBNull.Value;
}
if (IsSearchTelephone)
{
strSql.Append(" and Telephone like '%'+@Telephone+'%'");
parameters[2].Value = Telephone;
}
else
{
parameters[2].Value = DBNull.Value;
}
if (IsSearchEmail)
{
strSql.Append(" and Email like '%'+@Email+'%'");
parameters[3].Value = Email;
}
else
{
parameters[3].Value = DBNull.Value;
}
if (IsSearchPermission)
{
strSql.Append(" and Permission = @Permission");
parameters[4].Value = Permission;
}
else
{
parameters[4].Value = DBNull.Value;
}
if (IsSearchPassword)
{
strSql.Append(" and Password = @Password");
parameters[5].Value = Password;
}
else
{
parameters[5].Value = DBNull.Value;
}
string pageSql = strSql.ToString();
if (pageInfo != null)
{
if (pageInfo.IsPage)
{
SqlHelper.SqlHelper.getCountInfo(pageSql, pageInfo, parameters);
pageSql = SqlHelper.SqlHelper.PreparePageCommand(pageSql, pageInfo, parameters);
}
else
{
pageSql = SqlHelper.SqlHelper.AppendSortString(pageSql, pageInfo);
}
}
return(SqlHelper.SqlHelper.ExecuteDataTable(pageSql, parameters));
}
