private async void button_Click(object sender, RoutedEventArgs e)
{
if (selected == 1)
{
await this.ShowMessageAsync("提示", "请先选择操作类型");
}
if (selected == 2)
{
if (comboBox.Text == "")
{
await this.ShowMessageAsync("提示", "请选择要删除的栋号");
}
else
{
string s = "select * from DS where buildingnum='" + comboBox.Text + "'";
DataTable d = mysql.ExecuteQuery(s);
if (d.Rows.Count != 0)
{
await this.ShowMessageAsync("提示", "该寝室楼有人入住，不能删除");
}
else
{
MessageDialogResult result = await this.ShowMessageAsync("删除信息", "您真的要删除该寝室楼信息吗?", MessageDialogStyle.AffirmativeAndNegative);
if (result != MessageDialogResult.Negative)
{
mysql.ExecuteUpdate("delete from broom where buildingnum='" + comboBox.Text + "'");
await this.ShowMessageAsync("提示", "删除成功");
this.Close();
}
}
}
}
if (selected == 3)
{
Progress1.IsActive = true;
DataTable d = mysql.ExecuteQuery("select MAX(buildingnum) from broom");
int buildingnum = int.Parse(d.Rows[0][0].ToString()) + 1;
string b = buildingnum.ToString();
string brsex = comboBox1.Text;
string size = comboBox2.Text;
int Size = int.Parse(size);
int num = int.Parse(textBox.Text); //层数
int num1 = int.Parse(textBox1.Text); //每层房间数
for (int i = 1; i <= num; i++)
{
for (int j = 1; j <= num1; j++)
{
int temp = i * 100 + j;
string t = temp.ToString();
mysql.ExecuteUpdate("insert into broom values('" + b + "','" + t + "','" + brsex + "','" + Size + "')");
}
}
Progress1.IsActive = false;
await this.ShowMessageAsync("提示", "成功");
this.Close();
}
}
private async void button_Click(object sender, RoutedEventArgs e)
{
if (comboBox.Text == "" || comboBox1.Text == "" || textBox2.Text == "")
{
await this.ShowMessageAsync("提示", "信息填写不完整");
}
else
{
try {
string build = Source.build;
string roomnum = comboBox.Text;
string sid = comboBox1.Text;
string nowtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string thing = textBox2.Text;
string s = "Insert into Late values('" + build + "','" + roomnum + "','" + sid + "','" + nowtime + "','" + thing + "')";
mysql.ExecuteUpdate(s);
this.Close();
mainlate.dataGrid.ItemsSource = mysql.ExecuteQuery("select roomnum as '寝室号',sid as '学号',time as '时间',thing as '原因' from Late where buildingnum= '" + Source.build + "'").DefaultView;//刷新表格
}
catch (Exception ex)
{
await this.ShowMessageAsync("错误", ex.ToString());
}
}
}
private async void button_Click(object sender, RoutedEventArgs e)
{
string ornot = choice.Text;
string sassess = infoBox.Text;
if (ornot == "" || sassess == "")
{
await this.ShowMessageAsync("提示", "请输入完整信息");
}
else
{
string time;
System.DateTime dateTime = new System.DateTime();
dateTime = System.DateTime.Now;
time = dateTime.Year.ToString() + "-" + toStd(dateTime.Month) + "-" + toStd(dateTime.Day);
string sql = "update record set oassess= '" + ornot + "',sassess = '" + sassess + "' ,status = '" + 3 + "', repaireddate = '" + time + "' where recordid = '" + recordid + "'";
try
{
mYSql.ExecuteUpdate(sql);
await this.ShowMessageAsync("提示", "修改完成");
}
catch (Exception ex)
{
await this.ShowMessageAsync("提示", ex.ToString());
}
}
}
private async void button_Click(object sender, RoutedEventArgs e)
{
IntPtr p = System.Runtime.InteropServices.Marshal.SecureStringToBSTR(this.passwordBox.SecurePassword);
string password = System.Runtime.InteropServices.Marshal.PtrToStringBSTR(p);
IntPtr p1 = System.Runtime.InteropServices.Marshal.SecureStringToBSTR(this.passwordBox1.SecurePassword);
string password1 = System.Runtime.InteropServices.Marshal.PtrToStringBSTR(p1);
MYSql mysql = new MYSql();
if (textBox.Text == "" || password == "" || password1 == "")
{
await this.ShowMessageAsync("提示", "信息填写不完整");
}
else
{
string username = textBox.Text.Trim();
string s1 = "select wnum,pwd from worker where wnum='" + username + "' and pwd='" + password + "'";
DataTable dt = new DataTable();
dt = mysql.ExecuteQuery(s1);
if (dt != null && dt.Rows.Count > 0)
{
string s2 = "update worker set pwd='" + password1 + "'where wnum='" + username + "'";
int n = mysql.ExecuteUpdate(s2);
if (n != 0)
{
await this.ShowMessageAsync("提示", "修改成功");
this.Close();
}
}
else
{
await this.ShowMessageAsync("提示", "用户名或旧密码输入错误");
}
}
}
private async void button_Click(object sender, RoutedEventArgs e)//确定
{
if (textBox.Text == "" || textBox1.Text == "")
{
await this.ShowMessageAsync("提示", "信息填写不完整");
}
else
{
try
{
string currenttime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string name = textBox.Text;
string thing = textBox1.Text;
string build = Source.build;
string s = "Insert into Come values('" + build + "','" + name + "','" + currenttime + "','" + thing + "')";
mysql.ExecuteUpdate(s);
this.Close();
maincome.dataGrid.ItemsSource = mysql.ExecuteQuery("select ctime as '时间',name as '姓名',thing as '原因' from Come where buildingnum='" + Source.build + "'").DefaultView;//刷新新表格
}
catch (Exception ex)
{
await this.ShowMessageAsync("错误", ex.ToString());
}
}
}
private async void button_Click(object sender, RoutedEventArgs e)
{
string time = Convert.ToDateTime(datepicker.Text).ToString("yyyy-MM-dd");
string rid = recomboBox.Text;
string sql = "update record set repairdate = '" + time + "',rid = '" + rid + "' ,status = '" + 2 + "' where recordid = '" + id + "'";
try
{
mysql.ExecuteUpdate(sql);
await this.ShowMessageAsync("提示", "成功安排修理工作");
}catch (Exception ex)
{
await this.ShowMessageAsync("提示", ex.ToString());
}
}
private async void MenuItem_Click_2(object sender, RoutedEventArgs e)//删除
{
MessageDialogResult result1 = await this.ShowMessageAsync("删除信息", "您真的要删除吗?", MessageDialogStyle.AffirmativeAndNegative);
if (result1 != MessageDialogResult.Negative)//取消
{
DataRowView d = (DataRowView)this.dataGrid.SelectedItems[this.dataGrid.SelectedItems.Count - 1];
string result = d.Row[0].ToString();
string s = "delete from worker where wnum='" + result + "'";
mysql.ExecuteUpdate(s);
await this.ShowMessageAsync("提示", "删除成功");
this.dt.Rows.Remove(d.Row);
}
}
private async void button_Click(object sender, RoutedEventArgs e)//办理入住
{
MYSql mysql = new MYSql();
if (asize + 1 > maxsize)
{
await this.ShowMessageAsync("提示", "该宿舍已经满员");
}
else
{
string sid = textBox.Text;
string year = yearBox.Text;
if (sid == "")
{
await this.ShowMessageAsync("提示", "请勿输入空值");
}
else
{
if (!getstu().Contains(sid))
{
await this.ShowMessageAsync("提示", "此学生已有住宿信息或不存在此学号");
}
else
{
string s = "insert into DS(buildingnum,roomnum,sid,livetime)values('" + buildingnum + "','" + roomnum + "','" + sid + "','" + year + "')";
if (GetSex(sid).Equals(sex[0].ToString()) == true)
{
mysql.ExecuteUpdate(s);
await this.ShowMessageAsync("提示", "插入成功");
this.Close();
drmain.first();
}
else
{
await this.ShowMessageAsync("提示", "不能将" + GetSex(sid) + "生添加进" + sex[0] + "寝室");
}
}
}
}
}
private async void button_Click(object sender, RoutedEventArgs e)//修改
{
string ss = comboBox.Text;
if (ss == "")
{
await this.ShowMessageAsync("提示", "请选择栋号");
}
else
{
MessageDialogResult result1 = await this.ShowMessageAsync("修改信息", "您真的要修改吗?", MessageDialogStyle.AffirmativeAndNegative);
if (result1 != MessageDialogResult.Negative)//取消
{
string s = "update worker set bnum='" + ss + "'where wnum='" + label3.Content + "'";
mysql.ExecuteUpdate(s);
await this.ShowMessageAsync("提示", "修改成功");
man.dataGrid.ItemsSource = mysql.ExecuteQuery("select wnum as '工号',wname as '姓名',bnum as '管理栋号' from worker").DefaultView;
this.Close();
}
}
}
private async void MenuItem_Click_1(object sender, RoutedEventArgs e)//删除寝室
{
DataRowView d = (DataRowView)this.dataGrid.SelectedItems[this.dataGrid.SelectedItems.Count - 1];
if (d.Row[4].ToString() != "0")
{
await this.ShowMessageAsync("提示", "该寝室不可删除");
}
else
{
MessageDialogResult result1 = await this.ShowMessageAsync("删除信息", "您真的要删除吗?", MessageDialogStyle.AffirmativeAndNegative);
if (result1 != MessageDialogResult.Negative)//取消
{
string result2 = d.Row[0].ToString();
string result3 = d.Row[1].ToString();
String s = "delete from broom where buildingnum = '" + result2 + "' and roomnum = '" + result3 + "'";
mysql.ExecuteUpdate(s);
await this.ShowMessageAsync("提示", "删除成功");
this.dt.Rows.Remove(d.Row);
}
}
}
private async void button2_Click(object sender, RoutedEventArgs e)
{
GetInfo getInfo = new GetInfo();
string sid = textBox.Text.Trim();
string newroomnum = textBox1.Text.Trim();
MYSql mysql = new MYSql();
string s;
if (selected == 0 || selected == 2 || selected == 1)
{
if (newroomnum == "" || sid == "")
{
await this.ShowMessageAsync("提示", "您还有属性未填写");
}
else
{
if (selected == 0)
{
await this.ShowMessageAsync("提示", "请先选择更改属性");
}
if (selected == 1)//修改个人
{
string newbuildingnum = comboBox1.SelectedValue.ToString().Replace("System.Windows.Controls.ComboBoxItem: ", "");
if (Getin(newbuildingnum, newroomnum, 1))
{
s = "update DS set buildingnum = '" + newbuildingnum + "' ,roomnum = '" + newroomnum + "' where sid = '" + sid + "'";//sql语句
MessageDialogResult result = await this.ShowMessageAsync("更改信息", "您真的要修改吗?", MessageDialogStyle.AffirmativeAndNegative);
if (result != MessageDialogResult.Negative)//取消
{
if (getInfo.setin(sid, newbuildingnum))
{
try
{
mysql.ExecuteUpdate(s);
await this.ShowMessageAsync("提示", "修改成功");
this.Close();
}
catch
{
await this.ShowMessageAsync("提示", "无此寝室号");
}
}
else
{
await this.ShowMessageAsync("提示", "不同性别学生不能安排在同一寝室");
}
}
}
else
{
await this.ShowMessageAsync("提示", "寝室无空余床位或是无此寝室号");
}
}
if (selected == 2)//修改整个寝室
{
string newbuildingnum = comboBox1.SelectedValue.ToString().Replace("System.Windows.Controls.ComboBoxItem: ", "");
string oldbuildingnum = comboBox2.SelectedValue.ToString().Replace("System.Windows.Controls.ComboBoxItem: ", "");
if (Getin(newbuildingnum, newroomnum, 2))
{
s = "update DS set buildingnum = '" + newbuildingnum + "',roomnum = '" + newroomnum + "'where buildingnum ='" + sid + "'and roomnum ='" + oldbuildingnum + "'";
MessageDialogResult result = await this.ShowMessageAsync("更改信息", "您真的要修改吗?", MessageDialogStyle.AffirmativeAndNegative);
if (result != MessageDialogResult.Negative)//取消
{
if ((Convert.ToInt32(newbuildingnum) % 2) != (Convert.ToInt32(oldbuildingnum) % 2))
{
await this.ShowMessageAsync("提示", "不同性别不能安排在同一个寝室楼");
}
else
{
try
{
mysql.ExecuteUpdate(s);
await this.ShowMessageAsync("提示", "修改成功");
this.Close();
}
catch
{
await this.ShowMessageAsync("提示", "无此寝室号");
}
}
}
}
else
{
await this.ShowMessageAsync("提示", "寝室无空余床位或是无此寝室号");
}
}
}
}
else if (selected == 3)
{
string year = yeartextbox.Text;
if (year == "")
{
await this.ShowMessageAsync("提示", "请输入年份");
}
else
{
AGSI gs = new AGSI(year);
try
{
Progress1.IsActive = true;
gs.DAlloc();
Progress1.IsActive = false;
await this.ShowMessageAsync("提示", "完成");
}
catch (Exception ex)
{
await this.ShowMessageAsync("异常", ex.ToString());
}
this.Close();
}
}
}
