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