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 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 bool IsExitsMemeber(string Name) { Oss = new OpenSQLSERVER().Start(); string SqlSearchUname = $"select * from MemeberInfo where Name='{Name}'"; bool IsExits = new CreateSQLCommand().ExcuteCountNum(Oss, SqlSearchUname); return(IsExits); }
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); } }
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(); } } }