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