public HttpResponseMessage SetMemberRole(string MemberCode, int RoleID, string ShopIDS)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C015_MBController_SetMemberRole";
var msg = "";
try
{
var ShopIDSList = ShopIDS.ToArryList('_');
if (ShopIDSList.Count == 0)
{
response.SetContent(HttpStatus.error, "营业部不能为空", ShopIDSList.Count, ResponseType.josn);
return(response);
}
var role = new ORM.SqlSugar.Model.mb.mb_MemberRole();
role.MemberCode = MemberCode;
role.RoleID = RoleID.ToInt32();
var result = db.SqlServerClient.Ado.UseTran(() =>
{
mb.mb_MemberRoleSugar.Insert(role);
foreach (var item in ShopIDSList)
{
var memberCrop = new ORM.SqlSugar.Model.mb.mb_MemberCorp();
memberCrop.MemberCode = MemberCode;
memberCrop.CorpCode = org.org_ShopSugar.GetById(item.ToInt32()).CorpCode;
memberCrop.ShopID = item.ToInt32();
memberCrop.CreateTime = DateTime.Now;
mb.mb_MemberCorpSugar.Insert(memberCrop);
}
});
if (result.IsSuccess)
{
response.SetContent(HttpStatus.ok, "分配成功", result, ResponseType.josn);
}
else
{
response.SetContent(HttpStatus.error, "分配失败", result.ErrorMessage, ResponseType.josn);
}
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.org, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage VerifyJoinIn(string MemberCode, string JoinTime)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C066_EQMController_VerifyJoinIn";
var msg = "";
try
{
var join = org.org_JoinInSugar.GetSingle(p => p.MemberCode == MemberCode && p.JoinTime == JoinTime.ToDateTime());
if (join == null)
{
response.SetContent(HttpStatus.error, "不存在这条记录", join, ResponseType.josn);
return(response);
}
join.Status = 1;
var result = db.SqlServerClient.Ado.UseTran(() =>
{
if (string.IsNullOrEmpty(join.CorpCode))
{
//创建企业
var corp = new ORM.SqlSugar.Model.org.org_CorpMaster();
var CorpCode = org.GetCorpCode(join.CorpProvince);
corp.CorpCode = CorpCode;
corp.CorpName = join.CorpName;
corp.SocialCreditCode = join.SocialCreditCode;
corp.RegisteredAddr = join.CorpAddr;
join.CorpCode = corp.CorpCode;
org.org_CorpMasterSugar.Insert(corp);
}
if (join.ShopID == 0)
{
//创建营业部
var shop = new ORM.SqlSugar.Model.org.org_Shop();
shop.ShopName = join.ShopName;
shop.Address = join.CorpAddr;
shop.CorpCode = join.CorpCode;
shop.DutyMemberCode = MemberCode;
var id = org.org_ShopSugar.InsertReturnIdentity(shop);
join.ShopID = id;
}
var mc = new ORM.SqlSugar.Model.mb.mb_MemberCorp();
mc.MemberCode = MemberCode;
mc.CorpCode = join.CorpCode;
mc.ShopID = join.ShopID.ToInt32();
mc.CreateTime = DateTime.Now;
mb.mb_MemberCorpSugar.Insert(mc);
org.org_JoinInSugar.Update(join);
});
if (result.IsSuccess)
{
response.SetContent(HttpStatus.ok, "审核成功", join, ResponseType.josn);
}
else
{
response.SetContent(HttpStatus.error, result.ErrorMessage, null, ResponseType.josn);
}
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.org, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage PayBalance(string MemberCode, string CardNo)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C028_SysControllerr_PayBalance";
try
{
if (CardNo.Contains("Card"))
{
var Card = mb.mb_CardList.GetById(CardNo);
var vCard = org.org_VirtualCardSugar.GetById(Card.VCardNo);
var wallet = mb.mb_WalletSugar.GetById(MemberCode);
if (wallet == null)
{
response.SetContent(HttpStatus.error, "没找到您的余额账户！", Card, ResponseType.josn);
return(response);
}
if (wallet.Balance < Card.Amount)
{
response.SetContent(HttpStatus.error, "您的余额不足，请充值！", Card, ResponseType.josn);
return(response);
}
var result = db.SqlServerClient.Ado.UseTran(() =>
{
var f = mb.FinshRecharg(Card, vCard);
if (f)
{
Card.Status = 3;
Card.PayNo = "Balance" + JVS_ADM.Common.Utils.GetRamCode();
Card.PayTime = DateTime.Now;
mb.mb_CardList.Update(Card);
var crdLog = new ORM.SqlSugar.Model.crd.crd_BalanceLog();
crdLog.BalanceNo = "Balance" + Utils.GetRamCode() + "";
crdLog.Balance = -Card.Amount;
crdLog.OriginalBalance = -Card.Amount;
crdLog.DonationBalance = 0;
crdLog.BalanceID = 0;
crdLog.MemberCode = MemberCode;
crdLog.BalanceType = 2;
crdLog.Remark = "";
crdLog.TradeNo = "";
crdLog.PayTime = null;
crdLog.PayWay = 0;
crdLog.Status = 3;
crdLog.CreateDate = DateTime.Now;
crd.crd_BalanceLogSQLSugar.Insert(crdLog);
wallet.Balance = wallet.Balance - Card.Amount;
mb.mb_WalletSugar.Update(wallet);
if (mb.mb_MemberCorpSugar.Count(p => p.MemberCode == Card.MemberCode && p.CorpCode == vCard.CorpCode) <= 0)
{
var mcorp = new ORM.SqlSugar.Model.mb.mb_MemberCorp();
mcorp.CorpCode = vCard.CorpCode;
mcorp.MemberCode = Card.MemberCode;
mcorp.ShopID = 0;
mcorp.CreateTime = DateTime.Now;
mb.mb_MemberCorpSugar
.Insert(mcorp);
}
}
});
if (result.IsSuccess)
{
response.SetContent(HttpStatus.ok, "支付完成", Card, ResponseType.josn);
return(response);
}
else
{
response.SetContent(HttpStatus.error, "余额扣款失败", Card, ResponseType.josn);
return(response);
}
}
response.SetContent(HttpStatus.error, "余额支付失败", "", ResponseType.josn);
return(response);
}
catch (Exception ex)
{
AddErrorLog(LogEnum.member, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, ex.Message, ResponseType.josn);
return(response);
}
}