///// <summary>
///// 页面通知地址
///// </summary>
//const string pageNoticeUrl = "";
#region orderApply承保
/// <summary>
/// 承保
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public OrderApplyOutputModel OrderApply(OrderApplyInputModel model)
{
try
{
string methodName = "orderApply";
model.customkey = Customkey;
string strJson = SerializerHelper.ToJson(model);
string sign = UtilityHelper.Utils.MD5(VI + strJson);
string url = URLBaseMoFang + methodName + ".html?sign=" + sign;
string retrunStr = UtilityHelper.HttpService.GetHttpWebResponseByRestSharp(url, strJson);
#region 发送魔方日志
//MofangSendLog mofangSendLog = new MofangSendLog();
//mofangSendLog.MothodName = "OrderApply";
//mofangSendLog.FKID = ApplyId;
//mofangSendLog.TransNo = orderModel.transNo;
//mofangSendLog.IsSend = true;
//mofangSendLogMessage =
#endregion
OrderApplyOutputModel outModel = new OrderApplyOutputModel();
outModel = SerializerHelper.FromJsonTo <OrderApplyOutputModel>(retrunStr);
if (outModel.respstat != "0000")
{
ReceivedLog(model.transNo, "OrderApply", outModel.respmsg);
}
return(outModel);
}
catch (Exception ex)
{
ExceptionLogBLL.WriteExceptionLogToDB(ex.ToString());
return(null);
}
}
public void OrderApply()
{
OrderApplyInputModel model = new OrderApplyInputModel();
model.transNo = UtilityHelper.CommonHelper.OrderNoOne();
//model.customkey = "bowangjishi";
model.caseCode = "0000052178002133";
model.insurantDateLimit = "365";
ApplicationData _applicationData = new ApplicationData();
_applicationData.applicationDate = "2017-09-07 13:00:00";
_applicationData.startDate = "2017-09-08";
_applicationData.endDate = "2018-09-08";
ApplicantInfo _applicantInfo = new ApplicantInfo();
_applicantInfo.cName = "倪成智";
_applicantInfo.eName = "nichengzhi";
_applicantInfo.cardType = 1;
_applicantInfo.cardCode = "210623199008092631";
_applicantInfo.sex = 1;
_applicantInfo.birthday = "1990-08-09";
_applicantInfo.mobile = "15841505041";
_applicantInfo.email = "*****@*****.**";
_applicantInfo.cardPeriod = "2020-10-01";
InsurantInfo _insurantInfo = new InsurantInfo();
_insurantInfo.cName = "倪成智";
_insurantInfo.eName = "nichengzhi";
_insurantInfo.cardType = 1;
_insurantInfo.cardCode = "210623199008092631";
_insurantInfo.sex = 1;
_insurantInfo.birthday = "1990-08-09";
_insurantInfo.mobile = "15841505041";
_insurantInfo.relationId = 1;
_insurantInfo.count = 1;
_insurantInfo.singlePrice = 12;
_insurantInfo.cardPeriod = "2020-10-01";
OtherInfo _otherInfo = new OtherInfo();
_otherInfo.provCityId = "510000-511800-511821";
_otherInfo.cardPeriod = "2020-10-01";
_otherInfo.notifyAnswerId = "";
_otherInfo.priceArgsId = "";
model.applicationdata = _applicationData;
model.applicantinfo = _applicantInfo;
model.insurantInfo = _insurantInfo;
model.otherInfo = _otherInfo;
BaoxianDataBLL baoxianDataBLL = new BaoxianDataBLL();
var res = baoxianDataBLL.OrderApply(model);
}
public bool OrderApplyAdd(OrderApplyViewModel viewModel, out string msg)
{
msg = "ok";
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
int ApplyId = dalOrderApply.Add(viewModel.orderApply, trans, conn);//
if (ApplyId < 0)
{
return(false);
}
else
{
viewModel.insurantInfo.OrderApplyID = ApplyId;
viewModel.applicantInfo.OrderApplyID = ApplyId;
viewModel.applicationData.OrderApplyID = ApplyId;
viewModel.otherInfo.OrderApplyID = ApplyId;
#region 创建人赋值
//LoginUserCookie cookie = MerchantFrontCookieBLL.GetMerchantFrontUserCookie();
int createUserId = MerchantFrontCookieBLL.GetMerchantFrontUserId();
//int createUserId= cookie.LoginUserID;
try
{
UsersBLL opUsersBLL = new UsersBLL();
Users modelUsers = opUsersBLL.GetModel(createUserId);
if (modelUsers != null)
{
departmentId = modelUsers.DepartmentID;
}
}
catch { }
viewModel.insurantInfo.CreatUserID = createUserId;
viewModel.applicantInfo.CreatUserID = createUserId;
viewModel.applicationData.CreatUserID = createUserId;
viewModel.otherInfo.CreatUserID = createUserId;
viewModel.orderApply.CreatUserID = createUserId;
viewModel.orderApply.DepartmentId = departmentId;
#endregion
}
int retCatId = dalApplicationData.Add(viewModel.applicationData, trans, conn); //
int retInfoId = dalApplicantInfo.Add(viewModel.applicantInfo, trans, conn); //
int retInsurantId = dalInsurantInfo.Add(viewModel.insurantInfo, trans, conn); //
int retotherId = otherInfoDAL.Add(viewModel.otherInfo, trans, conn);
//调用Mofang业务BaoxianDataBLL
BaoxianDataBLL baoxianBLL = new BaoxianDataBLL();
OrderApplyInputModel orderModel = new OrderApplyInputModel();
orderModel.applicantinfo = new ApplicantInfo();
orderModel.applicantinfo.cName = viewModel.applicantInfo.CName;
orderModel.applicantinfo.eName = viewModel.applicantInfo.EName;
orderModel.applicantinfo.cardType = viewModel.applicantInfo.CardType;
orderModel.applicantinfo.cardCode = viewModel.applicantInfo.CardCode;
orderModel.applicantinfo.sex = viewModel.applicantInfo.Sex;
orderModel.applicantinfo.birthday = viewModel.applicantInfo.BirthDay;
orderModel.applicantinfo.mobile = viewModel.applicantInfo.Mobile;
orderModel.applicantinfo.email = viewModel.applicantInfo.Email;
orderModel.applicantinfo.cardPeriod = viewModel.applicantInfo.CardPeriod;
orderModel.applicantinfo.job = viewModel.applicantInfo.Job;
orderModel.applicationdata = new ApplicationData();
orderModel.applicationdata.applicationDate = viewModel.applicationData.ApplicationDate;
orderModel.applicationdata.startDate = viewModel.applicationData.StartDate;
orderModel.applicationdata.endDate = viewModel.applicationData.EndDate;
orderModel.insurantInfo = new InsurantInfo();
orderModel.insurantInfo.birthday = viewModel.insurantInfo.Birthday;
orderModel.insurantInfo.cardCode = viewModel.insurantInfo.CardCode;
orderModel.insurantInfo.cardPeriod = viewModel.insurantInfo.CardPeriod;
orderModel.insurantInfo.cardType = viewModel.insurantInfo.CardType;
orderModel.insurantInfo.cName = viewModel.insurantInfo.CName;
orderModel.insurantInfo.count = viewModel.insurantInfo.Count;
orderModel.insurantInfo.eName = viewModel.insurantInfo.EName;
orderModel.insurantInfo.mobile = viewModel.insurantInfo.Mobile;
orderModel.insurantInfo.relationId = viewModel.insurantInfo.RelationID;
orderModel.insurantInfo.sex = viewModel.insurantInfo.Sex;
orderModel.insurantInfo.singlePrice = viewModel.insurantInfo.SinglePrice;
orderModel.insurantInfo.email = viewModel.insurantInfo.Email;
orderModel.insurantInfo.job = viewModel.insurantInfo.Job;
orderModel.caseCode = viewModel.caseCode;
orderModel.transNo = viewModel.transNo;
int Days = 0;
try
{
TimeSpan ts = Convert.ToDateTime(viewModel.applicationData.EndDate) - Convert.ToDateTime(viewModel.applicationData.StartDate);
Days = ts.Days;
if (Days == 0)
{
msg = "投保时间差有误!";
}
}
catch (Exception ex)
{
ExceptionLogBLL.WriteExceptionLogToDB(ex.ToString());
}
orderModel.insurantDateLimit = Days.ToString();
orderModel.otherInfo = new OtherInfo();
orderModel.otherInfo.provCityId = viewModel.otherInfo.ProvCityID;
orderModel.otherInfo.cardPeriod = viewModel.otherInfo.CardPeriod.ToString("yyyy-MM-dd");
orderModel.otherInfo.notifyAnswerId = viewModel.otherInfo.NotifyAnswerID.ToString();
orderModel.otherInfo.priceArgsId = viewModel.otherInfo.PriceArgsID;
orderModel.otherInfo.visaCity = viewModel.otherInfo.VisaCity;
orderModel.otherInfo.destination = viewModel.otherInfo.Destination;
orderModel.otherInfo.tripPurposeId = viewModel.otherInfo.TripPurposeId;
orderModel.otherInfo.propertyAddress = viewModel.otherInfo.PropertyAddress;
orderModel.otherInfo.relatedPersonHouse = viewModel.otherInfo.RelatedPersonHouse;
OrderApplyOutputModel outPutModel = baoxianBLL.OrderApply(orderModel);
OrderPayViewModel orderPayViewModel = new OrderPayViewModel();
orderPayViewModel.transNo = outPutModel.transNo;
orderPayViewModel.insureNum = outPutModel.insureNum;
orderPayViewModel.price = outPutModel.price;
orderPayViewModel.caseCode = orderModel.insurantInfo.cardCode;
orderPayViewModel.customkey = orderModel.customkey;
msg = SerializerHelper.SerializeObject(outPutModel);
if (outPutModel.respstat == "0000")
{
trans.Commit();//提交事务
Model.OrderApply oOrderApply = new Model.OrderApply();
OrderApplyBLL orderbll = new OrderApplyBLL();
oOrderApply = orderbll.GetModel(ApplyId);
oOrderApply.InsureNum = orderPayViewModel.insureNum;
oOrderApply.Price = orderPayViewModel.price;
oOrderApply.Respmsg = outPutModel.respmsg;
oOrderApply.Respstat = outPutModel.respstat;
oOrderApply.DepartmentId = departmentId;
bool flag = dalOrderApply.Update(oOrderApply);
if (!flag)
{
ExceptionLogBLL.WriteExceptionLogToDB("更新OrderApply表失败");
}
else //没问题后提交返利设置
{
#region 获取渠道返利设置
if (ApplyId > 0)
{
CompanyRebate modelSys_CompanyRebate = new CompanyRebate();
CompanyRebateBLL opSys_CompanyRebateBLL = new CompanyRebateBLL();
StringBuilder where = new StringBuilder();
where.AppendFormat("IsDeleted=0 and casecode='{0}'", viewModel.caseCode);
DataSet ds = opSys_CompanyRebateBLL.GetList(where.ToString());
DataTable dt = null;
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
modelSys_CompanyRebate = opSys_CompanyRebateBLL.DataRowToModel(dr);
if (modelSys_CompanyRebate != null)
{
/*
* 总价=订单金额
* 总部毛利=总价*产品分成百分比（魔方提供 我方后台管理设置渠道各产品返回分成百分比）
* 商家利润=总部毛利*商家返利百分比（我方后台管理设置渠各产品商家分成百分比）
* 代理商利润=总部毛利*代理商返利百分比（我方后台管理设置渠各产品商家分成百分比）
* 总部净利润=总部毛利-商家利润-代理商利润
*/
decimal orderMoney = viewModel.TotalPrice;
decimal hqRebate = modelSys_CompanyRebate.CompanyRebatePer;
decimal hqMoney = orderMoney * (hqRebate / 100);
decimal agentRebate = modelSys_CompanyRebate.AgentRebate;
decimal agentMoney = hqMoney * (agentRebate / 100);
decimal merchantRebate = modelSys_CompanyRebate.MerchantRebate;
decimal merchantMoney = hqMoney * (merchantRebate / 100);
decimal netProfit = hqMoney - agentMoney - merchantMoney;
#region 订单返利信息入库
OrderRebateBLL opSys_OrderRebate = new OrderRebateBLL();
OrderRebate modelSys_OrderRebate = new OrderRebate();
modelSys_OrderRebate.TransNo = viewModel.transNo;
modelSys_OrderRebate.CompanyId = 1;
modelSys_OrderRebate.UserId = viewModel.orderApply.UserID;
modelSys_OrderRebate.OrderApplyId = ApplyId;
modelSys_OrderRebate.CompanyRebateId = modelSys_CompanyRebate.CompanyRebateId;
modelSys_OrderRebate.OrderMoney = orderMoney;
modelSys_OrderRebate.HQRebate = hqRebate;
modelSys_OrderRebate.HQMoney = hqMoney;
modelSys_OrderRebate.MerchantRebate = merchantRebate;
modelSys_OrderRebate.MerchantMoney = merchantMoney;
modelSys_OrderRebate.AgentRebate = agentRebate;
modelSys_OrderRebate.AgentMoney = agentMoney;
modelSys_OrderRebate.NetProfit = netProfit;
modelSys_OrderRebate.PayStatus = 0;
modelSys_OrderRebate.IsSettled = 0;
modelSys_OrderRebate.IsCancel = 0;
modelSys_OrderRebate.SettlementDate = null;
modelSys_OrderRebate.CreateDate = DateTime.Now;
modelSys_OrderRebate.Remark = modelSys_CompanyRebate.RebateName;
modelSys_OrderRebate.IsDeleted = 0;
int orderRebateId = opSys_OrderRebate.Add(modelSys_OrderRebate);
if (orderRebateId < 0)
{
ExceptionLogBLL.WriteExceptionLogToDB("订单返利信息添加失败");
}
#endregion
#region 订单支付申请预先入库
OrderPayApplyBLL opSys_OrderPayApplyBLL = new OrderPayApplyBLL();
OrderPayApply modelSys_OrderPayApply = new OrderPayApply();
modelSys_OrderPayApply.OrderRebateId = orderRebateId;
modelSys_OrderPayApply.OrderMoney = orderMoney;
modelSys_OrderPayApply.PayOrderNumber = string.Empty;
modelSys_OrderPayApply.PayStatus = 0;
modelSys_OrderPayApply.PayPlatform = 1;
modelSys_OrderPayApply.PayMethod = 1;
modelSys_OrderPayApply.PayCode = string.Empty;
modelSys_OrderPayApply.PayText = string.Empty;
modelSys_OrderPayApply.PayJson = string.Empty;
modelSys_OrderPayApply.CreateDate = DateTime.Now;
modelSys_OrderPayApply.Remark = modelSys_CompanyRebate.RebateName;
modelSys_OrderPayApply.IsDeleted = 0;
int res1 = opSys_OrderPayApplyBLL.Add(modelSys_OrderPayApply);
if (res1 < 0)
{
ExceptionLogBLL.WriteExceptionLogToDB("订单支付申请预先入库失败");
}
#endregion
}
}
else
{
ExceptionLogBLL.WriteExceptionLogToDB("获取渠道返利设置信息获取失败");
}
}
#endregion
}
}
else
{
trans.Rollback();
}
return(true);
}
catch (Exception ex)
{
ExceptionLogBLL.WriteExceptionLogToDB(ex.ToString());
return(false);
}
}
}
}
