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));
}
