/// <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)); }