/// <summary>
/// 新增一条限制字符信息
/// </summary>
/// <param name="content"></param>
public void InsertConfineContent(ConfineContent content)
{
DataRow dr = aideConfineContentProvider.NewRow( );
dr[ConfineContent._String] = content.String;
if (!content.EnjoinOverDate.Equals(Convert.ToDateTime("1900-01-01")))
{
dr[ConfineContent._EnjoinOverDate] = content.EnjoinOverDate;
}
dr[ConfineContent._CollectDate] = DateTime.Now;
aideConfineContentProvider.Insert(dr);
}
/// <summary>
/// 获取限制字符
/// </summary>
/// <param name="strString">限制字符表主健</param>
/// <returns></returns>
public ConfineContent GetConfineContentByString(string strString)
{
string sqlQuery = string.Format("(NOLOCK) WHERE String= N'{0}'", strString);
ConfineContent model = aideConfineContentProvider.GetObject <ConfineContent>(sqlQuery);
if (model != null)
{
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新限制字符信息
/// </summary>
/// <param name="content"></param>
public void UpdateConfineContent(ConfineContent content)
{
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("UPDATE ConfineContent SET ")
.Append("EnjoinOverDate=@EnjoinOverDate ")
.Append("WHERE String=@String");
var prams = new List <DbParameter>();
prams.Add(Database.MakeInParam("EnjoinOverDate", content.EnjoinOverDate.Equals(Convert.ToDateTime("1900-01-01")) ? null : content.EnjoinOverDate.ToString()));
prams.Add(Database.MakeInParam("String", content.String));
Database.ExecuteNonQuery(CommandType.Text, sqlQuery.ToString(), prams.ToArray());
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strString = CtrlHelper.GetText(txtString);
//验证数据
if (string.IsNullOrEmpty(StrParam) && string.IsNullOrEmpty(strString))
{
ShowError("限制用户名不能为空");
return;
}
ConfineContent confineContent = new ConfineContent( );
confineContent.String = strString;
confineContent.EnjoinOverDate = string.IsNullOrEmpty(CtrlHelper.GetText(txtEnjoinOverDate)) ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(CtrlHelper.GetText(txtEnjoinOverDate));
Message msg = new Message( );
if (string.IsNullOrEmpty(StrParam))
{
ConfineContent model = aideAccountsFacade.GetConfineContentByString(strString);
if (model != null)
{
ShowError("该限制用户名已经存在");
return;
}
//判断权限
AuthUserOperationPermission(Permission.Add);
msg = aideAccountsFacade.InsertConfineContent(confineContent);
}
else
{
//判断权限
AuthUserOperationPermission(Permission.Edit);
confineContent.String = StrParam;
msg = aideAccountsFacade.UpdateConfineContent(confineContent);
}
if (msg.Success)
{
ShowInfo("操作成功", "ConfineContentList.aspx", 1200);
}
else
{
ShowError(msg.Content, "ConfineContentList.aspx", 1200);
}
}
private void BindData( )
{
if (string.IsNullOrEmpty(StrParam))
{
return;
}
//获取信息
ConfineContent model = aideAccountsFacade.GetConfineContentByString(StrParam);
if (model == null)
{
ShowError("该限制字符不存在");
return;
}
CtrlHelper.SetText(ltString, model.String);
txtString.Visible = false;
CtrlHelper.SetText(txtEnjoinOverDate, model.EnjoinOverDate == DateTime.Now ? "" : model.EnjoinOverDate.ToString("yyyy-MM-dd"));
}
public Message UpdateConfineContent(ConfineContent content)
{
aideAccountsData.UpdateConfineContent(content);
return(new Message(true));
}
public Message InsertConfineContent(ConfineContent content)
{
aideAccountsData.InsertConfineContent(content);
return(new Message(true));
}
