/// <summary>
/// 添加辞职信息
/// </summary>
/// <param name="MY"></param>
/// <returns></returns>
public static bool TR(Entity.Resignation MY)
{
string sql = string.Format("INSERT INTO Resignation VALUES('{0}','{1}','{2}','申请中')", MY.pID, MY.rText, System.DateTime.Now);
int i = (int)DBHelper.GetLine(sql);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除辞职表
/// </summary>
/// <param name="pr"></param>
/// <returns></returns>
public static bool SR(Entity.Resignation dd)
{
string sqlstr = "delete from Resignation where RID='" + dd.rID + "'";
int i = DBHelper.GetLine(sqlstr);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改状态的方法
/// </summary>
/// <param name="pr"></param>
/// <returns></returns>
public static bool xR(Entity.Resignation pr)
{
string sqlstr = "update Resignation set Rstate='" + pr.rState + "' where RID='" + pr.rID + "'";
int i = DBHelper.GetLine(sqlstr);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
private void btn_no_Click(object sender, EventArgs e)
{
if (this.dataGridView1.Rows.Count == 0)
{
return;
}
if (this.textBox1.Text == "")
{
Msg.Box.Show("请选择信息");
return;
}
bool isGo = Msg.Box.RShow("是否同意该员工的辞职申请？", Msg.Box.Ico.Question);
if (isGo == true)
{
Entity.Person per = new Entity.Person();
per.pID = int.Parse(this.dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[1].Value.ToString());
Entity.Resignation RE = new Entity.Resignation();
RE.rID = int.Parse(this.textBox1.Text);
bool XG = BLL.ResignationBLL.SR(RE);
if (XG == true)
{
Msg.Box.Show("辞退成功！", "成功提示", Msg.Box.Ico.Info);
BLL.PersonBLL.Person1(per);
this.dataGridView1.DataSource = BLL.ResignationBLL.cr();
}
else
{
Msg.Box.Show("辞退失败！", "失败示", Msg.Box.Ico.Info);
return;
}
}
else
{
Msg.Box.Show("辞退失败！", "失败示", Msg.Box.Ico.Info);
return;
}
}
private void btn_use_Click(object sender, EventArgs e)
{
if (this.dataGridView1.Rows.Count == 0)
{
return;
}
if (this.textBox1.Text == "")
{
Msg.Box.Show("请选择信息");
return;
}
Entity.Resignation RE = new Entity.Resignation();
RE.rID = int.Parse(this.textBox1.Text);
RE.rState = "驳回";
bool XG = BLL.ResignationBLL.XG(RE);
if (XG == true)
{
Msg.Box.Show("驳回成功！", "成功提示", Msg.Box.Ico.Info);
this.dataGridView1.DataSource = BLL.ResignationBLL.cr();
}
}
/// <summary>
/// 传递添加个人辞职申请的方法
/// </summary>
/// <param name="Tr"></param>
/// <returns></returns>
public static bool TR(Entity.Resignation Tr)
{
return(EDAL.MyInfoDAL.TR(Tr));
}
/// <summary>
/// 传递查询个人申请的方法
/// </summary>
/// <param name="Cr"></param>
/// <returns></returns>
public static System.Data.DataTable CR(Entity.Resignation Cr)
{
return(EDAL.MyInfoDAL.CR(Cr));
}
/// <summary>
/// 查询个人辞职申请
/// </summary>
/// <returns></returns>
public static System.Data.DataTable CR(Entity.Resignation CR)
{
string sql = "select RID 编号,Person.PID 工号,PName 姓名,JName 所在岗位,Rtext 辞职理由,RTime 申请时间,Rstate 状态 from Resignation,Person,Job where Resignation.PID=Person.PID and Job.JID =Person.JID and Person.PID='" + CR.pID + "'";
return(DBHelper.GetDT(sql));
}
/// <summary>
/// 传递删除信息的方法
/// </summary>
/// <param name="Re"></param>
/// <returns></returns>
public static bool SR(Entity.Resignation dd)
{
return(DAL.ResignationDAL.SR(dd));
}
/// <summary>
/// 传递修改状态的方法
/// </summary>
/// <param name="Re"></param>
/// <returns></returns>
public static bool XG(Entity.Resignation Re)
{
return(DAL.ResignationDAL.xR(Re));
}
