Пример #1
0
        /// <summary>
        /// 获取产品财产所在地
        /// </summary>
        static public Object GetProductPropertyArea()
        {
            string result = string.Empty;

            try
            {
                #region 获取列表

                BaoxianDataBLL         baoxianDataBLL = new BaoxianDataBLL();
                ProductPropertyAreaReq model          = new ProductPropertyAreaReq();
                model.transNo  = DNTRequest.GetString("transNo");
                model.caseCode = DNTRequest.GetString("caseCode");
                model.areaCode = DNTRequest.GetString("areaCode");
                ProductPropertyAreaResp res = baoxianDataBLL.GetProductPropertyArea(model);

                object obj = new
                {
                    result = true,
                    msg    = "",
                    data   = res.areas,
                };
                result = Newtonsoft.Json.JsonConvert.SerializeObject(obj);

                #endregion
            }
            catch (Exception ex)
            {
                result = DNTRequest.GetResultJson(false, "操作异常,请稍候再试", null);
                Log.WriteLog(" " + ex);
            }
            return(result);
        }
Пример #2
0
        /// <summary>
        /// 获取承保人职业列表
        /// </summary>
        /// <param name="oJobInfoResp"></param>
        /// <returns></returns>
        static public Object GetJobInfo()
        {
            string result   = string.Empty;
            string cacheKey = string.Empty;

            try
            {
                BaoxianDataBLL oBaoxianDataBLL = new BaoxianDataBLL();
                JobInfoReq     oJobInfoReq     = new JobInfoReq();

                string parentId = DNTRequest.GetString("parentId");
                cacheKey             = "jobCacheKey";
                oJobInfoReq.caseCode = DNTRequest.GetString("caseCode");
                oJobInfoReq.transNo  = DNTRequest.GetString("transNo");

                object      objJob       = CacheHelper.GetCache(cacheKey);
                JobInfoResp oJobInfoResp = new JobInfoResp();
                if (objJob != null)
                {
                    oJobInfoResp = (JobInfoResp)objJob;
                }
                else
                {
                    oJobInfoResp = oBaoxianDataBLL.GetJobInfo(oJobInfoReq);
                    CacheHelper.SetCache(cacheKey, oJobInfoResp, 10);
                }
                if (oJobInfoResp != null)
                {
                    List <InsureJobVo> jobList = oJobInfoResp.insureJobVos;
                    if (jobList.Count > 0)
                    {
                        int pid = 0;
                        if (!string.IsNullOrEmpty(parentId))
                        {
                            pid     = int.Parse(parentId);
                            jobList = jobList.Where(c => c.parentId == pid).ToList();
                        }
                        else
                        {
                            result = DNTRequest.GetResultJson(false, "ajax:GetJobInfo方法 ----parentId异常", null);
                            return(result);
                        }
                        object obj = new
                        {
                            result = true,
                            msg    = "",
                            data   = jobList,
                        };
                        result = Newtonsoft.Json.JsonConvert.SerializeObject(obj);
                    }
                }
            }
            catch (Exception ex)
            {
                result = DNTRequest.GetResultJson(false, "操作异常,请稍候再试", null);
                Log.WriteLog(" " + ex);
            }

            return(result);
        }
Пример #3
0
        protected void btnProductInsuredArea_Click(object sender, EventArgs e)
        {
            //string areaCode = areaCode.tex;
            //string caseCode  =caseCode.Value;
            //string customkey =customkey.Value;
            //string transNo   = transNo.Value;

            string result = string.Empty;

            Response.Write(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "ProductInsuredArea开始");
            try
            {
                BaoxianDataBLL        baoxianDataBLL = new BaoxianDataBLL();
                ProductInsuredAreaReq model          = new ProductInsuredAreaReq();
                model.transNo  = DateTime.Now.ToString("yyyyMMddHHmmssfffff");
                model.caseCode = "0000052178002133";
                model.areaCode = string.Empty;
                var res = baoxianDataBLL.ProductInsuredArea(model);
            }
            catch (Exception ex)
            {
                result = ex.Message;
            }
            Response.Write(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "OrderSummary结果:" + result);
        }
Пример #4
0
        protected void btnOrderSummary_Click(object sender, EventArgs e)
        {
            string result = string.Empty;

            Response.Write(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "OrderSummary开始");
            try
            {
                BaoxianDataBLL         baoxianDataBLL = new BaoxianDataBLL();
                OrderSummaryInputModel model          = new OrderSummaryInputModel();
                //model.starttime = DateTime.Now.AddDays(-10).ToString("yyyy-MM-dd");
                //model.endtime = DateTime.Now.AddDays(10).ToString("yyyy-MM-dd");
                model.starttime = "2016-11-25 16:25:20";
                model.endtime   = "2018-12-03 16:25:20";
                model.customkey = "bowangjishi";
                model.start     = 1;
                model.limit     = 50;
                baoxianDataBLL.OrderSummary(model);
                result = "成功";
            }
            catch (Exception ex)
            {
                result = ex.Message;
            }
            Response.Write(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "OrderSummary结果:" + result);
        }
