public bool AddMemeberAction(string Name, int Age, string Sex, string Briday) { string NowTime = DateTime.Now.ToString("yyyy/MM/dd"); string InsertIntoSqlString = $"insert into MemeberInfo values('{Name}',{Age},'{Sex}','{NowTime}','{NowTime}','{Briday}')"; bool MemeberExits = IsExitsMemeber(Name); if (MemeberExits == false) { SqlConnection Oss = new OpenSQLSERVER().Start(); int WriteState = new CreateSQLCommand().ExcuteSqlStr(Oss, InsertIntoSqlString); if (WriteState != 0) { return(true); } else { return(false); } } else { new ShowMessageBox().ShowInforMation("暂时无法修改已有会员数据,请等待下一版本更新", "提示"); return(false); } }
public DataTable QueryData() { try { SqlConnection SQlConRsul = null; OpenSQLSERVER OSL = new OpenSQLSERVER(); SQlConRsul = OSL.Start(); string SQLstring = "select * from MemeberInfo"; SqlDataAdapter SDA = new SqlDataAdapter(SQLstring, SQlConRsul); DataSet DST = new DataSet(); SDA.Fill(DST); string a = DST.Tables[0].Rows[0].ToString(); DataTable ReturnTable = DST.Tables[0]; SQlConRsul.Close(); //OSL.Close(); return(ReturnTable); } catch (Exception ERROR) { ShowMessageBox SMB = new ShowMessageBox(); SMB.ShowError("发生错误,请检查数据库连接", "错误"); WriteLog W = new WriteLog(); W.WriteToLogFile(ERROR.Message); return(null); } }
public void AddMemberRecord(string Name) { bool state = CheckMember(Name); if (state) { string NowTime = DateTime.Now.ToString("yyyy/MM/dd"); string UpdateStr = $"update MemeberInfo set FirstTime_Come='{NowTime}',LeaveTime='{NowTime}' where Name='{Name}'"; SqlConnection Oss = new OpenSQLSERVER().Start(); int ReturnCode = new CreateSQLCommand().ExcuteSqlStr(Oss, UpdateStr); if (ReturnCode != 0) { new ShowMessageBox().ShowInforMation("已记录会员来访", "提示"); new WriteLog().WriteToLogFile($"会员来访:会员名称:{Name}"); } else { new ShowMessageBox().ShowError("记录出错,可能和服务器短裤连接", "错误"); } } else { new ShowMessageBox().ShowError("没有找到会员,请确认后重试", "错误"); } }
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请检查之后重试。", "错误"); } }
private bool CheckMember(string Name) { string SQSTR = $"select * from MemeberInfo where Name='{Name}'"; SqlConnection OSS = new OpenSQLSERVER().Start(); bool state = new CreateSQLCommand().ExcuteCountNum(OSS, SQSTR); if (state == true) { return(true); } else { return(false); } }
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 ChangeButton_Click(object sender, EventArgs e) { if (ChangeText.Text.Trim() == "") { new ShowMessageBox().ShowError("密码不能为空", "错误"); } else { OpenSQLSERVER OSS = new OpenSQLSERVER(); SqlConnection SRLT = OSS.Start(); string ChangeSqlStr = $"update Super_Info set PassWord='******' where UserName='******'"; int ResultCode = new CreateSQLCommand().ExcuteSqlStr(SRLT, ChangeSqlStr); if (ResultCode != 0) { new ShowMessageBox().ShowInforMation("修改成功,密码将在下一次打开软件时生效", "提示"); this.Close(); } else { new ShowMessageBox().ShowError("修改失败", "没有找到匹配的用户名"); this.Close(); } } }