public void DAlloc() { prepare(); StudentToDB(); string sx = slist[10].sid; List <Student> boy = new List <Student>(); List <Student> girl = new List <Student>(); for (int i = 0; i < slist.Count; i++) { if (slist[i].ssex.Equals("男")) { boy.Add(slist[i]); } else { girl.Add(slist[i]); } } List <Room> boyroom = geteRoom("男生宿舍"); List <Room> girlroom = geteRoom("女生宿舍"); //安排男生入住 string s = boyroom[11].brsex; MYSql mysql = new MYSql(); int stu = 0; for (int i = 0; i < boyroom.Count; i++) { int maxsize = getMaxsize(boyroom[i].buildingnum, boyroom[i].roomnum); int asize = getacsize(boyroom[i].buildingnum, boyroom[i].roomnum); for (; stu < boy.Count; stu++) { if (asize == maxsize) { break; } string year = "20" + boy[stu].sid.Substring(0, 2); string intoDS = "insert into DS(buildingnum,roomnum,sid,livetime)values('" + boyroom[i].buildingnum + "','" + boyroom[i].roomnum + "','" + boy[stu].sid + "','" + year + "')"; mysql.ExecuteQuery(intoDS); asize++; } } stu = 0; for (int i = 0; i < girlroom.Count; i++) { int asize = getacsize(girlroom[i].buildingnum, girlroom[i].roomnum); int maxsize = getMaxsize(girlroom[i].buildingnum, girlroom[i].roomnum); for (; stu < girl.Count; stu++) { if (asize == maxsize) { break; } string year = "20" + girl[stu].sid.Substring(0, 2); string intoDS = "insert into DS(buildingnum,roomnum,sid,livetime)values('" + girlroom[i].buildingnum + "','" + girlroom[i].roomnum + "','" + girl[stu].sid + "','" + year + "')"; mysql.ExecuteQuery(intoDS); asize++; } } }
private async void button_Click(object sender, RoutedEventArgs e)//增加寝室 { string buildingnum = textBox.Text; string roomnum = textBox1.Text; string sex = textBox3.Text; int size; if (buildingnum == "" || roomnum == "" || sex == "" || textBox2.Text == "") { await this.ShowMessageAsync("提示", "请输入完整信息"); } //性别选项 try { size = Convert.ToInt32(textBox2.Text); string s = "insert into DS(buildingnum,roomnum,brsex,size)values('" + buildingnum + "','" + sex + "','" + roomnum + "','" + size + "')"; MYSql mYSql = new MYSql(); try { mYSql.ExecuteQuery(s); await this.ShowMessageAsync("提示", "修改成功"); } catch { await this.ShowMessageAsync("提示", "已存在该宿舍"); } } catch { await this.ShowMessageAsync("提示", "数据未按格式输入"); } }
private async void button_Click(object sender, RoutedEventArgs e)//添加 { string buildingnum; string wnum; GetInfo g = new GetInfo(); buildingnum = comboBox.SelectedValue.ToString().Replace("System.Windows.Controls.ComboBoxItem: ", ""); int num = g.getMnum(buildingnum) + 1; wnum = "00" + buildingnum + "00" + num.ToString(); string wname = textBox1.Text; string pwd = "111111"; labelwnum.Content = wnum; string s = "insert into worker(wnum,wname,bnum,pwd)values('" + wnum + "','" + wname + "','" + buildingnum + "','" + pwd + "')"; if (wname == "" || buildingnum == "") { await this.ShowMessageAsync("提示", "请输入完整的信息"); } MYSql mYSql = new MYSql(); try { mYSql.ExecuteQuery(s); await this.ShowMessageAsync("提示", "插入成功,新的工号是" + wnum); man.dataGrid.ItemsSource = mYSql.ExecuteQuery("select wnum as '工号',wname as '姓名',bnum as '管理栋号' from worker").DefaultView; this.Close(); } catch (Exception ex) { await this.ShowMessageAsync("提示", "未插入成功,已有此工号" + ex); } }
public static DataTable changeDt() { MYSql mysql = new MYSql(); string s = "select wnum as '工号',wname as '姓名',bnum as '管理栋号' from worker"; return(dt = mysql.ExecuteQuery(s)); }
public Boolean setin(string id, string bunum) { MYSql mYSql = new MYSql(); string sql = "select Ssex from student where sid = '" + id + "'";; DataTable dt = mYSql.ExecuteQuery(sql); if (dt.Rows.Count == 0) { return(false); } string sex = dt.Rows[0]["Ssex"].ToString(); if (sex == "男") { if (Convert.ToInt32(bunum) % 2 == 0) { return(true); } else { return(false); } } else { if (Convert.ToInt32(bunum) % 2 != 0) { return(true); } else { return(false); } } }
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("提示", "用户名或旧密码输入错误"); } } }
public String GetSex(string id) { string s = "select Ssex from student where sid = '" + id + "'"; MYSql mYSql = new MYSql(); DataTable dt = mYSql.ExecuteQuery(s); return(dt.Rows[0]["Ssex"].ToString()); }
public DataTable getRepairman() { MYSql mYSql = new MYSql(); DataTable dt = new DataTable(); dt = mYSql.ExecuteQuery("select rid from repairman"); return(dt); }
public int getMnum(string buildingnum) { string s = "select count(*) as num from worker group by bnum"; MYSql mYSql = new MYSql(); DataTable dt = mYSql.ExecuteQuery(s); int num = Convert.ToInt32(dt.Rows[0]["num"]); return(num); }
public string GetBuildingnum(string wnum) { MYSql mYSql = new MYSql(); DataTable dt = new DataTable(); dt = mYSql.ExecuteQuery("select bnum from worker where wnum = '" + wnum + "'"); string bnum = dt.Rows[0]["bnum"].ToString(); return(bnum); }
public List <String> getstu() { List <string> slist = new List <String>(); MYSql mYSql = new MYSql(); DataTable dt = mYSql.ExecuteQuery("select sid from student where sid not in (select sid from DS)"); for (int i = 0; i < dt.Rows.Count; i++) { slist.Add(dt.Rows[i]["sid"].ToString()); } return(slist); }
public bool notin(string id) { string sql = "select sid from DS where sid ='" + id + "'"; MYSql mYSql = new MYSql(); DataTable dt = mYSql.ExecuteQuery(sql); try { string ids = dt.Rows[0]["sid"].ToString(); return(false); } catch { return(true); } }
public int getacsize(string buildingnum, string roomnum) { string s = "select count(*) as size from DS where buildingnum = '" + buildingnum + "' and roomnum = '" + roomnum + "'"; int size; MYSql mYSql = new MYSql(); DataTable dt = mYSql.ExecuteQuery(s); if (dt.Rows[0]["size"] == null) { size = 0; } else { size = Convert.ToInt32(dt.Rows[0]["size"]); } return(size); }
/// <summary> /// 自动为学生分配寝室 /// </summary> public List <Room> geteRoom(string sex) { MYSql mYSql = new MYSql(); List <Room> roomlist = new List <Room>(); string sql = "select * from broom where brsex = '" + sex + "'"; DataTable dt = mYSql.ExecuteQuery(sql); for (int i = 0; i < dt.Rows.Count; i++) { string buildingnum = dt.Rows[i]["buildingnum"].ToString(); string roomnum = dt.Rows[i]["roomnum"].ToString(); string brsex = dt.Rows[i]["brsex"].ToString(); int size = Convert.ToInt32(dt.Rows[i]["size"]); roomlist.Add(new Room(buildingnum, roomnum, brsex, size)); } return(roomlist); }
public bool Getin(string buildingnum, string roomnum, int type) //type等于1 判断一个人入住,等于2 判断两个人入住情况 { int size; buildingnum = buildingnum.Replace("System.Windows.Controls.ComboBoxItem: ", ""); MYSql mYSql = new MYSql(); DataTable dt = mYSql.ExecuteQuery("select 'size'=count(*) from DS where buildingnum = '" + buildingnum + "' and roomnum = '" + roomnum + "'"); if (dt.Rows.Count == 0) { size = 0; return(true); } size = Convert.ToInt32(dt.Rows[0]["size"]); dt = mYSql.ExecuteQuery("select size from broom where buildingnum = '" + buildingnum + "' and roomnum = '" + roomnum + "'"); if (dt.Rows.Count == 0) { return(false); } int maxsize = Convert.ToInt32(dt.Rows[0]["size"]); switch (type) { case 1: if (size == maxsize) { return(false); } else { return(true); } case 2: if (size != 0) { return(false); } return(true); default: break; } return(false); }
public string[] GetTable(string sid) { string[] temp = { "", "" }; string sql = "select buildingnum,roomnum from DS where sid = '" + sid + "'"; DataTable dt = new DataTable(); MYSql mysql = new MYSql(); dt = mysql.ExecuteQuery(sql); try { temp[0] = dt.Rows[0]["buildingnum"].ToString(); temp[1] = dt.Rows[0]["roomnum"].ToString(); } catch (Exception ex) { temp[0] = "error"; temp[1] = "error"; } return(temp); }
private async void button_Click(object sender, RoutedEventArgs e) { string info = infoBox.Text; string time; System.DateTime dateTime = new System.DateTime(); dateTime = System.DateTime.Now; time = dateTime.Year.ToString() + "-" + toStd(dateTime.Month) + "-" + toStd(dateTime.Day); MYSql mYSql = new MYSql(); string sql = "insert into record(content,buildingnum,roomnum,status,redate)values('" + info + "','" + buildingnum + "','" + roomnum + "','" + 1 + "','" + time + "')"; try { mYSql.ExecuteQuery(sql); await this.ShowMessageAsync(buildingnum + "栋" + roomnum + "号寝室", "您的信息已提交"); }catch (Exception ex) { await this.ShowMessageAsync(ex.ToString(), ""); } }
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 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(); } } }