/// <summary>
/// 这个方法在couponWriteOff.js已经不用,Sun@2015-11-03标注
/// </summary>
/// <param name="pRequest"></param>
/// <returns></returns>
public string GetCardVip(string pRequest)
{
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var vipBLL = new VipBLL(loggingSessionInfo);
var rd = new GetCardVipRD();
var rp = pRequest.DeserializeJSONTo <APIRequest <GetCardVipRP> >();
rp.Parameters.Validate();
var ds = vipBLL.GetCardVip(rp.Parameters.Criterion, rp.Parameters.CouponCode, rp.Parameters.PageSize, rp.Parameters.PageIndex);
if (ds.Tables.Count == 2)
{
var vipList = (from d in ds.Tables[0].AsEnumerable()
select new BS.Entity.VipEntity()
{
VIPID = d["VIPID"].ToString(),
VipCode = d["VipCode"].ToString(),
VipRealName = d["VipRealName"].ToString(),
VipName = d["VipName"].ToString(),
Phone = d["Phone"].ToString(),
Col2 = d["Col2"].ToString(),
Col4 = d["EndAmount"].ToString()
}).ToList();
rd.VipList = vipList.ToArray();
rd.TotalPage = int.Parse(ds.Tables[1].Rows[0][0].ToString());
rd.TotalCount = int.Parse(ds.Tables[1].Rows[0][1].ToString());
}
var rsp = new SuccessResponse <IAPIResponseData>(rd);
//获取优惠券
var couponBll = new CouponBLL(loggingSessionInfo); //优惠券BLL实例化
var couponEntity = couponBll.QueryByEntity(new CouponEntity()
{
CouponCode = rp.Parameters.CouponCode
}, null);
if (couponEntity == null || couponEntity.Length == 0)
{
rsp.ResultCode = 103;
rsp.Message = "优惠券无效";
return(rsp.ToJSON());
}
if (couponEntity[0].Status == 1)
{
rsp.ResultCode = 103;
rsp.Message = "优惠券已核销";
return(rsp.ToJSON());
}
return(rsp.ToJSON());
}
/// <summary>
/// 修改提现密码
/// </summary>
/// <param name="pRequest"></param>
/// <returns></returns>
public string SetWithdrawalPwd(string pRequest)
{
var rsp = new SuccessResponse <IAPIResponseData>();
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var rp = pRequest.DeserializeJSONTo <APIRequest <SetWithdrawalPwdRP> >();
var customerId = loggingSessionInfo.ClientID;
var Oldpwd = rp.Parameters.OldWithdrawalPassword; //提现密码
var NewPwd = rp.Parameters.NewWithdrawalPassword; //新密码
var rd = new SetWithdrawalPwdRD();
var bll = new CustomerBackBLL(loggingSessionInfo);
CustomerBackEntity entity = new CustomerBackEntity();
entity.CustomerId = customerId; //客户ID
entity.BackStatus = 1; //账户状态
entity.WithdrawalPassword = rp.Parameters.OldWithdrawalPassword;
var ds = bll.QueryByEntity(entity, null);
if (ds.Length > 0)
{
entity = (CustomerBackEntity)ds[0];
string strPwd = string.Empty; //密码
if (ds.Length > 0 && ds != null)
{
strPwd = ds.FirstOrDefault().WithdrawalPassword;
if (!string.IsNullOrWhiteSpace(strPwd) && strPwd == Oldpwd) //当数据库中存的密码和输入的密码一样，更新密码
{
entity.WithdrawalPassword = NewPwd;
entity.MD5Pwd = NewPwd.Trim() + MD5Helper.Encryption(customerId.ToString()).Trim();
entity.CustomerBackId = Guid.Parse(ds.FirstOrDefault().CustomerBackId.ToString());
bll.Update(entity);//更新密码
rsp.ResultCode = 0;
rsp.Message = "OK";
return(rsp.ToJSON());
}
}
}
else
{
rsp.ResultCode = 301;
rsp.Message = "提现密码输入错误！请重新输入";
return(rsp.ToJSON());
throw new APIException("提现密码输入错误！")
{
ErrorCode = 301
};
}
return(rsp.ToJSON());
}
private string ImportEnrollData(string pRequest)
{
HttpFileCollection files = HttpContext.Current.Request.Files;
string errorMessage = "";
//1. 保存上传的文件
//string fileName = Utils.SaveUploadAttachment(files, PrivateLoggingSessionInfo.ClientID, PrivateLoggingSessionInfo.UserID, out errorMessage);
string fileName = Utils.SaveUploadAttachment(files, "PrivateLoggingSessionInfo.ClientID", "PrivateLoggingSessionInfo.UserID", out errorMessage);
var rp = pRequest.DeserializeJSONTo <APIRequest <JIT.CPOS.BS.BLL.LEventSignUpBLL.DownEnrollTplRP> >();
rp.Parameters.Validate();
var rd = new JIT.CPOS.BS.BLL.LEventSignUpBLL.DownEnrollTplRD();
int total = 0, add = 0, update = 0;
string result = PrivateLEventSignUpBLL.ImportEnrollData(fileName, rp.Parameters, out total, out add, out update);
var rsp = new SuccessResponse <JIT.CPOS.BS.BLL.LEventSignUpBLL.DownEnrollTplRD>(rd);
if (!string.IsNullOrEmpty(result))
{
rsp.ResultCode = 201;
rsp.Message = result;
rsp.Data.Total = total;
rsp.Data.Add = add;
rsp.Data.Update = update;
}
return(rsp.ToJSON());
}
private string DownEnrollTpl(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <JIT.CPOS.BS.BLL.LEventSignUpBLL.DownEnrollTplRP> >();
rp.Parameters.Validate();
var rd = new EmptyRD(); // new JIT.CPOS.BS.BLL.LEventSignUpBLL.DownEnrollTplRD();
DataTable dataTable = PrivateLEventSignUpBLL.DownEnrollTpl(rp.Parameters.EventID, rp.Parameters.Status);
//数据获取
Workbook wb = DataTableExporter.WriteXLS(dataTable, 0);
string savePath = HttpContext.Current.Server.MapPath(@"~/File/Excel");
if (!System.IO.Directory.Exists(savePath))
{
System.IO.Directory.CreateDirectory(savePath);
}
savePath = savePath + "\\报名人员模板-" + dataTable.TableName + ".xls";
wb.Save(savePath);//保存Excel文件
new ExcelCommon().OutPutExcel(HttpContext.Current, savePath);
HttpContext.Current.Response.End();
var rsp = new SuccessResponse <IAPIResponseData>(rd);
if (dataTable == null || !(dataTable.Columns.Count > 0))
{
rsp.ResultCode = 201;
rsp.Message = "生成失败!";
}
return(rsp.ToJSON());
}
/// <summary>
/// 销售（服务）订单
/// </summary>
public string GetMenusByPMenuCode(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <GetMenusByPMenuCodeRP> >();//不需要参数
string userId = rp.UserID;
string customerId = rp.CustomerID;
var menu_code = rp.Parameters.menu_code;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
AppSysService appSysService = new AppSysService(loggingSessionInfo);
string errMsg = "";
MenuModel Menu = appSysService.GetRoleMenusByPMenuCode(loggingSessionInfo,
loggingSessionInfo.CurrentUserRole.RoleId, menu_code, out errMsg);//根据当前用户的角色，来取他拥有的页面
if (errMsg != "")
{
throw new APIException("errMsg:" + errMsg)
{
ErrorCode = 135
};
}
var rd = new GetMenusByPMenuCodeRD();
rd.currentMenu = Menu;
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
/// <summary>
/// 根据CustomerId获取成为经销商条件
/// </summary>
/// <param name="pRequest"></param>
/// <returns></returns>
private string GetVipMultiLevelSalerConfig(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <EmptyRequestParameter> >();
if (string.IsNullOrEmpty(rp.UserID))
{
throw new APIException("缺少参数【UserID】或参数值为空")
{
ErrorCode = 135
};
}
var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, "1");
var RetailTraderBLL = new RetailTraderBLL(loggingSessionInfo);
var ds = RetailTraderBLL.GetVMultiLevelSalerConfigByCId(rp.CustomerID);
var rd = new VipMultiLevelSalerConfigRP();
rd.config = new VipMultiLevelSalerConfigEntity();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
rd.config.Id = ds.Tables[0].Rows[0]["Id"].ToString();
rd.config.MustBuyAmount = ds.Tables[0].Rows[0]["MustBuyAmount"].ToString();
rd.config.Agreement = ds.Tables[0].Rows[0]["Agreement"].ToString();
rd.config.CustomerId = ds.Tables[0].Rows[0]["CustomerId"].ToString();
}
var rsp = new SuccessResponse <VipMultiLevelSalerConfigRP>(rd);
return(rsp.ToJSON());
}
//修改分销商密码
private string RetailSetPassWord(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <RetailSetPassWordRP> >();
var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID);
string pNewPass = MD5Helper.Encryption(rp.Parameters.pNewPWD);
//pOldPWD = MD5Helper.Encryption(pOldPWD);
rp.Parameters.pOldPWD = EncryptManager.Hash(rp.Parameters.pOldPWD, HashProviderType.MD5);
//组装参数
var rd = new RetailSetPassWordRD();
var rsp = new SuccessResponse <IAPIResponseData>(rd);
var serviceBll = new RetailTraderBLL(loggingSessionInfo);
var entity = serviceBll.GetByID(rp.Parameters.pID);//获取分销商实体
//if (pOldPWD == entity.User_Password)
if (rp.Parameters.pOldPWD == entity.RetailTraderPass)
{
entity.RetailTraderPass = pNewPass;
entity.LastUpdateBy = "1";
entity.LastUpdateTime = DateTime.Now;
//new cUserService(CurrentUserInfo).SetUserInfo(entity, entity.userRoleInfoList, out error);
serviceBll.Update(entity);
rsp.Message = "";
}
else
{
rsp.ResultCode = 135;
rsp.Message = "旧密码不正确";
}
return(rsp.ToJSON());
}
/// <summary>
/// 删除
/// </summary>
public string DeleteInnerGroupNews(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <DeleteInnerGroupNewsRP> >();
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var rd = new DeleteInnerGroupNewsRD();//返回值
var TypeId = rp.Parameters.GroupNewsId;
if (string.IsNullOrEmpty(TypeId))
{
throw new APIException("缺少参数【GroupNewsId】或参数值为空")
{
ErrorCode = 135
};
}
InnerGroupNewsBLL _InnerGroupNewsBLL = new InnerGroupNewsBLL(loggingSessionInfo);
// TagsTypeEntity TagsTypeEn = TagsTypeBLL.GetByID(TypeId);
//虚拟删除标签类型和下面的标签
_InnerGroupNewsBLL.DeleteInnerGroupNews(rp.Parameters.GroupNewsId);
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
public string GetCard(string pRequest)
{
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var cardDepositBLL = new CardDepositBLL(loggingSessionInfo);
var rd = new GetCardRD();
var rp = pRequest.DeserializeJSONTo <APIRequest <GetCardRP> >();
rp.Parameters.Validate();
var ds = cardDepositBLL.PagedSearch(rp.Parameters, loggingSessionInfo.ClientID);
if (ds.Tables.Count == 2)
{
var cardInfoList = (from d in ds.Tables[0].AsEnumerable()
select new BLL.Card()
{
CardID = d["CardDepositId"].ToString(),
CardNo = d["CardNo"].ToString(),
ChannelTitle = d["ChannelTitle"].ToString(),
Amount = decimal.Parse(d["Amount"].ToString()),
Bonus = decimal.Parse(d["Bonus"].ToString()),
CardStatus = int.Parse(d["CardStatus"].ToString()),
UseStatus = int.Parse(d["UseStatus"].ToString())
});
rd.CardList = cardInfoList.ToArray();
rd.TotalPage = int.Parse(ds.Tables[1].Rows[0][0].ToString());
rd.TotalCount = int.Parse(ds.Tables[1].Rows[0][1].ToString());
}
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
public string CategorySort(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <CategorySortRP> >();
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var rd = new SaveSkuRD();//返回值
var service = new ItemCategoryService(loggingSessionInfo);//保存到商品分类表
// var skuPropServer = new SkuPropServer(loggingSessionInfo);//保存到T_Sku_Property
if (rp.Parameters.CategoryList == null)
{
throw new APIException("缺少参数【CategoryList】或参数值为空")
{
ErrorCode = 135
};
}
foreach (var item in rp.Parameters.CategoryList)
{
service.SetItemCategoryDisplayIndex(loggingSessionInfo, item.Item_Category_Id, item.DisplayIndex == null ? 0 : (int)item.DisplayIndex);
}
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
/// <summary>
/// 提现确认/完成操作
/// </summary>
/// <param name="pRequest"></param>
/// <returns></returns>
public string UpdateWDApply(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <UpdateWDApplyRP> >();
//var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID);
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var vipWDApplyBll = new VipWithdrawDepositApplyBLL(loggingSessionInfo); //提现申请BLL实例化
string[] applyIdArray = rp.Parameters.ApplyID.Split(',');
if (applyIdArray.Length > 0)
{
foreach (var applyId in applyIdArray)
{
var vipWDApplyEntity = vipWDApplyBll.GetByID(applyId); //获取提现申请对象
if (vipWDApplyEntity != null)
{
switch (rp.Parameters.Status)
{
case 1: //已确认
vipWDApplyEntity.Status = 1;
vipWDApplyEntity.ConfirmDate = DateTime.Now;
break;
case 2: //已完成
vipWDApplyEntity.Status = 2;
vipWDApplyEntity.CompleteDate = DateTime.Now;
break;
}
vipWDApplyBll.Update(vipWDApplyEntity); //修改
}
}
}
var rsp = new SuccessResponse <IAPIResponseData>();
return(rsp.ToJSON());
}
public string ToggleRetailStatus(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <ToggleRetailStatusRP> >();
if (string.IsNullOrEmpty(rp.Parameters.RetailTraderID))
{
throw new APIException("缺少参数【RetailTraderID】或参数值为空")
{
ErrorCode = 135
};
}
if (string.IsNullOrEmpty(rp.Parameters.Status))
{
throw new APIException("缺少参数【Status】或参数值为空")
{
ErrorCode = 135
};
}
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var bll = new RetailTraderBLL(loggingSessionInfo);
RetailTraderEntity en = new RetailTraderEntity();
en.RetailTraderID = rp.Parameters.RetailTraderID;
en.Status = rp.Parameters.Status;
bll.Update(en, null, false);
var rd = new EmptyRD();
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
public string SaveRetailTraderItemMapping(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <RetailTraderItemMappingRP> >();
var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID);
var bll = new RetailTraderItemMappingBLL(loggingSessionInfo);
var rd = new EmptyRD();
var rsp = new SuccessResponse <IAPIResponseData>(rd);
var itemService = new ItemService(loggingSessionInfo);
var bllTrader = new RetailTraderBLL(loggingSessionInfo);
var entityTrader = bllTrader.GetByID(rp.Parameters.RetailTraderId);
entityTrader.SalesType = "Sales";
bllTrader.Update(entityTrader, null, false);
bll.DeleteData(rp.Parameters.RetailTraderId);
if (rp.Parameters.ItemList.Count() > 0)
{
foreach (var item in rp.Parameters.ItemList)
{
RetailTraderItemMappingEntity entityRTIM = new RetailTraderItemMappingEntity();
entityRTIM.ItemId = item.ItemId;
entityRTIM.RetailTraderId = rp.Parameters.RetailTraderId;
entityRTIM.CustomerID = rp.CustomerID;
bll.Create(entityRTIM);
itemService.CreateTraderQRCode(rp.CustomerID, item.ItemId, item.ItemName, rp.Parameters.RetailTraderId, entityRTIM.MappingId.ToString());
}
}
return(rsp.ToJSON());
}
/// <summary>
/// 增加下载记录
/// </summary>
/// <param name="pRequest"></param>
/// <returns></returns>
private string AddVersionDownLoadLog(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <AppVersionDownloadLogRP> >();
var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, "1");
if (rp.Parameters.Channel == 0 || string.IsNullOrEmpty(rp.CustomerID + rp.Parameters.Plat + rp.Parameters.Version + rp.Parameters.DownloadURL))
{
throw new APIException("缺少请求参数。")
{
ErrorCode = ERROR_CODES.INVALID_REQUEST_LACK_REQUEST_PARAMETER
}
}
;
var appVersionLogBLL = new APPVersionDownloadVIPLogBLL(loggingSessionInfo);
var entity = new APPVersionDownloadVIPLogEntity
{
Channel = rp.Parameters.Channel,
Plat = rp.Parameters.Plat, Version = rp.Parameters.Version,
DownloadUrl = rp.Parameters.DownloadURL, CustomerId = rp.CustomerID,
VipId = rp.Parameters.VipId
};
try
{
appVersionLogBLL.AddAppVersionDownloadLog(entity);
var result = new EmptyResponseData();
var rsp = new SuccessResponse <IAPIResponseData>(result);
return(rsp.ToJSON());
}
catch (APIException ex)
{
throw new APIException("添加过程中出错.");
}
}
/// <summary>
/// 获取我的卡包
/// </summary>
/// <param name="pRequest"></param>
/// <returns></returns>
public string GetCardBag(string pRequest)
{
try
{
string cloudCustomerId = ConfigurationManager.AppSettings["CloudCustomerId"];//云店标识
var rp = pRequest.DeserializeJSONTo <APIRequest <EmptyRequestParameter> >();
var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID);
var vipBll = new VipBLL(loggingSessionInfo);
var vipInfo = vipBll.GetByID(rp.UserID);
string userId = string.Empty;
var rd = new CardBagRD();
if (vipInfo != null)
{
if (!string.IsNullOrEmpty(vipInfo.WeiXinUserId))
{
DataSet dsVip = vipBll.GetCardBag(vipInfo.WeiXinUserId, cloudCustomerId);
if (dsVip.Tables[0].Rows.Count > 0)
{
rd.CardBagList = DataTableToObject.ConvertToList <CardBag>(dsVip.Tables[0]);
}
}
}
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
catch (Exception ex)
{
throw new APIException(ex.Message);
}
}
public string GetVipCount15Days(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <GeneralRP> >();
var para = rp.Parameters;
var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, "1");
var bll = new SysRetailRewardRuleBLL(loggingSessionInfo);
var rd = new VipCountRD();
var rsp = new SuccessResponse <IAPIResponseData>(rd);
rd.VipCountList = DataTableToObject.ConvertToList <VipCountInfo>(bll.GetRetailTraderVipCountByDays(rp.Parameters.RetailTraderId, 15).Tables[0]).ToArray();
var dsMain = bll.GetRetailTraderEarnings(para.RetailTraderId, "All", 0, 0);
if (dsMain.Tables[0].Rows.Count > 0)
{
rd.Bonus = Convert.ToDecimal(dsMain.Tables[0].Rows[0]["Bonus"]);
rd.SalesMoney = Convert.ToDecimal(dsMain.Tables[0].Rows[0]["SalesMoney"]);
}
var dsMonth = bll.GetRetailTraderEarnings(para.RetailTraderId, "Month", 0, 0);
if (dsMonth.Tables[0].Rows.Count > 0)
{
rd.Bonus_Month = Convert.ToDecimal(dsMonth.Tables[0].Rows[0]["Bonus"]);
rd.SalesMoney_Month = Convert.ToDecimal(dsMonth.Tables[0].Rows[0]["SalesMoney"]);
}
var dsDaily = bll.GetRetailTraderEarnings(para.RetailTraderId, "Daily", 0, 0);
if (dsDaily.Tables[0].Rows.Count > 0)
{
rd.Bonus_Day = Convert.ToDecimal(dsDaily.Tables[0].Rows[0]["Bonus"]);
rd.SalesMoney_Day = Convert.ToDecimal(dsDaily.Tables[0].Rows[0]["SalesMoney"]);
}
return(rsp.ToJSON());
}
/// 内部消息
/// </summary>
public string GetInnerGroupNewsList(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <GetInnerGroupNewsListRP> >();//不需要参数
string userId = rp.UserID;
string customerId = rp.CustomerID;
var pageSize = rp.Parameters.PageSize;
var pageIndex = rp.Parameters.PageIndex;
LoggingSessionInfo loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID);
// var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
InnerGroupNewsBLL bll = new InnerGroupNewsBLL(loggingSessionInfo);
var rd = new GetInnerGroupNewsListRD();
var ds = bll.GetInnerGroupNewsList(pageIndex ?? 1, pageSize ?? 15, rp.Parameters.OrderBy, rp.Parameters.OrderType, rp.UserID, loggingSessionInfo.ClientID, rp.Parameters.DeptID);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
rd.InnerGroupNewsList = DataTableToObject.ConvertToList <InnerGroupNewsInfo>(ds.Tables[1]);//直接根据所需要的字段反序列化
rd.TotalCount = ds.Tables[1].Rows.Count;
rd.TotalPages = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(ds.Tables[0].Rows.Count * 1.00 / (pageSize ?? 15) * 1.00)));
}
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
public string GetTCTWPanicbuyingEventKV(string pRequest)
{
TCTWPanicbuyingEventKVRD rd = new TCTWPanicbuyingEventKVRD();
try
{
var rp = pRequest.DeserializeJSONTo <APIRequest <GetTCTWPanicbuyingEventKVRP> >();
//var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID);
var bll = new PanicbuyingEventSkuMappingBLL(loggingSessionInfo);
DataSet ds = bll.GetTCTWPanicbuyingEventKV(rp.Parameters.CTWEventId);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count != 0)
{
rd.TCTWPanicbuyingEventKVInfo = DataTableToObject.ConvertToObject <T_CTW_PanicbuyingEventKVEntity>(ds.Tables[0].Rows[0]);
}
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
catch (Exception ex)
{
throw new APIException(ex.Message);
}
//return "{\"ResultCode\":0,\"Message\":\"OK\",\"Data\":{\"ItemList\":[{\"ItemID\":\"22\",\"ItemName\":\"美的\",\"ImageUrl\":\"http://www.o2omarketing.cn: 8400/Framework/Javascript/Other/kindeditor/attached/image/lzlj/album1.jpg\",\"SkuList\":[{\"kuID\":\"1111\",\"SkuName\":\"138L(银灰色)\",\"Qty\":\"250\",\"KeepQty\":\"200\",\"SoldQty\":\"30\",\"InverTory\":\"20\"}]}]}}";
}
public string GetTypeList(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <GetTypeListRP> >();
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var rd = new GetTypeListRD();//返回值
var t_TypeBLL = new T_TypeBLL(loggingSessionInfo);
T_TypeEntity en = new T_TypeEntity();
en.customer_id = loggingSessionInfo.ClientID;
var typeList = t_TypeBLL.QueryByEntity(en, null).Where(p => p.type_code != "OnlineShopping").OrderBy(p => p.type_Level).ToList();
rd.HasSave = 1;//默认已经保存
if (typeList != null && typeList.Count != 0)
{
int type_Level = (int)typeList[typeList.Count - 1].type_Level;
// var userDefineTypeList = typeList.Where(p => p.type_system_flag != 1).ToList();
if (type_Level == 99)
// if(userDefineTypeList.Count==0)
{
rd.HasSave = 0;//默认已经保存
}
}
rd.TypeList = typeList;
rd.LevelCount = typeList.Count;
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
public string GetOptionsStatus(string pRequest)
{
OptionStatusRD rd = new OptionStatusRD();
try
{
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
ReqOptionStatus entity = pRequest.DeserializeJSONTo <ReqOptionStatus>();
OptionsBLL server = new OptionsBLL(loggingSessionInfo);
OrderBy[] orders = new OrderBy[1];
orders[0] = new OrderBy()
{
FieldName = "Sequence", Direction = OrderByDirections.Asc
};
OptionsEntity[] options = server.QueryByEntity(new OptionsEntity {
OptionName = entity.Parameters.statusName, IsDelete = 0
}, orders);
rd.listOptionStatus = options;
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
catch (Exception)
{
throw;
}
}
public string GetRetailTraders(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <SellUserMainAchieveRP> >();
var pageSize = rp.Parameters.PageSize;
var pageIndex = rp.Parameters.PageIndex;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var bll = new RetailTraderBLL(loggingSessionInfo);
var rd = new GetRetailTradersBySellUserRD();
var rsp = new SuccessResponse <IAPIResponseData>(rd);
//获取分销商的信息，loggingSessionInfo.ClientID
var ds = bll.GetRetailTraders(rp.Parameters.RetailTraderName, rp.Parameters.RetailTraderAddress, rp.Parameters.RetailTraderMan,
rp.Parameters.Status, rp.Parameters.CooperateType, rp.Parameters.UnitID, "", loggingSessionInfo.ClientID, loggingSessionInfo.UserID, pageIndex ?? 1, pageSize ?? 15, rp.Parameters.OrderBy, rp.Parameters.OrderType); //获取
//判断账号是否存在
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
var tempDt = ds.Tables[1];
rd.RetailTraderList = DataTableToObject.ConvertToList <RetailTraderInfo>(tempDt);//直接根据所需要的字段反序列化
rd.TotalCount = Convert.ToInt32(ds.Tables[0].Rows[0]["TotalCount"]);
rd.TotalPages = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(Convert.ToInt32(ds.Tables[0].Rows[0]["TotalCount"]) * 1.00 / (pageSize ?? 15) * 1.00)));
}
return(rsp.ToJSON());
}
public string DynamicVipPropertySave(string pRequest)
{
var clientBussinessDefinedBLL = new ClientBussinessDefinedBLL(PrivateLoggingSessionInfo);
var rd = new EmptyRD();
var rp = pRequest.DeserializeJSONTo <APIRequest <JIT.CPOS.BS.BLL.ClientBussinessDefinedBLL.DynamicVipPropertySaveRP> >();
rp.Parameters.Validate();
string result = clientBussinessDefinedBLL.DynamicVipPropertySave(rp.Parameters);
var rsp = new SuccessResponse <IAPIResponseData>(rd);
if (result == "3")
{
rsp.Message = "添加属性失败,属性名称已经存在.";
rsp.ResultCode = 201;
}
else if (result == "2")
{
rsp.Message = "添加属性失败,最多添加50个.";
rsp.ResultCode = 201;
}
return(rsp.ToJSON());
}
public string GetRetailMonthRewardList(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <GetSellUserRewardListRP> >();
var pageSize = rp.Parameters.PageSize;
var pageIndex = rp.Parameters.PageIndex;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var bll = new RetailTraderBLL(loggingSessionInfo);
var rd = new GetRetailMonthRewardListRD();
var rsp = new SuccessResponse <IAPIResponseData>(rd);
//获取分销商的信息，loggingSessionInfo.ClientID，必须要传customerID
var ds = bll.GetRetailMonthRewardList(rp.Parameters.UnitID, rp.Parameters.SellerOrRetailName, rp.Parameters.Year,
rp.Parameters.Month, loggingSessionInfo.ClientID, loggingSessionInfo.UserID, pageIndex ?? 1, pageSize ?? 15, rp.Parameters.OrderBy, rp.Parameters.OrderType); //获取
//判断账号是否存在
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
var tempDt = ds.Tables[1];
rd.RetailMonthRewardList = DataTableToObject.ConvertToList <RetailMonthRewards>(tempDt);//直接根据所需要的字段反序列化
rd.TotalCount = ds.Tables[0].Rows.Count;
rd.TotalPages = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(ds.Tables[0].Rows.Count * 1.00 / (pageSize ?? 15) * 1.00)));
}
return(rsp.ToJSON());
}
public string ActiveCard(string pRequest)
{
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var cardDepositBLL = new CardDepositBLL(loggingSessionInfo);
var rp = pRequest.DeserializeJSONTo <APIRequest <ActiveCardRP> >();
rp.Parameters.Validate();
var rd = new EmptyRD();
var rsp = new SuccessResponse <IAPIResponseData>(rd);
int result = cardDepositBLL.ActiveCard(rp);
if (result >= 1)
{
rsp.ResultCode = 0;
rsp.Message = result.ToString();
}
else
{
rsp.ResultCode = 300;
rsp.Message = "密码错误或卡已被使用!";
}
return(rsp.ToJSON());
}
public string GetSkuList(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <GetSkuListRP> >();
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var rd = new GetSkuListRD();//返回值
var propService = new JIT.CPOS.BS.BLL.PropService(loggingSessionInfo);
//sku部分
var SKUDomain = "SKU";
var skuPropService = new JIT.CPOS.BS.BLL.SkuPropServer(loggingSessionInfo);
var skuList = skuPropService.GetSkuPropList();//获取了所有的规格（T_SKU_PROPerty a 和 T_Prop关联有数据的），T_SKU_PROPerty只存T_Prop表里prop_type为2（即属性级别的）并且domain为sku的
foreach (var sku in skuList)
{
sku.Children = propService.GetPropListByParentId(SKUDomain, sku.prop_id);//sku的明细项,暂时用不到就不要加上了。
if (sku.Children != null && sku.Children.Count != 0)
{
sku.SkuValues = "";
foreach (var child in sku.Children)
{
if (sku.SkuValues != "")
{
sku.SkuValues += ",";
}
sku.SkuValues += child.Prop_Name;
}
}
}
rd.SKUPropList = skuList;
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
public string GetMonthVipList(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <SellUserMainAchieveRP> >();
if (string.IsNullOrEmpty(rp.UserID))
{
throw new APIException("缺少参数【UserID】或参数值为空")
{
ErrorCode = 135
};
}
var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, "1");
var bll = new RetailTraderBLL(loggingSessionInfo);
var rd = new GetMonthVipListRD();
var rsp = new SuccessResponse <IAPIResponseData>(rd);
//获取分销商的信息，loggingSessionInfo.ClientID
int year = DateTime.Now.Year;
int month = DateTime.Now.Month;
var ds = bll.GetMonthVipList(rp.UserID, loggingSessionInfo.ClientID, month, year); //获取
//判断账号是否存在
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
var tempDt = ds.Tables[0];
rd.VipList = DataTableToObject.ConvertToList <VipInfo>(tempDt);//直接根据所需要的字段反序列化
}
return(rsp.ToJSON());
}
protected string GetEventCommentList(string pRequest)
{
EventCommentListRD rd = new EventCommentListRD();
try
{
var rp = pRequest.DeserializeJSONTo <APIRequest <EventCommentListRP> >();
var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID);
QuestionnaireBLL bll = new QuestionnaireBLL(loggingSessionInfo);
var ds = bll.GetCommentList(rp.Parameters.QuestionnaireID, rp.UserID);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string VIPName = ds.Tables[0].Rows[0]["VipName"].ToString();
var list1 = ds.Tables[0].AsEnumerable().Where(t => t["QuestionType"].ToString() == "3"); //查内容
var list2 = ds.Tables[0].AsEnumerable().Where(t => t["QuestionType"].ToString() == "6"); //查询评分
var Grade = list2.Aggregate(0, (a, b) => a + Convert.ToInt32(b["OptionsText"])) / list2.Count();
var Commentcontent = list1.Aggregate("", (a, b) => a + b["Content"].ToString() + "\r\n ");
rd.VipName = VIPName;
rd.Grade = Grade;
rd.Commentcontent = Commentcontent;
}
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
catch (Exception ex)
{
throw new APIException(ex.Message);
}
}
public string SaveAgentCustomer(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <SaveAgentCustomerRP> >();
LoggingSessionInfo loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID);
if (rp.Parameters.AgentCustomerInfo == null)
{
throw new APIException("缺少参数【AgentCustomerInfo】或参数值为空")
{
ErrorCode = 135
};
}
if (string.IsNullOrEmpty(rp.Parameters.AgentCustomerInfo.AgentName))
{
throw new APIException("缺少参数【AgentName】或参数值为空")
{
ErrorCode = 135
};
}
AgentCustomerBLL _AgentCustomerBLL = new AgentCustomerBLL(loggingSessionInfo);
var AgentCustomerInfo = rp.Parameters.AgentCustomerInfo;
if (string.IsNullOrEmpty(AgentCustomerInfo.FromSource))//如果没有标识来源，则默认为微信
{
AgentCustomerInfo.FromSource = "WeiXin";
}
//如果该标签的id为空//创建一条记录
if (string.IsNullOrEmpty(AgentCustomerInfo.AgentID))
{
//TagsEntity en = new TagsEntity();
AgentCustomerInfo.AgentID = Guid.NewGuid().ToString();
AgentCustomerInfo.CreateTime = DateTime.Now;
AgentCustomerInfo.CreateBy = rp.UserID;
AgentCustomerInfo.LastUpdateTime = DateTime.Now;
AgentCustomerInfo.LastUpdateBy = rp.UserID;
AgentCustomerInfo.IsDelete = 0;
AgentCustomerInfo.CustomerID = rp.CustomerID;
_AgentCustomerBLL.Create(AgentCustomerInfo);
}
else
{
AgentCustomerInfo.LastUpdateTime = DateTime.Now;
AgentCustomerInfo.LastUpdateBy = rp.UserID;
AgentCustomerInfo.IsDelete = 0;
AgentCustomerInfo.CustomerID = rp.CustomerID;
_AgentCustomerBLL.Update(AgentCustomerInfo, null, false);
}
var rd = new EmptyRD();//返回值
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
/// <summary>
/// 获取客户提现信息
/// </summary>
/// <param name="pRequest"></param>
/// <returns></returns>
public string GetCustomerWithdrawal(string pRequest)
{
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var rp = pRequest.DeserializeJSONTo <APIRequest <GetCustomerWithdrawalInfoRP> >();
var customerId = loggingSessionInfo.ClientID;
var rd = new GetCustomerWithdrawalInfoRD();
var bll = new CustomerWithdrawalBLL(loggingSessionInfo);
var ds = bll.GetCustomerWithrawalInfo(customerId);
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
GetCustomerWithdrawalInfo customerWithdrawalInfo = new GetCustomerWithdrawalInfo();
foreach (DataRow row in ds.Tables[0].Rows)
{
customerWithdrawalInfo.CustomerName = row["CustomerName"].ToString(); //客户名称
customerWithdrawalInfo.ReceivingBank = row["ReceivingBank"].ToString(); //收款银行
if (row["BankAccount"] != DBNull.Value)
{
int i = 4;
string strBankAccount = row["BankAccount"].ToString();
string strLeft = strBankAccount.Substring(0, i);
string strRight = strBankAccount.Substring(strBankAccount.Length - i, i);
customerWithdrawalInfo.BankAccount = strLeft + "**********" + strRight; //收款账号
}
customerWithdrawalInfo.OpenBank = row["OpenBank"].ToString(); //开户行
}
foreach (DataRow row in ds.Tables[2].Rows)
{
customerWithdrawalInfo.CountWithdrawalAmount = row["CountWithdrawalAmount"] != DBNull.Value ? Convert.ToDecimal(row["CountWithdrawalAmount"].ToString()) : 0; //提现总金额
customerWithdrawalInfo.BeenAmount = row["BeenAmount"] != DBNull.Value ? Convert.ToDecimal(row["BeenAmount"].ToString()) : 0; //已到账金额
customerWithdrawalInfo.WaitForAmount = row["WaitForAmount"] != DBNull.Value ? Convert.ToDecimal(row["WaitForAmount"].ToString()) : 0; //待出账金额
customerWithdrawalInfo.CanWithdrawalAmount = row["WithdrawalAmount"] != DBNull.Value ? Convert.ToDecimal(row["WithdrawalAmount"].ToString()) : 0; //可提现金额
if (row["LastWithdrawalTime"] != DBNull.Value)
{
customerWithdrawalInfo.LastWithdrawalTime = DateTimeExtensionMethods.To19FormatString(Convert.ToDateTime(row["LastWithdrawalTime"])); //上次提现时间 ;
}
customerWithdrawalInfo.CautionMoney = row["CautionMoney"] != DBNull.Value ? Convert.ToDecimal(row["CautionMoney"].ToString()) : 0; //保证金
customerWithdrawalInfo.RefundAmount = row["RefundAmount"] != DBNull.Value ? Convert.ToDecimal(row["RefundAmount"].ToString()) : 0; //退款金额
}
//结算信息
foreach (DataRow row in ds.Tables[1].Rows)
{
customerWithdrawalInfo.PaypalRate = row["PaypalRate"] != DBNull.Value ? Convert.ToDecimal(row["PaypalRate"].ToString()) : 0;
customerWithdrawalInfo.CUPRate = row["CUPRate"] != DBNull.Value ? Convert.ToDecimal(row["CUPRate"].ToString()) : 0;
customerWithdrawalInfo.OffPeriod = row["OffPeriod"] != DBNull.Value ? Convert.ToInt32(row["OffPeriod"].ToString()) : 0;
customerWithdrawalInfo.MinAmount = row["MinAmount"] != DBNull.Value ? Convert.ToInt32(row["MinAmount"].ToString()) : 0;
customerWithdrawalInfo.PayRemark = row["PayRemark"].ToString();
}
rd.GetCustomerWithdrawal = customerWithdrawalInfo;
}
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}
/// 内部消息
/// </summary>
public string GetGroupNewsByID(string pRequest)
{
var rp = pRequest.DeserializeJSONTo <APIRequest <GetGroupNewsByIDRP> >();//不需要参数
string userId = rp.UserID;
string customerId = rp.CustomerID;
if (string.IsNullOrEmpty(rp.Parameters.GroupNewsID))
{
throw new APIException("缺少参数【GroupNewsID】或参数值为空")
{
ErrorCode = 135
};
}
LoggingSessionInfo loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID);
// var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
InnerGroupNewsBLL bll = new InnerGroupNewsBLL(loggingSessionInfo);
var rd = new GetGroupNewsByIDRD();
var ds = bll.GetByID(rp.Parameters.GroupNewsID); //
if (ds != null && !string.IsNullOrEmpty(ds.CreateBy))
{
//t_user从取创建用户
T_UserBLL bll2 = new T_UserBLL(loggingSessionInfo);
//更新为已读
T_UserEntity t_user = bll2.GetByID(ds.CreateBy);
if (t_user != null)
{
ds.CreateBy = t_user.user_name;
}
else
{
ds.CreateBy = "";
}
//把该条信息设置为已经读过
NewsUserMappingBLL bll3 = new NewsUserMappingBLL(loggingSessionInfo);
NewsUserMappingEntity en = new NewsUserMappingEntity();
en.UserID = rp.UserID;
en.GroupNewsID = rp.Parameters.GroupNewsID;
NewsUserMappingEntity[] lsen = bll3.QueryByEntity(en, null);
if (lsen != null && lsen.Length != 0)
{
en = lsen[0];
en.HasRead = 1;
bll3.Update(en, null);
}
}
rd.InnerGroupNewsInfo = ds;
var rsp = new SuccessResponse <IAPIResponseData>(rd);
return(rsp.ToJSON());
}