//派工单model
public JsonResult LoadWorkOrder(long id)
{
CheckConnect();
string query1 = "SELECT * FROM MAINTAIN_PROJECT";
string query2 = "SELECT * FROM DEPART_BASE WHERE departLevel = 3";
string query3 = "SELECT * FROM CLASS_ITEM WHERE classNum LIKE '030_'";
string query4 = "SELECT * FROM MAINTAIN_ORDER WHERE maintainOrderID = @Id";
string query5 = "SELECT customerCarNum FROM CUSTOMER_CAR_BASE WHERE customerCarID = @Id";
string query6 = "SELECT customerID FROM CUSTOMER_CAR_BASE WHERE customerCarID = @Id";
string query7 = "SELECT customerName FROM CUSTOMER WHERE customerID = @Id";
string query8 = "SELECT customerPhone FROM CUSTOMER WHERE customerID = @Id";
string query9 = "SELECT staffNum FROM STAFF_BASE WHERE staffID = @Id";
List <project> pj = (List <project>)db.Query <project>(query1);
List <depart> dp = (List <depart>)db.Query <depart>(query2);
List <partclass> pc = (List <partclass>)db.Query <partclass>(query3);
maintainOrder order = db.Query <maintainOrder>(query4, new { Id = id }).SingleOrDefault();
string carNum = db.Query <string>(query5, new { Id = order.customerCarID }).SingleOrDefault();
long customerId = db.Query <long>(query6, new { Id = order.customerCarID }).SingleOrDefault();
string customerName = db.Query <string>(query7, new { Id = customerId }).SingleOrDefault();
string phone = db.Query <string>(query8, new { Id = customerId }).SingleOrDefault();
string staffNum = db.Query <string>(query9, new { Id = order.createStaffID }).SingleOrDefault();
workOrderModel model = new workOrderModel()
{
pj = pj, dp = dp, pc = pc
};
maintainOrderModel order_model = new maintainOrderModel()
{
maintainOrderID = order.maintainOrderID,
maintainOrderNum = order.maintainOrderNum,
appointOrderNum = "",
carNum = carNum,
customerName = customerName,
customerPhone = phone,
createTime = order.createTime,
createStaff = staffNum,
faultDescript = order.faultDescript,
expectedPj = order.expectedProjects,
expectedPrice = order.expectedPrice,
expectedTime = order.expectedPickTime,
model = model
};
return(Json(order_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));
}
