private void GetDetail(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } try { int ID = RequestHelper.GetInt("ID", 0); SCZM.BLL.Repair.repair_Schedule bll = new SCZM.BLL.Repair.repair_Schedule(); DataSet ds = bll.GetDetail(ID); DataTable dt = ds.Tables[0]; if (dt.Rows.Count == 0) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,该条数据已被其他人删除!\"}"); return; } string rowsStr = Utils.ToJson(dt); DataTable AttachmentDT = ds.Tables["attachment"]; string attachmentStr = Utils.ToJson(AttachmentDT); StringBuilder jsonStr = new StringBuilder(); jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功!\",\"info\":" + rowsStr); jsonStr.Append(",\"attachmentInfo\":" + attachmentStr); jsonStr.Append("}"); context.Response.Write(jsonStr); } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" + Utils.HtmlEncode(e.Message) + "\"}"); } }
private void GetList(HttpContext context, string btn) { if (btn != "show") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } try { StringBuilder strWhere = new StringBuilder(); string AssignmentProcedureId = RequestHelper.GetString("AssignmentProcedureId"); if (AssignmentProcedureId != "") { strWhere.Append(" and a.AssignmentProcedureId=" + Utils.StrToInt(AssignmentProcedureId, 0)); } //------------------------------------ SCZM.BLL.Repair.repair_Schedule bll = new SCZM.BLL.Repair.repair_Schedule(); DataTable dt = bll.GetList(strWhere.ToString()).Tables[0]; string rowsStr = Utils.ToJson(dt); StringBuilder jsonStr = new StringBuilder(); jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功!\",\"info\":" + rowsStr + "}"); context.Response.Write(jsonStr); } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" + Utils.HtmlEncode(e.Message) + "\"}"); } }
private void DeleteLastSchedule(HttpContext context, string btn) { if (btn != "btnDel") { context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起,您没有操作权限!\"}"); return; } string ID = RequestHelper.GetString("ID"); if (ID == "") { context.Response.Write("{\"status\":\"0\",\"msg\":\"请选择需要删除的记录!\"}"); return; } string prevId = RequestHelper.GetString("prevId"); Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo(); SCZM.BLL.Repair.repair_Schedule bll = new SCZM.BLL.Repair.repair_Schedule(); string operaMessage = ""; string status = "0"; string operaAction = ""; string operaMemo = ""; try { if (bll.DeleteLastSchedule(Utils.StrToInt(ID, 0), Utils.StrToInt(prevId, 0), out operaMessage)) { status = "1"; operaAction = Enums.ActionEnum.Delete.ToString(); operaMemo = "删除进度反馈:" + ID; //写入操作日志 BaseWeb.AddOpera(loginUserModel, int.Parse(RequestHelper.GetQueryString("MenuId")), operaAction, operaMemo); } context.Response.Write("{\"status\":\"" + status + "\",\"msg\":\"" + operaMessage + "\"}"); return; } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" + Utils.HtmlEncode(e.Message) + "\"}"); } }
private void SaveData(Model.Repair.repair_Schedule model, HttpContext context) { Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo(); SCZM.BLL.Repair.repair_Schedule bll = new SCZM.BLL.Repair.repair_Schedule(); string operaMessage = ""; string status = "0"; string operaAction = ""; string operaMemo = ""; try { if (model.ID == -1) { model.ID = bll.Add(model, out operaMessage); if (model.ID > 0) { status = "1"; operaAction = Enums.ActionEnum.Add.ToString(); operaMemo = "新增进度反馈:" + model.ID; } } else { if (bll.Update(model, out operaMessage)) { status = "1"; operaAction = Enums.ActionEnum.Edit.ToString(); operaMemo = "修改进度反馈:" + model.ID; } } if (status == "1") { //写入操作日志 BaseWeb.AddOpera(loginUserModel, int.Parse(RequestHelper.GetQueryString("MenuId")), operaAction, operaMemo); } //if (status == "1") { // BLL.WX.WX_GetLoginInfo bll_Wx = new BLL.WX.WX_GetLoginInfo(); // bll_Wx.getWxAccount_Procedure //} if (status == "1" && model.PauseReason == 5) { //----------------------------------------------------------- string PartDepId = "23"; BLL.WX.WX_GetLoginInfo bll_Wx = new BLL.WX.WX_GetLoginInfo(); DataSet wx_AccountDs = bll_Wx.getWxAccount_Dep(PartDepId); if (wx_AccountDs != null && wx_AccountDs.Tables[0].Rows.Count > 0) { string touser = "", touser_ds = ""; for (int i = 0; i < wx_AccountDs.Tables[0].Rows.Count; i++) { touser_ds = wx_AccountDs.Tables[0].Rows[i][0].ToString(); if (touser_ds != "") { touser += touser_ds + "|"; } } if (touser.Length > 0) { touser = touser.Remove(touser.Length - 1); SCZM.BLL.Repair.Repair_Assignment bll_Assignment = new BLL.Repair.Repair_Assignment(); DataTable dt_CustMessage = bll_Assignment.GetComboList(" and a.ID=" + model.AssignmentId + " ").Tables[0]; SCZM.BLL.Base.base_Procedure bll_Procedure = new BLL.Base.base_Procedure(); DataTable dt_Procedure = bll_Procedure.GetComboList(" and a.ID=" + model.ProcedureId + " ").Tables[0]; WX_GetLoginInfo.GetMessage(touser, "", "客户:" + dt_CustMessage.Rows[0]["CustName"] + "\n机型:" + dt_CustMessage.Rows[0]["MachineModel"] + " \n机号:" + dt_CustMessage.Rows[0]["MachineCode"] + "\n工序:" + dt_Procedure.Rows[0]["ProcedureName"] + "\n维修担当:" + dt_CustMessage.Rows[0]["PerName"] + "\n因等件原因:" + model.Memo + "\n暂停维修,请及时沟通。", "Schedule"); } } //----------------------------------------------------------- } else if (status == "1" && model.ScheduleType == 3) { BLL.Repair.Repair_Assignment bll_Assignment = new BLL.Repair.Repair_Assignment(); //model.AssignmentId; 派工ID //model.AssignmentProcedureId 派工工序ID //---------------------2018/6/26---取消审核(系统内默认审核同意,需手动审核时删掉此段+Wx_GetLoginInfo.ashx也有同样的设置,需同步修改)----------------------------- Model.Repair.Repair_Assignment_Procedure model_AssignmentProcedure = null; BLL.Repair.repair_Report bll_Report = new BLL.Repair.repair_Report(); DataTable dt = bll_Assignment.GetAssignmentProcedureList(" and a.ID=" + model.AssignmentProcedureId + " ").Tables[0]; DataRow[] dr = dt.Select("ID=" + model.AssignmentProcedureId); if (dr.Length == 1) { model_AssignmentProcedure = new Model.Repair.Repair_Assignment_Procedure(); if (dr[0]["AllNat"].ToString() != "") { model_AssignmentProcedure.AllNat_Audit = Utils.StrToDecimal(dr[0]["AllNat"].ToString(), 0); } else { DataTable dt_Detail = bll_Report.GetRepairerRewardDetail(" and d.ID=" + model.AssignmentProcedureId + " ").Tables[0]; if (dt_Detail.Rows[0]["AllNat"].ToString() != "") { model_AssignmentProcedure.AllNat_Audit = Utils.StrToDecimal(dt_Detail.Rows[0]["AllNat"].ToString(), 0) * Utils.StrToDecimal(dr[0]["Num"].ToString(), 0); } } model_AssignmentProcedure.AuditDate = DateTime.Now; model_AssignmentProcedure.AuditOpinion = ""; model_AssignmentProcedure.AuditState = 1; model_AssignmentProcedure.AuditorId = loginUserModel.ID; model_AssignmentProcedure.ID = model.AssignmentProcedureId; bll_Report.SaveRepairReward_Audit(model_AssignmentProcedure); } //----------------------------zhx----------------上箭头------------------------------------------------------------------- BLL.WX.WX_GetLoginInfo bll_Wx = new BLL.WX.WX_GetLoginInfo(); DataSet wx_AccountDs = bll_Wx.getWxAccount_Procedure(model.AssignmentProcedureId); if (wx_AccountDs != null && wx_AccountDs.Tables[0].Rows.Count > 0) { string touser = "", touser_ds = ""; for (int i = 0; i < wx_AccountDs.Tables[0].Rows.Count; i++) { touser_ds = wx_AccountDs.Tables[0].Rows[i]["WXNo"].ToString(); if (touser_ds != "") { touser += touser_ds + "|"; } } if (touser.Length > 0) { touser = touser.Remove(touser.Length - 1); //SCZM.BLL.Repair.Repair_Assignment bll_Assignment = new BLL.Repair.Repair_Assignment(); DataTable dt_CustMessage = bll_Assignment.GetComboList(" and a.ID=" + model.AssignmentId + " ").Tables[0]; SCZM.BLL.Base.base_Procedure bll_Procedure = new BLL.Base.base_Procedure(); DataTable dt_Procedure = bll_Procedure.GetComboList(" and a.ID=" + model.ProcedureId + " ").Tables[0]; WX_GetLoginInfo.GetMessage(touser, "", "客户:" + dt_CustMessage.Rows[0]["CustName"] + "\n机型:" + dt_CustMessage.Rows[0]["MachineModel"] + " \n机号:" + dt_CustMessage.Rows[0]["MachineCode"] + "\n维修担当:" + dt_CustMessage.Rows[0]["PerName"] + "\n工序:" + dt_Procedure.Rows[0]["ProcedureName"] + "\n维修已完成。" + model.Memo + "\n", "Schedule"); } } //--------------------------------------------- } else if (status == "1" && (model.ScheduleType == 1 || model.ScheduleType == 2)) { BLL.Repair.Repair_Assignment bll_Assignment = new BLL.Repair.Repair_Assignment(); BLL.WX.WX_GetLoginInfo bll_Wx = new BLL.WX.WX_GetLoginInfo(); DataSet wx_AccountDs = bll_Wx.getWxAccount_Procedure_onlyGroup(model.AssignmentProcedureId); if (wx_AccountDs != null && wx_AccountDs.Tables[0].Rows.Count > 0) { string touser = "", touser_ds = ""; for (int i = 0; i < wx_AccountDs.Tables[0].Rows.Count; i++) { touser_ds = wx_AccountDs.Tables[0].Rows[i]["WXNo"].ToString(); if (touser_ds != "") { touser += touser_ds + "|"; } } if (touser.Length > 0) { touser = touser.Remove(touser.Length - 1); //SCZM.BLL.Repair.Repair_Assignment bll_Assignment = new BLL.Repair.Repair_Assignment(); DataTable dt_CustMessage = bll_Assignment.GetComboList(" and a.ID=" + model.AssignmentId + " ").Tables[0]; SCZM.BLL.Base.base_Procedure bll_Procedure = new BLL.Base.base_Procedure(); DataTable dt_Procedure = bll_Procedure.GetComboList(" and a.ID=" + model.ProcedureId + " ").Tables[0]; WX_GetLoginInfo.GetMessage(touser, "", "客户:" + dt_CustMessage.Rows[0]["CustName"] + "\n机型:" + dt_CustMessage.Rows[0]["MachineModel"] + " \n机号:" + dt_CustMessage.Rows[0]["MachineCode"] + "\n维修担当:" + dt_CustMessage.Rows[0]["PerName"] + "\n工序:" + dt_Procedure.Rows[0]["ProcedureName"] + "\n维修" + (model.ScheduleType == 1?"已开始":"已暂停") + "。" + model.Memo + "\n", "Schedule"); } } } if (status == "1") { if (bll.GetScheduleType(model.AssignmentProcedureId) == 3) { BLL.WX.WX_GetLoginInfo bll_Wx = new BLL.WX.WX_GetLoginInfo(); BLL.Repair.Repair_Assignment bll_Assignment = new BLL.Repair.Repair_Assignment(); DataTable dt_repairSecond = bll.GetRepairSceond(model.AssignmentProcedureId).Tables[0]; DataSet wx_AccountDs_onlyGroup = bll_Wx.getWxAccount_Procedure_onlyGroup(model.AssignmentProcedureId); if (wx_AccountDs_onlyGroup != null && wx_AccountDs_onlyGroup.Tables[0].Rows.Count > 0) { string touser = "", touser_ds = ""; for (int i = 0; i < wx_AccountDs_onlyGroup.Tables[0].Rows.Count; i++) { touser_ds = wx_AccountDs_onlyGroup.Tables[0].Rows[i]["WXNo"].ToString(); if (touser_ds != "") { touser += touser_ds + "|"; } } if (touser.Length > 0) { touser = touser.Remove(touser.Length - 1); int AllSecond = Convert.IsDBNull(dt_repairSecond.Rows[0]["AllSecond"]) == true ? 0 : Convert.ToInt32(dt_repairSecond.Rows[0]["AllSecond"]); int RepairSecond = Convert.IsDBNull(dt_repairSecond.Rows[0]["RepairSecond"]) == true ? 0 : Convert.ToInt32(dt_repairSecond.Rows[0]["RepairSecond"]); int PauseSecond = Convert.IsDBNull(dt_repairSecond.Rows[0]["PauseSecond"]) == true ? 0 : Convert.ToInt32(dt_repairSecond.Rows[0]["PauseSecond"]); WX_GetLoginInfo.GetMessage(touser, "", "本次派工工序总用时:" + WX_GetLoginInfo.GetDateTime(0, 0, 0, AllSecond) + "\n维修用时:" + WX_GetLoginInfo.GetDateTime(0, 0, 0, RepairSecond) + "\n暂停用时:" + WX_GetLoginInfo.GetDateTime(0, 0, 0, PauseSecond) + "", "Schedule"); bll_Assignment.UpdateRepairSecond(model.AssignmentProcedureId, AllSecond, RepairSecond, PauseSecond); } } } } context.Response.Write("{\"status\":\"" + status + "\",\"msg\":\"" + operaMessage + "\"}"); return; } catch (Exception e) { context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起,系统出错:" + Utils.HtmlEncode(e.Message) + "\"}"); return; } }