private void submitBtn_Click(object sender, EventArgs e) { if (MessageBox.Show("确定添加记录?", "JinZhan", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK) { this.hireHouse = GetData(); SubmitHireHouseInfo(); this.Close(); } }
private void ViewHouseInfo() { HireHouse house = new HireHouse(); try { string strSql = "Select * From HireHouse where Name ='" + this.dataGridView1.SelectedRows[0].Cells[4].Value.ToString() + "'"; DataTable dt = SqlHelper.dataTable(strSql); if (dt.Rows.Count == 0) { return; } house.CheckTime = Convert.ToDateTime(dt.Rows[0][1]); house.BaoPianName = dt.Rows[0][2].ToString(); house.BaoHuName = dt.Rows[0][3].ToString(); house.Name = dt.Rows[0][4].ToString(); house.XingBie = dt.Rows[0][5].ToString(); house.HirePhone = dt.Rows[0][6].ToString(); house.NowAddress = dt.Rows[0][7].ToString(); house.HireType = dt.Rows[0][8].ToString(); house.HireUse = dt.Rows[0][9].ToString(); house.BuildType = dt.Rows[0][10].ToString(); house.YinHuanType = dt.Rows[0][11].ToString(); house.HouseStruct = dt.Rows[0][12].ToString(); house.ChuZujianNum = dt.Rows[0][13].ToString(); house.ChuZuSquere = dt.Rows[0][14].ToString(); house.HirePerson1 = dt.Rows[0][15].ToString(); house.HirePerson2 = dt.Rows[0][16].ToString(); house.HirePerson3 = dt.Rows[0][17].ToString(); house.HirePerson4 = dt.Rows[0][18].ToString(); house.Dengji = dt.Rows[0][19].ToString(); house.Zerenshu = dt.Rows[0][20].ToString(); house.IsQunzu = dt.Rows[0][21].ToString(); house.PhotoPath = (byte[])dt.Rows[0][22]; house.QunzuType = dt.Rows[0][23].ToString(); house.WarmStyle = dt.Rows[0][24].ToString(); house.HaszerenBook = dt.Rows[0][25].ToString(); house.QiandingGrade = dt.Rows[0][26].ToString(); house.MeiluNum = dt.Rows[0][27].ToString(); house.BaojingNum = dt.Rows[0][28].ToString(); house.FengDouNum = dt.Rows[0][29].ToString(); house.ChennuoNum = dt.Rows[0][30].ToString(); } catch { MessageBox.Show("读取数据库出错"); } AddHireHouseInfo houseinfodlg = new AddHireHouseInfo(house); houseinfodlg.ShowDialog(); }
public AddHireHouseInfo(HireHouse hireHouse) { bModify = true; InitializeComponent(); if (Global.authority == Authority.Looker) { this.submitBtn.Enabled = false; } else { this.submitBtn.Enabled = true; } SetData(hireHouse); }
public void SetData(HireHouse house) { this.dateTimePicker1.Value = house.CheckTime; this.textBox2.Text = house.BaoPianName; this.textBox1.Text = house.BaoHuName; this.textBox3.Text = house.Name; this.comboBox2.Text = house.XingBie; this.textBox4.Text = house.HirePhone; this.textBox5.Text = house.NowAddress; this.chuzurenleixing.Text = house.HireType; this.chuzuyongtu.Text = house.HireUse; this.jiangzhuleixing.Text = house.BuildType; this.yinhuanleixing.Text = house.YinHuanType; this.fangwujiegou.Text = house.HouseStruct; this.textBox6.Text = house.ChuZujianNum; this.textBox7.Text = house.ChuZuSquere; this.textBox9.Text = house.HirePerson1; this.textBox8.Text = house.HirePerson2; this.textBox11.Text = house.HirePerson3; this.textBox10.Text = house.HirePerson4; this.dengjibeian.Text = house.Dengji; this.zerenshu.Text = house.Zerenshu; this.isqunzufang.Text = house.IsQunzu; this.PhotoBit = house.PhotoPath; try { if (house.PhotoPath != null) { MemoryStream mystream = new MemoryStream(house.PhotoPath); System.Drawing.Image img1 = System.Drawing.Image.FromStream(mystream, true); this.pictureBox1.Image = img1; } else { this.pictureBox1.Image = null; } } catch { } this.qunzufangtype.Text = house.QunzuType; this.qunuanfangshi.Text = house.WarmStyle; this.haszerenshu.Text = house.HaszerenBook; this.textBox12.Text = house.QiandingGrade; this.textBox16.Text = house.MeiluNum; this.textBox15.Text = house.BaojingNum; this.textBox14.Text = house.FengDouNum; this.textBox13.Text = house.ChennuoNum; }
private void ClearBtn_Click(object sender, EventArgs e) { HireHouse house = new HireHouse(); house.CheckTime = DateTime.Now; house.BaoPianName = null; house.BaoHuName = null; house.Name = null; house.XingBie = null; house.HirePhone = null; house.NowAddress = null; house.HireType = null; house.HireUse = null; house.BuildType = null; house.YinHuanType = null; house.HouseStruct = null; house.ChuZujianNum = null; house.ChuZuSquere = null; house.HirePerson1 = null; house.HirePerson2 = null; house.HirePerson3 = null; house.HirePerson4 = null; house.Dengji = null; house.Zerenshu = null; house.IsQunzu = null; house.PhotoPath = null; house.QunzuType = null; house.WarmStyle = null; house.HaszerenBook = null; house.QiandingGrade = null; house.MeiluNum = null; house.BaojingNum = null; house.FengDouNum = null; house.ChennuoNum = null; SetData(house); }
public HireHouse GetData() { HireHouse house = new HireHouse(); house.CheckTime = this.dateTimePicker1.Value.Date; house.BaoPianName = this.textBox2.Text; house.BaoHuName = this.textBox1.Text; house.Name = this.textBox3.Text; house.XingBie = this.comboBox2.Text; house.HirePhone = this.textBox4.Text; house.NowAddress = this.textBox5.Text; house.HireType = this.chuzurenleixing.Text; house.HireUse = this.chuzuyongtu.Text; house.BuildType = this.jiangzhuleixing.Text; house.YinHuanType = this.yinhuanleixing.Text; house.HouseStruct = this.fangwujiegou.Text; house.ChuZujianNum = this.textBox6.Text; house.ChuZuSquere = this.textBox7.Text; house.HirePerson1 = this.textBox9.Text; house.HirePerson2 = this.textBox8.Text; house.HirePerson3 = this.textBox11.Text; house.HirePerson4 = this.textBox10.Text; house.Dengji = this.dengjibeian.Text; house.Zerenshu = this.zerenshu.Text; house.IsQunzu = this.isqunzufang.Text; house.PhotoPath = this.PhotoBit; house.QunzuType = this.qunzufangtype.Text; house.WarmStyle = this.qunuanfangshi.Text; house.HaszerenBook = this.haszerenshu.Text; house.QiandingGrade = this.textBox12.Text; house.MeiluNum = this.textBox16.Text; house.BaojingNum = this.textBox15.Text; house.FengDouNum = this.textBox14.Text; house.ChennuoNum = this.textBox13.Text; return(house); }
private void saveBtn_Click(object sender, EventArgs e) { this.hireHouse = GetData(); }