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();
}
