/// <summary>
/// 获取限制地址
/// </summary>
/// <param name="strAddress">限制地址表主健</param>
/// <returns></returns>
public ConfineAddress GetConfineAddressByAddress(string strAddress)
{
string sqlQuery = string.Format("(NOLOCK) WHERE AddrString= N'{0}'", strAddress);
ConfineAddress model = aideConfineAddressProvider.GetObject <ConfineAddress>(sqlQuery);
return(model);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strString = CtrlHelper.GetText(txtString);
//验证数据
if (string.IsNullOrEmpty(StrParam) && string.IsNullOrEmpty(strString))
{
ShowError("限制IP地址不能为空");
return;
}
ConfineAddress address = new ConfineAddress( );
address.AddrString = strString;
address.EnjoinLogon = ckbEnjoinLogon.Checked;
address.EnjoinRegister = ckbEnjoinRegister.Checked;
address.EnjoinOverDate = string.IsNullOrEmpty(CtrlHelper.GetText(txtEnjoinOverDate)) ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(CtrlHelper.GetText(txtEnjoinOverDate));
address.CollectNote = TextFilter.FilterAll(CtrlHelper.GetText(txtCollectNote));
Message msg = new Message( );
if (string.IsNullOrEmpty(StrParam))
{
//判断权限
AuthUserOperationPermission(Permission.Add);
if (!Utils.Validate.IsIP(strString))
{
ShowError("该限制IP地址格式不正确");
return;
}
ConfineAddress model = aideAccountsFacade.GetConfineAddressByAddress(strString);
if (model != null)
{
ShowError("该限制IP地址已经存在");
return;
}
msg = aideAccountsFacade.InsertConfineAddress(address);
}
else
{
//判断权限
AuthUserOperationPermission(Permission.Edit);
address.AddrString = StrParam;
msg = aideAccountsFacade.UpdateConfineAddress(address);
}
if (msg.Success)
{
ShowInfo("操作成功", "ConfineAddressList.aspx", 1200); //Server.UrlDecode( GameRequest.GetQueryString("reurl"))
}
else
{
ShowError(msg.Content);
}
}
/// <summary>
/// 数据保存
/// </summary>
protected void btnSave_Click(object sender, EventArgs e)
{
ConfineAddress address = new ConfineAddress();
if (!string.IsNullOrEmpty(StrParam))
{
if (!AuthUserOperationPermission(Permission.Edit))
{
return;
}
address = FacadeManage.aideAccountsFacade.GetConfineAddressByAddress(StrParam);
}
else
{
if (!AuthUserOperationPermission(Permission.Add))
{
return;
}
address.AddrString = CtrlHelper.GetText(txtString);
}
address.EnjoinLogon = ckbEnjoinLogon.Checked;
address.EnjoinRegister = ckbEnjoinRegister.Checked;
address.EnjoinOverDate = string.IsNullOrEmpty(CtrlHelper.GetText(txtEnjoinOverDate)) ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(CtrlHelper.GetText(txtEnjoinOverDate));
address.CollectNote = TextFilter.FilterAll(CtrlHelper.GetText(txtCollectNote));
int result = 0;
if (string.IsNullOrEmpty(StrParam))
{
if (!Utils.Validate.IsIP(address.AddrString))
{
ShowError("该限制IP地址格式不正确");
return;
}
ConfineAddress model = FacadeManage.aideAccountsFacade.GetConfineAddressByAddress(address.AddrString);
if (model != null)
{
ShowError("该限制IP地址已经存在");
return;
}
result = FacadeManage.aideAccountsFacade.InsertConfineAddress(address);
}
else
{
result = FacadeManage.aideAccountsFacade.UpdateConfineAddress(address);
}
if (result > 0)
{
ShowInfo("操作成功", "ConfineAddressList.aspx", 1200);
}
else
{
ShowError("操作失败");
}
}
/// <summary>
/// 新增一条限制地址信息
/// </summary>
/// <param name="address"></param>
public void InsertConfineAddress(ConfineAddress address)
{
DataRow dr = aideConfineAddressProvider.NewRow();
dr[ConfineAddress._AddrString] = address.AddrString;
dr[ConfineAddress._EnjoinLogon] = address.EnjoinLogon;
dr[ConfineAddress._EnjoinRegister] = address.EnjoinRegister;
if (!address.EnjoinOverDate.Equals(Convert.ToDateTime("1900-01-01")))
{
dr[ConfineContent._EnjoinOverDate] = address.EnjoinOverDate;
}
dr[ConfineAddress._CollectNote] = address.CollectNote;
dr[ConfineAddress._CollectDate] = DateTime.Now;
aideConfineAddressProvider.Insert(dr);
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
if (!string.IsNullOrEmpty(StrParam))
{
ConfineAddress model = FacadeManage.aideAccountsFacade.GetConfineAddressByAddress(StrParam);
if (model != null)
{
CtrlHelper.SetText(ltString, model.AddrString);
txtString.Visible = false;
ckbEnjoinLogon.Checked = model.EnjoinLogon;
ckbEnjoinRegister.Checked = model.EnjoinRegister;
CtrlHelper.SetText(txtEnjoinOverDate, model.EnjoinOverDate == null ? "" : Convert.ToDateTime(model.EnjoinOverDate).ToString("yyyy-MM-dd"));
CtrlHelper.SetText(txtCollectNote, model.CollectNote);
}
}
}
/// <summary>
/// 新增限制地址信息
/// </summary>
/// <param name="address">地址信息</param>
/// <returns></returns>
public int InsertConfineAddress(ConfineAddress address)
{
string sqlQuery = "INSERT INTO ConfineAddress VALUES(@AddrString,@EnjoinLogon,@EnjoinRegister,@EnjoinOverDate,@CollectDate,@CollectNote)";
var prams = new List <DbParameter>
{
Database.MakeInParam("AddrString", address.AddrString),
Database.MakeInParam("EnjoinLogon", address.EnjoinLogon),
Database.MakeInParam("EnjoinRegister", address.EnjoinRegister),
Database.MakeInParam("EnjoinOverDate",
address.EnjoinOverDate.Equals(Convert.ToDateTime("1900-01-01"))
? null
: address.EnjoinOverDate.ToString()),
Database.MakeInParam("CollectDate", DateTime.Now),
Database.MakeInParam("CollectNote", address.CollectNote)
};
return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery, prams.ToArray()));
}
/// <summary>
/// 更新限制地址信息
/// </summary>
/// <param name="address">地址信息</param>
/// <returns></returns>
public int UpdateConfineAddress(ConfineAddress address)
{
string sqlQuery = @"UPDATE ConfineAddress SET EnjoinLogon=@EnjoinLogon,EnjoinRegister=@EnjoinRegister,
EnjoinOverDate=@EnjoinOverDate,CollectNote=@CollectNote WHERE AddrString=@AddrString";
var prams = new List <DbParameter>
{
Database.MakeInParam("EnjoinLogon", address.EnjoinLogon),
Database.MakeInParam("EnjoinRegister", address.EnjoinRegister),
Database.MakeInParam("EnjoinOverDate",
address.EnjoinOverDate.Equals(Convert.ToDateTime("1900-01-01"))
? null
: address.EnjoinOverDate.ToString()),
Database.MakeInParam("CollectNote", address.CollectNote),
Database.MakeInParam("AddrString", address.AddrString)
};
return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery, prams.ToArray()));
}
/// <summary>
/// 更新限制地址信息
/// </summary>
/// <param name="address"></param>
public void UpdateConfineAddress(ConfineAddress address)
{
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("UPDATE ConfineAddress SET ")
.Append("EnjoinLogon=@EnjoinLogon, ")
.Append("EnjoinRegister=@EnjoinRegister, ")
.Append("EnjoinOverDate=@EnjoinOverDate, ")
.Append("CollectNote=@CollectNote ")
.Append("WHERE AddrString=@AddrString");
var prams = new List <DbParameter>();
prams.Add(Database.MakeInParam("EnjoinLogon", address.EnjoinLogon));
prams.Add(Database.MakeInParam("EnjoinRegister", address.EnjoinRegister));
prams.Add(Database.MakeInParam("EnjoinOverDate", address.EnjoinOverDate.Equals(Convert.ToDateTime("1900-01-01")) ? null : address.EnjoinOverDate.ToString()));
prams.Add(Database.MakeInParam("CollectNote", address.CollectNote));
prams.Add(Database.MakeInParam("AddrString", address.AddrString));
Database.ExecuteNonQuery(CommandType.Text, sqlQuery.ToString(), prams.ToArray());
}
private void BindData( )
{
if (string.IsNullOrEmpty(StrParam))
{
return;
}
//获取信息
ConfineAddress model = aideAccountsFacade.GetConfineAddressByAddress(StrParam);
if (model == null)
{
ShowError("该限制IP地址不存在");
return;
}
CtrlHelper.SetText(ltString, model.AddrString);
txtString.Visible = false;
ckbEnjoinLogon.Checked = model.EnjoinLogon;
ckbEnjoinRegister.Checked = model.EnjoinRegister;
CtrlHelper.SetText(txtEnjoinOverDate, model.EnjoinOverDate == DateTime.Now ? "" : model.EnjoinOverDate.ToString("yyyy-MM-dd"));
CtrlHelper.SetText(txtCollectNote, model.CollectNote);
}
public Message UpdateConfineAddress(ConfineAddress address)
{
aideAccountsData.UpdateConfineAddress(address);
return(new Message(true));
}
public Message InsertConfineAddress(ConfineAddress address)
{
aideAccountsData.InsertConfineAddress(address);
return(new Message(true));
}
/// <summary>
/// 更新限制地址信息
/// </summary>
/// <param name="address">地址信息</param>
/// <returns></returns>
public int UpdateConfineAddress(ConfineAddress address)
{
return(aideAccountsData.UpdateConfineAddress(address));
}
/// <summary>
/// 新增限制地址信息
/// </summary>
/// <param name="address">地址信息</param>
/// <returns></returns>
public int InsertConfineAddress(ConfineAddress address)
{
return(aideAccountsData.InsertConfineAddress(address));
}
