public ActionResult Audit(StopPayAudit StopPayAudit)
{
if (StopPayAudit.Id.IsNullOrEmpty())
{
ViewBag.ErrorMsg = "请填写ID";
return(View("Error"));
}
var BaseStopPayAudit = Entity.StopPayAudit.FirstOrDefault(o => o.Id == StopPayAudit.Id);
if (BaseStopPayAudit == null)
{
ViewBag.ErrorMsg = "数据不存在";
return(View("Error"));
}
var BaseUsers = this.Entity.Users.FirstOrDefault(o => o.Id == BaseStopPayAudit.UId);
if (BaseUsers == null)
{
ViewBag.ErrorMsg = "数据不存在";
return(View("Error"));
}
if (!BaseUsers.IfUnFrozenAudit())
{
ViewBag.ErrorMsg = "不符合解冻审核规则";
return(View("Error"));
}
//商户数据修改
BaseUsers.StopPayAuditState = StopPayAudit.TState;
if (BaseUsers.StopPayAuditState == 2)
{
BaseUsers.StopPayState = 0;
}
BaseStopPayAudit.TState = StopPayAudit.TState;
BaseStopPayAudit.AuditRemark = StopPayAudit.AuditRemark;
BaseStopPayAudit.AuditInteriorRemark = StopPayAudit.AuditInteriorRemark;
BaseStopPayAudit.AuditTime = DateTime.Now;
BaseStopPayAudit.AuditAdminId = this.AdminUser.Id;
BaseStopPayAudit.AuditAdminName = this.AdminUser.TrueName;
//记录日志
var UserFrozenLog = new UserFrozenLog()
{
Img = string.Empty,
Remark = StopPayAudit.AuditRemark,
AddTime = DateTime.Now,
OpName = this.AdminUser.TrueName,
UId = BaseUsers.Id,
LogType = StopPayAudit.TState,
OpType = 2,
AId = this.AdminUser.Id,
InteriorRemark = StopPayAudit.AuditInteriorRemark,
Platform = 2,
};
this.Entity.UserFrozenLog.AddObject(UserFrozenLog);
this.Entity.SaveChanges();
ViewBag.Title = "操作成功";
ViewBag.Msg = "操作结果：审核" + (StopPayAudit.TState == 2 ? "通过" : "不通过");
return(View("Succeed"));
}
public JsonResult EditUpLoadUsers()
{
JsonResult json = new JsonResult();
try
{
//上传
var file = HttpContext.Request.Files.Get("UpLoadFile");
var savePath = "/UpLoadFiles/Users/";
var param = new UpLoadFileParam(file, savePath, false);
param.AllowType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
json.Data = UpLoadFileHelpOld.UpLoadFileExcel(param);
//var sjson = JsonConvert.SerializeObject(json.Data);
//var djson = JsonConvert.DeserializeObject(sjson) as JObject;
//JToken Result = djson["Result"];
//string filename = Result["SaveFileName"].ToString();
string filename = param.SaveFileName;
//获取数据
string path = Server.MapPath("//UpLoadFiles/Users") + "\\" + filename;
ExcelPackage package = new ExcelPackage(new FileInfo(path), true);
var sheet = package.Workbook.Worksheets[1];
int rows = sheet.Dimension.End.Row;
int OpType = 0;
for (int i = 2; i < rows + 1; i++)
{
Users baseUsers = new Users();
if (sheet.Cells[i,1].Value != null)
{
string mobile=sheet.Cells[i, 1].Value.ToString().Replace(" ", "");
baseUsers = Entity.Users.FirstOrNew(o => o.Mobile == mobile);
}
else if(sheet.Cells[i,2].Value!=null)
{
string cardid = sheet.Cells[i, 2].Value.ToString().Replace(" ", "");
baseUsers = Entity.Users.FirstOrNew(o => o.CardId == cardid && o.CardStae == 2);
}
if (!baseUsers.Id.IsNullOrEmpty()&&sheet.Cells[i,3].Value!=null)
{
decimal StopPayMoney = 0;
#region 部分止付
if (sheet.Cells[i, 3].Value.ToString() == "部分止付")//部份
{
OpType = 3;
if (sheet.Cells[i, 4].Value != null)
{
StopPayMoney =Math.Round(Convert.ToDecimal(sheet.Cells[i, 4].Value),2);
if (StopPayMoney < 0)
{ continue; }
}
//帐户变动记录
string SP_Ret = Entity.SP_UsersMoney(baseUsers.Id, "部分止付", StopPayMoney, 9, "部分止付");
if (SP_Ret != "3")
{
Utils.WriteLog(string.Format("U{0},O{1},T{2}:{3}【{4}】", baseUsers.Id, "部分止付", 9, StopPayMoney, SP_Ret), "SP_UsersMoney");
}
baseUsers = this.Entity.Users.FirstOrDefault(o => o.Id == baseUsers.Id);
if (baseUsers.StopPayState == 0)
{
baseUsers.StopPayMoney = StopPayMoney;
}
else if (baseUsers.StopPayState == 1)
{
baseUsers.StopPayMoney += StopPayMoney;
}
else if (baseUsers.StopPayState == 2)
{
baseUsers.StopPayMoney = StopPayMoney;
}
baseUsers.StopPayState = 1;
//日记写入
var UserFrozenLog = new UserFrozenLog()
{
AddTime = DateTime.Now,
OpName = AdminUser.TrueName,
AId = AdminUser.Id,
OpType = OpType,
LogType = 2,
UId = baseUsers.Id,
StopPayMoney = StopPayMoney,
Remark = sheet.Cells[i, 5].Value == null ? "" : sheet.Cells[i, 5].Value.ToString().Length > 1999 ? sheet.Cells[i, 5].Value.ToString().Substring(0, 1999) : sheet.Cells[i, 5].Value.ToString(),
Platform = 2,
InteriorRemark = sheet.Cells[i, 6].Value == null ? "" : sheet.Cells[i, 6].Value.ToString().Length > 1999 ? sheet.Cells[i, 6].Value.ToString().Substring(0, 1999) : sheet.Cells[i, 6].Value.ToString(),
};
Entity.UserFrozenLog.AddObject(UserFrozenLog);
//Entity.SaveChanges();
}
#endregion
#region 全止付
if (sheet.Cells[i, 3].Value.ToString() == "全止付")//全帐户
{
OpType = 1;
if (baseUsers.StopPayState == 0)
{
baseUsers.StopPayState = 2;
baseUsers.AutoBao = 0;
baseUsers.AutoCash = 0;
}
else if (baseUsers.StopPayState == 1)
{
StopPayMoney = baseUsers.StopPayMoney;
if (StopPayMoney > 0)
{
//帐户变动记录
string SP_Ret = Entity.SP_UsersMoney(baseUsers.Id, "解除部分止付", StopPayMoney, 10, "解除部分止付");
if (SP_Ret != "3")
{
Utils.WriteLog(string.Format("U{0},O{1},T{2}:{3}【{4}】", baseUsers.Id, "解除部分止付", 10, StopPayMoney, SP_Ret), "SP_UsersMoney");
}
baseUsers = this.Entity.Users.FirstOrDefault(o => o.Id == baseUsers.Id);
baseUsers.StopPayState = 2;
baseUsers.AutoBao = 0;
baseUsers.AutoCash = 0;
baseUsers.StopPayMoney = 0;
}
}
else if (baseUsers.StopPayState == 2)
{
continue;
}
//日记写入
var UserFrozenLog = new UserFrozenLog()
{
AddTime = DateTime.Now,
OpName = AdminUser.TrueName,
AId = AdminUser.Id,
OpType = OpType,
LogType = 2,
UId = baseUsers.Id,
StopPayMoney = StopPayMoney,
Remark = sheet.Cells[i, 5].Value == null ? "" : sheet.Cells[i, 5].Value.ToString().Length>1999?sheet.Cells[i, 5].Value.ToString().Substring(0,1999):sheet.Cells[i, 5].Value.ToString(),
Platform = 2,
InteriorRemark = sheet.Cells[i, 6].Value == null ? "" : sheet.Cells[i, 6].Value.ToString().Length > 1999 ? sheet.Cells[i, 6].Value.ToString().Substring(0, 1999) : sheet.Cells[i, 6].Value.ToString(),
};
Entity.UserFrozenLog.AddObject(UserFrozenLog);
}
#endregion
}
}
Entity.SaveChanges();
return json;
}
catch
{
json = new JsonResult();
return json;
}
}
public ActionResult UnFrozen(StopPayAudit StopPayAudit)
{
#region 条件
if (StopPayAudit.UId.IsNullOrEmpty())
{
ViewBag.ErrorMsg = "请选择目标商户";
return(View("Error"));
}
StopPayAudit = Request.ConvertRequestToModel <StopPayAudit>(StopPayAudit, StopPayAudit);
if (StopPayAudit.Pic == "System.Web.HttpPostedFileWrapper" || StopPayAudit.Pic == null)
{
ViewBag.ErrorMsg = "文件类型错误";
return(View("Error"));
}
if (StopPayAudit.Remark.IsNullOrEmpty())
{
ViewBag.ErrorMsg = "请填写解除止付原因";
return(View("Error"));
}
var BaseUsers = this.Entity.Users.Where(o => o.Id == StopPayAudit.UId).FirstOrDefault();
if (BaseUsers == null)
{
ViewBag.ErrorMsg = AgentLanguage.Empty;
return(View("Error"));
}
if (!BaseUsers.IfUnFrozen())
{
ViewBag.ErrorMsg = "不符合解除止付规则，无法解除";
return(View("Error"));
}
var ForSysAgent = BaseUsers.ForSysAgent(this.Entity);
if (ForSysAgent != null)
{
ViewBag.ErrorMsg = "代理商钱包账号无法解除止付";
return(View("Error"));
}
if (this.BasicAgent.Tier != 1)
{
if (BaseUsers.Agent != this.BasicAgent.Id)
{
ViewBag.ErrorMsg = "不能解除下级的商户";
return(View("Error"));
}
}
else if (!IsBelongToAgent(BaseUsers.Agent))
{
ViewBag.ErrorMsg = AgentLanguage.Surmount;
return(View("Error"));
}
#endregion
BaseUsers.StopPayAuditState = 1;
StopPayAudit.AddTime = DateTime.Now;
StopPayAudit.CreateAdminId = this.AdminUser.Id;
StopPayAudit.CreateAdminName = this.AdminUser.TrueName;
StopPayAudit.StopPayMoney = 0;
StopPayAudit.StopPayType = 2;
StopPayAudit.TState = 1;
StopPayAudit.Agent = BaseUsers.Agent;
this.Entity.StopPayAudit.AddObject(StopPayAudit);
var UserFrozenLog = new UserFrozenLog()
{
AddTime = DateTime.Now,
OpName = AdminUser.TrueName,
AId = AdminUser.Id,
OpType = 2,
LogType = 1,
UId = StopPayAudit.UId,
StopPayMoney = 0,
Remark = StopPayAudit.Remark,
Platform = 1,
InteriorRemark = string.Empty,
Img = StopPayAudit.Pic,
};
this.Entity.UserFrozenLog.AddObject(UserFrozenLog);
this.Entity.SaveChanges();
ViewBag.Title = "操作成功";
ViewBag.Msg = BaseUsers.UserName + "申请解除止付成功，请等待审核";
return(View("Succeed"));
}
public ActionResult StopPaySave(Users Users)
{
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Id == Users.Id);
if (baseUsers == null)
{
ViewBag.ErrorMsg = "数据不存在";
return View("Error");
}
if (Users.Remark.IsNullOrEmpty())
{
ViewBag.ErrorMsg = "请填写备注";
return View("Error");
}
string State = "无改变";
int OpType = 0;
decimal StopPayMoney = 0m;
#region 解止付
if (Users.StopPayState == 0)//解
{
OpType = 2;
var StopPayAudit = Entity.StopPayAudit.FirstOrDefault(o => o.UId == Users.Id && (o.TState == 1 || o.TState == 3));
if (baseUsers.StopPayState == 0)
{
ViewBag.ErrorMsg = "当前没有止付，无需解止付！";
return View("Error");
}
else if (baseUsers.StopPayState == 1)
{
StopPayMoney = baseUsers.StopPayMoney;
if (StopPayMoney > 0)
{
//帐户变动记录
string SP_Ret = Entity.SP_UsersMoney(baseUsers.Id, "解除部分止付", StopPayMoney, 10, "解除部分止付");
if (SP_Ret != "3")
{
Utils.WriteLog(string.Format("U{0},O{1},T{2}:{3}【{4}】", baseUsers.Id, "解除部分止付", 10, StopPayMoney, SP_Ret), "SP_UsersMoney");
}
baseUsers = this.Entity.Users.FirstOrDefault(o => o.Id == baseUsers.Id);
baseUsers.StopPayMoney = 0;
baseUsers.StopPayState = 0;
baseUsers.StopPayAuditState = 2;
}
State = "部分止付→正常";
}
else if (baseUsers.StopPayState == 2)
{
baseUsers.StopPayState = 0;
baseUsers.StopPayAuditState = 2;
State = "全止付→正常";
}
if (baseUsers.StopPayState == 0 && StopPayAudit != null)
{
StopPayAudit.TState = 2;
StopPayAudit.AuditAdminId = this.AdminUser.Id;
StopPayAudit.AuditAdminName = this.AdminUser.TrueName;
StopPayAudit.AuditRemark = Users.Remark;
StopPayAudit.AuditInteriorRemark = Users.CardRemark;
StopPayAudit.AuditTime = DateTime.Now;
}
}
#endregion
#region 部分止付
if (Users.StopPayState == 1)//部份
{
OpType = 3;
StopPayMoney = Users.StopPayMoney;
if (StopPayMoney.IsNullOrEmpty())
{
ViewBag.ErrorMsg = "止付金额设置错误！";
return View("Error");
}
//帐户变动记录
string SP_Ret = Entity.SP_UsersMoney(baseUsers.Id, "部分止付", StopPayMoney, 9, "部分止付");
if (SP_Ret != "3")
{
Utils.WriteLog(string.Format("U{0},O{1},T{2}:{3}【{4}】", baseUsers.Id, "部分止付", 9, StopPayMoney, SP_Ret), "SP_UsersMoney");
}
baseUsers = this.Entity.Users.FirstOrDefault(o => o.Id == baseUsers.Id);
if (baseUsers.StopPayState == 0)
{
baseUsers.StopPayMoney = StopPayMoney;
State = "正常→部分止付";
}
else if (baseUsers.StopPayState == 1)
{
baseUsers.StopPayMoney += StopPayMoney;
State = "部分止付→部分止付";
}
else if (baseUsers.StopPayState == 2)
{
baseUsers.StopPayMoney = StopPayMoney;
State = "全止付→部分止付";
}
baseUsers.StopPayState = 1;
//baseUsers.Frozen += StopPayMoney;
//baseUsers.Amount -= StopPayMoney;
}
#endregion
#region 全止付
if (Users.StopPayState == 2)//全帐户
{
OpType = 1;
if (baseUsers.StopPayState == 0)
{
baseUsers.StopPayState = 2;
baseUsers.AutoBao = 0;
baseUsers.AutoCash = 0;
State = "正常→全止付";
}
else if (baseUsers.StopPayState == 1)
{
StopPayMoney = baseUsers.StopPayMoney;
if (StopPayMoney > 0)
{
//帐户变动记录
string SP_Ret = Entity.SP_UsersMoney(baseUsers.Id, "解除部分止付", StopPayMoney, 10, "解除部分止付");
if (SP_Ret != "3")
{
Utils.WriteLog(string.Format("U{0},O{1},T{2}:{3}【{4}】", baseUsers.Id, "解除部分止付", 10, StopPayMoney, SP_Ret), "SP_UsersMoney");
}
baseUsers = this.Entity.Users.FirstOrDefault(o => o.Id == baseUsers.Id);
baseUsers.StopPayState = 2;
baseUsers.AutoBao = 0;
baseUsers.AutoCash = 0;
baseUsers.StopPayMoney = 0;
}
State = "部分止付→全止付";
}
else if (baseUsers.StopPayState == 2)
{
ViewBag.ErrorMsg = "当前状态无变动！";
return View("Error");
}
}
#endregion
var UserFrozenLog = new UserFrozenLog()
{
AddTime = DateTime.Now,
OpName = AdminUser.TrueName,
AId = AdminUser.Id,
OpType = OpType,
LogType = 2,
UId = Users.Id,
StopPayMoney = StopPayMoney,
Remark = Users.Remark,
Platform = 2,
InteriorRemark = Users.CardRemark,
};
Entity.UserFrozenLog.AddObject(UserFrozenLog);
Entity.SaveChanges();
ViewBag.Msg = State;
return View("Succeed");
}
