public int UpdateFile(string id, string fileName, string contents)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseNewsEntity.FieldTitle, fileName);
sqlBuilder.SetValue(BaseNewsEntity.FieldContents, contents);
sqlBuilder.SetValue(BaseNewsEntity.FieldFileSize, contents.Length);
sqlBuilder.SetValue(BaseNewsEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseNewsEntity.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetDBNow(BaseNewsEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseNewsEntity.FieldId, id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="userInfo">操作员</param>
/// <param name="entity">实体</param>
/// <returns>影响行数</returns>
public int UpdateEntity(BaseUserInfo userInfo, BaseContactEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(BaseContactEntity.TableName);
this.SetEntity(sqlBuilder, entity);
if (userInfo != null)
{
sqlBuilder.SetValue(BaseContactEntity.FieldModifiedUserId, userInfo.Id);
sqlBuilder.SetValue(BaseContactEntity.FieldModifiedBy, userInfo.RealName);
}
sqlBuilder.SetDBNow(BaseContactEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseContactEntity.FieldId, entity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 替换流程定义中的用户
/// </summary>
/// <param name="oldUserId">原来的userId</param>
/// <param name="newUserId">新的userId</param>
/// <returns>影响行数</returns>
public int ReplaceUser(string oldUserId, string newUserId)
{
BaseUserManager userManager = new BaseUserManager(this.UserInfo);
BaseUserEntity newUserEntity = userManager.GetObject(newUserId);
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldAuditUserId, newUserEntity.Id);
sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldAuditUserCode, newUserEntity.Code);
sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldAuditUserRealName, newUserEntity.RealName);
sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldAuditDepartmentId, newUserEntity.DepartmentId);
sqlBuilder.SetValue(BaseWorkFlowActivityEntity.FieldAuditDepartmentName, newUserEntity.DepartmentName);
sqlBuilder.SetWhere(BaseWorkFlowActivityEntity.FieldAuditUserId, oldUserId, "OldUserId");
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// (点通过时)当审核通过时
/// </summary>
/// <param name="workFlowCurrentEntity">当前审批流</param>
/// <returns>成功失败</returns>
public virtual bool OnAutoAuditPass(BaseWorkFlowCurrentEntity workFlowCurrentEntity)
{
if (!string.IsNullOrEmpty(workFlowCurrentEntity.ObjectId))
{
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseBusinessLogic.FieldAuditStatus, AuditStatus.AuditPass.ToString());
sqlBuilder.SetDBNow(BaseBusinessLogic.FieldModifiedOn);
sqlBuilder.SetValue(BaseBusinessLogic.FieldModifiedUserId, this.UserInfo.Id);
sqlBuilder.SetValue(BaseBusinessLogic.FieldModifiedBy, this.UserInfo.RealName);
sqlBuilder.SetWhere(BaseBusinessLogic.FieldId, workFlowCurrentEntity.ObjectId);
sqlBuilder.EndUpdate();
}
return(true);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="baseWorkFlowBillTemplateEntity">实体</param>
public int UpdateEntity(BaseWorkFlowBillTemplateEntity baseWorkFlowBillTemplateEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetEntity(sqlBuilder, baseWorkFlowBillTemplateEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseWorkFlowBillTemplateEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseWorkFlowBillTemplateEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseWorkFlowBillTemplateEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseWorkFlowBillTemplateEntity.FieldId, baseWorkFlowBillTemplateEntity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(BaseRoleEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseRoleEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseRoleEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseRoleEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseRoleEntity.FieldId, entity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 当自由工作流开始启动之后需要处理的工作，可以写在这里
/// </summary>
/// <param name="id">主键</param>
/// <returns>影响行数</returns>
public virtual bool AfterAutoStatr(BaseWorkFlowAuditInfo workFlowAuditInfo)
{
if (!string.IsNullOrEmpty(workFlowAuditInfo.ObjectId) && !string.IsNullOrEmpty(this.CurrentTableName))
{
// 这里是回写表的功能实现
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseBusinessLogic.FieldAuditStatus, AuditStatus.StartAudit.ToString());
sqlBuilder.SetDBNow(BaseBusinessLogic.FieldModifiedOn);
sqlBuilder.SetValue(BaseBusinessLogic.FieldModifiedUserId, this.UserInfo.Id);
sqlBuilder.SetValue(BaseBusinessLogic.FieldModifiedBy, this.UserInfo.RealName);
sqlBuilder.SetWhere(BaseBusinessLogic.FieldId, workFlowAuditInfo.ObjectId);
sqlBuilder.EndUpdate();
}
return(true);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="userEntity">实体</param>
public int UpdateEntity(BaseUserEntity userEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
userEntity.QuickQuery = StringUtil.GetPinyin(userEntity.RealName);
this.SetEntity(sqlBuilder, userEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseUserEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseUserEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseUserEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseUserEntity.FieldId, userEntity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 用户角色关系是否有模块权限
/// 2015-12-15 吉日嘎拉 优化参数化
/// </summary>
/// <param name="systemCode">系统编号</param>
/// <param name="roleId">角色主键</param>
/// <param name="permissionCode">权限编号</param>
/// <returns>有角色权限</returns>
public bool CheckPermissionByRole(string systemCode, string roleId, string permissionCode)
{
// 判断当前判断的权限是否存在，否则很容易出现前台设置了权限，后台没此项权限
// 需要自动的能把前台判断过的权限，都记录到后台来
string permissionId = string.Empty;
#if (DEBUG)
if (String.IsNullOrEmpty(permissionId))
{
BaseModuleEntity permissionEntity = new BaseModuleEntity();
permissionEntity.Code = permissionCode;
permissionEntity.FullName = permissionCode;
permissionEntity.IsScope = 0;
permissionEntity.IsPublic = 0;
permissionEntity.IsMenu = 0;
permissionEntity.IsVisible = 1;
permissionEntity.AllowDelete = 1;
permissionEntity.AllowEdit = 1;
permissionEntity.DeletionStateCode = 0;
permissionEntity.Enabled = 1;
// 这里是防止主键重复？
// permissionEntity.ID = BaseBusinessLogic.NewGuid();
BaseModuleManager moduleManager = new Business.BaseModuleManager();
moduleManager.AddObject(permissionEntity);
}
else
{
// 更新最后一次访问日期，设置为当前服务器日期
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetDBNow(BaseModuleEntity.FieldLastCall);
sqlBuilder.SetWhere(BaseModuleEntity.FieldId, permissionId);
sqlBuilder.EndUpdate();
}
#endif
permissionId = BaseModuleManager.GetIdByCodeByCache(systemCode, permissionCode);
// 没有找到相应的权限
if (String.IsNullOrEmpty(permissionId))
{
return(false);
}
string resourceCategory = systemCode + "Role";
return(CheckResourcePermission(systemCode, resourceCategory, roleId, permissionId));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <returns>主键</returns>
public string Add(BaseUserScoreEntity entity)
{
string result = string.Empty;
// 添加子表，用户积分表
result = this.AddObject(entity);
// 更新用户积分
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(BaseUserEntity.TableName);
sqlBuilder.SetFormula(BaseUserEntity.FieldScore, BaseUserEntity.FieldScore + " + " + entity.Score);
sqlBuilder.SetWhere(BaseUserEntity.FieldId, entity.UserId);
sqlBuilder.EndUpdate();
// 发送手机短信提醒
return(result);
}
public int UpdateFile(string id, string fileName, byte[] file)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseFileEntity.FieldFileName, fileName);
if (file != null)
{
sqlBuilder.SetValue(BaseFileEntity.FieldContents, file);
sqlBuilder.SetValue(BaseFileEntity.FieldFileSize, file.Length);
}
sqlBuilder.SetValue(BaseFileEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseFileEntity.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetDBNow(BaseFileEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseFileEntity.FieldId, id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 重置单据
/// （单据发生错误时）紧急情况下实用
/// </summary>
/// <param name="currentId">审批流当前主键</param>
/// <param name="categoryCode">单据分类</param>
/// <param name="auditIdea">批示</param>
/// <returns>影响行数</returns>
public virtual bool OnReset(BaseWorkFlowCurrentEntity workFlowCurrentEntity)
{
// 审核通过后，需要把有效状态修改过来
if (!string.IsNullOrEmpty(workFlowCurrentEntity.ObjectId))
{
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseBusinessLogic.FieldAuditStatus, AuditStatus.Draft.ToString());
sqlBuilder.SetValue(BaseBusinessLogic.FieldEnabled, 1);
sqlBuilder.SetDBNow(BaseBusinessLogic.FieldModifiedOn);
sqlBuilder.SetValue(BaseBusinessLogic.FieldModifiedUserId, this.UserInfo.Id);
sqlBuilder.SetValue(BaseBusinessLogic.FieldModifiedBy, this.UserInfo.RealName);
sqlBuilder.SetWhere(BaseBusinessLogic.FieldId, workFlowCurrentEntity.ObjectId);
sqlBuilder.EndUpdate();
}
// 若还需要有其他处理，就这后面继续处理
return(true);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="parameterEntity">实体</param>
/// <returns>影响行数</returns>
protected int UpdateEntity(BaseParameterEntity parameterEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseParameterEntity.FieldCategoryId, parameterEntity.CategoryId);
sqlBuilder.SetValue(BaseParameterEntity.FieldParameterCode, parameterEntity.ParameterCode);
sqlBuilder.SetValue(BaseParameterEntity.FieldParameterId, parameterEntity.ParameterId);
sqlBuilder.SetValue(BaseParameterEntity.FieldParameterContent, parameterEntity.ParameterContent);
sqlBuilder.SetValue(BaseParameterEntity.FieldWorked, parameterEntity.Worked ? 1 : 0);
sqlBuilder.SetValue(BaseParameterEntity.FieldEnabled, parameterEntity.Enabled ? 1 : 0);
sqlBuilder.SetValue(BaseParameterEntity.FieldDeletionStateCode, parameterEntity.DeletionStateCode);
sqlBuilder.SetValue(BaseParameterEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseParameterEntity.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetDBNow(BaseParameterEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseParameterEntity.FieldId, parameterEntity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 当自由工作流(点通过时)当审核通过时
/// </summary>
/// <param name="workFlowCurrentEntity">当前审批流</param>
/// <returns>成功失败</returns>
public virtual bool OnAutoAuditPass(BaseWorkFlowCurrentEntity workFlowCurrentEntity)
{
if (!string.IsNullOrEmpty(workFlowCurrentEntity.ObjectId))
{
// 这里是回写表的功能实现
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
// 审核流程主键，走哪个审核流程的
// workFlowCurrentEntity.ProcessId;
// 分类编号
// workFlowCurrentEntity.CategoryCode;
// 分类名称
// workFlowCurrentEntity.CategoryFullName;
// 单据主键
// workFlowCurrentEntity.ObjectId;
// 单据名称
// workFlowCurrentEntity.ObjectFullName;
// 当前审核步骤主键
// workFlowCurrentEntity.ActivityId;
// 当前流程编号
// workFlowCurrentEntity.ActivityCode;
// 当前审核步骤名称
// workFlowCurrentEntity.ActivityFullName;
// 当前审核人主键
// workFlowCurrentEntity.AuditUserId;
// 当前审核人姓名
// workFlowCurrentEntity.AuditUserRealName;
// 审核意见
// workFlowCurrentEntity.AuditIdea;
// 送给谁审核主键
// workFlowCurrentEntity.ToUserId;
// 送给谁审核的姓名
// workFlowCurrentEntity.ToUserRealName;
sqlBuilder.SetValue(BaseBusinessLogic.FieldAuditStatus, AuditStatus.AuditPass.ToString());
sqlBuilder.SetDBNow(BaseBusinessLogic.FieldModifiedOn);
sqlBuilder.SetValue(BaseBusinessLogic.FieldModifiedUserId, this.UserInfo.Id);
sqlBuilder.SetValue(BaseBusinessLogic.FieldModifiedBy, this.UserInfo.RealName);
sqlBuilder.SetWhere(BaseBusinessLogic.FieldId, workFlowCurrentEntity.ObjectId);
sqlBuilder.EndUpdate();
}
return(true);
}
/// <summary>
/// 离开时的日志记录
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="logId">日志主键</param>
public void WriteExit(BaseUserInfo userInfo, string logId)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
if (!string.IsNullOrEmpty(logId))
{
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginUpdate(BaseLogEntity.TableName);
sqlBuilder.SetDBNow(BaseLogEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseLogEntity.FieldId, logId);
sqlBuilder.EndUpdate();
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
}
/// <summary>
/// (点通过时)当审核通过时
/// </summary>
/// <param name="workFlowCurrentEntity">当前审批流</param>
/// <returns>成功失败</returns>
public override bool OnAutoAuditPass(BaseWorkFlowCurrentEntity workFlowCurrentEntity)
{
string objectId = workFlowCurrentEntity.ObjectId;
if (!string.IsNullOrEmpty(objectId))
{
// 这里写自己的方法(审核 过程中的回调),通过审核时
IDbHelper dbHelper = new DotNet.Utilities.SqlHelper(BaseSystemInfo.BusinessDbConnection);
dbHelper.Open();
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginUpdate("WL物品申购");
sqlBuilder.SetDBNow("审核日期");
sqlBuilder.SetValue("审核员", BaseSystemInfo.UserInfo.Code);
sqlBuilder.SetValue("AuditStatus", AuditStatus.AuditPass.ToString());
sqlBuilder.SetWhere("申请单号", objectId);
sqlBuilder.EndUpdate();
dbHelper.Close();
}
return(true);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(BaseAreaProvinceMarkEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseAreaProvinceMarkEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseAreaProvinceMarkEntity.FieldModifiedBy, UserInfo.RealName);
}
// 若有修改时间标示，那就按修改时间来，不是按最新的时间来
if (entity.ModifiedOn.HasValue)
{
sqlBuilder.SetValue(BaseAreaProvinceMarkEntity.FieldModifiedOn, entity.ModifiedOn.Value);
}
else
{
sqlBuilder.SetDBNow(BaseAreaProvinceMarkEntity.FieldModifiedOn);
}
sqlBuilder.SetWhere(BaseAreaProvinceMarkEntity.FieldId, entity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(BaseUserEntity entity)
{
if (string.IsNullOrEmpty(entity.QuickQuery))
{
// 2015-12-11 吉日嘎拉 全部小写，提高Oracle的效率
entity.QuickQuery = StringUtil.GetPinyin(entity.RealName).ToLower();
}
if (string.IsNullOrEmpty(entity.SimpleSpelling))
{
// 2015-12-11 吉日嘎拉 全部小写，提高Oracle的效率
entity.SimpleSpelling = StringUtil.GetSimpleSpelling(entity.RealName).ToLower();
}
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
// 2015-12-11 吉日嘎拉 全部小写，提高Oracle的效率
entity.QuickQuery = StringUtil.GetPinyin(entity.RealName).ToLower();
this.SetObject(sqlBuilder, entity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseUserEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseUserEntity.FieldModifiedBy, UserInfo.RealName);
}
// 若有修改时间标示，那就按修改时间来，不是按最新的时间来
if (entity.ModifiedOn.HasValue)
{
sqlBuilder.SetValue(BaseUserEntity.FieldModifiedOn, entity.ModifiedOn.Value);
}
else
{
sqlBuilder.SetDBNow(BaseUserEntity.FieldModifiedOn);
}
sqlBuilder.SetWhere(BaseUserEntity.FieldId, entity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 阅读短信后设置状态值和阅读次数
/// </summary>
/// <param name="messageEntity">实体</param>
/// <param name="id">短信主键</param>
/// <returns>影响的条数</returns>
private int OnRead(BaseMessageEntity messageEntity, string id)
{
int returnValue = 0;
// 针对“已发送”的情况
if (messageEntity.ReceiverId == UserInfo.Id)
{
// 针对“删除的信息”的情况
if (messageEntity.IsNew == (int)MessageStateCode.New)
{
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetValue(BaseMessageEntity.FieldIsNew, ((int)MessageStateCode.Old).ToString());
sqlBuilder.SetDBNow(BaseMessageEntity.FieldReadDate);
sqlBuilder.SetWhere(BaseMessageEntity.FieldId, id);
sqlBuilder.EndUpdate();
}
}
// 增加阅读次数
messageEntity.ReadCount++;
this.SetProperty(id, new KeyValuePair <string, object>(BaseMessageEntity.FieldReadCount, messageEntity.ReadCount.ToString()));
returnValue++;
return(returnValue);
}
/// <summary>
/// 设置按省路由大头笔
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="dtAreaRouteMark">路由设置</param>
/// <returns>影响行数</returns>
public int SetAreaRouteMark(string areaId, DataTable dtAreaRouteMark)
{
int result = 0;
string areaName = string.Empty;
BaseAreaEntity areaEntity = BaseAreaManager.GetObjectByCache(areaId);
if (areaEntity != null)
{
areaName = areaEntity.FullName;
}
if (string.IsNullOrEmpty(areaName))
{
return(result);
}
IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType, BaseSystemInfo.UserCenterDbConnection);
foreach (DataRow dr in dtAreaRouteMark.Rows)
{
// BaseAreaProvinceMarkEntity entity = null;
if (string.IsNullOrWhiteSpace(dr["Id"].ToString()))
{
/*
* entity = new BaseAreaProvinceMarkEntity();
* BaseEntity.Create<BaseAreaProvinceMarkEntity>(dr);
* entity.Province = dr["AREANAME"].ToString();
* entity.ProvinceId = dr["AREAID"].ToString();
* entity.Mark = dr["MARK"].ToString();
* entity.Description = dr["DESCRIPTION"].ToString();
* entity.CreateBy = this.UserInfo.RealName;
* entity.CreateUserId = this.UserInfo.Id;
* entity.CreateOn = DateTime.Now;
* this.AddObject(entity);
*/
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginInsert("BASEAREA_PROVINCEMARK");
sqlBuilder.SetFormula("Id", "SEQ_BASEAREA_PROVINCEMARK.NEXTVAL");
sqlBuilder.SetValue("MARK", dr["MARK"].ToString());
sqlBuilder.SetValue("DESCRIPTION", dr["DESCRIPTION"].ToString());
sqlBuilder.SetValue("AREAID", areaId);
sqlBuilder.SetValue("AREA", areaName);
sqlBuilder.SetValue("ProvinceID", dr["AREAID"].ToString());
sqlBuilder.SetValue("Province", dr["AREANAME"].ToString());
sqlBuilder.SetValue("CreateUserId", this.UserInfo.Id);
sqlBuilder.SetValue("CreateBy", this.UserInfo.RealName);
sqlBuilder.SetDBNow("CreateOn");
sqlBuilder.SetValue("Enabled", 1);
sqlBuilder.EndInsert();
// sqlBuilder.PrepareCommand();
// dotNetService.AreaService.ExecuteNonQuery(UserInfo, sqlBuilder.CommandText, sqlBuilder.DbParameters, CommandType.Text.ToString());
}
else
{
/*
* if (string.IsNullOrWhiteSpace(dr["MARK"].ToString()) && string.IsNullOrWhiteSpace(dr["DESCRIPTION"].ToString()))
* {
* this.Delete(dr["Id"].ToString());
* }
* else
* {
* entity = this.GetObject(dr["Id"].ToString());
* // entity = BaseEntity.Create<BaseAreaProvinceMarkEntity>(dr);
* entity.Mark = dr["MARK"].ToString();
* entity.Description = dr["DESCRIPTION"].ToString();
* entity.ModifiedBy = this.UserInfo.RealName;
* entity.ModifiedUserId = this.UserInfo.Id;
* entity.ModifiedOn = DateTime.Now;
* this.Update(entity);
* }
*/
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
if (string.IsNullOrWhiteSpace(dr["MARK"].ToString()) && string.IsNullOrWhiteSpace(dr["DESCRIPTION"].ToString()))
{
sqlBuilder.BeginDelete("BASEAREA_PROVINCEMARK");
sqlBuilder.SetWhere("Id", dr["Id"].ToString());
sqlBuilder.EndDelete();
// sqlBuilder.PrepareCommand();
// dotNetService.AreaService.ExecuteNonQuery(UserInfo, sqlBuilder.CommandText, sqlBuilder.DbParameters, CommandType.Text.ToString());
}
else
{
sqlBuilder.BeginUpdate("BASEAREA_PROVINCEMARK");
sqlBuilder.SetValue("MARK", dr["MARK"].ToString());
sqlBuilder.SetValue("DESCRIPTION", dr["DESCRIPTION"].ToString());
sqlBuilder.SetValue("ModifiedUserId", this.UserInfo.Id);
sqlBuilder.SetValue("ModifiedBy", this.UserInfo.RealName);
sqlBuilder.SetDBNow("ModifiedOn");
sqlBuilder.SetWhere("ID", dr["Id"].ToString());
sqlBuilder.EndUpdate();
// sqlBuilder.PrepareCommand();
// dotNetService.AreaService.ExecuteNonQuery(UserInfo, sqlBuilder.CommandText, sqlBuilder.DbParameters, CommandType.Text.ToString());
}
}
}
return(result);
}
/// <summary>
/// 获取一个操作权限的主键
/// 若不存在就自动增加一个
/// </summary>
/// <param name="permissionCode">操作权限编号</param>
/// <param name="permissionItemName">操作权限名称</param>
/// <returns>主键</returns>
public string GetIdByAdd(string permissionCode, string permissionName = null)
{
// 判断当前判断的权限是否存在，否则很容易出现前台设置了权限，后台没此项权限
// 需要自动的能把前台判断过的权限，都记录到后台来
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldCode, permissionCode));
parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldEnabled, 1));
parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldDeletionStateCode, 0));
BaseModuleEntity entity = BaseEntity.Create <BaseModuleEntity>(this.GetDataTable(parameters, BaseModuleEntity.FieldId));
string result = string.Empty;
if (entity != null)
{
result = entity.Id.ToString();
}
else
{
entity = new BaseModuleEntity();
}
// 若是在调试阶段、有没在的权限被判断了，那就自动加入这个权限，不用人工加入权限了，工作效率会提高很多，
// 哪些权限是否有被调用什么的，还可以进行一些诊断
// #if (DEBUG)
if (String.IsNullOrEmpty(result))
{
/*
* // 这里需要进行一次加锁，方式并发冲突发生
* lock (PermissionLock)
* {
* entity.Code = permissionCode;
* if (string.IsNullOrEmpty(permissionName))
* {
* entity.FullName = permissionCode;
* }
* else
* {
* entity.FullName = permissionName;
* }
* entity.ParentId = null;
* entity.IsScope = 0;
* entity.IsPublic = 0;
* // permissionEntity.CategoryCode = "Application";
* entity.IsMenu = 0;
* entity.IsVisible = 1;
* entity.DeletionStateCode = 0;
* entity.Enabled = 1;
* entity.AllowDelete = 1;
* entity.AllowEdit = 1;
* // 这里是防止主键重复？
* // permissionEntity.Id = BaseBusinessLogic.NewGuid();
* result = this.AddObject(entity);
* }
*/
}
else
{
// 更新最后一次访问日期，设置为当前服务器日期
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetDBNow(BaseModuleEntity.FieldLastCall);
sqlBuilder.SetWhere(BaseModuleEntity.FieldId, result);
sqlBuilder.EndUpdate();
}
// #endif
return(result);
}
/// <summary>
/// 更新密码
/// </summary>
/// <param name="userId">用户主键、方便外部系统调用，若能传递参数过来</param>
/// <param name="oldPassword">原密码</param>
/// <param name="newPassword">新密码</param>
/// <returns>影响行数</returns>
public virtual BaseUserInfo ChangePassword(string userId, string oldPassword, string newPassword)
{
#if (DEBUG)
int milliStart = Environment.TickCount;
#endif
string encryptOldPassword = oldPassword;
string encryptNewPassword = newPassword;
BaseUserInfo userInfo = null;
// 密码强度检查
if (BaseSystemInfo.CheckPasswordStrength)
{
if (String.IsNullOrEmpty(newPassword))
{
this.StatusCode = Status.PasswordCanNotBeNull.ToString();
return(userInfo);
}
}
// 判断输入原始密码是否正确
BaseUserLogOnEntity entity = new BaseUserLogOnManager(this.DbHelper, this.UserInfo).GetObject(UserInfo.Id);
if (entity.UserPassword == null)
{
entity.UserPassword = string.Empty;
}
// 加密密码
if (BaseSystemInfo.ServerEncryptPassword)
{
encryptOldPassword = this.EncryptUserPassword(oldPassword, entity.Salt);
}
// 密码错误
if (!entity.UserPassword.Equals(encryptOldPassword, StringComparison.CurrentCultureIgnoreCase))
{
this.StatusCode = Status.OldPasswordError.ToString();
return(userInfo);
}
// 对比是否最近2次用过这个密码
if (BaseSystemInfo.CheckPasswordStrength)
{
/*
* int i = 0;
* BaseParameterManager manager = new BaseParameterManager(this.DbHelper, this.UserInfo);
* var dt = manager.GetDataTableParameterCode("User", this.UserInfo.Id, "Password");
* foreach (DataRow dr in dt.Rows)
* {
* string parameter = dr[BaseParameterEntity.FieldParameterContent].ToString();
* if (parameter.Equals(newPassword))
* {
* this.StatusCode = Status.PasswordCanNotBeRepeat.ToString();
* return userInfo;
* }
* i++;
* {
* // 判断连续2个密码就是可以了
* if (i > 2)
* {
* break;
* }
* }
* }
*/
}
// 更改密码，同时修改密码的修改日期，这里需要兼容多数据库
string salt = string.Empty;
if (BaseSystemInfo.ServerEncryptPassword)
{
salt = BaseRandom.GetRandomString(20);
encryptNewPassword = this.EncryptUserPassword(newPassword, salt);
}
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(BaseUserLogOnEntity.TableName);
if (BaseSystemInfo.ServerEncryptPassword)
{
sqlBuilder.SetValue(BaseUserLogOnEntity.FieldSalt, salt);
}
// 宋彪：此处增加更新密码强度级别
sqlBuilder.SetValue(BaseUserLogOnEntity.FieldPasswordStrength, SecretUtil.GetUserPassWordRate(newPassword));
sqlBuilder.SetValue(BaseUserLogOnEntity.FieldUserPassword, encryptNewPassword);
// 2015-08-04 吉日嘎拉 修改了密码后,把需要修改密码字段设置为 0
sqlBuilder.SetValue(BaseUserLogOnEntity.FieldNeedModifyPassword, 0);
sqlBuilder.SetDBNow(BaseUserLogOnEntity.FieldChangePasswordDate);
sqlBuilder.SetWhere(BaseUserLogOnEntity.FieldId, userId);
int result = sqlBuilder.EndUpdate();
if (result == 1)
{
// 2015-12-09 吉日嘎拉 确认已经记录了修改密码日志
// BaseLoginLogManager.AddLog(this.UserInfo, Status.ChangePassword.ToDescription());
// 2015-12-09 吉日嘎拉 增加日志功能、谁什么时候设置了谁的密码？
var record = new BaseModifyRecordEntity();
record.TableCode = BaseUserLogOnEntity.TableName.ToUpper();
record.TableDescription = "用户登录信息表";
record.ColumnCode = BaseUserLogOnEntity.FieldUserPassword;
record.ColumnDescription = "用户密码";
record.RecordKey = userId;
record.NewValue = "修改密码";
// record.OldValue = "";
if (this.UserInfo != null)
{
record.IPAddress = this.UserInfo.IPAddress;
record.CreateUserId = this.UserInfo.Id;
record.CreateOn = DateTime.Now;
}
BaseModifyRecordManager modifyRecordManager = new Business.BaseModifyRecordManager(this.UserInfo, BaseUserEntity.TableName + "_Log");
modifyRecordManager.Add(record, true, false);
/*
* // 若是强类型密码检查，那就保存密码修改历史，防止最近2-3次的密码相同的功能实现。
* if (BaseSystemInfo.CheckPasswordStrength)
* {
* BaseParameterManager parameterManager = new BaseParameterManager(this.DbHelper, this.UserInfo);
* BaseParameterEntity parameterEntity = new BaseParameterEntity();
* parameterEntity.CategoryCode = "User";
* parameterEntity.ParameterId = this.UserInfo.Id;
* parameterEntity.ParameterCode = "Password";
* parameterEntity.ParameterContent = newPassword;
* parameterEntity.DeletionStateCode = 0;
* parameterEntity.Enabled = true;
* parameterEntity.Worked = true;
* parameterManager.AddObject(parameterEntity);
* }
*/
userInfo = this.LogOnByOpenId(this.UserInfo.OpenId, this.UserInfo.SystemCode).UserInfo;
// 同步处理其他系统的密码修改动作
if (BaseSystemInfo.ServerEncryptPassword)
{
// AfterChangePassword(this.UserInfo.Id, salt, oldPassword, newPassword);
}
// 修改密码成功，写入状态
this.StatusCode = Status.ChangePasswordOK.ToString();
}
else
{
// 数据可能被删除
this.StatusCode = Status.ErrorDeleted.ToString();
}
return(userInfo);
}
/// <summary>
/// 获取一个操作权限的主键
/// 若不存在就自动增加一个
/// </summary>
/// <param name="permissionItemCode">操作权限编号</param>
/// <param name="permissionItemName">操作权限名称</param>
/// <returns>主键</returns>
public string GetIdByAdd(string permissionItemCode, string permissionItemName = null)
{
// 判断当前判断的权限是否存在，否则很容易出现前台设置了权限，后台没此项权限
// 需要自动的能把前台判断过的权限，都记录到后台来
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BasePermissionItemEntity.FieldCode, permissionItemCode));
parameters.Add(new KeyValuePair <string, object>(BasePermissionItemEntity.FieldEnabled, 1));
parameters.Add(new KeyValuePair <string, object>(BasePermissionItemEntity.FieldDeletionStateCode, 0));
BasePermissionItemEntity permissionItemEntity = new BasePermissionItemEntity();
permissionItemEntity = new BasePermissionItemEntity(this.GetDataTable(parameters, BasePermissionItemEntity.FieldId));
string permissionItemId = string.Empty;
if (permissionItemEntity != null)
{
permissionItemId = permissionItemEntity.Id.ToString();
}
// 若是在调试阶段、有没在的权限被判断了，那就自动加入这个权限，不用人工加入权限了，工作效率会提高很多，
// 哪些权限是否有被调用什么的，还可以进行一些诊断
#if (DEBUG)
if (String.IsNullOrEmpty(permissionItemId))
{
// 这里需要进行一次加锁，方式并发冲突发生
lock (PermissionItemLock)
{
permissionItemEntity.Code = permissionItemCode;
if (string.IsNullOrEmpty(permissionItemName))
{
permissionItemEntity.FullName = permissionItemCode;
}
else
{
permissionItemEntity.FullName = permissionItemName;
}
permissionItemEntity.ParentId = null;
permissionItemEntity.IsScope = 0;
permissionItemEntity.AllowDelete = 1;
permissionItemEntity.AllowEdit = 1;
permissionItemEntity.Enabled = 1;
// 这里是防止主键重复？
// permissionEntity.ID = BaseBusinessLogic.NewGuid();
permissionItemId = this.AddEntity(permissionItemEntity);
}
}
else
{
// 更新最后一次访问日期，设置为当前服务器日期
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
sqlBuilder.SetDBNow(BasePermissionItemEntity.FieldLastCall);
sqlBuilder.SetWhere(BasePermissionItemEntity.FieldId, permissionItemId);
sqlBuilder.EndUpdate();
}
#endif
return(permissionItemId);
}
