//加载数据
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));
}
