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