private void Login_Form_LoginButton_Click(object sender, EventArgs e)
{
ShowMessageBox SMB = new ShowMessageBox();
try
{
if (Login_Form_UserName.Text.Trim() == "" && Login_Form_UserPassword.Text.Trim() == "")
{
SMB.ShowError("请输入账号密码", "错误");
}
else
{
SqlConnection LoginConnectResult = null;
OpenSQLSERVER OSS = new OpenSQLSERVER();
LoginConnectResult = OSS.Start();
SqlCommand SQLCMD = LoginConnectResult.CreateCommand();
SQLCMD.CommandType = CommandType.Text;
SQLCMD.CommandText = $"select UserName from Super_Info";
SqlDataReader UnameRead = SQLCMD.ExecuteReader();
if (UnameRead.Read())
{
string ReaderUserName = UnameRead["UserName"].ToString();
if (ReaderUserName == Login_Form_UserName.Text.Trim())
{
UnameRead.Close();
SQLCMD.CommandText = "select PassWord from Super_Info";
SqlDataReader PassWordRead = SQLCMD.ExecuteReader();
if (PassWordRead.Read())
{
string ReaderPassWord = PassWordRead["PassWord"].ToString();
if (ReaderPassWord == Login_Form_UserPassword.Text.Trim())
{
SMB.ShowInforMation("登录成功", "提示");
PassWordRead.Close();
LoginConnectResult.Close();
Hide();
MemberInfoForm MIF = new MemberInfoForm();
MIF.Show();
}
else
{
SMB.ShowError("密码错误,请重新登录", "错误");
}
}
}
else
{
SMB.ShowError("账号错误,请重新登录", "错误");
}
}
}
}
catch (Exception ErrorMessage)
{
WriteLog WLG = new WriteLog();
WLG.WriteToLogFile(ErrorMessage.Message);
SMB.ShowError("数据库连接失败，可能是以下原因：\n1.数据库的账号密码没有设为sa/123456\n2.数据库端口没有启动\n3.数据库服务没有启动\n4.其他异常问题\n请检查之后重试。", "错误");
}
}
public DeleteUserById(int id)
{
int Lines = 0;
SqlConnection DelSQl = null;
OpenSQLSERVER OSS = new OpenSQLSERVER();
DelSQl = OSS.Start();
SqlCommand SCD = DelSQl.CreateCommand();
SCD.CommandType = CommandType.Text;
SCD.CommandText = $"delete from MemeberInfo where id={id}";
Lines = SCD.ExecuteNonQuery();
if (Lines != 0)
{
ShowMessageBox SMB = new ShowMessageBox();
SMB.ShowInforMation("删除成功", "提示");
MemberInfoForm MIF = new MemberInfoForm();
}
else
{
//
}
}
private void StartQuerry_Click(object sender, EventArgs e)
{
ShowMessageBox SMB = new ShowMessageBox();
MemberInfoForm MIF = (MemberInfoForm)this.Owner;//子窗体向父窗体传值
QueryUserInfoLimit QIL = new QueryUserInfoLimit();
if (QueryUserName.Text.Trim() != "")
{
DataTable DTLU = QIL.LimtQueryByUname(QueryUserName.Text.Trim());
if (DTLU == null)
{
SMB.ShowInforMation("没有找到相关数据", "信息");
QIL.Close();
}
else
{
MIF.MemeberDataView.DataSource = DTLU.DefaultView;
MIF.MemeberDataView.Columns[6].Visible = false;
string[] InfoArray = new string[] { "会员姓名", "年龄", "性别", "注册日期", "上次来访时间", "生日" };
for (int Index = 0; Index < 6; Index++)
{
MIF.MemeberDataView.Columns[Index].HeaderText = InfoArray[Index];
MIF.MemeberDataView.Columns[Index].ReadOnly = true;
}
QIL.Close();
this.Close();//待异步优化
}
}
else if (QueryUserBriday.Text.Trim() != "")
{
DataTable DTLU = QIL.LimitQueryByBrithDay(QueryUserBriday.Text.Trim());
if (DTLU == null)
{
SMB.ShowInforMation("没有找到相关数据", "提示");
QIL.Close();
}
else
{
MIF.MemeberDataView.DataSource = DTLU.DefaultView;
MIF.MemeberDataView.Columns[6].Visible = false;
string[] InfoArray = new string[] { "会员姓名", "年龄", "性别", "注册日期", "上次来访时间", "生日" };
for (int Index = 0; Index < 6; Index++)
{
MIF.MemeberDataView.Columns[Index].HeaderText = InfoArray[Index];
MIF.MemeberDataView.Columns[Index].ReadOnly = true;
}
QIL.Close();
this.Close();
}
}
else if (QueryUserName.Text.Trim() != "" && QueryUserName.Text.Trim() != "")
{
DataTable DTLU = QIL.LimitBoth(QueryUserBriday.Text.Trim(), QueryUserName.Text.Trim());
if (DTLU == null)
{
SMB.ShowInforMation("没有找到相关数据", "提示");
QIL.Close();
}
else
{
MIF.MemeberDataView.DataSource = DTLU.DefaultView;
MIF.MemeberDataView.Columns[6].Visible = false;
string[] InfoArray = new string[] { "会员姓名", "年龄", "性别", "注册日期", "上次来访时间", "生日" };
for (int Index = 0; Index < 6; Index++)
{
MIF.MemeberDataView.Columns[Index].HeaderText = InfoArray[Index];
MIF.MemeberDataView.Columns[Index].ReadOnly = true;
}
QIL.Close();
this.Close();
}
}
else
{
SMB.ShowError("你没有输入任何数据", "错误");
}
}
