public void MyBind()
{
M_UserRegisterIP userRegIP = B_UserRegisterIP.GetRegisterIPAll();
if (userRegIP != null && userRegIP.Id > 0)
{
RBLDZ.Checked = userRegIP.IsLimit.ToString() == "true" ? true : false;
txtLimitTime.Text = userRegIP.LimitTime.ToString();
RadioButtonList1.Checked = userRegIP.IsIPpart.ToString() == "0" ? true : false;
if (RadioButtonList1.Checked == true)
{
IPpart.Visible = false;
}
if (userRegIP.BeginIP != null && userRegIP.BeginIP != "" && userRegIP.EndIP != null && userRegIP.EndIP != "")
{
txtBeginIP.Text = userRegIP.BeginIP.ToString();
txtEndIP.Text = userRegIP.EndIP.ToString();
}
}
}
public static M_UserRegisterIP GetRegisterIPAll()
{
string sqlStr = "SELECT * FROM ZL_UserRegisterIP where Id = 1";
M_UserRegisterIP registerIP = new M_UserRegisterIP();
using (SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, sqlStr))
{
if (reader.Read())
{
registerIP.Id = DataConverter.CLng(reader["Id"].ToString());
registerIP.LimitTime = DataConverter.CLng(reader["LimitTime"].ToString());
registerIP.IsLimit = DataConverter.CLng(reader["IsLimit"].ToString());
registerIP.IsIPpart = DataConverter.CLng(reader["IsIPpart"].ToString());
registerIP.BeginIP = reader["BeginIP"].ToString();
registerIP.EndIP = reader["EndIP"].ToString();
}
reader.Close();
reader.Dispose();
}
return(registerIP);
}
