//加载数据 public JsonResult LoadData(long id) { CheckConnect(); string queryOrder = "select * from APPOINT_ORDER where appointOrderID = @Id"; string queryCar = "select * from CUSTOMER_CAR_BASE where customerCarID = @Id"; string queryCustomer = "select * from CUSTOMER where customerID = @Id"; appointOrderModel model = new appointOrderModel(); appointOrder order = (appointOrder)db.Query <appointOrder>(queryOrder, new { Id = id }).SingleOrDefault(); customerCar car = (customerCar)db.Query <customerCar>(queryCar, new { Id = order.customerCarID }).SingleOrDefault(); Customer cus = (Customer)db.Query <Customer>(queryCustomer, new { Id = car.customerID }).SingleOrDefault(); model.cus = cus; model.car = car; model.order = order; return(Json(model, JsonRequestBehavior.AllowGet)); }
//加载结算单信息 public JsonResult LoadSettleOrder(long id) { CheckConnect(); settleOrderModel model = new settleOrderModel(); string query = "SELECT * FROM MAINTAIN_ORDER WHERE maintainOrderID = @Id"; maintainOrder Morder = db.Query <maintainOrder>(query, new { Id = id }).SingleOrDefault(); string query2 = "SELECT * FROM CUSTOMER_CAR_BASE WHERE customerCarID = @Id"; customerCar Car = db.Query <customerCar>(query2, new { Id = Morder.customerCarID }).SingleOrDefault(); string query3 = "SELECT * FROM CUSTOMER WHERE customerID = @Id"; Customer Cus = db.Query <Customer>(query3, new { Id = Car.customerID }).SingleOrDefault(); model.customerName = Cus.customerName; model.phone = Cus.customerPhone; model.address = Cus.customerAddress; model.carBrand = Car.carBrand; model.carType = Car.carType; model.engineNum = Car.engineNum; model.licenseNum = Car.licenseNum; model.startTime = Morder.createTime; model.finishTime = Morder.finishTime; string query4 = "SELECT W.workOrderID as workOrderID,PJ.projectName as projectName,W.workTime as workTime,D.departNum as departNum" + " FROM WORK_ORDER AS W" + " INNER JOIN MAINTAIN_PROJECT AS PJ" + " ON W.maintainProjectID = PJ.projectID" + " INNER JOIN DEPART_BASE AS D" + " ON W.departID = D.departID" + " WHERE W.maintainOrderID = @Id"; List <workOrderSettleModel> Wmodel = (List <workOrderSettleModel>)db.Query <workOrderSettleModel>(query4, new { Id = id }); foreach (workOrderSettleModel item in Wmodel) { string q = "SELECT MP.partName AS partName,P.partQuantity AS partAmount,MP.partPrice* P.partQuantity AS partPrice" + " FROM PART_RECEIVE AS P" + " INNER JOIN MAINTAIN_PART AS MP" + " ON P.partID = MP.partID" + " WHERE P.workOrderID = @Id"; List <partSettleModel> parts = (List <partSettleModel>)db.Query <partSettleModel>(q, new { Id = item.workOrderID }); item.parts = parts; } model.orders = Wmodel; return(Json(model, JsonRequestBehavior.AllowGet)); }