/// <summary> /// 根据条件获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="parameters">参数</param> /// <returns>数据表</returns> public DataTable GetDataTableByValues(UserInfo userInfo, List <KeyValuePair <string, object> > parameters) { DataTable dataTable = new DataTable(LinkManTable.TableName); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 根据条件获取数据 LinkManManager manager = new LinkManManager(dbProvider, userInfo); dataTable = manager.GetDT(parameters); dataTable.TableName = LinkManTable.TableName; } catch (Exception ex) { CiExceptionManager.LogException(dbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } return(dataTable); }
/// <summary> /// 批量删除数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int BatchDelete(UserInfo userInfo, string[] ids) { int returnValue = 0; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "批量删除数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 开始事务 dbProvider.BeginTransaction(); LinkManManager manager = new LinkManManager(dbProvider, userInfo); returnValue = manager.Delete(ids); // 提交事务 dbProvider.CommitTransaction(); } catch (Exception ex) { // 回滚事务 dbProvider.RollbackTransaction(); CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 批量存储实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entites">实体列表</param> /// <returns>影响行数</returns> public int BatchSave(UserInfo userInfo, List <CUSTOMERCHANCEEntity> entites) { int returnValue = 0; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "批量存储实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); // returnValue = manager.BatchSave(entites); foreach (var entity in entites) { returnValue += manager.Update(entity); } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 更新实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>影响行数</returns> public int Update(UserInfo userInfo, CUSTOMERCHANCEEntity entity, out string statusCode, out string statusMessage) { int returnValue = 0; statusCode = string.Empty; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "更新实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); returnValue = manager.UpdateEntity(entity); // returnValue = manager.Update(entity, out statusCode); statusMessage = manager.GetStateMessage(statusCode); } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 发送密码给指定的邮箱 /// </summary> /// <param name="userEntity">用户实体</param> /// <returns>成功发送邮件</returns> private static bool SendPassword(PiUserEntity userEntity) { bool returnValue = false; IDbProvider dbProvider = new SqlProvider(RDIFrameworkDbConection); UserInfo userInfo = null; try { string password = RandomHelper.GetRandom(100000, 999999).ToString(); using (var mailMessage = new System.Net.Mail.MailMessage()) { // 接收人邮箱地址 mailMessage.To.Add(new System.Net.Mail.MailAddress(userEntity.Email)); mailMessage.Body = GetSendPasswordBody(userEntity, password); mailMessage.From = new System.Net.Mail.MailAddress("*****@*****.**", ".NET快速开发、整合框架"); mailMessage.BodyEncoding = Encoding.GetEncoding("GB2312"); mailMessage.Subject = ".NET快速开发、整合框架 新密码。"; mailMessage.IsBodyHtml = true; var smtpclient = new System.Net.Mail.SmtpClient("SMTP.126.COM", 25); smtpclient.Credentials = new System.Net.NetworkCredential("*****@*****.**", "abcd"); smtpclient.EnableSsl = false; smtpclient.Send(mailMessage); returnValue = true; // 修改用户的密码 // 用户数据库进行差找用户操作 dbProvider.Open(); PiUserManager userManager = new PiUserManager(dbProvider); userInfo = userManager.ConvertToUserInfo(userEntity); userManager.SetParameter(userInfo); // 密码进行加密,读取网站的密钥 password = userManager.EncryptUserPassword(password); userManager.SetPassword(userEntity.Id.ToString(), password); } } catch (System.Exception exception) { // 若有异常,应该需要保存异常信息 CiExceptionManager.LogException(dbProvider, userInfo, exception); returnValue = false; } finally { dbProvider.Close(); } return(returnValue); }
/// <summary> /// 新增实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状态消息</param> /// <returns>主鍵</returns> public string Add(UserInfo userInfo, CustomerEntity entity, out string statusCode, out string statusMessage) { string returnValue = string.Empty; statusCode = string.Empty; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "新增实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CustomerManager manager = new CustomerManager(dbProvider, userInfo); returnValue = manager.Add(entity, out statusCode); statusMessage = manager.GetStateMessage(statusCode); } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 分页查询 /// </summary> /// <param name="userInfo">用户</param> /// <param name="searchValue">查询关键字</param> /// <param name="recordCount">记录数</param> /// <param name="pageIndex">当前页</param> /// <param name="pageSize">每页显示记录条数</param> /// <param name="sortExpression">排序字段</param> /// <returns>数据表</returns> public DataTable GetDTByPage(UserInfo userInfo, string searchValue, out int recordCount, int pageIndex = 1, int pageSize = 20, string sortExpression = null) { DataTable dataTable = new DataTable(CUSTOMERCHANCETable.TableName); using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "取得列表", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 取得列表 CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); dataTable = manager.GetDTByPage(out recordCount, pageIndex, pageSize, searchValue, sortExpression); dataTable.TableName = CUSTOMERCHANCETable.TableName; } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(dataTable); }
/// <summary> /// 得到数据表 /// </summary> /// <param name="userInfo">用户</param> /// <returns>数据表</returns> public DataTable GetDataTable(UserInfo userInfo) { DataTable dataTable = new DataTable(CUSTOMERCHANCETable.TableName); using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "取得列表", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 取得列表 CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); dataTable = manager.GetDT(new KeyValuePair <string, object>(CUSTOMERCHANCETable.FieldDELETEMARK, 0), CUSTOMERCHANCETable.FieldSORTCODE); dataTable.TableName = CUSTOMERCHANCETable.TableName; } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(dataTable); }
/// <summary> /// 根据条件获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="names">字段</param> /// <param name="values">值</param> /// <returns>数据表</returns> public DataTable GetDataTableByValues(UserInfo userInfo, List <KeyValuePair <string, object> > parameters) { DataTable dataTable = new DataTable(CUSTOMERCHANCETable.TableName); using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "根据条件获取数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 根据条件获取数据 CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); dataTable = manager.GetDT(parameters); dataTable.TableName = CUSTOMERCHANCETable.TableName; } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(dataTable); }
/// <summary> /// 根据主键数组获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主鍵</param> /// <returns>数据表</returns> public DataTable GetDataTableByIds(UserInfo userInfo, string[] ids) { DataTable dataTable = new DataTable(CUSTOMERCHANCETable.TableName); using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "根据主键数组获取数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); dataTable = manager.GetDT(CUSTOMERCHANCETable.FieldId, ids, CUSTOMERCHANCETable.FieldSORTCODE); dataTable.TableName = CUSTOMERCHANCETable.TableName; } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(dataTable); }
/// <summary> /// 批量设置删除标志 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int SetDeleted(UserInfo userInfo, string[] ids) { int returnValue = 0; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "批量设置删除标志", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); returnValue = manager.SetDeleted(ids); } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 取得实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主鍵</param> /// <returns>实体</returns> public CUSTOMERCHANCEEntity GetEntity(UserInfo userInfo, string id) { CUSTOMERCHANCEEntity entity = null; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "取得实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); entity = manager.GetEntity(id); } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(entity); }
/// <summary> /// 新增实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <returns>主鍵</returns> public string Add(UserInfo userInfo, IncomingCallEntity entity) { string returnValue = string.Empty; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "新增实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); IncomingCallManager manager = new IncomingCallManager(dbProvider, userInfo); returnValue = manager.AddEntity(entity); } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 删除数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主鍵</param> /// <returns>数据表</returns> public int Delete(UserInfo userInfo, string id) { int returnValue = 0; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "删除数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); IncomingCallManager manager = new IncomingCallManager(dbProvider, userInfo); returnValue = manager.Delete(id); } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 根据条件更新数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="whereParameters">条件键值对</param> /// <param name="parameters">键值对</param> /// <returns>受影响的行数</returns> public int UpdateByValues(UserInfo userInfo, List <KeyValuePair <string, object> > whereParameters, List <KeyValuePair <string, object> > parameters) { int returnValue = 0; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "根据条件更新数据", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); // 根据条件获取数据 CustomerManager manager = new CustomerManager(dbProvider, userInfo); returnValue = manager.SetProperty(manager.GetIds(parameters), whereParameters); } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 用户注册之后,给用户发的激活账户的邮件 /// </summary> /// <param name="userEntity">用户实体</param> /// <returns>成功发送邮件</returns> public static bool AfterUserRegister(PiUserEntity userEntity) { bool returnValue = false; IDbProvider dbProvider = new SqlProvider(RDIFrameworkDbConection); UserInfo userInfo = null; try { using (var mailMessage = new System.Net.Mail.MailMessage()) { // 接收人邮箱地址 mailMessage.To.Add(new System.Net.Mail.MailAddress(userEntity.Email)); mailMessage.Body = GetAfterUserRegisterBody(userEntity); mailMessage.From = new System.Net.Mail.MailAddress("*****@*****.**", "新密码"); mailMessage.BodyEncoding = Encoding.GetEncoding("GB2312"); mailMessage.Subject = "新密码。"; mailMessage.IsBodyHtml = true; var smtpclient = new System.Net.Mail.SmtpClient(SystemInfo.ErrorReportMailServer) { Credentials = new System.Net.NetworkCredential(SystemInfo.ErrorReportMailUserName, SystemInfo.ErrorReportMailPassword), EnableSsl = false }; smtpclient.Send(mailMessage); returnValue = true; } } catch (System.Exception exception) { // 若有异常,应该需要保存异常信息 CiExceptionManager.LogException(dbProvider, userInfo, exception); returnValue = false; } finally { dbProvider.Close(); } return(returnValue); }
/// <summary> /// 记录异常信息 /// </summary> /// <param name="exception">异常信息实体</param> public void LogException(Exception exception) { CiExceptionManager.LogException(this.RDIFrameworkDbProvider, this.UserInfo, exception); }