private void button2_Click(object sender, EventArgs e)
{
Entity.JobPlan jp = new Entity.JobPlan();
//接受编号
jp.jpID = int.Parse(this.textBox1.Text);
//接受岗位
jp.jID = int.Parse(this.comboBox2.SelectedValue.ToString());
//接受人数
jp.jpCount = int.Parse(this.textBox3.Text);
//接受内容
jp.jpNeed = this.textBox6.Text;
//接受联系人
jp.jpCall = this.comboBox3.Text;
//接受电话
jp.jpPhone = this.textBox5.Text;
//接受最后时间
jp.jpStop = this.dateTimePicker1.Value;
bool jop = BLL.AddFinder.JPL(jp);
if (jop == true)
{
Msg.Box.Show("修改成功！", "成功提示", Msg.Box.Ico.Info);
}
this.dataGridView1.DataSource = BLL.AddFinder.CJobPla();
}
private void button4_Click(object sender, EventArgs e)
{
Entity.JobPlan jp = new Entity.JobPlan();
//接受编号
jp.jpID = int.Parse(this.textBox1.Text);
bool Djp = BLL.AddFinder.DJP(jp);
if (Djp == true)
{
Msg.Box.Show("删除成功！", "成功提示", Msg.Box.Ico.Info);
}
this.dataGridView1.DataSource = BLL.AddFinder.CJobPla();
}
/// <summary>
/// 增加招聘计划
/// </summary>
/// <param name="AJP"></param>
/// <returns></returns>
public static bool AJPlan(Entity.JobPlan AJP)
{
string sql = string.Format("insert into JobPlan values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", AJP.jID, AJP.jpCount, AJP.jpNeed, System.DateTime.Now, AJP.jpStop.ToString("yyyy-MM-dd HH:mm:ss"), AJP.jpCall, AJP.jpPhone);
int i = (int)DBHelper.GetLine(sql);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
Entity.JobPlan jp = new Entity.JobPlan();
string a = this.dataGridView1.Rows[this.dataGridView1.CurrentCell.RowIndex].Cells[0].Value.ToString();
jp.jpID = int.Parse(a);
bool isExit = Msg.Box.RShow("请确认是否删除此项？", "删除提示", Msg.Box.Ico.Question);
if (isExit == true)
{
BLL.AddFinder.DJP(jp);
this.dataGridView1.DataSource = BLL.AddFinder.CJobPla();
}
}
/// <summary>
/// 删除招聘计划的方法
/// </summary>
/// <param name="JPlan"></param>
/// <returns></returns>
public static bool DJPlan(Entity.JobPlan DJP)
{
string sql = string.Format("delete from JobPlan where JPID='{0}'", DJP.jpID);
int i = (int)DBHelper.GetLine(sql);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改招聘表方法
/// </summary>
/// <param name="JPlan"></param>
/// <returns></returns>
public static bool JPlan(Entity.JobPlan JPlan)
{
string sql = string.Format("update JobPlan set JID='{0}',JPCount='{1}',JPNeed='{2}',JPStop='{3}',JPCall='{4}',JPPhone='{5}' where JPID='{6}'", JPlan.jID, JPlan.jpCount, JPlan.jpNeed, JPlan.jpStop, JPlan.jpCall, JPlan.jpPhone, JPlan.jpID);
int i = (int)DBHelper.GetLine(sql);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
//传递增加方法
public static bool AJP(Entity.JobPlan AJP)
{
return(DAL.JobPlan.AJPlan(AJP));
}
//传递删除方法
public static bool DJP(Entity.JobPlan DJP)
{
return(DAL.JobPlan.DJPlan(DJP));
}
//传递修改方法
public static bool JPL(Entity.JobPlan JPlan)
{
return(DAL.JobPlan.JPlan(JPlan));
}
