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