private void toolStripButtonSave_Click(object sender, EventArgs e)
{
SqlParameter[] param = null;
AreaInfo areaInfo = this.buttonEditArea1.Tag as AreaInfo;
string sql = String.Format("update IO_AreaName2 set M_Name='{0}', M_Devs='{1}', M_Title='{2}', M_Used={3} where M_AreaId = {4}",
areaInfo.AreaName, areaInfo.AreaDevs, this.textBoxArea1.Text, Convert.ToInt32(this.checkBox1.Checked), areaInfo.AreaId);
areaInfo = this.buttonEditArea2.Tag as AreaInfo;
sql += String.Format(" update IO_AreaName2 set M_Name='{0}', M_Devs='{1}', M_Title='{2}', M_Used={3} where M_AreaId = {4}",
areaInfo.AreaName, areaInfo.AreaDevs, this.textBoxArea2.Text, Convert.ToInt32(this.checkBox2.Checked), areaInfo.AreaId);
areaInfo = this.buttonEditArea3.Tag as AreaInfo;
sql += String.Format(" update IO_AreaName2 set M_Name='{0}', M_Devs='{1}', M_Title='{2}', M_Used={3} where M_AreaId = {4}",
areaInfo.AreaName, areaInfo.AreaDevs, this.textBoxArea3.Text, Convert.ToInt32(this.checkBox3.Checked), areaInfo.AreaId);
areaInfo = this.buttonEditArea4.Tag as AreaInfo;
sql += String.Format(" update IO_AreaName2 set M_Name='{0}', M_Devs='{1}', M_Title='{2}', M_Used={3} where M_AreaId = {4}",
areaInfo.AreaName, areaInfo.AreaDevs, this.textBoxArea4.Text, Convert.ToInt32(this.checkBox4.Checked), areaInfo.AreaId);
areaInfo = this.buttonEditArea5.Tag as AreaInfo;
sql += String.Format(" update IO_AreaName2 set M_Name='{0}', M_Devs='{1}', M_Title='{2}', M_Used={3} where M_AreaId = {4}",
areaInfo.AreaName, areaInfo.AreaDevs, this.textBoxArea5.Text, Convert.ToInt32(this.checkBox5.Checked), areaInfo.AreaId);
areaInfo = this.buttonEditArea6.Tag as AreaInfo;
sql += String.Format(" update IO_AreaName2 set M_Name='{0}', M_Devs='{1}', M_Title='{2}', M_Used={3} where M_AreaId = {4}",
areaInfo.AreaName, areaInfo.AreaDevs, this.textBoxArea6.Text, Convert.ToInt32(this.checkBox6.Checked), areaInfo.AreaId);
SqlHelper.ExecuteSql(sql, param);
MessageBox.Show("保存成功", "提示");
}
private void buttonEditArea6_Click(object sender, EventArgs e)
{
FrmAreaSelect frmAreaSelect = new FrmAreaSelect(this.buttonEditArea6.Tag as AreaInfo);
frmAreaSelect.ShowDialog();
AreaInfo areaInfo = frmAreaSelect.AreaInfo;
if (!this.buttonEditArea6.Text.Equals(areaInfo.AreaName))
{
this.buttonEditArea6.Text = areaInfo.AreaName;
}
}
private void LoadAreaDevInfo()
{
string sql = "select * from IO_AreaName2";
SqlParameter[] param = null;
DataTable dataTable = null;
dataTable = SqlHelper.ExecuteDataTable(sql, param);
if (dataTable.Rows.Count > 0)
{
AreaInfo areaInfo = new AreaInfo();
areaInfo.AreaId = dataTable.Rows[0]["M_AreaId"].ToString();
areaInfo.AreaName = this.buttonEditArea1.Text = dataTable.Rows[0]["M_Name"].ToString();
areaInfo.Title = this.textBoxArea1.Text = dataTable.Rows[0]["M_Title"].ToString();
areaInfo.AreaDevs = dataTable.Rows[0]["M_Devs"].ToString();
areaInfo.Used = Convert.ToInt32(dataTable.Rows[0]["M_Used"].ToString());
this.checkBox1.Checked = (areaInfo.Used > 0);
this.buttonEditArea1.Tag = areaInfo;
}
if (dataTable.Rows.Count > 1)
{
AreaInfo areaInfo = new AreaInfo();
areaInfo.AreaId = dataTable.Rows[1]["M_AreaId"].ToString();
areaInfo.AreaDevs = dataTable.Rows[1]["M_Devs"].ToString();
areaInfo.AreaName = this.buttonEditArea2.Text = dataTable.Rows[1]["M_Name"].ToString();
areaInfo.Title = this.textBoxArea2.Text = dataTable.Rows[1]["M_Title"].ToString();
areaInfo.Used = Convert.ToInt32(dataTable.Rows[1]["M_Used"].ToString());
this.checkBox2.Checked = (areaInfo.Used > 0);
this.buttonEditArea2.Tag = areaInfo;
}
if (dataTable.Rows.Count > 2)
{
AreaInfo areaInfo = new AreaInfo();
areaInfo.AreaId = dataTable.Rows[2]["M_AreaId"].ToString();
areaInfo.AreaDevs = dataTable.Rows[2]["M_Devs"].ToString();
areaInfo.AreaName = this.buttonEditArea3.Text = dataTable.Rows[2]["M_Name"].ToString();
areaInfo.Title = this.textBoxArea3.Text = dataTable.Rows[2]["M_Title"].ToString();
areaInfo.Used = Convert.ToInt32(dataTable.Rows[2]["M_Used"].ToString());
this.checkBox3.Checked = (areaInfo.Used > 0);
this.buttonEditArea3.Tag = areaInfo;
}
if (dataTable.Rows.Count > 3)
{
AreaInfo areaInfo = new AreaInfo();
areaInfo.AreaId = dataTable.Rows[3]["M_AreaId"].ToString();
areaInfo.AreaDevs = dataTable.Rows[3]["M_Devs"].ToString();
areaInfo.AreaName = this.buttonEditArea4.Text = dataTable.Rows[3]["M_Name"].ToString();
areaInfo.Title = this.textBoxArea4.Text = dataTable.Rows[3]["M_Title"].ToString();
areaInfo.Used = Convert.ToInt32(dataTable.Rows[3]["M_Used"].ToString());
this.checkBox4.Checked = (areaInfo.Used > 0);
this.buttonEditArea4.Tag = areaInfo;
}
if (dataTable.Rows.Count > 4)
{
AreaInfo areaInfo = new AreaInfo();
areaInfo.AreaId = dataTable.Rows[4]["M_AreaId"].ToString();
areaInfo.AreaDevs = dataTable.Rows[4]["M_Devs"].ToString();
areaInfo.AreaName = this.buttonEditArea5.Text = dataTable.Rows[4]["M_Name"].ToString();
areaInfo.Title = this.textBoxArea5.Text = dataTable.Rows[4]["M_Title"].ToString();
areaInfo.Used = Convert.ToInt32(dataTable.Rows[4]["M_Used"].ToString());
this.checkBox5.Checked = (areaInfo.Used > 0);
this.buttonEditArea5.Tag = areaInfo;
}
if (dataTable.Rows.Count > 5)
{
AreaInfo areaInfo = new AreaInfo();
areaInfo.AreaId = dataTable.Rows[5]["M_AreaId"].ToString();
areaInfo.AreaDevs = dataTable.Rows[5]["M_Devs"].ToString();
areaInfo.AreaName = this.buttonEditArea6.Text = dataTable.Rows[5]["M_Name"].ToString();
areaInfo.Title = this.textBoxArea6.Text = dataTable.Rows[5]["M_Title"].ToString();
areaInfo.Used = Convert.ToInt32(dataTable.Rows[5]["M_Used"].ToString());
this.checkBox6.Checked = (areaInfo.Used > 0);
this.buttonEditArea6.Tag = areaInfo;
}
}