public JsonResult LoadOrders(int page = 1, int limit = 10, int code = 0) { CheckConnect(); table <appointOrder> data = new table <appointOrder>(); string query; List <appointOrder> orders; if (code == 0) { query = "select * from APPOINT_ORDER limit " + ((page - 1) * limit).ToString() + "," + limit.ToString(); orders = (List <appointOrder>)db.Query <appointOrder>(query); } else if (code == 1) { query = "select * from APPOINT_ORDER where appointOrderState = 1 limit " + ((page - 1) * limit).ToString() + "," + limit.ToString(); orders = (List <appointOrder>)db.Query <appointOrder>(query); } else if (code == 2) { query = "select * from APPOINT_ORDER where appointOrderState = 2 limit " + ((page - 1) * limit).ToString() + "," + limit.ToString(); orders = (List <appointOrder>)db.Query <appointOrder>(query); } else { query = "select * from APPOINT_ORDER where appointOrderState = 3 limit " + ((page - 1) * limit).ToString() + "," + limit.ToString(); orders = (List <appointOrder>)db.Query <appointOrder>(query); } data.data = orders; return(Json(data, JsonRequestBehavior.AllowGet)); }
//选择部门 public JsonResult DepartSelect(int id) { string query = "select * from DEPART_BASE where departLevel = @Level"; table <depart> data = new table <depart>(); List <depart> departs = (List <depart>)db.Query <depart>(query, new { Level = id }); data.data = departs; return(Json(data, JsonRequestBehavior.AllowGet)); }
//返回维保项目信息 public JsonResult LoadProjects(int page = 1, int limit = 10) { CheckConnect(); string query = "SELECT * FROM MAINTAIN_PROJECT LIMIT " + ((page - 1) * limit).ToString() + "," + limit.ToString(); table <project> data = new table <project>(); List <project> project = (List <project>)db.Query <project>(query); data.data = project; return(Json(data, JsonRequestBehavior.AllowGet)); }
//返回员工信息 public JsonResult LoadStaff(int page = 1, int limit = 10) { CheckConnect(); string query = "SELECT * FROM STAFF_BASE limit " + ((page - 1) * limit).ToString() + "," + limit.ToString(); table <staff> data = new table <staff>(); List <staff> staff = (List <staff>)db.Query <staff>(query); data.data = staff; return(Json(data, JsonRequestBehavior.AllowGet)); }
//返回部门信息 public JsonResult LoadDeparts(int page = 1, int limit = 10) { CheckConnect(); string query = "select * from DEPART_BASE limit " + ((page - 1) * limit).ToString() + "," + limit.ToString(); table <depart> data = new table <depart>(); List <depart> departs = (List <depart>)db.Query <depart>(query); data.data = departs; return(Json(data, JsonRequestBehavior.AllowGet)); }
//选择职位 public JsonResult PositionSelect(int id) { CheckConnect(); string query = "SELECT * FROM CLASS_ITEM WHERE classNum LIKE '020" + id.ToString() + "%'"; table <position> data = new table <position>(); List <position> positions = (List <position>)db.Query <position>(query); data.data = positions; return(Json(data, JsonRequestBehavior.AllowGet)); }
//加载派工单 public JsonResult LoadWorkOrders(int page = 1, int limit = 10, int code = 0) { CheckConnect(); table <workOrderTableModel> data = new table <workOrderTableModel>(); string query; int count = 1000; string querycount = "SELECT COUNT(*) FROM WORK_ORDER"; count = db.Query <int>(querycount).SingleOrDefault(); List <workOrderTableModel> orders; if (code == 0) { query = "SELECT W.workOrderID as workOrderID,W.workOrderNum as workOrderNum," + "M.maintainOrderNum as maintainOrderNum,D.departNum as departNum," + "W.expectedTime as expectedTime,W.assignTime as assignTime," + "W.workOrderState as workOrderState" + " FROM WORK_ORDER as W" + " INNER JOIN MAINTAIN_ORDER AS M" + " ON W.maintainOrderID = M.maintainOrderID" + " INNER JOIN DEPART_BASE AS D" + " ON W.departID = D.departID" + " LIMIT " + ((page - 1) * limit).ToString() + "," + limit.ToString(); } else { query = "SELECT W.workOrderID as workOrderID,W.workOrderNum as workOrderNum," + "M.maintainOrderNum as maintainOrderNum,D.departNum as departNum," + "W.expectedTime as expectedTime,W.assignTime as assignTime," + "W.workOrderState as workOrderState" + " FROM WORK_ORDER as W" + " INNER JOIN MAINTAIN_ORDER AS M" + " ON W.maintainOrderID = M.maintainOrderID" + " INNER JOIN DEPART_BASE AS D" + " ON W.departID = D.departID" + " WHERE W.workOrderState = " + code.ToString() + " LIMIT " + ((page - 1) * limit).ToString() + "," + limit.ToString(); } orders = (List <workOrderTableModel>)db.Query <workOrderTableModel>(query); data.data = orders; data.count = count; return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadUsers(int page = 1, int limit = 10) { if (db.State == ConnectionState.Open) { db.Close(); db.Open(); } else { db.Open(); } table <Customer> data = new table <Customer>(); string query = "select * from CUSTOMER limit " + ((page - 1) * limit).ToString() + "," + limit.ToString(); List <Customer> customers = (List <Customer>)db.Query <Customer>(query); data.data = customers; return(Json(data, JsonRequestBehavior.AllowGet)); }
//要打印的零件领取单 public JsonResult Order2Print(long id, int code = 0) { CheckConnect(); string query = "SELECT PR.partReceiveID as partReceiveID,W.workOrderNum as workOrderNum,P.partNum as partNum,PR.partQuantity as partQuantity,PR.partEXID as partEXID" + " FROM PART_RECEIVE AS PR" + " INNER JOIN WORK_ORDER AS W" + " ON PR.workOrderID = W.workOrderID" + " INNER JOIN MAINTAIN_PART AS P" + " ON PR.partID = P.partID" + " WHERE PR.workOrderID = @Id"; int count = 0; table <partReceive> data = new table <partReceive>(); List <partReceive> parts = (List <partReceive>)db.Query <partReceive>(query, new { Id = id }); count = parts.Count(); data.data = parts; data.count = count; return(Json(data, JsonRequestBehavior.AllowGet)); }
// GET: MaintainManage public JsonResult LoadOrders(int page = 1, int limit = 10, int code = 0) { CheckConnect(); table <maintainOrderTableModel> data = new table <maintainOrderTableModel>(); string query; string querycount = "SELECT COUNT(1) FROM MAINTAIN_ORDER"; int count = db.Query <int>(querycount).SingleOrDefault(); List <maintainOrderTableModel> orders; if (code == 0) { query = "SELECT M.maintainOrderID as maintainOrderID,M.maintainOrderNum as maintainOrderNum," + "A.appointOrderNum as appointOrderNum,C.customerCarNum as customerCarNum," + "S.staffNum as createstaffNum,M.createTime as createTime,M.orderState as orderState" + " FROM MAINTAIN_ORDER AS M" + " LEFT JOIN APPOINT_ORDER AS A" + " ON M.maintainAppointID = A.appointOrderID" + " INNER JOIN CUSTOMER_CAR_BASE AS C" + " ON M.customerCarID = C.customerCarID" + " INNER JOIN STAFF_BASE AS S" + " ON M.createStaffID = S.staffID" + " LIMIT " + ((page - 1) * limit).ToString() + "," + limit.ToString(); } else { query = "SELECT M.maintainOrderID as maintainOrderID,M.maintainOrderNum as maintainOrderNum," + "A.appointOrderNum as appointOrderNum,C.customerCarNum as customerCarNum," + "S.staffNum as createstaffNum,M.createTime as createTime,M.orderState as orderState" + " FROM MAINTAIN_ORDER AS M" + " INNER JOIN APPOINT_ORDER AS A" + " ON M.maintainAppointID = A.appointOrderID" + " INNER JOIN CUSTOMER_CAR_BASE AS C" + " ON M.customerCarID = C.customerCarID" + " INNER JOIN STAFF_BASE AS S" + " ON M.createStaffID = S.staffID" + " WHERE M.orderState == " + code.ToString() + " LIMIT " + ((page - 1) * limit).ToString() + "," + limit.ToString(); } orders = (List <maintainOrderTableModel>)db.Query <maintainOrderTableModel>(query); data.data = orders; data.count = count; return(Json(data, JsonRequestBehavior.AllowGet)); }