public override void OnActionExecuting(System.Web.Http.Controllers.HttpActionContext context)
{
if (_isDebugLog)
{
var Authorization = context.Request.Headers.Authorization == null ? string.Empty : context.Request.Headers.Authorization.ToString();
JwtModel model = JwtHelper.getToken(Authorization);
if (model.status_code != 200)
{
context.Response = new HttpResponseMessage
{
Content = new StringContent("{\"message\":\"" + model.message + "\",\"status_code\":" + model.status_code + "}",
Encoding.GetEncoding("UTF-8"), "application/json"),
StatusCode = HttpStatusCode.Unauthorized
};
return;
}
}
base.OnActionExecuting(context);
}
public ResponseMessageResult Get(int page, int pagesize, string code, int agentid, int businessid = 0)
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var temp = from a in db.aa_business_balance
join b in db.fa_business_basic on a.businessid equals b.id
where (b.shortName.Contains(code) || string.IsNullOrEmpty(code)) &&
(b.agentid == agentid || agentid == 0) &&
(b.id == businessid || businessid == 0)
select new
{
a.id,
a.businessid,
a.businesspasstype,
a.wechatbalance,
a.alipaybalance,
a.unionpaybalance,
a.totalbalance,
b.shortName
};
model.total = temp.Count();
model.data = temp.OrderByDescending(s => s.id).Skip((page - 1) * pagesize).Take(pagesize).ToList();
if (model.data.Count > 0)
{
model.message = "查询成功";
model.status_code = 200;
}
else
{
model.message = "暂无数据";
model.status_code = 200;
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
public async Task <bool> ValidateTokens(string Bearer, string UserName)
{
JwtModel model = new JwtModel();
string bear = JWT.Payload(Bearer);
model = JsonConvert.DeserializeObject <JwtModel>(bear);
string usuario = System.Text.Encoding.UTF8.GetString(Convert.FromBase64String(model.sub));
string userNam2e = System.Text.Encoding.UTF8.GetString(Convert.FromBase64String(UserName));
if (usuario == userNam2e)
{
return(true);
}
else
{
return(false);
}
}
public ResponseMessageResult Getsy_admin()
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var sy_admin = from a in db.sy_admin
join b in db.sy_role on a.roleid equals b.roleid
where a.userid == jwtmodel.userid
select new
{
a.userid,
a.usercode,
a.username,
a.roleid,
b.rolecode,
b.rolename,
a.status,
b.isadmin,
a.addtime,
a.adduser,
a.updatetime,
a.updateuser
};
if (sy_admin == null)
{
model.message = "暂无数据";
model.status_code = 200;
}
else
{
model.data = sy_admin.FirstOrDefault();
model.message = "查询成功";
model.status_code = 200;
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
// GET: api/Admin 用户列表
public ResponseMessageResult Getsy_routers(int page, int pagesize, string code)
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var temp = from a in db.sy_routers
join b in db.sy_router on a.id equals b.id
where (a.name.Contains(code) || string.IsNullOrEmpty(code))
select new
{
a.id,
a.name,
a.path,
a.sort,
a.component,
a.autoid,
a.meta,
a.hidden,
router_name = b.name
};
model.total = temp.Count();
model.data = temp.OrderByDescending(s => s.id).Skip((page - 1) * pagesize).Take(pagesize).ToList();
if (model.data.Count > 0)
{
model.message = "查询成功";
model.status_code = 200;
}
else
{
model.message = "暂无数据";
model.status_code = 200;
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
public ResponseMessageResult Get()
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var sy_admin = from a in db.sh_business_appinfo
where a.id == jwtmodel.userid
select new
{
a.id,
a.sh_appid,
a.sh_appsecret,
a.sh_storeid,
a.sh_storename,
a.sh_businessname,
a.sh_mobile,
a.sh_balance,
a.sh_commission,
a.sh_commratio,
a.agid,
a.status
};
if (sy_admin == null)
{
model.message = "暂无数据";
model.status_code = 200;
}
else
{
model.data = sy_admin.FirstOrDefault();
model.message = "查询成功";
model.status_code = 200;
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
public ResponseMessageResult Postsy_merchant(sy_merchant sy_merchant)
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var info = db.sy_merchant.Where(o => o.name == sy_merchant.name && sy_merchant.agid == o.agid).Count();
if (info > 0)
{
model.message = "商户名称已经存在";
model.status_code = 401;
}
else
{
var strDateTime = DateTime.Now.ToString("yyyyMMddHHmmssfff");
sy_merchant.appid = strDateTime;
sy_merchant.appsecret = BaseHelper.Md5Hash(strDateTime + "buyunchina");
sy_merchant.agid = jwtmodel.userid;
sy_merchant.addtime = DateTime.Now;
sy_merchant.adduser = jwtmodel.username;
sy_merchant.password = BaseHelper.Md5Hash(sy_merchant.password);
db.sy_merchant.Add(sy_merchant);
try
{
db.SaveChanges();
model.message = "新增成功";
model.status_code = 200;
}
catch (Exception ex)
{
model.message = ex.Message;
model.status_code = 401;
}
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
public async Task <JwtModel> SignWithJwt(Admin admin)
{
var tuple = await GetClaimsIdentity(admin);
if (tuple == null)
{
return(null);
}
var identity = tuple.Item1;
var applicationUser = tuple.Item2;
var claims = new[]
{
new Claim(JwtRegisteredClaimNames.Sub, admin.Username),
new Claim(JwtRegisteredClaimNames.Jti, await _jwtOptions.JtiGenerator()),
new Claim(JwtRegisteredClaimNames.Iat, ToUnixEpochDate(_jwtOptions.IssuedAt).ToString(), ClaimValueTypes.Integer64),
new Claim(JwtRegisteredClaimNames.NameId, applicationUser.Id.ToString()),
new Claim(JwtRegisteredClaimNames.UniqueName, applicationUser.Id.ToString()),
identity.FindFirst("LoggedSystemAdmin")
};
var jwt = new JwtSecurityToken(
issuer: _jwtOptions.Issuer,
audience: _jwtOptions.Audience,
claims: claims,
notBefore: _jwtOptions.NotBefore,
expires: _jwtOptions.Expiration,
signingCredentials: _jwtOptions.SigningCredentials);
var encodedJwt = new JwtSecurityTokenHandler().WriteToken(jwt);
admin.Password = "";
var response = new JwtModel()
{
Token = encodedJwt,
ExpiresIn = (int)_jwtOptions.ValidFor.TotalMinutes
};
return(response);
}
public string GenerateSecurityToken(JwtModel jwtModel)
{
var tokenHandler = new JwtSecurityTokenHandler();
var key = Encoding.ASCII.GetBytes(_configuration["JwtSettings:Secret"]);
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new ClaimsIdentity(new[]
{
new Claim(EClaimTypes.UserId, jwtModel.ApplicationUserId.ToString())
}
.Concat(jwtModel.UserRoles.Select(roleName => new Claim(ClaimTypes.Role, roleName)))),
Expires = DateTime.UtcNow.AddDays(int.Parse(_configuration["JwtSettings:ExpireDays"])),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature)
};
var token = tokenHandler.CreateToken(tokenDescriptor);
return(tokenHandler.WriteToken(token));
}
public ResponseMessageResult Getsy_agent()
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
var sy_agent = from a in db.sy_agent
where a.id == jwtmodel.userid
select a;
if (sy_agent == null)
{
model.message = "暂无数据";
model.status_code = 200;
}
else
{
model.data = sy_agent.FirstOrDefault();
model.message = "查询成功";
model.status_code = 200;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
// GET: api/Admin 用户登录
public ResponseMessageResult Getsy_admin(string code, string password)
{
var temp = from a in db.sy_admin
join b in db.sy_role on a.roleid equals b.roleid
select new
{
a.userid,
a.usercode,
a.username,
a.roleid,
b.rolecode,
b.rolename,
a.status,
b.isadmin,
a.password,
a.addtime,
a.adduser,
a.updatetime,
a.updateuser
};
password = BaseHelper.Md5Hash(password);
model.data = temp.Where(o => o.usercode == code && o.password == password && o.status == 1).FirstOrDefault();
if (model.data != null)
{
JwtModel jwtmodel = new JwtModel();
jwtmodel.userid = model.data.userid;
jwtmodel.usercode = model.data.usercode;
jwtmodel.username = model.data.username;
jwtmodel.isadmin = model.data.isadmin;
jwtmodel.rolecode = model.data.rolecode;
JwtHelper.setToken(jwtmodel);
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)jwtmodel.status_code, jwtmodel)));
}
else
{
model.message = "用户名或密码错误";
model.status_code = 401;
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
}
public ResponseMessageResult Get()
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
var sy_merchant = from a in db.sy_merchant
select new {
id=a.id.ToString(),
a.name,
};
if (sy_merchant == null)
{
model.message = "暂无数据";
model.status_code = 200;
}
else
{
model.data = sy_merchant.ToList();
model.message = "查询成功";
model.status_code = 200;
}
return new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model));
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
JwtModel model = GetJwtSettings();
services.AddAuthentication(options => {
options.DefaultAuthenticateScheme = "JwtBearer";
options.DefaultChallengeScheme = "JwtBearer";
})
.AddJwtBearer("JwtBearer", jwtBearerOptions => {
jwtBearerOptions.TokenValidationParameters = new TokenValidationParameters
{
ValidateIssuerSigningKey = true,
IssuerSigningKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(model.Key)),
ValidateIssuer = false,
ValidIssuer = model.Issuer,
ValidateAudience = true,
ValidAudience = model.Audience,
ValidateLifetime = true,
ClockSkew = TimeSpan.FromMinutes(model.MinutesToExpiration)
};
});
services.AddSingleton <JwtModel>(model);
services.AddSingleton <MainDbUser>();
RepositoryMapper repoMapper = new RepositoryMapper();
ServiceMapper serviceMapper = new ServiceMapper();
repoMapper.AddMappings(services);
serviceMapper.AddMappings(services);
services.AddSingleton <IConfiguration>(Configuration);
services.AddCors();
services.AddMvc();
}
public async Task <JwtModel> GetTokenForUser(LoginViewModel loginModel)
{
var authenticateResult = await Authenticate(loginModel);
if (authenticateResult.UserValidated)
{
// Internal users can authenticate via email address but need correct login Id
loginModel.Username = authenticateResult.LoginId;
UserData userData = await UAMClientLibrary.GetUserData(loginModel.Username, true);
JwtModel userJwt = CreateUser(userData);
// 4. Map Username to get tblUsers.UserID (if 0)
if (userJwt.UserId == 0)
{
userJwt.UserId = await _userService.GetUserId(loginModel.Username, 0);
// If UserId == 0, invalid user????
}
// 5a. Add Claims
Claim[] claims = _claimService.BuildClaims(userData); // Build Claims
userJwt.Token = _tokenService.BuildJwtSecurityToken(userJwt, claims, _config); // Build JWT (including Claims)
// 7. Save UserSession (needed for verification of token)
// tblUserSessions mySession = new tblUserSessions() { UserID = userJwt.UserId, SessionAttribute = userJwt.Token };
// var sessionOkay = _sessionService.SaveSession(userJwt);
return(userJwt);
}
else
{
return(new JwtModel()
{
});
}
}
public async Task <ActionResult <JwtModel> > Login([FromBody] LoginModel model)
{
var loginRequest = new LoginOperationRequest
{
Email = model.Email, Password = model.Password
};
var authenticationResult = await _loginOperation.Execute(loginRequest);
if (authenticationResult.IsAuthenticated)
{
var tokenModel = new JwtModel
{
Token = authenticationResult.Token,
Expires = authenticationResult.Expires
};
return(Ok(tokenModel));
}
return(Unauthorized());
}
public async Task AutheticateModelIsValid_TryAuthenticate_ReturnsUserAuthenticatedAndJwtToken()
{
var jwt = new JwtModel {
AccessToken = "TOKEN_AUTHETICATED", ExpiresAt = DateTime.Now
};
var model = new CredentialsInputModel {
Login = "******", Password = "******"
};
var userLogged = new UserLoggedOutputModel {
JsonWebToken = jwt, Login = "******", Name = "Vinicius Santana"
};
mockUserRepository.Setup(x => x.GetUserWithCompany(It.IsAny <string>(), It.IsAny <CancellationToken>())).ReturnsAsync(user);
mockJwtService.Setup(x => x.GenerateToken(It.IsAny <User>())).ReturnsAsync(jwt);
mockMapper.Setup(x => x.Map <UserLoggedOutputModel>(It.IsAny <User>())).Returns(userLogged);
var domain = GenerateUserService();
var result = await domain.Authenticate(model, new CancellationToken());
Assert.NotNull(result);
}
private async Task <string> GetAccessTokenAsync()
{
var generateJwtModel = new GenerateJwtModel
{
UserName = $"user-{Guid.NewGuid():N}",
Password = $"password-{Guid.NewGuid():N}",
};
using HttpClient httpClient = CreateClient();
HttpResponseMessage httpResponseMessage =
await httpClient.PostAsJsonAsync("api/jwt", generateJwtModel).ConfigureAwait(false);
if (!httpResponseMessage.IsSuccessStatusCode)
{
throw new CouldNotGetJwtException(httpResponseMessage);
}
JwtModel jwtModel =
await httpResponseMessage.Content.ReadAsAsync <JwtModel>().ConfigureAwait(false);
return(jwtModel.AccessToken);
}
public IActionResult refreshToken([FromBody] JwtModel model)
{
ClaimsPrincipal principal = Jwt.GetClaimsWithToken(model.accesToken);
var UserRefreshToken = Jwt.getRefreshTokenInBd(principal.Identity.Name, con);
if (UserRefreshToken != model.refreshToken)
{
HttpContext.Response.Headers.Add("refreshSave", UserRefreshToken);
HttpContext.Response.Headers.Add("refresh", model.refreshToken);
return(BadRequest());
}
string EnCodedJwt = new JwtSecurityTokenHandler().WriteToken(Jwt.GenerateToken(principal.Claims));
string NewRefreshToken = Jwt.SaveRefreshToken(principal.Identity.Name, con);
return(Ok(new
{
jwt = EnCodedJwt,
Refresh = NewRefreshToken
}));
}
private async Task <string> GetAccessTokenAsync()
{
var generateJwtModel = new GenerateJwtModel
{
UserName = $"user-{Guid.NewGuid():N}",
Password = $"password-{Guid.NewGuid():N}",
};
using HttpClient httpClient = CreateClientWithLoggingCapabilities();
HttpResponseMessage httpResponseMessage = await httpClient.PostAsync("api/jwt",
new StringContent(JsonConvert.SerializeObject(generateJwtModel), Encoding.UTF8, "application/json"));
if (!httpResponseMessage.IsSuccessStatusCode)
{
throw new CouldNotGetJwtException(httpResponseMessage);
}
JwtModel jwtModel =
JsonConvert.DeserializeObject <JwtModel>(await httpResponseMessage.Content.ReadAsStringAsync());
return(jwtModel.AccessToken);
}
public ResponseMessageResult Postfa_business_basic(fa_business_basic fa_business_basic)
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var info = db.fa_business_basic.Where(o => o.merchantName == fa_business_basic.merchantName && fa_business_basic.merchantid == o.merchantid).Count();
if (info > 0)
{
model.message = "商户名称已经存在";
model.status_code = 401;
}
else
{
fa_business_basic.addtime = DateTime.Now;
fa_business_basic.adduser = jwtmodel.username;
fa_business_basic.password = BaseHelper.Md5Hash(fa_business_basic.password);
db.fa_business_basic.Add(fa_business_basic);
try
{
db.SaveChanges();
model.message = "新增成功";
model.status_code = 200;
}
catch (Exception ex)
{
model.message = ex.Message;
model.status_code = 401;
}
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
// GET: api/Role
public ResponseMessageResult Getsy_role()
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var temp = from a in db.sy_role
select new
{
a.rolename,
a.roleid,
a.rolecode,
a.isadmin,
a.addtime,
a.adduser,
a.updatetime,
a.updateuser
};
model.data = temp.ToList();
if (model.data.Count > 0)
{
model.message = "查询成功";
model.status_code = 200;
}
else
{
model.message = "暂无数据";
model.status_code = 200;
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
public ResponseMessageResult Getfa_business_basic()
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var temp = from a in db.fa_business_basic
join b in db.fa_merchant_bank_card on a.appId equals b.merchantId
join c in db.sy_merchant on a.merchantid equals c.id
where c.id == jwtmodel.userid
select new
{
b.id,
card_bankaccountNo = b.bankaccountNo,
a.appId
};
model.total = temp.Count();
model.data = temp.ToList();
if (model.data.Count > 0)
{
model.message = "查询成功";
model.status_code = 200;
}
else
{
model.message = "暂无数据";
model.status_code = 200;
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
public IHttpActionResult Postsy_role(sy_role sy_role)
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var info = db.sy_role.Where(o => o.rolecode == sy_role.rolecode).Count();
if (info > 0)
{
model.message = "角色编码已经存在";
model.status_code = 401;
}
else
{
sy_role.addtime = DateTime.Now;
sy_role.adduser = jwtmodel.username;
db.sy_role.Add(sy_role);
try
{
db.SaveChanges();
model.message = "新增成功";
model.status_code = 200;
}
catch (Exception ex)
{
model.message = ex.Message;
model.status_code = 401;
}
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
// GET: api/Admin 用户登录
public ResponseMessageResult Get(string code, string password)
{
var temp = from a in db.sh_business_appinfo select a;
password = BaseHelper.Md5Hash(password);
model.data = temp.Where(o => o.sh_mobile == code && o.sh_password == password && o.status == true).FirstOrDefault();
if (model.data != null)
{
JwtModel jwtmodel = new JwtModel();
jwtmodel.userid = model.data.id;
jwtmodel.usercode = model.data.sh_mobile;
jwtmodel.username = model.data.sh_businessname;
jwtmodel.isadmin = true;
jwtmodel.rolecode = "admin";
JwtHelper.setToken(jwtmodel);
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)jwtmodel.status_code, jwtmodel)));
}
else
{
model.message = "用户名或密码错误";
model.status_code = 401;
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
}
public async Task <ActionResult> Login([FromBody] LoginDto model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.ValidationState));
}
JwtModel token = null;
try
{
token = await _authRepo.Login(model);
if (token == null)
{
return(BadRequest(new { Error = "User does not Exist or Invalid Password" }));
}
}
catch (Exception e)
{
_logger.LogError(e.InnerException?.ToString() ?? e.Message);
return(StatusCode(StatusCodes.Status500InternalServerError, "Internal Server Error"));
}
return(Ok(token));
}
// GET: api/Admin 用户列表
public ResponseMessageResult Getfa_open_payment(int page, int pagesize, string code)
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var temp = from a in db.fa_open_payment
join b in db.fa_business_basic on a.merchantId equals b.appId
join c in db.sy_merchant on b.merchantid equals c.id
join d in db.sy_agent on c.agid equals d.id
where (a.merchantId.Contains(code) || string.IsNullOrEmpty(code))
select new
{
a.id,
a.merchantId,
a.handleType,
a.cycleValue,
a.busiCode,
a.futureRateType,
a.futureRateValue,
a.futureMinAmount,
a.futureMaxAmount,
a.agencyId,
a.wechat_status,
a.wechat_rate,
a.alipay_status,
a.alipay_rate,
a.daipay_status,
a.daipay_rate,
a.qqpay_status,
a.qqpay_rate,
a.jdpay_status,
a.jdpay_rate,
a.unionpay_status,
a.unionpay_rate,
a.addtime,
a.adduser,
a.updatetime,
a.updateuser,
a.isaudit,
b.shortName,
merchantname = c.name,
agname = d.name
};
model.total = temp.Count();
model.data = temp.OrderByDescending(s => s.id).Skip((page - 1) * pagesize).Take(pagesize).ToList();
if (model.data.Count > 0)
{
model.message = "查询成功";
model.status_code = 200;
}
else
{
model.message = "暂无数据";
model.status_code = 200;
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
public ResponseMessageResult Putsy_agent(sy_agent sy_agent)
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var count = db.sy_agent.Where(o => o.name == sy_agent.name && o.id != sy_agent.id).Count();
if (count > 0)
{
model.message = "用户编码已经存在";
model.status_code = 401;
}
else
{
var info = db.sy_agent.Find(sy_agent.id);
if (!string.IsNullOrEmpty(sy_agent.password))
{
info.password = BaseHelper.Md5Hash(sy_agent.password);
}
info.name = sy_agent.name;
info.ratio = sy_agent.ratio;
info.account_name = sy_agent.account_name;
info.card_number = sy_agent.card_number;
info.bank_accounts = sy_agent.bank_accounts;
info.opening_address = sy_agent.opening_address;
info.opening_point = sy_agent.opening_point;
info.agency_level = sy_agent.agency_level;
info.direct_identity = sy_agent.direct_identity;
info.agent_rights = sy_agent.agent_rights;
info.agency_amount = sy_agent.agency_amount;
info.agency_expiration_date = sy_agent.agency_expiration_date;
info.user_status = sy_agent.user_status;
info.remarks = sy_agent.remarks;
info.corporate_name = sy_agent.corporate_name;
info.province = sy_agent.province;
info.city = sy_agent.city;
info.area = sy_agent.area;
info.industry_owned = sy_agent.industry_owned;
info.main_business = sy_agent.main_business;
info.company_number = sy_agent.company_number;
info.annual_turnover = sy_agent.annual_turnover;
info.contacts = sy_agent.contacts;
info.contact_number = sy_agent.contact_number;
info.mobile_phone = sy_agent.mobile_phone;
info.qq_number = sy_agent.qq_number;
info.mail_box = sy_agent.mail_box;
info.proof_document = sy_agent.proof_document;
info.company_logo = sy_agent.company_logo;
info.is_alipay = sy_agent.is_alipay;
info.is_jd = sy_agent.is_jd;
info.is_t0 = sy_agent.is_t0;
info.updatetime = DateTime.Now;
info.updateuser = jwtmodel.username;
info.domain = sy_agent.domain;
info.bus_domain = sy_agent.bus_domain;
//db.Entry(sy_agent).State = EntityState.Modified;
try
{
model.message = "修改成功";
model.status_code = 200;
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
model.message = ex.Message;
model.status_code = 401;
}
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
public ResponseMessageResult Getsy_merchant(int page, int pagesize, string code)
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var temp = from a in db.sy_merchant
join b in db.sy_agent on a.agid equals b.id
where (a.name.Contains(code) || string.IsNullOrEmpty(code)) &&
a.agid == jwtmodel.userid
select new
{
a.id,
a.name,
a.agid,
a.user_status,
a.user_rights,
a.merchant_name,
a.province,
a.city,
a.area,
a.merchant_address,
a.contacts,
a.contact_information,
a.mail_box,
a.qq_number,
a.expiration_date,
a.enabletime,
a.disabletime,
a.payment_limit,
a.recharge_limit,
a.last_login_time,
a.addtime,
a.adduser,
a.appid,
a.appsecret,
agname = b.name,
a.comm_ratio,
a.company_logo,
a.domain
};
model.total = temp.Count();
model.data = temp.OrderByDescending(s => s.id).Skip((page - 1) * pagesize).Take(pagesize).ToList();
if (model.data.Count > 0)
{
model.message = "查询成功";
model.status_code = 200;
}
else
{
model.message = "暂无数据";
model.status_code = 200;
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
public ResponseMessageResult Putfa_business_basic(fa_business_basic fa_business_basic)
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var info = db.fa_business_basic.Find(fa_business_basic.id);
if (!string.IsNullOrEmpty(fa_business_basic.password))
{
info.password = BaseHelper.Md5Hash(fa_business_basic.password);
}
var db_content = ContextDB.Context();
db_content.Execute("exec p_alipaydetail_add @0,@1", fa_business_basic.id, fa_business_basic.alipayaccount);
info.isaudit = fa_business_basic.isaudit;
info.merchantid = fa_business_basic.merchantid;
info.merchantName = fa_business_basic.merchantName;
info.shortName = fa_business_basic.shortName;
info.handleType = fa_business_basic.handleType;
info.city = fa_business_basic.city;
info.merchantAddress = fa_business_basic.merchantAddress;
info.servicePhone = fa_business_basic.servicePhone;
info.orgCode = fa_business_basic.orgCode;
info.merchantType = fa_business_basic.merchantType;
info.category = fa_business_basic.category;
info.corpmanName = fa_business_basic.corpmanName;
info.corpmanId = fa_business_basic.corpmanId;
info.corpmanPhone = fa_business_basic.corpmanPhone;
info.corpmanMobile = fa_business_basic.corpmanMobile;
info.corpmanEmail = fa_business_basic.corpmanEmail;
info.bankCode = fa_business_basic.bankCode;
info.bankName = fa_business_basic.bankName;
info.bankaccountNo = fa_business_basic.bankaccountNo;
info.bankaccountName = fa_business_basic.bankaccountName;
info.autoCus = fa_business_basic.autoCus;
info.remark = fa_business_basic.remark;
info.licenseNo = fa_business_basic.licenseNo;
info.taxRegisterNo = fa_business_basic.taxRegisterNo;
info.appId = fa_business_basic.appId;
info.appSecret = fa_business_basic.appSecret;
info.status = fa_business_basic.status;
info.addrType = fa_business_basic.addrType;
info.contactType = fa_business_basic.contactType;
info.mcc = fa_business_basic.mcc;
info.licenseType = fa_business_basic.licenseType;
info.contactMan = fa_business_basic.contactMan;
info.telNo = fa_business_basic.telNo;
info.mobilePhone = fa_business_basic.mobilePhone;
info.email = fa_business_basic.email;
info.licenseBeginDate = fa_business_basic.licenseBeginDate;
info.licenseEndDate = fa_business_basic.licenseEndDate;
info.licenseRange = fa_business_basic.licenseRange;
info.ratio = fa_business_basic.ratio;
info.minAmount = fa_business_basic.minAmount;
info.maxAmount = fa_business_basic.maxAmount;
info.disabletime = fa_business_basic.disabletime;
info.enabletime = fa_business_basic.enabletime;
info.updatetime = DateTime.Now;
info.updateuser = jwtmodel.username;
info.agentid = fa_business_basic.agentid;
info.depositratio = fa_business_basic.depositratio;
info.businesspasstype = fa_business_basic.businesspasstype;
info.wechatratio = fa_business_basic.wechatratio;
info.alipayratio = fa_business_basic.alipayratio;
info.unionratio = fa_business_basic.unionratio;
info.alipayaccount = fa_business_basic.alipayaccount;
try
{
model.message = "修改成功";
model.status_code = 200;
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
model.message = ex.Message;
model.status_code = 401;
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
public ResponseMessageResult Getfa_business_basic(int page, int pagesize, string code, int merchantid)
{
JwtModel jwtmodel = JwtHelper.getToken(HttpContext.Current.Request.Headers.GetValues("Authorization").First().ToString());
if (jwtmodel.isadmin)
{
var temp = from a in db.fa_business_basic
join b in db.sy_merchant on a.merchantid equals b.id
join c in db.sy_agent on a.agentid equals c.id
where (a.merchantName.Contains(code) || b.name.Contains(code) || c.name.Contains(code) || a.shortName.Contains(code) || string.IsNullOrEmpty(code)) &&
(a.merchantid == merchantid || merchantid <= 0)
select new
{
a.balance,
a.id,
a.code,
a.password,
a.merchantid,
a.merchantName,
a.shortName,
a.handleType,
a.city,
a.merchantAddress,
a.servicePhone,
a.orgCode,
a.merchantType,
a.category,
a.corpmanName,
a.corpmanId,
a.corpmanPhone,
a.corpmanMobile,
a.corpmanEmail,
a.bankCode,
a.bankName,
a.bankaccountNo,
a.bankaccountName,
a.autoCus,
a.remark,
a.licenseNo,
a.taxRegisterNo,
a.appId,
a.appSecret,
a.status,
a.addtime,
a.adduser,
a.updatetime,
a.updateuser,
a.isaudit,
mername = b.name,
agname = c.name,
a.addrType,
a.contactType,
a.mcc,
a.licenseType,
a.contactMan,
a.telNo,
a.mobilePhone,
a.email,
a.licenseBeginDate,
a.licenseEndDate,
a.licenseRange,
a.ratio,
a.minAmount,
a.maxAmount,
a.disabletime,
a.enabletime,
a.agentid,
a.depositratio,
c.bus_domain,
a.businesspasstype,
a.wechatratio,
a.alipayratio,
a.unionratio,
a.alipayaccount
};
model.total = temp.Count();
model.data = temp.OrderByDescending(s => s.id).Skip((page - 1) * pagesize).Take(pagesize).ToList();
if (model.data.Count > 0)
{
model.message = "查询成功";
model.status_code = 200;
}
else
{
model.message = "暂无数据";
model.status_code = 200;
}
}
else
{
model.message = "用户权限不足";
model.status_code = 401;
}
return(new ResponseMessageResult(Request.CreateResponse((HttpStatusCode)model.status_code, model)));
}
