/// <summary>
/// 注册
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public int Sign(Users u)
{
string pwd = EncryptionHelper.Sha1(u.Upwd); //Sha1加密密码
int i = DapperHelper.NonQuery($"insert into Users values('{u.Uname}','{u.Utname}','{pwd}','{u.Utel}',80,GETDATE(),'{null}')", null);
return(i);
}
/// <summary>
/// 添加审核员
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public int AddShen(Users u)
{
string p = "zx123456";
string pwd = EncryptionHelper.Sha1(p);//Sha1加密密码
DapperHelper.NonQuery($"insert into Users values('{u.Uname}','{u.Utname}','{pwd}','{u.Utel}',80,GETDATE(),'{u.Ulevel}')", null);
int n = DapperHelper.Exists($"select Uid from Users where Uname = '{u.Uname}'", null);
int a = DapperHelper.NonQuery("update UserRole set Rid= 2 where Uid=" + n, null);
return(a);
}
/// <summary>
/// 合规审核
/// </summary>
/// <param name="id">对应的用户id</param>
/// <returns></returns>
public int UptState(int nuid, int ncid)
{
string sql = $"update VehicleInfo set Czt = 2 where Cuid ={nuid} and Cid = {ncid}";
return(DapperHelper.NonQuery(sql, null));
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public int UptPwd(Users u)
{
string pwd = EncryptionHelper.Sha1(u.Upwd);//Sha1加密密码
return(DapperHelper.NonQuery($"update Users set Upwd= '{pwd}' where Uname='{u.Uname}'", null));
}
/// <summary>
/// 取消审核员身份
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public int CancelShen(int uid)
{
return(DapperHelper.NonQuery("update UserRole set Rid= 3 where Uid=" + uid, null));
}
/// <summary>
/// 车辆信息删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DelVehicleInfos(string id)
{
return(DapperHelper.NonQuery($"delete from VehicleInfo where Cid in ({id})", null));
}
/// <summary>
/// 车辆信息提交并申请贷款
/// </summary>
/// <param name="vehicle"></param>
/// <returns></returns>
public int VechcleAdd(VehicleInfo vehicle)
{
return(DapperHelper.NonQuery <VehicleInfo>($"Insert into VehicleInfo(Cid,Cimg,Cuid,Cbrand,Ctype,Cvin,Cyear,Ckm,Csf,Ctime,Czt,Cqx,Cbj) values('{vehicle.Cid}','{vehicle.Cimg}','{vehicle.Cuid}','{vehicle.Cbrand}','{vehicle.Ctype}','{vehicle.Cvin}','{vehicle.Cyear}','{vehicle.Ckm}','{vehicle.Csf}','{DateTime.Now}',1,'{vehicle.Cqx}','{vehicle.Cbj}')", null));
}
/// <summary>
/// 用户还款
/// </summary>
/// <param name="id">对应的用户id</param>
/// <returns></returns>
public int UpdateState(int id)
{
string sql = "update VehicleInfo set Czt = 4 where Cuid =" + id;
return(DapperHelper.NonQuery(sql, null));
}