/// <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="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="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);
}
}
//修改合同
public static bool AgreeMent6(Entity.AgreeMent AgreeMent6)
{
string sqlstr = "update AgreeMent set PID='" + AgreeMent6.pID + "', AMStop='" + AgreeMent6.amStop + "', AMBase=" + AgreeMent6.amBase + ",AMState='" + AgreeMent6.amState + "' where AMID='" + AgreeMent6.amID + "'";
int i = DBHelper.GetLine(sqlstr);
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
//添加请假信息
public static bool Leave1(Entity.Leave leave)
{
string sqlstr = string.Format("insert into Leave values({0},'{1}','{2}','{3}','{4}','{5}')", leave.pID, leave.lWhy, leave.lStart, leave.lStop, leave.lBoss, leave.lState);
int i = (int)DBHelper.GetLine(sqlstr);
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);
}
}
/// <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);
}
}
//添加合同
public static bool AgreeMent(Entity.AgreeMent AgreeMent1)
{
string sqlstr = "insert into AgreeMent values('" + AgreeMent1.pID + "','" + AgreeMent1.amStart + "','" + AgreeMent1.amStop + "','" + AgreeMent1.AMText + "'," + AgreeMent1.amBase + ",'" + AgreeMent1.amState + "')";
int i = DBHelper.GetLine(sqlstr);
if (i > 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 int STCOM(Entity.Train a)
{
string sql = "insert into Tpnotes values('" + a.pID + "','" + a.tpID + "','" + a.nResult + "','" + a.nTexts + "')";
return(DBHelper.GetLine(sql));
}
/// <summary>
/// 更新工资记录
/// </summary>
/// <param name="id"></param>
/// <param name="money"></param>
/// <returns></returns>
public static int UpPay1(int id, double money)
{
string sql = "update Pay set PayDel+=" + money + " where PID=" + id + " and YEAR(PayTime)=" + System.DateTime.Now.Year + " and MONTH(PayTime)=" + System.DateTime.Now.Month + "";
return(DBHelper.GetLine(sql));
}
/// <summary>
/// 更新人员照片
/// </summary>
/// <param name="p"></param>
/// <param name="name"></param>
/// <returns></returns>
public static int UpLogo(Entity.Person p, string name)
{
string sql = "update Person set PPic='" + name + "' where PID=" + p.pID + "";
return(DBHelper.GetLine(sql));
}
public static int pxjh(Entity.Train z)
{
string s = "insert into trainplan values('" + z.leID + "','" + z.tpTeacher + "','" + z.tpAdr + "','" + z.tpCount + "','" + z.tpStart + "','" + z.tpStop + "')";
return(DBHelper.GetLine(s));
}
/// <summary>
/// 奖惩记录操作
/// </summary>
/// <param name="a"></param>
/// <returns></returns>
public static int Penlt(Entity.Express a)
{
string s = "insert into express values('" + a.pID + "','" + a.eType + "','" + a.eMoney + "','" + a.eWhy + "','" + a.eTime + "','" + a.eBoss + "')";
return(DBHelper.GetLine(s));
}
/// <summary>
/// 工资奖励操作
/// </summary>
/// <returns></returns>
public static int MoneyAdd(Entity.Express e)
{
string sql = "update Pay set PayAdd=PayAdd+" + e.eMoney + " where PID=" + e.pID + "";
return(DBHelper.GetLine(sql));
}
/// <summary>
/// 更新用户头像
/// </summary>
/// <returns></returns>
public static int UpLogo(Entity.Users u)
{
string sql = "update Users set ULogo='" + u.logo + "' where UserID=" + u.uID + "";
return(DBHelper.GetLine(sql));
}
/// <summary>
/// 删除部门下的岗位
/// </summary>
/// <returns></returns>
public static int DelJob(Entity.Job job)
{
string sql = "delete from Job where JID=" + job.jID + "";
return(DBHelper.GetLine(sql));
}
//修改课程
public static int Mod(Entity.Train a)
{
string s = string.Format("update lesson set leName='{0}',leType='{1}',leText='{2}' where leId='{3}'", a.leName, a.leType, a.leText, a.leID);
return(DBHelper.GetLine(s));
}
/// <summary>
/// 用户注册
/// </summary>
/// <returns></returns>
public static int RegUser(Entity.Users users)
{
string sql = string.Format("insert into Users values('{0}','{5}', '{1}', '{2}', {3}, '2', '待审核', '{4}')", users.uName, users.uPwd, users.sex, users.age, users.lastTime, users.uMail);
return(DBHelper.GetLine(sql));
}
/// <summary>
/// 提交使用反馈
/// </summary>
/// <param name="fb"></param>
/// <returns></returns>
public static int SubQuestion(Entity.FindBug fb)
{
string sql = string.Format("insert into FindBug values('{0}',{1},'{2}','{3}')", fb.title, fb.type, fb.call, fb.text);
return(DBHelper.GetLine(sql));
}
/// <summary>
/// 发送消息
/// </summary>
/// <param name="m"></param>
public static int AddMsg(Entity.Message m)
{
string sql = "insert into Message values('"+m.uID+"','"+m.mText+"','"+m.mTIme.ToString("yyyy-MM-dd HH:mm:ss")+"','未读',"+m.pID+")";
return DBHelper.GetLine(sql);
}
/// <summary>
/// 添加岗位到部门
/// </summary>
/// <returns></returns>
public static int AddJob(Entity.Job job)
{
string sql = "insert into Job values('" + job.jName + "'," + job.depID + ")";
return(DBHelper.GetLine(sql));
}
/// <summary>
/// 插入缺勤惩罚记录
/// </summary>
/// <param name="id"></param>
/// <param name="money"></param>
/// <returns></returns>
public static int InAdd1(int id, double money)
{
string sql = "insert into Express values(" + id + ",'惩罚'," + money + ",'缺勤惩罚','" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','系统计算惩罚')";
return(DBHelper.GetLine(sql));
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public static int PassChange(Entity.Users users)
{
string sql = "update Users set UPwd='" + users.uPwd + "' where UserID=" + users.uID + "";
return(DBHelper.GetLine(sql));
}
/// <summary>
/// 插入工资记录
/// </summary>
public static void NewSalary(double b, int pid, int day, string time)
{
string sql = "insert into Pay values(" + pid + ",0," + b + "," + day + ",0,0,0,0,'" + time + "')";
DBHelper.GetLine(sql);
}
/// <summary>
/// 更新岗位名称
/// </summary>
/// <returns></returns>
public static int UpJob(Entity.Job job)
{
string sql = "update Job set JName='" + job.jName + "' where JID=" + job.jID + "";
return(DBHelper.GetLine(sql));
}
//添加课程
public static int Adt(Entity.Train a)
{
string s = "insert into lesson values('" + a.leName + "','" + a.leType + "','" + a.leText + "')";
return(DBHelper.GetLine(s));
}
/// <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));
}
public static int Del(Entity.Train a)
{
string s = string.Format("delete from lesson where LeID='{0}' ", a.leID);
return(DBHelper.GetLine(s));
}
/// <summary>
/// 驳回审核
/// </summary>
/// <returns></returns>
public static int DelSelf(Entity.Appraise a)
{
string sql = "delete from Appraise where AID=" + a.aID + "";
return(DBHelper.GetLine(sql));
}
