/// <summary> /// 查询所有记录 /// </summary> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="order">排序字段,不加“order by”</param> /// <param name="fieldList">设置需要返回的字段</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回实体记录集</returns> public static IList <EmailList> SelectListByAll(string dbkey = "", Where where = null, string order = "", string fieldList = "") { string cacheNameKey = "TH.Mailer.EmailListCache_SelectListByAll_{0}_{1}_{2}".FormatWith(where, order, fieldList); return(Cache2.Get <IList <EmailList> >(cacheNameKey, cacheSeconds, () => { IList <EmailList> list = new List <EmailList>(); if (fieldList.IsNullEmpty()) { list = new SQL().Database(dbkey).From(EmailList._) .Select(EmailList._EmailAddress) .Select(EmailList._NickName) .Select(EmailList._LastSendStatus) .Select(EmailList._LastSendError) .Select(EmailList._LastSendTime) .Select(EmailList._LastSendSmtp) .Select(EmailList._SendCount) .Select(EmailList._CreateTime) .Select(EmailList._ex0) .Select(EmailList._ex1) .Select(EmailList._ex2) .Select(EmailList._ex3) .Select(EmailList._ex4) .Select(EmailList._ex5) .Select(EmailList._ex6) .Select(EmailList._ex7) .Select(EmailList._ex8) .Where(where).Order(order).ToList <EmailList>(); } else { list = new SQL().Database(dbkey).From(EmailList._).Select(fieldList).Where(where).Order(order).ToList <EmailList>(); } return list; })); }
/// <summary> /// 查询所有记录 /// </summary> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="order">排序字段,不加“order by”</param> /// <param name="fieldList">设置需要返回的字段</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回实体记录集</returns> public static IList <SmtpList> SelectListByAll(string dbkey = "", Where where = null, string order = "", string fieldList = "") { string cacheNameKey = "TH.Mailer.SmtpListCache_SelectListByAll_{0}_{1}_{2}".FormatWith(where, order, fieldList); return(Cache2.Get <IList <SmtpList> >(cacheNameKey, cacheSeconds, () => { IList <SmtpList> list = new List <SmtpList>(); if (fieldList.IsNullEmpty()) { list = new SQL().Database(dbkey).From(SmtpList._) .Select(SmtpList._SmtpServer) .Select(SmtpList._SmtpPort) .Select(SmtpList._UserName) .Select(SmtpList._SPassword) .Select(SmtpList._SSL) .Select(SmtpList._Status) .Select(SmtpList._Sends) .Select(SmtpList._SendFails) .Select(SmtpList._CreateTime) .Where(where).Order(order).ToList <SmtpList>(); } else { list = new SQL().Database(dbkey).From(SmtpList._).Select(fieldList).Where(where).Order(order).ToList <SmtpList>(); } return list; })); }
/// <summary> /// 邮件模版查询所有记录 /// </summary> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="order">排序字段,不加“order by”</param> /// <param name="fieldList">设置需要返回的字段</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回实体记录集</returns> public static IList <HtmlTemplate> SelectListByAll(string dbkey = "", Where where = null, string order = "", string fieldList = "") { string cacheNameKey = "TH.Mailer.HtmlTemplateCache_SelectListByAll_{0}_{1}_{2}".FormatWith(where, order, fieldList); return(Cache2.Get <IList <HtmlTemplate> >(cacheNameKey, cacheSeconds, () => { IList <HtmlTemplate> list = new List <HtmlTemplate>(); if (fieldList.IsNullEmpty()) { list = new SQL().Database(dbkey).From(HtmlTemplate._) .Select(HtmlTemplate._TemplateID) .Select(HtmlTemplate._Subject) .Select(HtmlTemplate._Body) .Select(HtmlTemplate._ShowName) .Select(HtmlTemplate._IsHTML) .Select(HtmlTemplate._Status) .Select(HtmlTemplate._CreateTime) .Where(where).Order(order).ToList <HtmlTemplate>(); } else { list = new SQL().Database(dbkey).From(HtmlTemplate._).Select(fieldList).Where(where).Order(order).ToList <HtmlTemplate>(); } return list; })); }
/// <summary> /// 按主键查询,返回数据的实体类 /// </summary> /// <param name="emailAddress">发送的Email</param> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回单条记录的实体类</returns> public static EmailList SelectByID(string emailAddress, string dbkey = "", Where where = null) { string cacheNameKey = "TH.Mailer.EmailListCache_SelectByID_{0}".FormatWith(emailAddress + "_" + "_" + where); return(Cache2.Get <EmailList>(cacheNameKey, cacheSeconds, () => { EmailList obj = new SQL().Database(dbkey).From(EmailList._) .Select(EmailList._EmailAddress) .Select(EmailList._NickName) .Select(EmailList._LastSendStatus) .Select(EmailList._LastSendError) .Select(EmailList._LastSendTime) .Select(EmailList._LastSendSmtp) .Select(EmailList._SendCount) .Select(EmailList._CreateTime) .Select(EmailList._ex0) .Select(EmailList._ex1) .Select(EmailList._ex2) .Select(EmailList._ex3) .Select(EmailList._ex4) .Select(EmailList._ex5) .Select(EmailList._ex6) .Select(EmailList._ex7) .Select(EmailList._ex8) .Where(new Where() .AndP(EmailList._EmailAddress, emailAddress, Operator.Equal) ).Where(where).ToEntity <EmailList>(); return obj; })); }
/// <summary> /// 天翼连接设置按主键查询,返回数据的实体类 /// </summary> /// <param name="tianYiID">天翼连接设置编号</param> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回单条记录的实体类</returns> public static TianYiSetting SelectByID(int tianYiID, string dbkey = "", Where where = null) { string cacheNameKey = "TH.Mailer.TianYiSettingCache_SelectByID_{0}".FormatWith(tianYiID + "_" + "_" + where); return(Cache2.Get <TianYiSetting>(cacheNameKey, cacheSeconds, () => { TianYiSetting obj = new SQL().Database(dbkey).From(TianYiSetting._) .Select(TianYiSetting._TianYiID) .Select(TianYiSetting._TianYiExePath) .Where(new Where() .AndP(TianYiSetting._TianYiID, tianYiID, Operator.Equal) ).Where(where).ToEntity <TianYiSetting>(); return obj; })); }
/// <summary> /// 拨号连接按主键查询,返回数据的实体类 /// </summary> /// <param name="modelID">拨号连接编号</param> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回单条记录的实体类</returns> public static ModelSetting SelectByID(int modelID, string dbkey = "", Where where = null) { string cacheNameKey = "TH.Mailer.ModelSettingCache_SelectByID_{0}".FormatWith(modelID + "_" + "_" + where); return(Cache2.Get <ModelSetting>(cacheNameKey, cacheSeconds, () => { ModelSetting obj = new SQL().Database(dbkey).From(ModelSetting._) .Select(ModelSetting._ModelID) .Select(ModelSetting._ModelName) .Select(ModelSetting._UserName) .Select(ModelSetting._MPassword) .Where(new Where() .AndP(ModelSetting._ModelID, modelID, Operator.Equal) ).Where(where).ToEntity <ModelSetting>(); return obj; })); }
/// <summary> /// 查询数据,带分页 /// </summary> /// <param name="pageIndex">当前第几页,从1开始</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalRecords">返回总记录数</param> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="order">排序字段,不加“order by”</param> /// <param name="fieldList">设置需要返回的字段</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <param name="pageEnum">使用哪种分页方式(not_in、max_top、top_top、row_number、mysql、oracle、sqlite)</param> /// <returns>返回实体记录集</returns> public static IList <SmtpList> SelectPageList(int pageIndex, int pageSize, out long totalRecords, string dbkey = "", Where where = null, string order = "", string fieldList = "", PagerSQLEnum pageEnum = PagerSQLEnum.sqlite) { string cacheNameKey = "TH.Mailer.SmtpListCache_SelectPageList_{0}_{1}_{2}_{3}_{4}".FormatWith(pageIndex, pageSize, where, order, fieldList); string cacheRecordsKey = "TH.Mailer.SmtpListCache_RecordsSelectPageList_{0}_{1}_{2}_{3}_{4}".FormatWith(pageIndex, pageSize, where, order, fieldList); IList <SmtpList> list = (IList <SmtpList>)Cache2.Get(cacheNameKey); if (!list.IsNull()) { totalRecords = (int)Cache2.Get(cacheRecordsKey); return(list); } using (PagerSQLHelper s = new PagerSQLHelper(pageEnum)) { list = s.GetSQL(pageIndex, pageSize, SmtpList._, SmtpList._SmtpServer, fieldList.IfNullOrEmpty("[SmtpServer],[SmtpPort],[UserName],[SPassword],[SSL],[Status],[Sends],[SendFails],[CreateTime],"), where, "", order).ToList <SmtpList>(out totalRecords, dbkey); } Cache2.Insert(cacheNameKey, list, cacheSeconds); Cache2.Insert(cacheRecordsKey, totalRecords, cacheSeconds); return(list); }
/// <summary> /// 查询数据,带分页 /// </summary> /// <param name="pageIndex">当前第几页,从1开始</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalRecords">返回总记录数</param> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="order">排序字段,不加“order by”</param> /// <param name="fieldList">设置需要返回的字段</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <param name="pageEnum">使用哪种分页方式(not_in、max_top、top_top、row_number、mysql、oracle、sqlite)</param> /// <returns>返回实体记录集</returns> public static IList <IpHistory> SelectPageList(int pageIndex, int pageSize, out long totalRecords, string dbkey = "", Where where = null, string order = "", string fieldList = "", PagerSQLEnum pageEnum = PagerSQLEnum.sqlite) { string cacheNameKey = "TH.Mailer.IpHistoryCache_SelectPageList_{0}_{1}_{2}_{3}_{4}".FormatWith(pageIndex, pageSize, where, order, fieldList); string cacheRecordsKey = "TH.Mailer.IpHistoryCache_RecordsSelectPageList_{0}_{1}_{2}_{3}_{4}".FormatWith(pageIndex, pageSize, where, order, fieldList); IList <IpHistory> list = (IList <IpHistory>)Cache2.Get(cacheNameKey); if (!list.IsNull()) { totalRecords = (int)Cache2.Get(cacheRecordsKey); return(list); } using (PagerSQLHelper s = new PagerSQLHelper(pageEnum)) { list = s.GetSQL(pageIndex, pageSize, IpHistory._, IpHistory._IP, fieldList.IfNullOrEmpty("[IP],[CreateTime],"), where, "", order).ToList <IpHistory>(out totalRecords, dbkey); } Cache2.Insert(cacheNameKey, list, cacheSeconds); Cache2.Insert(cacheRecordsKey, totalRecords, cacheSeconds); return(list); }
/// <summary> /// 查询数据,带分页 /// </summary> /// <param name="pageIndex">当前第几页,从1开始</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalRecords">返回总记录数</param> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="order">排序字段,不加“order by”</param> /// <param name="fieldList">设置需要返回的字段</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <param name="pageEnum">使用哪种分页方式(not_in、max_top、top_top、row_number、mysql、oracle、sqlite)</param> /// <returns>返回实体记录集</returns> public static IList <EmailList> SelectPageList(int pageIndex, int pageSize, out long totalRecords, string dbkey = "", Where where = null, string order = "", string fieldList = "", PagerSQLEnum pageEnum = PagerSQLEnum.sqlite) { string cacheNameKey = "TH.Mailer.EmailListCache_SelectPageList_{0}_{1}_{2}_{3}_{4}".FormatWith(pageIndex, pageSize, where, order, fieldList); string cacheRecordsKey = "TH.Mailer.EmailListCache_RecordsSelectPageList_{0}_{1}_{2}_{3}_{4}".FormatWith(pageIndex, pageSize, where, order, fieldList); IList <EmailList> list = (IList <EmailList>)Cache2.Get(cacheNameKey); if (!list.IsNull()) { totalRecords = (int)Cache2.Get(cacheRecordsKey); return(list); } using (PagerSQLHelper s = new PagerSQLHelper(pageEnum)) { list = s.GetSQL(pageIndex, pageSize, EmailList._, EmailList._EmailAddress, fieldList.IfNullOrEmpty("[EmailAddress],[NickName],[LastSendStatus],[LastSendError],[LastSendTime],[LastSendSmtp],[SendCount],[CreateTime],[ex0],[ex1],[ex2],[ex3],[ex4],[ex5],[ex6],[ex7],[ex8],"), where, "", order).ToList <EmailList>(out totalRecords, dbkey); } Cache2.Insert(cacheNameKey, list, cacheSeconds); Cache2.Insert(cacheRecordsKey, totalRecords, cacheSeconds); return(list); }
/// <summary> /// 路由按主键查询,返回数据的实体类 /// </summary> /// <param name="routeID">路由编号</param> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回单条记录的实体类</returns> public static RouteSetting SelectByID(int routeID, string dbkey = "", Where where = null) { string cacheNameKey = "TH.Mailer.RouteSettingCache_SelectByID_{0}".FormatWith(routeID + "_" + "_" + where); return(Cache2.Get <RouteSetting>(cacheNameKey, cacheSeconds, () => { RouteSetting obj = new SQL().Database(dbkey).From(RouteSetting._) .Select(RouteSetting._RouteID) .Select(RouteSetting._RouteIP) .Select(RouteSetting._UserName) .Select(RouteSetting._RPassword) .Select(RouteSetting._RouteConnect) .Select(RouteSetting._RouteDisConnect) .Select(RouteSetting._RouteMethod) .Where(new Where() .AndP(RouteSetting._RouteID, routeID, Operator.Equal) ).Where(where).ToEntity <RouteSetting>(); return obj; })); }
/// <summary> /// 查询所有记录 /// </summary> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="order">排序字段,不加“order by”</param> /// <param name="fieldList">设置需要返回的字段</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回实体记录集</returns> public static IList <IpHistory> SelectListByAll(string dbkey = "", Where where = null, string order = "", string fieldList = "") { string cacheNameKey = "TH.Mailer.IpHistoryCache_SelectListByAll_{0}_{1}_{2}".FormatWith(where, order, fieldList); return(Cache2.Get <IList <IpHistory> >(cacheNameKey, cacheSeconds, () => { IList <IpHistory> list = new List <IpHistory>(); if (fieldList.IsNullEmpty()) { list = new SQL().Database(dbkey).From(IpHistory._) .Select(IpHistory._IP) .Select(IpHistory._CreateTime) .Where(where).Order(order).ToList <IpHistory>(); } else { list = new SQL().Database(dbkey).From(IpHistory._).Select(fieldList).Where(where).Order(order).ToList <IpHistory>(); } return list; })); }
/// <summary> /// 设置按主键查询,返回数据的实体类 /// </summary> /// <param name="settingID">设置编号</param> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回单条记录的实体类</returns> public static SendSetting SelectByID(int settingID, string dbkey = "", Where where = null) { string cacheNameKey = "TH.Mailer.SendSettingCache_SelectByID_{0}".FormatWith(settingID + "_" + "_" + where); return(Cache2.Get <SendSetting>(cacheNameKey, cacheSeconds, () => { SendSetting obj = new SQL().Database(dbkey).From(SendSetting._) .Select(SendSetting._SettingID) .Select(SendSetting._TemplateID) .Select(SendSetting._ConnectType) .Select(SendSetting._SendInterval) .Select(SendSetting._IPInterval) .Select(SendSetting._SmtpInterval) .Select(SendSetting._DeleteInterval) .Select(SendSetting._MaxRetryCount) .Select(SendSetting._SendRetryCount) .Select(SendSetting._Status) .Where(new Where() .AndP(SendSetting._SettingID, settingID, Operator.Equal) ).Where(where).ToEntity <SendSetting>(); return obj; })); }
/// <summary> /// 按主键查询,返回数据的实体类 /// </summary> /// <param name="smtpServer">SMTP服务器</param> /// <param name="smtpPort">SMTP端口</param> /// <param name="userName">登录用户名</param> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回单条记录的实体类</returns> public static SmtpList SelectByID(string smtpServer, int smtpPort, string userName, string dbkey = "", Where where = null) { string cacheNameKey = "TH.Mailer.SmtpListCache_SelectByID_{0}".FormatWith(smtpServer + "_" + smtpPort + "_" + userName + "_" + "_" + where); return(Cache2.Get <SmtpList>(cacheNameKey, cacheSeconds, () => { SmtpList obj = new SQL().Database(dbkey).From(SmtpList._) .Select(SmtpList._SmtpServer) .Select(SmtpList._SmtpPort) .Select(SmtpList._UserName) .Select(SmtpList._SPassword) .Select(SmtpList._SSL) .Select(SmtpList._Status) .Select(SmtpList._Sends) .Select(SmtpList._SendFails) .Select(SmtpList._CreateTime) .Where(new Where() .AndP(SmtpList._SmtpServer, smtpServer, Operator.Equal) .AndP(SmtpList._SmtpPort, smtpPort, Operator.Equal) .AndP(SmtpList._UserName, userName, Operator.Equal) ).Where(where).ToEntity <SmtpList>(); return obj; })); }
/// <summary> /// 获取IP配置查询所有记录 /// </summary> /// <param name="where">附加条件,统一的前面要加链接符(and、or等等)</param> /// <param name="order">排序字段,不加“order by”</param> /// <param name="fieldList">设置需要返回的字段</param> /// <param name="dbkey">存在数据库连接池中的连接key,为空时随机取连接key</param> /// <returns>返回实体记录集</returns> public static IList <IpSetting> SelectListByAll(string dbkey = "", Where where = null, string order = "", string fieldList = "") { string cacheNameKey = "TH.Mailer.IpSettingCache_SelectListByAll_{0}_{1}_{2}".FormatWith(where, order, fieldList); return(Cache2.Get <IList <IpSetting> >(cacheNameKey, cacheSeconds, () => { IList <IpSetting> list = new List <IpSetting>(); if (fieldList.IsNullEmpty()) { list = new SQL().Database(dbkey).From(IpSetting._) .Select(IpSetting._IPCID) .Select(IpSetting._WebName) .Select(IpSetting._IPUrl) .Select(IpSetting._IPRegex) .Select(IpSetting._DataEncode) .Where(where).Order(order).ToList <IpSetting>(); } else { list = new SQL().Database(dbkey).From(IpSetting._).Select(fieldList).Where(where).Order(order).ToList <IpSetting>(); } return list; })); }