/// <summary>
/// 修改按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AlterButton_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
CententForm.Employee.WinForm.AddDemand addDemand = new CententForm.Employee.WinForm.AddDemand();
int buttonName = int.Parse(((Button)sender).Name);//获取要修改的数据所在行
int No = 0;
int y = 0;
LinkSQL linkSql = new LinkSQL();
try
{
linkSql.OpenSQL();
}
catch
{
MessageBox.Show("无法连接数据库！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
linkSql.SQLSelect(@"select No from demand");
System.Data.SqlClient.SqlDataReader DR = linkSql.Comm.ExecuteReader();
while (DR.Read())
{
if (buttonName == y)
{
No = int.Parse(DR[0].ToString());
}
y++;
}
addDemand.UpDataNo = No;
addDemand.Department_ID.Text = table[buttonName, 1].Text;
if (table[buttonName, 1].Text == "采购部")
{
addDemand.Department_ID.Text = "PU0001";
}
if (table[buttonName, 1].Text == "仓储部")
{
addDemand.Department_ID.Text = "ST0001";
}
addDemand.Post.Text = table[buttonName, 2].Text;
addDemand.Rec_Number.Text = table[buttonName, 3].Text;
addDemand.Explain.Text = detail[buttonName];
DialogResult dr = addDemand.ShowDialog();
if (dr == DialogResult.Cancel)
{
RefreshData();
}
else
{
return;
}
}
/// <summary>
/// 添加需求事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
int number = 22; //记录当前的需求信息的数量
try
{
LinkSQL linkSql = new LinkSQL();
linkSql.OpenSQL();
linkSql.SQLSelect(@"select count(*) from demand");
number = int.Parse(linkSql.Comm.ExecuteScalar().ToString());
linkSql.CloseSQL();
}
catch
{
MessageBox.Show("无法连接到服务器！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (number >= 20)
{
MessageBox.Show("最大只可发布20条招聘信息，请先删除部分的招聘信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (number == 22)
{
MessageBox.Show("无法连接到服务器！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
CententForm.Employee.WinForm.AddDemand addDemand = new CententForm.Employee.WinForm.AddDemand();
DialogResult dr = addDemand.ShowDialog();
if (dr == DialogResult.Cancel)
{
RefreshData();
}
else
{
return;
}
}