Пример #5
0
        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);
        }
Пример #6
0
        public void ProductDetails()
        {
            BaoxianDataBLL    baoxianDataBLL = new BaoxianDataBLL();
            ProductDetailsReq model          = new ProductDetailsReq();

            model.transNo = UtilityHelper.CommonHelper.OrderNoOne();
            //model.customkey = "bowangjishi";
            model.caseCode = "0001077178502139";
            var res = baoxianDataBLL.GetProductDetails(model);
        }
Пример #7
0
        public void ProductInsuredArea()
        {
            BaoxianDataBLL        baoxianDataBLL = new BaoxianDataBLL();
            ProductInsuredAreaReq model          = new ProductInsuredAreaReq();

            model.transNo  = UtilityHelper.CommonHelper.OrderNoOne();
            model.caseCode = "0000052178002133";
            model.areaCode = "110000";
            var res = baoxianDataBLL.ProductInsuredArea(model);
        }
Пример #8
0
        public void HealthAnswerSubmit()
        {
            BaoxianDataBLL  baoxianDataBLL = new BaoxianDataBLL();
            HealthNotifyReq model          = new HealthNotifyReq();

            model.transNo = UtilityHelper.CommonHelper.OrderNoOne();
            //model.customkey = "bowangjishi";
            model.answer = string.Empty;
            var res = baoxianDataBLL.HealthAnswerSubmit(model);
        }
Пример #9
0
        public void GetHealthNotifyQues()
        {
            BaoxianDataBLL      baoxianDataBLL = new BaoxianDataBLL();
            HealthNotifyQuesReq model          = new HealthNotifyQuesReq();

            model.transNo = UtilityHelper.CommonHelper.OrderNoOne();
            //model.customkey = "bowangjishi";
            model.caseCode = "0000052178002133";
            var res = baoxianDataBLL.GetHealthNotifyQues(model);
        }
Пример #10
0
        public void OrderCancle()
        {
            BaoxianDataBLL        baoxianDataBLL = new BaoxianDataBLL();
            OrderCancleInputModel model          = new OrderCancleInputModel();

            model.transNo = UtilityHelper.CommonHelper.OrderNoOne();
            //model.customkey = "bowangjishi";
            model.insureNum = "20170927001111";
            var res = baoxianDataBLL.OrderCancle(model);
        }
Пример #11
0
        public void ProductPropertyArea()
        {
            BaoxianDataBLL         baoxianDataBLL = new BaoxianDataBLL();
            ProductPropertyAreaReq model          = new ProductPropertyAreaReq();

            model.transNo = UtilityHelper.CommonHelper.OrderNoOne();
            //model.costomKey = "bowangjishi"; //costomKey!=Customkey ?
            model.caseCode = "0001075211202628";
            model.areaCode = "110000";
            var res = baoxianDataBLL.GetProductPropertyArea(model);
        }
Пример #12
0
        public void GetOrderTrial()
        {
            BaoxianDataBLL baoxianDataBLL = new BaoxianDataBLL();
            TrialReq       model          = new TrialReq();

            model.transNo = UtilityHelper.CommonHelper.OrderNoOne();
            //model.customkey = "bowangjishi";
            model.caseCode         = "0000052178002133";
            model.newRestrictGenes = null;
            model.oldRestrictGene  = null;
            var res = baoxianDataBLL.GetOrderTrial(model);
        }
Пример #13
0
        public void OrderPay(HttpRequest Request, HttpResponse Response)
        {
            MofangInterface.Model.InputModel.GetPayUrlReq   req  = new MofangInterface.Model.InputModel.GetPayUrlReq();
            MofangInterface.Model.OutputModel.GetPayUrlResp resp = new MofangInterface.Model.OutputModel.GetPayUrlResp();
            req.transNo   = UtilityHelper.BWJSCommonHelper.SafeString(Request["transNo"], "");
            req.caseCode  = UtilityHelper.BWJSCommonHelper.SafeString(Request["caseCode"], "");
            req.insureNum = UtilityHelper.BWJSCommonHelper.SafeString(Request["insureNum"], "");
            req.price     = Convert.ToDouble(Request["price"]);
            BaoxianDataBLL bll = new BaoxianDataBLL();

            resp = bll.GetPayUrl(req);
            Response.Write(SerializerHelper.ToJson(resp));
        }
Пример #14
0
        public void GetPayUrl()
        {
            BaoxianDataBLL baoxianDataBLL = new BaoxianDataBLL();
            GetPayUrlReq   model          = new GetPayUrlReq();

            model.transNo  = UtilityHelper.CommonHelper.OrderNoOne();
            model.caseCode = "0000052178002133";
            //model.customkey = "bowangjishi";
            model.insureNum     = "20170907004888";
            model.price         = 50;
            model.pageNoticeUrl = pageNoticeUrl;
            var res = baoxianDataBLL.GetPayUrl(model);
        }
