public HttpResponseMessage GetCardType(string MemberCode, string ProjectCode)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C084_PDController_GetCardType";
var msg = "";
try
{
if (string.IsNullOrEmpty(ProjectCode))
{
var CardType = pd.pd_ProductTypeSugar.GetList(p => p.SaleCard == true);
response.SetContent(HttpStatus.ok, "获取成功", CardType, ResponseType.josn);
}
else
{
var CardType = pd.pd_ProductTypeSugar.GetList(p => p.SaleCard == true && p.ProjectCode == ProjectCode);
response.SetContent(HttpStatus.ok, "获取成功", CardType, ResponseType.josn);
}
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.pd, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage GetBalanceTypeList(bool IsOnline)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C102_CrdController_GetBalanceTypeList";
var msg = "";
try
{
var BalanceType = crd.crd_BalanceTypeSQLSugar.GetList(p => p.IsOnline == true);
var lists = new List <object>();
foreach (var item in BalanceType)
{
var list = new { BalanceID = item.BalanceID, CreateTime = item.CreateTime, Description = item.Description, IsOnline = item.IsOnline, OriginalAmount = item.OriginalAmount, DonationAmount = item.DonationAmount };
lists.Add(list);
}
response.SetContent(HttpStatus.ok, "查询成功", lists, ResponseType.josn);
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.adv, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage code2Session(string appid, string js_code)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "A022_SysController_code2Session";
try
{
var model = sysManager.WxConfigSQLSugar.GetById(appid);
if (model == null)
{
response.SetContent(HttpStatus.ok, "appid不在配置中", "", ResponseType.josn);
return(response);
}
WebClient web = new WebClient();
web.Encoding = Encoding.UTF8;
var url = "https://api.weixin.qq.com/sns/jscode2session?appid=" + appid + "&secret=" + model.AppSecret + "&js_code=" + js_code + "&grant_type=authorization_code";
var res = web.DownloadString(url);
response.SetContent(HttpStatus.ok, "获取成功", res, ResponseType.josn);
}
catch (Exception ex)
{
AddErrorLog(LogEnum.sys, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, null, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage GetVersionList(string ver)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "A020_SysController_GetVersionList";
try
{
var curVersion = ver.ToDouble();
var verModel = db.SqlServerClient.Queryable <ORM.SqlSugar.Model.sys.sys_AppVersion>().OrderBy(p => p.Version, OrderByType.Desc).Where(p => p.Version > curVersion).Take(1).Single();
if (verModel != null)
{
System.IO.FileInfo fileInfo = new System.IO.FileInfo(server.MapPath(verModel.PackageUrl));
var rbj = new { verModel = verModel, length = fileInfo.Length };
response.SetContent(HttpStatus.ok, "获取成功", rbj, ResponseType.josn);
return(response);
}
response.SetContent(HttpStatus.error, "未获取到版本", null, ResponseType.josn);
}
catch (Exception ex)
{
AddErrorLog(LogEnum.sys, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, null, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage SaveFile(string fileName)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C024_SysController_SaveFile";
try
{
Stream st = context.Request.InputStream;
var savePath = "/fileServer/File/" + fileName;
if (!Directory.Exists(context.Request.MapPath("/fileServer/File//")))
{
Directory.CreateDirectory(context.Request.MapPath("/fileServer/File//"));
}
string fileSavePath = context.Request.MapPath(savePath);
byte[] buffer = new byte[st.Length];
st.Read(buffer, 0, buffer.Length);
if (File.Exists(fileSavePath))
{
File.Delete(fileSavePath);
}
File.WriteAllBytes(fileSavePath, buffer);
response.SetContent(HttpStatus.ok, "上传成功", savePath, ResponseType.josn);
}
catch (Exception ex)
{
AddErrorLog(LogEnum.sys, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, null, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage SetBalanceType(int BalanceID, string Description, decimal OriginalAmount, decimal DonationAmount, bool IsOnline, string CorpCode)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C103_CrdController_SetBalanceType";
var msg = "";
try
{
var BalanceType = crd.crd_BalanceTypeSQLSugar.GetById(BalanceID);
BalanceType.Description = Description;
BalanceType.OriginalAmount = OriginalAmount;
BalanceType.DonationAmount = DonationAmount;
BalanceType.IsOnline = IsOnline;
BalanceType.CorpCode = CorpCode;
var result = crd.crd_BalanceTypeSQLSugar.Insert(BalanceType);
response.SetContent(HttpStatus.ok, "修改成功", result, ResponseType.josn);
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.adv, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage QeuryMemberUser(string thMobile)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C007_MBController_QeuryMBProduct";
try
{
var pd = new pdMannager();
var user = mb.mb_BaseInfoSQLSugar.GetList(p => p.NewestMobile == thMobile).First();
if (user == null)
{
response.SetContent(HttpStatus.error, "会员不存在", user, ResponseType.josn);
return(response);
}
response.SetContent(HttpStatus.ok, "查询成功", user, 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);
}
}
public HttpResponseMessage CardDelete(string MemberCode, string CardNo)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C072_ORGController_CardDelete";
var msg = "";
try
{
//var cardNo = org.org_VirtualCardSugar.GetById(CardNum);
var result = db.SqlServerClient.Ado.UseTran(() =>
{
org.org_VirtualCardSugar.DeleteById(CardNo);
org.org_VirtualCardBelongSugar.Delete(p => p.CardNo == CardNo);
});
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 ReservedEQMList(string MemberCode, int pageIndex, int pageSize, int Status, bool isManager, string EqmUID)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C054_EQMController_ReservedEQMList";
var msg = "";
try
{
var exp = Expressionable.Create <ORM.SqlSugar.Model.order.order_Reserved>();
exp.And(p => p.Status == Status);
if (!isManager)
{
exp.And(p => p.MemberCode == MemberCode);
}
if (string.IsNullOrEmpty(EqmUID))
{
exp.And(p => p.EqmUID == EqmUID);
}
var totalCount = 0;
var list = db.SqlServerClient.Queryable <ORM.SqlSugar.Model.order.order_Reserved>().Where(exp.ToExpression()).OrderBy(it => it.ReservedTime).ToPageList(pageIndex, pageSize, ref totalCount);
var rbj = new { list = list, totalCount = totalCount };
response.SetContent(HttpStatus.ok, "获取成功", rbj, ResponseType.josn);
return(response);
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.eqm, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage QeuryEQMOrder(string MemberCode, string ProjectCode, int pageIndex, int pageSize, int Status)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C047_EQMController_QeuryEQMOrder";
var msg = "";
try
{
var totalCount = 0;
var list = db.SqlServerClient.Queryable <ORM.SqlSugar.Model.order.order_Header>().Where(p => p.MemberCode == MemberCode && p.ProjectCode == ProjectCode && p.Status == Status).OrderBy(it => it.OrderTime, OrderByType.Desc).ToPageList(pageIndex, pageSize, ref totalCount);
List <object> rbList = new List <object>();
foreach (var item in list)
{
var eqmModel = eqm.eqm_EquipmentSugar.GetById(item.EqmUID);
rbList.Add(new { item = item, eqm = eqmModel.EquipmentName });
}
var rbs = new { list = rbList, totalCount = totalCount };
response.SetContent(HttpStatus.ok, "获取成功", rbs, ResponseType.josn);
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.eqm, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage QeuryEQMOrderList(string ThOrderRef)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C048_EQMController_QeuryEQMOrderList";
var msg = "";
try
{
var list = db.SqlServerClient.Queryable <ORM.SqlSugar.Model.order.order_List, ORM.SqlSugar.Model.pd.pd_ProductList>((st, sc) => new object[] {
JoinType.Left, st.ProductCode == sc.ProductCode
})
.Select((st, sc) => new { st.OrderRef, st.MemberCode, st.ProductCode, st.Qty, st.UnitPrice, st.CreditsNo, st.OldProductCode, sc.ProductName }).Where(st => st.OrderRef == ThOrderRef).ToList();
response.SetContent(HttpStatus.ok, "获取成功", list, ResponseType.josn);
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.eqm, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage RoleAuthorization(string PowerKey, string RoleIDS)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C018_MBController_RoleAuthorization";
var msg = "";
try
{
var roleIDList = RoleIDS.ToArryList('_');
foreach (var RoleID in roleIDList)
{
var rolePower = new ORM.SqlSugar.Model.mb.mb_RolePower();
rolePower.PowerKey = PowerKey;
rolePower.RoleID = RoleID.ToInt32();
bool result = mb.mb_RolePowerSugar.Insert(rolePower);
if (result)
{
response.SetContent(HttpStatus.ok, "授权成功", result, ResponseType.josn);
}
else
{
response.SetContent(HttpStatus.error, "授权失败", result, 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 SetEQMOClose(string CloseOrderRef)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C048_EQMController_SetEQMOClose";
var msg = "";
try
{
var model = order.order_HeaderSugar.GetById(CloseOrderRef);
if (model.Status == 3 || model.Status == 4)
{
response.SetContent(HttpStatus.error, "已完成的订单不能关闭", 3, ResponseType.josn);
return(response);
}
model.Status = 9;
order.order_HeaderSugar.Update(model);
response.SetContent(HttpStatus.ok, "关闭成功", 3, ResponseType.josn);
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.eqm, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage GetShopDetail(int ShopID)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C062_EQMController_GetShopDetail";
var msg = "";
try
{
var shop = org.org_ShopSugar.GetById(ShopID);
var corp = new ORM.SqlSugar.Model.org.org_CorpMaster();
if (shop != null)
{
if (!string.IsNullOrEmpty(shop.CorpCode))
{
corp = org.org_CorpMasterSugar.GetById(shop.CorpCode);
}
}
var rbj = new { shop = shop, corp = corp };
response.SetContent(HttpStatus.ok, "获取成功", rbj, 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 CreatePowerCode(string PowerKey, string PowerName, string Description, int NavID)
{
//NavID是什么？
var response = new MyHttpResponseMessage();
response.apiNumber = "C016_MBController_CreatePowerCode";
var msg = "";
try
{
var power = new ORM.SqlSugar.Model.mb.mb_Power();
power.PowerKey = PowerKey;
power.PowerName = PowerName;
power.Description = Description;
power.NavID = NavID;
var result = mb.mb_PowerSugar.Insert(power);
if (result)
{
response.SetContent(HttpStatus.ok, "增加成功", power, ResponseType.josn);
}
else
{
response.SetContent(HttpStatus.error, "增加失败", power, 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 GetMyCorpAndShop(string CurrentMemberCode)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C067_ORGController_GetMyCorpAndShop";
var msg = "";
try
{
var corps = mb.mb_MemberCorpSugar.GetList(p => p.MemberCode == CurrentMemberCode).Select(p => p.CorpCode);
var list = org.org_CorpMasterSugar.GetList(p => corps.Contains(p.CorpCode));
var rbjs = new List <object>();
foreach (var item in list)
{
var shops = org.org_ShopSugar.GetList(p => p.CorpCode == item.CorpCode);
var rbj = new { Corp = new { CorpCode = item.CorpCode, CorpName = item.CorpName, RegisteredAddr = item.RegisteredAddr }, shops };
rbjs.Add(rbj);
}
response.SetContent(HttpStatus.ok, "获取成功", rbjs, 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 GetMemberProdectTypeAndAssets(string MemberCode, string ProjectCode)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C011_MBController_GetMemberProdectTypeAndAssets";
try
{
var ptyCards = pd.pd_ProductTypeSugar.GetList(p => p.IsLease == true && p.ProjectCode == ProjectCode && p.SaleCard == true);
List <object> list = new List <object>();
foreach (var item in ptyCards)
{
var mbAsset = mb.mb_Assets.GetSingle(p => p.MemberCode == MemberCode && p.ProductType == item.ProductType);
var proType = pd.pd_ProductTypeSugar.GetById(item.ProductType);
var rbj = new { ProductType = item, mbAsset = mbAsset };
list.Add(rbj);
}
response.SetContent(HttpStatus.ok, "查询成功", list, 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);
}
}
public HttpResponseMessage QeuryMBProduct(string QueryProductCode)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C006_MBController_QeuryMBProduct";
try
{
var pd = new pdMannager();
var pros = mb.mb_StockLSugar.GetList(p => p.ProductCode == QueryProductCode);
if (pros == null)
{
response.SetContent(HttpStatus.error, "产品不存在", pros, ResponseType.josn);
return(response);
}
List <object> list = new List <object>();
foreach (var item in pros)
{
var user = mb.mb_BaseInfoSQLSugar.GetById(item.MemberCode);
var mobile = "";
if (user != null)
{
mobile = user.NewestMobile;
}
list.Add(new { bj = item, mob = mobile });
}
response.SetContent(HttpStatus.ok, "查询成功", list, 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);
}
}
public HttpResponseMessage MyMBProduct(string QueryMobile)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C007_MBController_QeuryMBProduct";
try
{
mb.mb_StockLSugar.Delete(p => p.ProductCode == "");
var pd = new pdMannager();
var user = mb.mb_BaseInfoSQLSugar.GetList(p => p.NewestMobile == QueryMobile).First();
if (user == null)
{
response.SetContent(HttpStatus.error, "用户不存在", user, ResponseType.josn);
return(response);
}
var pros = mb.mb_StockLSugar.GetList(p => p.MemberCode == user.MemberCode);
response.SetContent(HttpStatus.ok, "查询成功", pros, 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);
}
}
public HttpResponseMessage ChanagePWD(string MemberCode, string PassWord)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C003_MBController_ChanagePWD";
try
{
var model = new ORM.SqlSugar.Model.mb.mb_BaseInfo();
model = mb.mb_BaseInfoSQLSugar.GetById(MemberCode);
if (model == null)
{
response.SetContent(HttpStatus.error, "用户不存在", model, ResponseType.josn);
return(response);
}
model.PassWord = PassWord.MD5Encrypt(16);
var result = mb.mb_BaseInfoSQLSugar.Update(model);
if (result)
{
response.SetContent(HttpStatus.ok, "修改成功", model, ResponseType.josn);
}
else
{
response.SetContent(HttpStatus.error, "修改失败", model, 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);
}
}
public HttpResponseMessage CancelMBRoles(string MemberCode, int RoleID)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C021_MBController_CancelMBRoles";
var msg = "";
try
{
//var shopIDSList = ShopIDS.ToArryList('_');
var mbRole = new ORM.SqlSugar.Model.mb.mb_MemberRole();
mbRole.RoleID = RoleID;
mbRole.MemberCode = MemberCode;
var result = db.SqlServerClient.Ado.UseTran(() =>
{
mb.mb_MemberRoleSugar.Delete(mbRole);
});
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 CheckMyPower(string MemberCode, int pageIndex, int pageSize)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C019_MBController_CheckMyPower";
var msg = "";
try
{
var totalCount = 0;
var rbjs = new List <object>();
var powerNamelist = db.SqlServerClient.Queryable <ORM.SqlSugar.Model.mb.mb_MemberRole, ORM.SqlSugar.Model.mb.mb_RolePower, ORM.SqlSugar.Model.mb.mb_Power>((mr, rp, p) => new object[] { JoinType.Left, mr.RoleID == rp.RoleID, JoinType.Left, rp.PowerKey == p.PowerKey }).Where(mr => mr.MemberCode == MemberCode).Select((mr, rp, p) => new { p.PowerName, p.Description, p.PowerKey }).ToPageList(pageIndex, pageSize, ref totalCount);
foreach (var item in powerNamelist)
{
var rbj = new { MemberCode = MemberCode, PowerKey = item.PowerKey, PowerName = item.PowerName, Description = item.Description };
rbjs.Add(rbj);
}
var resultList = new { Powers = rbjs, totalCount = totalCount };
response.SetContent(HttpStatus.ok, "查询成功", resultList, 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 EditReservedEQM(string MemberCode, string ReservedRef, int Status)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C056_EQMController_EditReservedEQM";
var msg = "";
try
{
var model = order.order_ReservedSugar.GetById(ReservedRef);
if (model == null)
{
response.SetContent(HttpStatus.error, "预约记录不存在", model, ResponseType.josn);
return(response);
}
model.Status = Status;
order.order_ReservedSugar.Update(model);
response.SetContent(HttpStatus.ok, "修改成功", model, ResponseType.josn);
return(response);
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.eqm, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage GetOrgShop(string MemberCode, string Latitude, string Longitude, int pageSize, int pageIndex, int OnLine, string CorpCode)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C060_ORGController_GetOrgShop";
var msg = "";
try
{
var where = "where OnLine=" + OnLine + "";
var _total = 0;
if (!string.IsNullOrEmpty(CorpCode))
{
where += " and CorpCode=" + CorpCode + "";
_total = org.org_ShopSugar.Count(p => p.OnLine == true && p.CorpCode == CorpCode);
}
else
{
_total = org.org_ShopSugar.Count(p => p.OnLine == true);
}
var da = org.Getorg_ShopMySql(Latitude, Longitude, pageSize, pageIndex, true, "" + where + " ");
var rbj = new { data = da, total = _total };
response.SetContent(HttpStatus.ok, "获取成功", rbj, 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 PartitionErrorList(string MemberCode, string EqmUID, int PageIndex, int PageSize)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C057_EQMController_PartitionErrorList";
var msg = "";
try
{
var pmodel = new PageModel()
{
PageIndex = PageIndex, PageSize = PageSize
};
var list = eqm.eqm_PartitionErrorSugar.GetPageList(p => p.EqmUID == EqmUID, pmodel, p => p.CreateTime, OrderByType.Asc);
var rbj = new { list = list, totalCount = pmodel.PageCount };
response.SetContent(HttpStatus.ok, "获取成功", rbj, ResponseType.josn);
return(response);
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.eqm, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage QeuryMaintainEQM(string ExRef)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C050_EQMController_QeuryMaintainEQM";
var msg = "";
try
{
var model = eqm.eqm_ExchangeListSugar.GetById(ExRef);
if (model.Status == 3 || model.Status == 4)
{
response.SetContent(HttpStatus.ok, "获取成功", 3, ResponseType.josn);
}
else if (model.Status == 9)
{
response.SetContent(HttpStatus.ok, "获取成功", 9, ResponseType.josn);
}
else
{
response.SetContent(HttpStatus.ok, "获取成功", 0, ResponseType.josn);
}
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.eqm, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage BalanceRecharge(int BalanceID, string MemberCode, int PayWay)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C100_CrdController_BalanceRecharge";
var msg = "";
try
{
var balanceType = crd.crd_BalanceTypeSQLSugar.GetSingle(p => p.BalanceID == BalanceID && p.IsOnline == true);
if (balanceType == null)
{
response.SetContent(HttpStatus.error, "未能找到相关充值类型", balanceType, ResponseType.josn);
return(response);
}
var crdLog = new ORM.SqlSugar.Model.crd.crd_BalanceLog();
crdLog.BalanceNo = "Balance" + Utils.GetRamCode() + "";
crdLog.Balance = balanceType.OriginalAmount + balanceType.DonationAmount;
crdLog.OriginalBalance = balanceType.OriginalAmount;
crdLog.DonationBalance = balanceType.DonationAmount;
crdLog.BalanceID = BalanceID;
crdLog.MemberCode = MemberCode;
crdLog.BalanceType = 1;
crdLog.Remark = "";
crdLog.TradeNo = "";
crdLog.PayTime = null;
crdLog.PayWay = PayWay;
crdLog.Status = 0;
crdLog.CreateDate = DateTime.Now;
var result = db.SqlServerClient.Ado.UseTran(() =>
{
crd.crd_BalanceLogSQLSugar.Insert(crdLog);
});
if (result.IsSuccess)
{
response.SetContent(HttpStatus.ok, "订单生成成功", crdLog, ResponseType.josn);
}
else
{
response.SetContent(HttpStatus.error, result.ErrorMessage, "", ResponseType.josn);
}
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.adv, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage AES_decrypt(string encryptedDataStr, string key, string iv)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "A023_SysController_AES_decrypt";
try
{
encryptedDataStr = encryptedDataStr.Replace("2B%", "+");
key = key.Replace("2B%", "+");
iv = iv.Replace("2B%", "+");
RijndaelManaged rijalg = new RijndaelManaged();
//-----------------
//设置 cipher 格式 AES-128-CBC
rijalg.KeySize = 128;
rijalg.Padding = PaddingMode.PKCS7;
rijalg.Mode = CipherMode.CBC;
rijalg.Key = Convert.FromBase64String(key);
rijalg.IV = Convert.FromBase64String(iv);
byte[] encryptedData = Convert.FromBase64String(encryptedDataStr);
//解密
ICryptoTransform decryptor = rijalg.CreateDecryptor(rijalg.Key, rijalg.IV);
string result;
using (MemoryStream msDecrypt = new MemoryStream(encryptedData))
{
using (CryptoStream csDecrypt = new CryptoStream(msDecrypt, decryptor, CryptoStreamMode.Read))
{
using (StreamReader srDecrypt = new StreamReader(csDecrypt))
{
result = srDecrypt.ReadToEnd();
response.SetContent(HttpStatus.ok, "解密成功", result, ResponseType.josn);
}
}
}
}
catch (Exception ex)
{
AddErrorLog(LogEnum.sys, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, null, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage AdvListRevise(string AdCode, int SortID, bool OnLine, string AdLink, string AdContents, string AdImageLink, string AdImageURL, string AdImageTitle)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C093_ADVController_AdvListRevise";
var msg = "";
try
{
var advHead = adv.adv_HeadSQLSugar.GetSingle(p => p.AdCode == AdCode);
var advList = adv.adv_ListSQLSugar.GetSingle(p => p.AdCode == AdCode && p.SortID == SortID);
advList.AdLink = AdLink;
advList.OnLine = OnLine;
if (advHead.AdType == 0)
{
advList.AdContents = AdContents;
advList.AdImageLink = null;
advList.AdImageTitle = null;
advList.AdImageURL = null;
}
else if (advHead.AdType == 1)
{
advList.AdContents = null;
advList.AdImageLink = AdImageLink;
advList.AdImageTitle = AdImageTitle;
advList.AdImageURL = AdImageURL;
}
var result = adv.adv_ListSQLSugar.Update(advList);
if (result)
{
response.SetContent(HttpStatus.ok, "修改成功", advList, ResponseType.josn);
}
else
{
response.SetContent(HttpStatus.error, "修改失败", result, ResponseType.josn);
}
}
catch (Exception ex)
{
msg = "ERROR";
AddErrorLog(LogEnum.adv, ex.Message, ex.StackTrace);
response.SetContent(HttpStatus.error, ex.Message, msg, ResponseType.josn);
}
return(response);
}
public HttpResponseMessage GetOrgCardList(string MemberCode, int ProductType, int pageIndex, int pageSize, bool isManager, string CorpCode)
{
var response = new MyHttpResponseMessage();
response.apiNumber = "C012_MBController_GetOrgCardList";
var msg = "";
try
{
if (isManager)
{
var totalCount = 0;
var list = db.SqlServerClient.Queryable <ORM.SqlSugar.Model.mb.mb_CardList, ORM.SqlSugar.Model.mb.mb_MemberCorp>((c, m) => new object[] { JoinType.Right, c.MemberCode == m.MemberCode }).Where((c, m) => m.CorpCode == CorpCode && c.ProductType == ProductType && c.Status == 3).Select((c, m) => new { c, m }).ToPageList(pageIndex, pageSize, ref totalCount);
List <object> bjlist = new List <object>();
foreach (var item in list)
{
if (item.c != null && item.c.VCardNo != null)
{
var vc = org.org_VirtualCardSugar.GetById(item.c.VCardNo.ToString());
var ibj = new { item = item, vc = vc };
bjlist.Add(ibj);
}
}
var rbj = new { list = bjlist, totalCount = totalCount };
response.SetContent(HttpStatus.ok, "获取成功", rbj, ResponseType.josn);
}
else
{
var totalCount = 0;
var list = db.SqlServerClient.Queryable <ORM.SqlSugar.Model.mb.mb_CardList>().Where(p => p.ProductType == ProductType && p.MemberCode == MemberCode && p.Status == 3).OrderBy(it => it.GotTime).ToPageList(pageIndex, pageSize, ref totalCount);
List <object> bjlist = new List <object>();
foreach (var item in list)
{
var vc = org.org_VirtualCardSugar.GetById(item.VCardNo.ToString());
var ibj = new { item = item, vc = vc };
bjlist.Add(ibj);
}
var rbj = new { list = bjlist, totalCount = totalCount };
response.SetContent(HttpStatus.ok, "获取成功", rbj, 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);
}
