private void btnSubmit_Click(object sender, EventArgs e) { //接收界面参数 building t = new building(); t.buildId = int.Parse(this.txtTypeId.Text); t.buildName = this.txtTypeName.Text; t.dormCount = this.txtMemo.Text; t.dromFloor = this.txtdormFloor.Text; string reply1 = "亲,楼层名不能为空哦!"; string reply2 = "亲,人数不能为空哦!"; string reply3 = "亲,所在楼层不能为空哦!"; //文本框校验 if (Validation.checktxt(t.buildName, ref reply1)) { return; } if (Validation.checktxt(t.dormCount, ref reply2)) { return; } if (Validation.checktxt(t.dromFloor, ref reply3)) { return; } wsm.update(t); //刷新manager窗体的dgv //SingleWindow.ttmf.flush(); //关闭当前窗体 this.Close(); MessageBox.Show("修改成功!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); }
public void update(building t) { SqlConnection conn = new SqlConnection("server=" + MyGlobal.ip + ";database=dormitory;UID=sa;PWD=zyh@197068;Integrated Security=False"); conn.Open(); string mysql = string.Format("update building set buildName = '{0}',dormCount = '{1}',dormFloor = '{2}' where buildId = {3}", t.buildName, t.dormCount, t.dromFloor, t.buildId); SqlCommand sql = new SqlCommand(mysql, conn); SqlDataReader reader = sql.ExecuteReader(); reader.Close(); conn.Close(); }
//专门用来添加数据的方法 /// sql语句可以连接数据库进行操作数据 public void insert(building t) { SqlConnection conn = new SqlConnection("server=" + MyGlobal.ip + ";database=dormitory;UID=sa;PWD=zyh@197068;Integrated Security=False"); conn.Open(); string mysql = string.Format("insert into building(buildName,dormCount,dormFloor) values('{0}','{1}','{2}')", t.buildName, t.dormCount, t.dromFloor); SqlCommand sql = new SqlCommand(mysql, conn); SqlDataReader reader = sql.ExecuteReader(); reader.Close(); conn.Close(); }
/*****************变量声明结束*******************************/ public void flush() { //创建实体类对象 building t = new building(); //处理界面参数 t.buildName = this.txtDromName.Text; //查询总条数 page.count = wsm.count(t); //将数据库中的内容显示到界面上 this.dgvbuilding.DataSource = wsm.findAll(t, page); //给页面上的控件赋值 this.lblPage.Text = "当前:" + page.nowPage + "页 共:" + page.getTotalPage() + "页 总计:" + page.count + "条"; }
public int count(building t) { SqlConnection conn = new SqlConnection("server=" + MyGlobal.ip + ";database=dormitory;UID=sa;PWD=zyh@197068;Integrated Security=False"); conn.Open(); string mysql = string.Format("select * from building where buildName like '%{0}%'", t.buildName); SqlCommand sql = new SqlCommand(mysql, conn); SqlDataReader reader = sql.ExecuteReader(); DataTable dt = new DataTable(); while (reader.Read())//决定行数 { dt.Columns.Add(reader.ToString()); } reader.Close(); conn.Close(); return(dt.Rows.Count); }
public DataTable findAll(building t, PageHelper page) { SqlConnection conn = new SqlConnection("server=" + MyGlobal.ip + ";database=dormitory;UID=sa;PWD=zyh@197068;Integrated Security=False"); conn.Open(); string mysql = string.Format("select * from building where buildName like '%{0}%' order by buildId asc limit {1},{2} ", t.buildName, page.getBegin(), page.pageSize); SqlCommand sql = new SqlCommand(mysql, conn); SqlDataReader reader = sql.ExecuteReader(); DataTable dt = new DataTable(); while (reader.Read())//决定行数 { dt.Columns.Add(reader.ToString()); } reader.Close(); conn.Close(); return(dt); }
public void delete(building t) { SqlConnection conn = new SqlConnection("server=" + MyGlobal.ip + ";database=dormitory;UID=sa;PWD=zyh@197068;Integrated Security=False"); conn.Open(); string mysql = string.Format("delete from building where buildId = {0}", t.buildId); SqlCommand sql = new SqlCommand(mysql, conn); SqlDataReader reader; try { reader = sql.ExecuteReader(); reader.Close(); conn.Close(); } catch (Exception e) { System.Windows.Forms.MessageBox.Show("该项正在被使用,无法删除!", "温馨提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Asterisk); } }