Пример #15
0
        public void OrderSummary()
        {
            BaoxianDataBLL         baoxianDataBLL = new BaoxianDataBLL();
            OrderSummaryInputModel model          = new OrderSummaryInputModel();

            model.starttime = DateTime.Now.AddDays(-10).ToString("yyyy-MM-dd");
            model.endtime   = DateTime.Now.AddDays(10).ToString("yyyy-MM-dd");
            //model.starttime = "2016-11-25 16:25:20";
            //model.endtime = "2018-12-03 16:25:20";
            //model.customkey = "bowangjishi";
            model.start = 1;
            model.limit = 50;
            var res = baoxianDataBLL.OrderSummary(model);
        }
Пример #16
0
        protected void Page_Load(object sender, EventArgs e)
        {
            BaoxianDataBLL      bll = new BaoxianDataBLL();
            HealthNotifyQuesReq req = new HealthNotifyQuesReq();

            TransNo  = UtilityHelper.BWJSCommonHelper.SafeString(Request["transNo"], "");
            CaseCode = UtilityHelper.BWJSCommonHelper.SafeString(Request["CaseCode"], "");

            priceArgsId = UtilityHelper.BWJSCommonHelper.SafeString(Request["priceArgsId"], "");
            price       = UtilityHelper.BWJSCommonHelper.SafeString(Request["price"], "");
            SinglePrice = UtilityHelper.BWJSCommonHelper.SafeString(Request["SinglePrice"], "");
            buyCount    = UtilityHelper.BWJSCommonHelper.SafeString(Request["buyCount"], "");
            //strPriceArgs = UtilityHelper.BWJSCommonHelper.SafeString(Request["priceArgs"], "");
            protectitemid         = UtilityHelper.BWJSCommonHelper.SafeString(Request["protectitemid"], "");
            insurantDateLimitVal  = BWJSCommonHelper.SafeString(Request["hdinsurantDateLimitVal"], "");  //承保值
            insurantDateLimitUnit = BWJSCommonHelper.SafeString(Request["hdinsurantDateLimitUnit"], ""); //承保单位
            req.priceArgsId       = priceArgsId;
            req.transNo           = TransNo;
            req.caseCode          = CaseCode;
            resp         = bll.GetHealthNotifyQues(req);
            strPriceArgs = SerializerHelper.ToJson(resp.priceArgs);
        }
Пример #17
0
        protected void Page_Load(object sender, EventArgs e)
        {
            BaoxianDataBLL bll = new BaoxianDataBLL();

            if (!Page.IsPostBack)
            {
                productId = DNTRequest.GetInt("productId", 0);
                //caseCode = UtilityHelper.BWJSCommonHelper.SafeString(Request["caseCode"], "0001077178502139");
                caseCode = DNTRequest.GetString("caseCode");
                if (!string.IsNullOrWhiteSpace(caseCode))
                {
                    try
                    {
                        ProductDetailsReq req = new ProductDetailsReq();

                        transNo      = req.transNo = UtilityHelper.CommonHelper.OrderNoOne();
                        req.caseCode = caseCode;


                        detailModel = bll.GetProductDetails(req);
                        if (detailModel == null)
                        {
                            detailModel = new ProductDetailsResp();
                        }
                    }
                    catch
                    { }
                    switch (caseCode)
                    {
                    case "0001077178502139":
                        isGotoNoticeInsurance = true;
                        isJBBERestrictGenes   = true;  //JBBE 有基本保额,首字母
                        break;

                    case "0001077178602140":
                        isGotoNoticeInsurance = true;
                        isJBBERestrictGenes   = true;  //JBBE 有基本保额,首字母
                        break;

                    case "0000052178002133":        //“账户保”个人账户资金安全险
                        isJBBERestrictGenes = true; //JBBE 有基本保额,首字母
                        break;

                    case "0001076209802609":          //一起慧99-百万医疗保险 无门诊计划
                        isGotoNoticeInsurance = true;
                        isYQHWMZRestrictGenes = true; //YQHWMZ 一起慧无门诊首字母
                        isJBBERestrictGenes   = true; //JBBE 有基本保额,首字母
                        break;

                    case "0001076211102627":          //一起慧99-百万医疗保险 无门诊计划
                        isGotoNoticeInsurance = true;
                        isYQHWMZRestrictGenes = true; //YQHWMZ 一起慧无门诊首字母
                        isJBBERestrictGenes   = true; //JBBE 有基本保额,首字母
                        break;

                    case "0001075190802342":    //少儿住院宝
                        isGotoNoticeInsurance = true;
                        break;
                    }
                }
                else
                {
                    Response.Redirect("/Product/Index.aspx?wd=0");
                }
            }
        }
Пример #18
0
        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);
                    }
                }
            }
        }