/// <summary>
/// 批量删除参数
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="ids">主键数组</param>
/// <returns>影响行数</returns>
public int BatchDelete(BaseUserInfo userInfo, string[] ids)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
int returnValue = 0;
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
BaseParameterManager parameterManager = new BaseParameterManager(dbHelper, userInfo);
for (int i = 0; i < ids.Length; i++)
{
returnValue += parameterManager.Delete(ids[i]);
}
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.ParameterService_BatchDelete, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return returnValue;
}
/// <summary>
/// 更新密码
/// </summary>
/// <param name="oldPassword">原密码</param>
/// <param name="newPassword">新密码</param>
/// <param name="statusCode">返回状态码</param>
/// <returns>影响行数</returns>
public virtual int ChangePassword(string oldPassword, string newPassword, out string statusCode)
{
#if (DEBUG)
int milliStart = Environment.TickCount;
#endif
int returnValue = 0;
// 密码强度检查
if (BaseSystemInfo.CheckPasswordStrength)
{
if (String.IsNullOrEmpty(newPassword))
{
statusCode = StatusCode.PasswordCanNotBeNull.ToString();
return returnValue;
}
}
// 加密密码
if (BaseSystemInfo.ServerEncryptPassword)
{
oldPassword = this.EncryptUserPassword(oldPassword);
newPassword = this.EncryptUserPassword(newPassword);
}
// 判断输入原始密码是否正确
BaseUserEntity userEntity = new BaseUserEntity();
userEntity.GetSingle(this.GetDataTableById(UserInfo.Id));
if (userEntity.UserPassword == null)
{
userEntity.UserPassword = string.Empty;
}
// 密码错误
if (!userEntity.UserPassword.Equals(oldPassword))
{
statusCode = StatusCode.OldPasswordError.ToString();
return returnValue;
}
// 对比是否最近2次用过这个密码
if (BaseSystemInfo.CheckPasswordStrength)
{
int i = 0;
BaseParameterManager parameterManager = new BaseParameterManager(this.DbHelper, this.UserInfo);
DataTable dataTable = parameterManager.GetDataTableParameterCode("User", this.UserInfo.Id, "Password");
foreach (DataRow dataRow in dataTable.Rows)
{
string parameter = dataRow[BaseParameterEntity.FieldParameterContent].ToString();
if (parameter.Equals(newPassword))
{
statusCode = StatusCode.PasswordCanNotBeRepeat.ToString();
return returnValue;
}
i++;
{
// 判断连续2个密码就是可以了
if (i > 2)
{
break;
}
}
}
}
// 更改密码，同时修改密码的修改日期
List<KeyValuePair<string, object>> parameters = new List<KeyValuePair<string, object>>();
parameters.Add(new KeyValuePair<string, object>(BaseUserEntity.FieldUserPassword, newPassword));
// 注意日期格式，ACCESS中要用字符
parameters.Add(new KeyValuePair<string, object>(BaseUserEntity.FieldChangePasswordDate, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")));
returnValue = this.SetProperty(new KeyValuePair<string, object>(BaseUserEntity.FieldId, UserInfo.Id), parameters);
if (returnValue == 1)
{
statusCode = StatusCode.ChangePasswordOK.ToString();
// 若是强类型密码检查，那就保存密码修改历史，防止最近2-3次的密码相同的功能实现。
if (BaseSystemInfo.CheckPasswordStrength)
{
BaseParameterManager parameterManager = new BaseParameterManager(this.DbHelper, this.UserInfo);
BaseParameterEntity parameterEntity = new BaseParameterEntity();
parameterEntity.CategoryId = "User";
parameterEntity.ParameterId = this.UserInfo.Id;
parameterEntity.ParameterCode = "Password";
parameterEntity.ParameterContent = newPassword;
parameterEntity.DeletionStateCode = 0;
parameterEntity.Enabled = true;
parameterEntity.Worked = true;
parameterManager.AddEntity(parameterEntity);
}
}
else
{
// 数据可能被删除
statusCode = StatusCode.ErrorDeleted.ToString();
}
// 写入调试信息
#if (DEBUG)
int milliEnd = Environment.TickCount;
Trace.WriteLine(DateTime.Now.ToString(BaseSystemInfo.TimeFormat) + " Ticks: " + TimeSpan.FromMilliseconds(milliEnd - milliStart).ToString() + " " + " BaseUserManager.ChangePassword(" + userEntity.Id + ")");
#endif
return returnValue;
}
/// <summary>
/// 添加IP地址或者Mac地址
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
//检查输入是否有效
if (!this.CheckInput())
return;
string statusCode=string.Empty;
string returnValue=string.Empty;
string[] nameArr = new string[2];
string[] valueArr = new string[2];
BaseParameterManager parameterManager=new BaseParameterManager(this.UserCenterDbHelper,this.UserInfo);
BaseSequenceManager sequenceManager = new BaseSequenceManager(this.UserCenterDbHelper,this.UserInfo);
// 增加ip
List<KeyValuePair<string, object>> parameters = new List<KeyValuePair<string, object>>();
if (!string.IsNullOrEmpty(this.txtIPAddress.Text.Trim()))
{
parameters.Add(new KeyValuePair<string, object>(BaseParameterEntity.FieldParameterId, this.ucUser.SelectedId));
parameters.Add(new KeyValuePair<string, object>(BaseParameterEntity.FieldParameterContent, this.txtIPAddress.Text.Trim()));
// 检查是否存在IpAddress
if (parameterManager.Exists(parameters))
{
statusCode = AppMessage.MSG0055;
MessageBox.Show(statusCode, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
BaseParameterEntity entityIp = new BaseParameterEntity();
entityIp.Id = sequenceManager.GetSequence(BaseParameterEntity.TableName);
entityIp.CategoryId = "IPAddress";
entityIp.ParameterId = this.ucUser.SelectedId;
string ipStr = this.txtIPAddress.Text.Trim();
//Range Mask 和Single 在CheckInput 方法中使用正则表达式对输入进行验证
//如果是地址段
if(ipStr.IndexOf('-')>0)
{
entityIp.ParameterCode = "Range";// mask range
}
else if (ipStr.IndexOf('*') > 0)
{ //如果有mask
entityIp.ParameterCode = "Mask";
}
else
{
entityIp.ParameterCode = "Single";
}
//如果是单个ip
entityIp.ParameterContent = this.txtIPAddress.Text.Trim();
returnValue = parameterManager.AddEntity(entityIp);
if (!string.IsNullOrEmpty(returnValue))
{
statusCode = AppMessage.MSG0056;
}
else
{
statusCode = AppMessage.MSG0057;
}
}
// 增加Mac
if (!string.IsNullOrEmpty(this.txtMacAddress.Text.Trim()))
{
parameters = new List<KeyValuePair<string, object>>();
parameters.Add(new KeyValuePair<string, object>(BaseParameterEntity.FieldParameterId, this.ucUser.SelectedId));
parameters.Add(new KeyValuePair<string, object>(BaseParameterEntity.FieldParameterContent, this.txtMacAddress.Text.Trim()));
// 检查是否存在MacAddress
if (parameterManager.Exists(parameters))
{
statusCode = AppMessage.MSG0058;
MessageBox.Show(statusCode, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
BaseParameterEntity entityMac = new BaseParameterEntity();
entityMac.Id = sequenceManager.GetSequence(BaseParameterEntity.TableName);
entityMac.CategoryId = "MacAddress";
entityMac.ParameterId = this.ucUser.SelectedId;
entityMac.ParameterCode = "Single";
entityMac.ParameterContent = this.txtMacAddress.Text.Trim();
returnValue = parameterManager.AddEntity(entityMac);
if (!string.IsNullOrEmpty(returnValue))
{
statusCode += AppMessage.MSG0059;
}
else
{
statusCode += AppMessage.MSG0061;
}
}
MessageBox.Show(statusCode, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
// 重新绑定listbox
this.GetIpList(this.ucUser.SelectedId);
this.GetMacList(this.ucUser.SelectedId);
this.CleanScreen();
}
/// <summary>
/// 进行登录操作
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="password">密码</param>
/// <param name="createNewOpenId"></param>
/// <param name="ipAddress">IP地址</param>
/// <param name="macAddress">MAC地址</param>
/// <param name="checkUserPassword">是否要检查用户密码</param>
/// <returns>用户信息</returns>
public BaseUserInfo LogOn(string userName, string password, bool createNewOpenId = false, string ipAddress = null, string macAddress = null, bool checkUserPassword = true)
{
BaseUserInfo userInfo = null;
string realName = string.Empty;
if (UserInfo != null)
{
realName = UserInfo.RealName;
}
if (ipAddress == null)
{
if (UserInfo != null)
{
ipAddress = UserInfo.IPAddress;
}
}
// 01: 系统是否采用了在线用户的限制
if (BaseSystemInfo.OnLineLimit > 0)
{
if (this.CheckOnLineLimit())
{
this.ReturnStatusCode = StatusCode.ErrorOnLineLimit.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userName, ipAddress, AppMessage.MSG0089 + BaseSystemInfo.OnLineLimit.ToString());
return userInfo;
}
}
// 04. 默认为用户没有找到状态，查找用户
// 这是为了达到安全要求，不能提示用户未找到，那容易让别人猜测到帐户
if (BaseSystemInfo.CheckPasswordStrength)
{
this.ReturnStatusCode = StatusCode.ErrorLogOn.ToString();
}
else
{
this.ReturnStatusCode = StatusCode.UserNotFound.ToString();
}
// 02. 查询数据库中的用户数据？只查询未被删除的
// 先按用户名登录
DataTable dataTable = this.GetDataTable(new KeyValuePair<string, object>(BaseUserEntity.FieldUserName, userName)
, new KeyValuePair<string, object>(BaseUserEntity.FieldDeletionStateCode, 0));
// 若不是严格检查，可以采用多种方式登录
if (!BaseSystemInfo.CheckPasswordStrength)
{
if (dataTable.Rows.Count == 0)
{
// 若没数据再按工号登录
dataTable = this.GetDataTable(new KeyValuePair<string, object>(BaseUserEntity.FieldCode, userName)
, new KeyValuePair<string, object>(BaseUserEntity.FieldDeletionStateCode, 0));
}
if (dataTable.Rows.Count == 0)
{
// 若没数据再按邮件登录
dataTable = this.GetDataTable(new KeyValuePair<string, object>(BaseUserEntity.FieldEmail, userName)
, new KeyValuePair<string, object>(BaseUserEntity.FieldDeletionStateCode, 0));
}
if (dataTable.Rows.Count == 0)
{
// 若没数据再按手机号码登录
dataTable = this.GetDataTable(new KeyValuePair<string, object>(BaseUserEntity.FieldMobile, userName)
, new KeyValuePair<string, object>(BaseUserEntity.FieldDeletionStateCode, 0));
}
if (dataTable.Rows.Count == 0)
{
// 若没数据再按手机号码登录
dataTable = this.GetDataTable(new KeyValuePair<string, object>(BaseUserEntity.FieldTelephone, userName)
, new KeyValuePair<string, object>(BaseUserEntity.FieldDeletionStateCode, 0));
}
}
BaseUserEntity userEntity = null;
if (dataTable.Rows.Count > 1)
{
this.ReturnStatusCode = StatusCode.UserDuplicate.ToString();
}
else if (dataTable.Rows.Count == 1)
{
// 03. 系统是否采用了密码加密策略？
string encryptPassword = string.Empty;
if (checkUserPassword)
{
if (BaseSystemInfo.ServerEncryptPassword)
{
password = this.EncryptUserPassword(password);
}
}
// 05. 判断密码，是否允许登录，是否离职是否正确
foreach (DataRow dataRow in dataTable.Rows)
{
userEntity = new BaseUserEntity(dataRow);
if (!string.IsNullOrEmpty(userEntity.AuditStatus) && userEntity.AuditStatus.EndsWith(AuditStatus.WaitForAudit.ToString()))
{
this.ReturnStatusCode = AuditStatus.WaitForAudit.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userName, ipAddress, AppMessage.MSG0078);
return userInfo;
}
// 用户是否有效的
if (userEntity.Enabled == 0)
{
this.ReturnStatusCode = StatusCode.LogOnDeny.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userName, ipAddress, AppMessage.MSG0079);
return userInfo;
}
// 用户是否有效的
if (userEntity.Enabled == -1)
{
this.ReturnStatusCode = StatusCode.UserNotActive.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userName, ipAddress, AppMessage.MSG0080);
return userInfo;
}
// 06. 允许登录时间是否有限制
if (userEntity.AllowEndTime != null)
{
userEntity.AllowEndTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, userEntity.AllowEndTime.Value.Hour, userEntity.AllowEndTime.Value.Minute, userEntity.AllowEndTime.Value.Second);
}
if (userEntity.AllowStartTime != null)
{
userEntity.AllowStartTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, userEntity.AllowStartTime.Value.Hour, userEntity.AllowStartTime.Value.Minute, userEntity.AllowStartTime.Value.Second);
if (DateTime.Now < userEntity.AllowStartTime)
{
this.ReturnStatusCode = StatusCode.UserLocked.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userName, ipAddress, AppMessage.MSG0081 + userEntity.AllowStartTime.Value.ToString("HH:mm"));
return userInfo;
}
}
if (userEntity.AllowEndTime != null)
{
if (DateTime.Now > userEntity.AllowEndTime)
{
this.ReturnStatusCode = StatusCode.UserLocked.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userName, ipAddress, AppMessage.MSG0082 + userEntity.AllowEndTime.Value.ToString("HH:mm"));
return userInfo;
}
}
// 07. 锁定日期是否有限制
if (userEntity.LockStartDate != null)
{
if (DateTime.Now > userEntity.LockStartDate)
{
if (userEntity.LockEndDate == null || DateTime.Now < userEntity.LockEndDate)
{
this.ReturnStatusCode = StatusCode.UserLocked.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userName, ipAddress, AppMessage.MSG0083 + userEntity.LockStartDate.Value.ToString("yyyy-MM-dd"));
return userInfo;
}
}
}
if (userEntity.LockEndDate != null)
{
if (DateTime.Now < userEntity.LockEndDate)
{
this.ReturnStatusCode = StatusCode.UserLocked.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userName, ipAddress, AppMessage.MSG0084 + userEntity.LockEndDate.Value.ToString("yyyy-MM-dd"));
return userInfo;
}
}
// 08. 是否检查用户IP地址，是否进行访问限制？管理员不检查IP.
if (BaseSystemInfo.CheckIPAddress && !this.IsAdministrator(userEntity.Id.ToString()))
{
List<KeyValuePair<string, object>> parameters = new List<KeyValuePair<string, object>>();
parameters.Add(new KeyValuePair<string, object>(BaseParameterEntity.FieldParameterId, userEntity.Id.ToString()));
parameters.Add(new KeyValuePair<string, object>(BaseParameterEntity.FieldCategoryId, "IPAddress"));
// 没有设置IP地址时不检查
BaseParameterManager baseParameterManager = new BaseParameterManager(this.DbHelper);
if (baseParameterManager.Exists(parameters))
{
if (!string.IsNullOrEmpty(ipAddress) && !this.CheckIPAddress(ipAddress, userEntity.Id.ToString()))
{
this.ReturnStatusCode = StatusCode.ErrorIPAddress.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, ipAddress, ipAddress, AppMessage.MSG0085);
return userInfo;
}
}
// 没有设置MAC地址时不检查
parameters = new List<KeyValuePair<string, object>>();
parameters.Add(new KeyValuePair<string, object>(BaseParameterEntity.FieldParameterId, userEntity.Id.ToString()));
parameters.Add(new KeyValuePair<string, object>(BaseParameterEntity.FieldCategoryId, "MacAddress"));
if (baseParameterManager.Exists(parameters))
{
if (!string.IsNullOrEmpty(macAddress) && !this.CheckMacAddress(macAddress, userEntity.Id.ToString()))
{
this.ReturnStatusCode = StatusCode.ErrorMacAddress.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, macAddress, ipAddress, AppMessage.MSG0086);
return userInfo;
}
}
}
// 10. 只允许登录一次，需要检查是否自己重新登录了，或者自己扮演自己了
if ((UserInfo != null) && (!UserInfo.Id.Equals(userEntity.Id.ToString())))
{
if (BaseSystemInfo.CheckOnLine)
{
if (userEntity.UserOnLine > 0)
{
this.ReturnStatusCode = StatusCode.ErrorOnLine.ToString();
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userName, ipAddress, AppMessage.MSG0087);
return userInfo;
}
}
}
// 11. 密码是否正确(null 与空看成是相等的)
if (!(string.IsNullOrEmpty(userEntity.UserPassword) && string.IsNullOrEmpty(password)))
{
bool userPasswordOK = true;
// 用户密码是空的
if (string.IsNullOrEmpty(userEntity.UserPassword))
{
// 但是输入了不为空的密码
if (!string.IsNullOrEmpty(password))
{
userPasswordOK = false;
}
}
else
{
// 用户的密码不为空，但是用户是输入了密码
if (string.IsNullOrEmpty(password))
{
userPasswordOK = false;
}
else
{
// 再判断用户的密码与输入的是否相同
userPasswordOK = userEntity.UserPassword.Equals(password);
}
}
// 用户的密码不相等
if (!userPasswordOK)
{
// 密码错误后 1：应该记录日志
BaseLogManager.Instance.Add(DbHelper, userEntity.Id.ToString(), userEntity.RealName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userEntity.RealName, ipAddress, AppMessage.MSG0088);
// TODO: 密码错误后 2：看最近1个小时输入了几次错误了？24小时里。
// TODO: 密码错误后 3：若错误密码数量已经超过了指定的限制，那用户就需要被锁定1个小时。
// TODO: 密码错误后 4：同时需要处理返回值，是由于密码次数过多导致的被锁定，登录时也应该能读取这个状态比较，时间过期了，也应该进行处理一下状态。
// 密码强度检查，若是要有安全要求比较高的，返回的提醒消息要进行特殊处理，不能返回非常明确的提示信息。
if (BaseSystemInfo.CheckPasswordStrength)
{
this.ReturnStatusCode = StatusCode.ErrorLogOn.ToString();
}
else
{
this.ReturnStatusCode = StatusCode.PasswordError.ToString();
}
return userInfo;
}
}
// 09. 更新IP地址，更新MAC地址
if (!string.IsNullOrEmpty(ipAddress))
{
this.SetProperty(userEntity.Id, new KeyValuePair<string, object>(BaseUserEntity.FieldIPAddress, ipAddress));
}
if (!string.IsNullOrEmpty(macAddress))
{
this.SetProperty(userEntity.Id, new KeyValuePair<string, object>(BaseUserEntity.FieldMACAddress, macAddress));
}
// 可以正常登录了
this.ReturnStatusCode = StatusCode.OK.ToString();
// 13. 登录、重新登录、扮演时的在线状态进行更新
this.ChangeOnLine(userEntity.Id.ToString());
userInfo = this.ConvertToUserInfo(userEntity);
// 获得员工的信息，这里员工的一些信息还是有错误，部门的主键啥的
if (userEntity.IsStaff == 1)
{
// BaseStaffManager staffManager = new BaseStaffManager(DbHelper, UserInfo);
// 这里需要按 员工的用户ID来进行查找对应的员工-用户关系
// BaseStaffEntity staffEntity = new BaseStaffEntity(staffManager.GetDataTable(BaseStaffEntity.FieldUserId, userEntity.Id));
// if (staffEntity.Id > 0)
// {
// userInfo = staffManager.ConvertToUserInfo(staffEntity, userInfo);
// }
}
userInfo.IPAddress = ipAddress;
userInfo.MACAddress = macAddress;
userInfo.Password = password;
// 这里是判断用户是否为系统管理员的
userInfo.IsAdministrator = IsAdministrator(userInfo.Id);
userInfo.StaffId = new BaseStaffManager(DbHelper).GetIdByUserId(userInfo.Id);
// 数据找到了，就可以退出循环了)
break;
}
}
// 14. 记录系统访问日志
if (this.ReturnStatusCode == StatusCode.OK.ToString())
{
BaseLogManager.Instance.Add(DbHelper, userEntity.Id.ToString(), userEntity.RealName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userEntity.RealName, ipAddress, AppMessage.BaseUserManager_LogOnSuccess);
if (string.IsNullOrEmpty(userInfo.OpenId))
{
createNewOpenId = true;
}
if (createNewOpenId)
{
userInfo.OpenId = this.UpdateVisitDate(userEntity.Id.ToString(), createNewOpenId);
}
else
{
this.UpdateVisitDate(userEntity.Id.ToString());
}
}
else
{
BaseLogManager.Instance.Add(DbHelper, userName, realName, "LogOn", AppMessage.BaseUserManager, "LogOn", AppMessage.BaseUserManager_LogOn, userName, ipAddress, AppMessage.MSG0090);
}
return userInfo;
}
/// <summary>
/// 设置参数值
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="categoryId">分类主键</param>
/// <param name="parameterId">参数主键</param>
/// <param name="parameterCode">参数编号</param>
/// <param name="parameterContent">参数内容</param>
/// <returns>影响行数</returns>
public int SetParameter(BaseUserInfo userInfo, string categoryId, string parameterId, string parameterCode, string parameterContent)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
int returnValue = 0;
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
BaseParameterManager parameterManager = new BaseParameterManager(dbHelper, userInfo);
returnValue = parameterManager.SetParameter(categoryId, parameterId, parameterCode, parameterContent);
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.ParameterService_SetParameter, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return returnValue;
}
/// <summary>
/// 获取参数列表
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="categoryId">分类主键</param>
/// <param name="parameterId">参数主键</param>
/// <returns>数据表</returns>
public DataTable GetDataTableByParameter(BaseUserInfo userInfo, string categoryId, string parameterId)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
DataTable dataTable = new DataTable(BaseParameterEntity.TableName);
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
BaseParameterManager parameterManager = new BaseParameterManager(dbHelper, userInfo);
dataTable = parameterManager.GetDataTableByParameter(categoryId, parameterId);
dataTable.TableName = BaseParameterEntity.TableName;
BaseLogManager.Instance.Add(dbHelper, userInfo, AppMessage.ParameterService_GetDataTableByParameter, this.serviceName, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return dataTable;
}
