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("你没有输入任何数据", "错误"); } }