private void addCompany_Click(object sender, EventArgs e) { AddHireHouseInfo addInfoDlg = new AddHireHouseInfo(); addInfoDlg.ShowDialog(); string strSql = "Select * From HireHouse"; this.BindData(strSql); this.strTempSql = strSql; }
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(); }