//按评估等级查询
public static DataTable Appraise5(Entity.Appraise Appraise5)
{
string sqlstr = "select * from Appraise where ARate='" + Appraise5.aRate + "' and AType!='待审核'";
DataTable dt = DBHelper.GetDT(sqlstr);
return(dt);
}
//按员工编号查询
public static DataTable Appraise4(Entity.Appraise Appraise4)
{
string sqlstr = "select * from Appraise where PID like '%" + Appraise4.pID + "%' and AType!='待审核'";
DataTable dt = DBHelper.GetDT(sqlstr);
return(dt);
}
//查看评估
public static DataTable Appraise2(Entity.Appraise Appraise2)
{
string sqlstr = "select * from Appraise where AType!='待审核'";
DataTable dt1 = DBHelper.GetDT(sqlstr);
return(dt1);
}
/// <summary>
/// 驳回审核
/// </summary>
/// <returns></returns>
public static bool DelSelf(Entity.Appraise a)
{
if (DAL.AppraiseDAL.DelSelf(a) > 0)
{
return(true);
}
else
{
return(false);
}
}
//添加评估
public static bool Appraise(Entity.Appraise Appraise1)
{
string sqlstr = "insert into Appraise values('" + Appraise1.pID + "','" + Appraise1.aTIme + "','" + Appraise1.ABoss + "','" + Appraise1.aText + "','" + Appraise1.aType + "','" + Appraise1.aRate + "')";
int i = DBHelper.GetLine(sqlstr);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
//按评估等级查询
public static DataTable Appraise5(Entity.Appraise Appraise5)
{
return(DAL.AppraiseDAL.Appraise5(Appraise5));
}
//按员工编号查询
public static DataTable Appraise4(Entity.Appraise Appraise4)
{
return(DAL.AppraiseDAL.Appraise4(Appraise4));
}
//按评估编号查询
public static DataTable Appraise3(Entity.Appraise Appraise3)
{
return(DAL.AppraiseDAL.Appraise3(Appraise3));
}
//查询评估表
public static DataTable Appraise2(Entity.Appraise Appraise2)
{
return(DAL.AppraiseDAL.Appraise2(Appraise2));
}
//添加评估
public static bool Appraise1(Entity.Appraise Appraise1)
{
return(DAL.AppraiseDAL.Appraise(Appraise1));
}
/// <summary>
/// 驳回审核
/// </summary>
/// <returns></returns>
public static int DelSelf(Entity.Appraise a)
{
string sql = "delete from Appraise where AID=" + a.aID + "";
return(DBHelper.GetLine(sql));
}
/// <summary>
/// 通过审核
/// </summary>
/// <returns></returns>
public static int UpSelf(Entity.Appraise a)
{
string sql = "update Appraise set AType='员工自评',ABoss='" + a.ABoss + "' where AID=" + a.aID + "";
return(DBHelper.GetLine(sql));
}