线上设计师都在哪挣钱_前端开发线上培训_整合营销传播的明显特征是_一手项目对接app平台

目录

1、 ClaimsettlementController

1.1、 查询三包明细信息

1.1.1、 //SYS_RecRepairItemDetail修理项目明细表

1.1.2、 //SYS_RecProductDetail产品明细表

1.2、 保存三包表

1.3、 审核预约单

1. ClaimsettlementController 

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 ClaimsettlementController : Controller

    {

        // GET: MechanicsManagment/Claimsettlement

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

1. 1. 查询三包明细信息

        public ActionResult SelectReceptionDetail(int ReceptionID)//查询三包明细信息

        {

            ArrayList lists = new ArrayList();

            try

            {

1. 1. 1.                 //SYS_RecRepairItemDetail修理项目明细表

                var listRecRepairItemDetail = myModels.SYS_RecRepairItemDetail.Where(m => m.ReceptionID == ReceptionID && (m.MaintainabilityID==3 || m.MaintainabilityID == 4)).ToList();

1. 1. 1.                 //SYS_RecProductDetail产品明细表

                var listCollageDetai = (from tbReception in myModels.PW_Reception

                                       join tbCollage in myModels.PW_Collage on tbReception.ReceptionID equals tbCollage.ReceptionID

                                       join tbCollageDetai in myModels.SYS_CollageDetai on tbCollage.CollageID equals tbCollageDetai.CollageID

                                       where tbReception.ReceptionID == ReceptionID && (tbCollageDetai.MaintainabilityID == 3 || tbCollageDetai.MaintainabilityID == 4)

                                        select tbCollageDetai).ToList();

                lists.Add(listRecRepairItemDetail);

                lists.Add(listCollageDetai);

            }

            catch (Exception)

            {

                throw;

            }

            return Json(lists, JsonRequestBehavior.AllowGet);

        }