当前位置: 首页> 汽车> 行情 > 网站建设在哪里申请_网络建设需求_广告投放的方式有哪些_网站建设免费

网站建设在哪里申请_网络建设需求_广告投放的方式有哪些_网站建设免费

时间:2025/7/11 14:42:44来源:https://blog.csdn.net/weixin_42132177/article/details/143301618 浏览次数: 0次
网站建设在哪里申请_网络建设需求_广告投放的方式有哪些_网站建设免费

目录

1、 InsuranceclaimsController

1.1、 判断是否存在索赔单据

1.1.1、 //结算状态名称

1.1.2、 //维修单号

1.1.3、 //保单金额

  1. InsuranceclaimsController 

using QXQPS.Models;

using QXQPS.Vo;

using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace QXQPS.Areas.MechanicsManagment.Controllers

{

    public class InsuranceclaimsController : Controller

    {

        // GET: MechanicsManagment/Insuranceclaims

        Models.QXQPEntities myModels = new Models.QXQPEntities();

    1. 判断是否存在索赔单据

        public ActionResult SelectInsuranceData(int InsuranceDetailID)//判断是否存在索赔单据

        {

            try

            {

                var lingItem = (from tbInsurance in myModels.PW_Insurance

                                join tbInsuranceDetail in myModels.SYS_InsuranceDetail on tbInsurance.InsuranceDetailID equals tbInsuranceDetail.InsuranceDetailID

                                join tbReception in myModels.PW_Reception on tbInsuranceDetail.ReceptionID equals tbReception.ReceptionID

                                join tbInsuranceCom in myModels.SYS_InsuranceCom on tbInsuranceDetail.InsuranceComID equals tbInsuranceCom.InsuranceComID

                                join tbRepair in myModels.SYS_Repair on tbReception.RepairID equals tbRepair.RepairID

                                join tbDocumentState in myModels.SYS_DocumentState on tbReception.DocumentStateID equals tbDocumentState.DocumentStateID

                                join tbBalanceState in myModels.SYS_BalanceState on tbReception.BalanceStateID equals tbBalanceState.BalanceStateID

                                join tbCustomerSou in myModels.SYS_CustomerSou on tbReception.CustomerSouID equals tbCustomerSou.CustomerSouID

                                where tbInsurance.InsuranceDetailID == InsuranceDetailID

                                select new ReceptionVo

                                {

                                    CustomerNum = tbReception.CustomerNum.Trim(),//客户编号

                                    ReceptionID = tbReception.ReceptionID,//客户接待ID

                                    DocumentStateID = tbDocumentState.DocumentStateID,//单据状态ID

                                    DocumentState = tbDocumentState.DocumentState.Trim(),//单据状态名称

                                    BalanceStateID = tbBalanceState.BalanceStateID,//结算状态ID

                                    BalanceState = tbBalanceState.BalanceState.Trim(),

      1. //结算状态名称

                                    CarNum = tbReception.CarNum.Trim(),//车牌

                                    VehicleType = tbReception.VehicleType.Trim(),//车型

                                    MaintenanceNum = tbReception.MaintenanceNum.Trim(),

      1. //维修单号

                                    Owner = tbReception.Owner.Trim(),//车主

                                    OpenDates = tbInsurance.OpenDate.ToString(),//开单日期

                                    balanceDates = tbInsurance.BalanceDate.ToString(),//结算日期

                                    ToAudit = tbInsurance.ToAudit,//审核否

                                    InsuranceID = tbInsurance.InsuranceID,//三包ID

                                    InsuranceDetailID = tbInsuranceDetail.InsuranceDetailID,//三包明细ID

                                    InsuranceComID = tbInsuranceCom.InsuranceComID,//索赔厂家ID

                                    ClaimStaff = tbInsurance.ClaimsStaff.Trim(),//索赔员工

                                    ToTicket = tbInsurance.ToTicket != true ? "false" : "true",//是否开票

                                    InsuranceNum = tbInsurance.InsuranceNum.Trim(),//索赔单号

                                    ReportNum = tbInsuranceDetail.ReportNum,//报案编号

                                    PolicyNum = tbInsuranceDetail.PolicyNum,//保单号

                                    PolicyMoney = (decimal)tbInsuranceDetail.PolicyMoney,

      1. //保单金额

                                    Amount = tbInsurance.Amount,//总金额

                                    Describe = tbInsurance.Remark.Trim(),//备注

                                }).Single();

                return Json(lingItem, JsonRequestBehavior.AllowGet);

            }

            catch (Exception)

            {

                return Json(false, JsonRequestBehavior.AllowGet);

            }

        }

关键字:网站建设在哪里申请_网络建设需求_广告投放的方式有哪些_网站建设免费

版权声明:

本网仅为发布的内容提供存储空间,不对发表、转载的内容提供任何形式的保证。凡本网注明“来源:XXX网络”的作品,均转载自其它媒体,著作权归作者所有,商业转载请联系作者获得授权,非商业转载请注明出处。

我们尊重并感谢每一位作者,均已注明文章来源和作者。如因作品内容、版权或其它问题,请及时与我们联系,联系邮箱:809451989@qq.com,投稿邮箱:809451989@qq.com

责任编辑: