public IHttpActionResult UserDisable(PBE_USER info)
{
using (ZDSYYC db = new ZDSYYC())
{
var sql = "update PBE_USER set password='******' where code='jy00001'";
int allnum = db.ExecuteNoQuery(sql);
db.Save();
return(Succeed("禁用成功"));
}
}
public IHttpActionResult UserLoginYC(PBE_USER info)
{
using (ZDSYYC db = new ZDSYYC())
{
string userName = info.CODE.Trim();
string _password = info.PASSWORD;
var user = db.PBE_USER.AsQuery().Where(w => w.CODE == userName && w.PASSWORD == _password).ToList();
if (user.Count == 1)
{
return(Succeed(user[0].CODE, 0, user[0].NAME, ""));
}
else
{
return(Succeed("拒绝访问", 1, "", ""));
}
}
}
public IHttpActionResult UserEditPwdYC(PBE_USER info)
{
using (ZDSYYC db = new ZDSYYC())
{
string code = info.CODE;
string oldpwd = info.NAME;
string _password = info.PASSWORD;
var sqlNum = "update PBE_USER set password='******' where code='" + code + "' and password='******'";
int allnum = db.ExecuteNoQuery(sqlNum);
db.Save();
if (allnum == 1)
{
return(Succeed("修改成功", 0, ""));
}
else
{
return(Succeed("修改失败", 1, "", "旧密码错误"));
}
}
}
public IHttpActionResult EidtUser(PBE_USER info)
{
using (ZDSYYC db = new ZDSYYC())
{
int user = db.PBE_USER.AsQuery().Where(w => w.CODE == info.CODE).Count();
if (user != 0)
{
return(Succeed(1));
}
else
{
PBE_USER pinfo = new PBE_USER();
pinfo.CODE = info.CODE.Trim().ToLower();
pinfo.NAME = info.NAME;
pinfo.PASSWORD = info.CODE;
db.PBE_USER.Add(pinfo);
db.Save();
return(Succeed(""));
}
}
}
