/// <summary>
/// 更新
/// </summary>
/// <param name="parameterEntity">参数基类表结构定义</param>
/// <returns>影响行数</returns>
public int Update(BaseParameterEntity parameterEntity)
{
int returnValue = 0;
// 检查是否已被其他人修改
//if (DbLogic.IsModifed(DbHelper, BaseParameterEntity.TableName, parameterEntity.Id, parameterEntity.ModifiedUserId, parameterEntity.ModifiedOn))
//{
// // 数据已经被修改
// this.ReturnStatusCode = StatusCode.ErrorChanged.ToString();
//}
//else
//{
// 检查编号是否重复
if (this.Exists(new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterCode, parameterEntity.ParameterCode), parameterEntity.Id))
{
// 文件夹名已重复
this.ReturnStatusCode = StatusCode.ErrorCodeExist.ToString();
}
else
{
// 进行更新操作
returnValue = this.UpdateEntity(parameterEntity);
if (returnValue == 1)
{
this.ReturnStatusCode = StatusCode.OKUpdate.ToString();
}
else
{
// 数据可能被删除
this.ReturnStatusCode = StatusCode.ErrorDeleted.ToString();
}
}
// }
return(returnValue);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="parameterEntity">实体对象</param>
/// <returns>主键</returns>
public string AddEntity(BaseParameterEntity parameterEntity)
{
if (string.IsNullOrEmpty(parameterEntity.Id))
{
parameterEntity.Id = Guid.NewGuid().ToString();
}
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginInsert(this.CurrentTableName);
sqlBuilder.SetValue(BaseParameterEntity.FieldId, parameterEntity.Id);
sqlBuilder.SetValue(BaseParameterEntity.FieldCategoryId, parameterEntity.CategoryId);
sqlBuilder.SetValue(BaseParameterEntity.FieldParameterId, parameterEntity.ParameterId);
sqlBuilder.SetValue(BaseParameterEntity.FieldParameterCode, parameterEntity.ParameterCode);
sqlBuilder.SetValue(BaseParameterEntity.FieldWorked, parameterEntity.Worked ? 1 : 0);
sqlBuilder.SetValue(BaseParameterEntity.FieldParameterContent, parameterEntity.ParameterContent);
sqlBuilder.SetValue(BaseParameterEntity.FieldEnabled, parameterEntity.Enabled ? 1 : 0);
sqlBuilder.SetValue(BaseParameterEntity.FieldDeletionStateCode, parameterEntity.DeletionStateCode);
sqlBuilder.SetValue(BaseParameterEntity.FieldDescription, parameterEntity.Description);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseParameterEntity.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseParameterEntity.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseParameterEntity.FieldCreateOn);
return(sqlBuilder.EndInsert() > 0 ? parameterEntity.Id : string.Empty);
}
/// <summary>
/// 更新参数设置
/// </summary>
/// <param name="categoryId">类别主键</param>
/// <param name="parameterId">标志主键</param>
/// <param name="parameterCode">编码</param>
/// <param name="parameterContent">参数内容</param>
/// <returns>影响行数</returns>
public int SetParameter(string categoryId, string parameterId, string parameterCode, string parameterContent)
{
int returnValue = 0;
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldCategoryId, categoryId));
parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterId, parameterId));
parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterCode, parameterCode));
parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldDeletionStateCode, 0));
// 检测是否无效数据
if ((parameterContent == null) || (parameterContent.Length == 0))
{
returnValue = this.Delete(parameters);
}
else
{
// 检测是否存在
returnValue = this.SetProperty(parameters, new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterContent, parameterContent));
if (returnValue == 0)
{
// 进行增加操作
BaseParameterEntity parameterEntity = new BaseParameterEntity();
parameterEntity.CategoryId = categoryId;
parameterEntity.ParameterId = parameterId;
parameterEntity.ParameterCode = parameterCode;
parameterEntity.ParameterContent = parameterContent;
parameterEntity.Enabled = true;
parameterEntity.DeletionStateCode = 0;
this.AddEntity(parameterEntity);
returnValue = 1;
}
}
return(returnValue);
}
/// <summary>
/// 校验接口基类参数
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="parameter"></param>
/// <param name="result"></param>
/// <returns></returns>
protected bool CheckBaseArgument <T>(BaseParameterEntity parameter, out BaseJsonResult <T> result)
{
if (string.IsNullOrEmpty(parameter.t))
{
result = new BaseJsonResult <T> {
Status = (int)JsonObjectStatus.Fail, Message = "时间戳不能为空。"
};
return(false);
}
else
{
if (!parameter.t.CheckTimeStamp())
{
result = new BaseJsonResult <T> {
Status = (int)JsonObjectStatus.Fail, Message = "时间戳有误。"
};
return(false);
}
else
{
result = new BaseJsonResult <T> {
Status = (int)JsonObjectStatus.Success
};
return(true);
}
}
}
public HttpResponseMessage GetSystemNotice(BaseParameterEntity arg)
{
BaseJson <string> resultMsg = new BaseJson <string> {
Status = (int)JsonObjectStatus.Error, Message = "服务器未知错误。", Data = null
};
Logger(typeof(CommonController), arg.TryToJson(), "获取系统公告-GetSystemNotice", () =>
{
if (!string.IsNullOrEmpty(arg.t))
{
if (arg.t.CheckTimeStamp())
{
resultMsg = new BaseJson <string>
{
Status = (int)JsonObjectStatus.Success,
Data = null,
Message = JsonObjectStatus.Success.GetEnumText(),
BackUrl = null
};
}
else
{
resultMsg = new BaseJson <string>
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = JsonObjectStatus.Fail.GetEnumText() + "，无效参数。",
BackUrl = null
};
}
}
else
{
resultMsg = new BaseJson <string>
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = JsonObjectStatus.Fail.GetEnumText() + "，请求参数为空。",
BackUrl = null
};
}
}, e =>
{
resultMsg = new BaseJson <string>
{
Status = (int)JsonObjectStatus.Exception,
Data = null,
Message = JsonObjectStatus.Exception.GetEnumText() + "，异常信息：" + e.Message,
BackUrl = null
};
});
return(resultMsg.TryToJson().ToHttpResponseMessage());
}
/// <summary>
/// 添加
/// </summary>
/// <param name="categoryId">类别主键</param>
/// <param name="parameterId">标记主键</param>
/// <param name="parameterCode">标记编码</param>
/// <param name="parameterContent">标记内容</param>
/// <param name="worked">工作状态</param>
/// <param name="enabled">有效</param>
/// <returns>主键</returns>
public string Add(string categoryId, string parameterId, string parameterCode, string parameterContent, bool worked, bool enabled)
{
BaseParameterEntity parameterEntity = new BaseParameterEntity();
parameterEntity.CategoryId = categoryId;
parameterEntity.ParameterId = parameterId;
parameterEntity.ParameterCode = parameterCode;
parameterEntity.ParameterContent = parameterContent;
parameterEntity.Worked = worked;
parameterEntity.Enabled = enabled;
return(this.Add(parameterEntity));
}
/// <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="parameterEntity">内容</param>
/// <returns>主键</returns>
public string Add(BaseParameterEntity parameterEntity)
{
string returnValue = string.Empty;
// 此处检查this.exist()
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldCategoryId, parameterEntity.CategoryId));
parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterId, parameterEntity.ParameterId));
parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterCode, parameterEntity.ParameterCode));
if (this.Exists(parameters))
{
// 编号已重复
this.ReturnStatusCode = StatusCode.ErrorCodeExist.ToString();
}
else
{
returnValue = this.AddEntity(parameterEntity);
// 运行成功
this.ReturnStatusCode = StatusCode.OKAdd.ToString();
}
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();
}
public HttpResponseMessage GetFriendLinkList(BaseParameterEntity arg)
{
BaseJson <List <FriendLinkViewEntity> > resultMsg = new BaseJson <List <FriendLinkViewEntity> > {
Status = (int)JsonObjectStatus.Error, Message = "服务器未知错误。", Data = null
};
Logger(typeof(CommonController), arg.TryToJson(), "获取友情链接-GetFriendLinkList", () =>
{
if (!string.IsNullOrEmpty(arg.t))
{
if (arg.t.CheckTimeStamp())
{
List <FriendLinkViewEntity> cache = Cache.Factory.CacheFactory.Cache().GetCache <List <FriendLinkViewEntity> >(CacheKeyEnum.FriendLink.ToString());
if (cache == null)
{
List <BaseFriendLinksEntity> temp = baseFriendLinksBll.GetList(f => f.IsEnable == true && f.IsDelete == false).ToList();
if (temp.Count > 0)
{
List <FriendLinkViewEntity> list = new List <FriendLinkViewEntity>();
foreach (BaseFriendLinksEntity entity in temp)
{
if (entity.TermOfValidity != 0)
{
if (entity.CreateTime != null && entity.CreateTime.Value.AddYears(entity.TermOfValidity) > DateTimeHelper.Now)
{
list.Add(new FriendLinkViewEntity
{
Name = entity.Name,
Url = entity.Url,
Type = entity.TypeName
});
}
}
else
{
list.Add(new FriendLinkViewEntity
{
Name = entity.Name,
Url = entity.Url,
Type = entity.TypeName
});
}
}
cache = list;
Cache.Factory.CacheFactory.Cache().WriteCache(list, CacheKeyEnum.FriendLink.ToString(), DateTimeHelper.Now.AddDays(30));
}
}
resultMsg = new BaseJson <List <FriendLinkViewEntity> >
{
Status = (int)JsonObjectStatus.Success,
Data = cache,
Message = JsonObjectStatus.Success.GetEnumText(),
BackUrl = null
};
}
else
{
resultMsg = new BaseJson <List <FriendLinkViewEntity> >
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = JsonObjectStatus.Fail.GetEnumText() + "，无效参数。",
BackUrl = null
};
}
}
else
{
resultMsg = new BaseJson <List <FriendLinkViewEntity> >
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = JsonObjectStatus.Fail.GetEnumText() + "，请求参数为空。",
BackUrl = null
};
}
}, e =>
{
resultMsg = new BaseJson <List <FriendLinkViewEntity> >
{
Status = (int)JsonObjectStatus.Exception,
Data = null,
Message = JsonObjectStatus.Exception.GetEnumText() + "，异常信息：" + e.Message,
BackUrl = null
};
});
return(resultMsg.TryToJson().ToHttpResponseMessage());
}
/// <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);
}
public HttpResponseMessage GetThematicArticleClassify(BaseParameterEntity arg)
{
BaseJson <List <ZTColumnViewModel> > resultMsg = new BaseJson <List <ZTColumnViewModel> > {
Status = (int)JsonObjectStatus.Error, Message = "服务器未知错误。", Data = null
};
Logger(typeof(ThematicArticleController), arg.TryToJson(), "获取专题文章分类-GetThematicArticleClassify", () =>
{
if (!string.IsNullOrEmpty(arg.t))
{
if (arg.t.CheckTimeStamp())
{
List <ZTColumnViewModel> res = Cache.Factory.CacheFactory.Cache().GetCache <List <ZTColumnViewModel> >("__ThematicArticleClassify");
if (res == null || res.Count == 0)
{
res = new List <ZTColumnViewModel>();
DataTable data = commonBll.ExcuteSqlDataTable(QueryThematicArticleClassify, DatabaseLinksEnum.CB55128);
if (data.IsExistRows())
{
List <ZTColumnEntity> list = data.DataTableToList <ZTColumnEntity>();
foreach (ZTColumnEntity entity in list)
{
ZTColumnViewModel model = new ZTColumnViewModel
{
Name = entity.Name.Trim(),
CId = entity.CId,
TagId = entity.TagId,
Logo = entity.Logo.ToLower(),
Lottery = entity.Lottery.Trim(),
About = entity.About,
hTitle = entity.hTitle,
hKeywords = entity.hKeywords,
hDescription = entity.hDescription,
RewriteUrl = entity.RewriteUrl.Trim()
};
res.Add(model);
}
Cache.Factory.CacheFactory.Cache().WriteCache(res, "__ThematicArticleClassify", DateTime.Now.AddHours(12));
}
}
resultMsg = new BaseJson <List <ZTColumnViewModel> >
{
Status = (int)JsonObjectStatus.Success,
Data = res,
Message = JsonObjectStatus.Success.GetEnumText(),
BackUrl = null
};
}
else
{
resultMsg = new BaseJson <List <ZTColumnViewModel> >
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = JsonObjectStatus.Fail.GetEnumText() + "，无效参数。",
BackUrl = null
};
}
}
else
{
resultMsg = new BaseJson <List <ZTColumnViewModel> >
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = JsonObjectStatus.Fail.GetEnumText() + "，请求参数为空。",
BackUrl = null
};
}
}, e =>
{
resultMsg = new BaseJson <List <ZTColumnViewModel> >
{
Status = (int)JsonObjectStatus.Exception,
Data = null,
Message = JsonObjectStatus.Exception.GetEnumText() + "，异常信息：" + e.Message,
BackUrl = null
};
});
return(resultMsg.TryToJson().ToHttpResponseMessage());
}
