/// <summary> /// 报事转发 /// </summary> /// <param name="Process"></param> /// <param name="strConnectionString"></param> /// <param name="strIncidentUserCode"></param> /// <returns></returns> private DataTable IncidentTransmit(Process_ToDealWith Process, string strConnectionString, string strIncidentUserCode) { try { Process.转发_8.DealCode = strIncidentUserCode; //转发_8 DataAccess DAccess = new DataAccess(strConnectionString); DbParamters dbParams = new DbParamters(); dbParams.CommandText = "Proc_HSPR_Incident_Transmit_Crm"; dbParams.CommandType = CommandType.StoredProcedure; dbParams.ProcParamters = @"@IncidentID,@TypeID,@DealMan,@DealCode,@DealLoginCode,@TransmitDateTime,@TransmitUserCode,@TransmitUserLoginCode,@TransmitReasons"; dbParams.Add("IncidentID", Process.Incident_Id); dbParams.Add("TypeID", Process.转发_8.Type_ID); dbParams.Add("DealMan", Process.转发_8.DealMan); dbParams.Add("DealCode", Process.转发_8.DealCode); dbParams.Add("DealLoginCode", Process.转发_8.Deal_UserLoginCode); dbParams.Add("TransmitDateTime", Process.转发_8.Transmit_DateTime); dbParams.Add("TransmitUserCode", Process.转发_8.TransmitUserCode); dbParams.Add("TransmitUserLoginCode", Process.转发_8.Transmit_UserLoginCode); dbParams.Add("TransmitReasons", Process.转发_8.Transmit_Reasons); return(DAccess.DataTable(dbParams)); } catch (Exception ex) { throw; } }
/// <summary> /// 报事回访 /// </summary> /// <param name="Process"></param> /// <param name="strConnectionString"></param> /// <param name="strIncidentUserCode"></param> /// <returns></returns> private DataTable IncidentReply(Process_ToDealWith Process, string strConnectionString, string strIncidentUserCode) { try { Process.回访_5.ReplyUserCode = strIncidentUserCode; DataAccess DAccess = new DataAccess(strConnectionString); DbParamters dbParams = new DbParamters(); dbParams.CommandText = "Proc_HSPR_IncidentReply_Insert_Crm"; dbParams.CommandType = CommandType.StoredProcedure; dbParams.ProcParamters = @"@IncidentID,@ReplyType,@ReplyUserLoginCode,@ReplyUserCode,@ReplyMan,@ReplyDateTime,@ReplyContent,@ServiceQuality,@ReplyResult,@ReplyWay,@ReplySituationCode"; dbParams.Add("IncidentID", Process.Incident_Id); dbParams.Add("ReplyType", Process.回访_5.Reply_Type); dbParams.Add("ReplyUserLoginCode", Process.回访_5.Reply_UserLoginCode); dbParams.Add("ReplyUserCode", Process.回访_5.ReplyUserCode); dbParams.Add("ReplyMan", Process.回访_5.ReplyMan); dbParams.Add("ReplyDateTime", Process.回访_5.Deal_DateTime); dbParams.Add("ReplyContent", Process.回访_5.Reply_Content); //非关原因 dbParams.Add("ServiceQuality", Process.回访_5.Service_Quality); dbParams.Add("ReplyResult", Process.回访_5.Reply_Result); dbParams.Add("ReplyWay", Process.回访_5.Reply_Way); dbParams.Add("ReplySituationCode", Process.回访_5.Reply_SituationCode); return(DAccess.DataTable(dbParams)); } catch (Exception ex) { throw; } }
/// <summary> /// 报事回退 /// </summary> /// <param name="Process"></param> /// <param name="strConnectionString"></param> /// <param name="strIncidentUserCode"></param> /// <returns></returns> private DataTable IncidentCancleFinish(Process_ToDealWith Process, string strConnectionString, string strIncidentUserCode) { try { //回退_7 Process.回退_7.FinishGoBackUserCode = strIncidentUserCode; DataAccess DAccess = new DataAccess(strConnectionString); DbParamters dbParams = new DbParamters(); dbParams.CommandText = "Proc_HSPR_Incident_CancleFinish_Crm"; dbParams.CommandType = CommandType.StoredProcedure; dbParams.ProcParamters = @"@IncidentID,@FallbackType,@FinishGoBackReasons,@FinishGoBackUserCode,@FinishGoBackUser,@FinishGoBackUserLoginCode,@FinishGoBackDateTime"; dbParams.Add("IncidentID", Process.Incident_Id); dbParams.Add("FallbackType", Process.回退_7.Fallback_Type); dbParams.Add("FinishGoBackReasons", Process.回退_7.FinishGoBack_Reasons); dbParams.Add("FinishGoBackUserCode", Process.回退_7.FinishGoBackUserCode); dbParams.Add("FinishGoBackUser", Process.回退_7.FinishGoBackUser); dbParams.Add("FinishGoBackUserLoginCode", Process.回退_7.FinishGoBack_UserLoginCode); dbParams.Add("FinishGoBackDateTime", Process.回退_7.FinishGoBack_DateTime); return(DAccess.DataTable(dbParams)); } catch (Exception ex) { throw; } }
/// <summary> /// 报事关闭 /// </summary> /// <param name="Process"></param> /// <param name="strConnectionString"></param> /// <param name="strIncidentUserCode"></param> /// <returns></returns> private DataTable IncidentClose(Process_ToDealWith Process, string strConnectionString, string strIncidentUserCode) { try { Process.关闭_4.CloseUserCode = strIncidentUserCode; DataAccess DAccess = new DataAccess(strConnectionString); DbParamters dbParams = new DbParamters(); dbParams.CommandText = "Proc_HSPR_IncidentAccept_IncidentClose_Crm"; dbParams.CommandType = CommandType.StoredProcedure; dbParams.ProcParamters = @"@IncidentID,@CloseUserCode,@CloseUser,@CloseUserLoginCode,@CloseSituation,@CloseType,@NoNormalCloseReasons,@CloseDateTime"; dbParams.Add("IncidentID", Process.Incident_Id); dbParams.Add("CloseUserCode", Process.关闭_4.CloseUserCode); dbParams.Add("CloseUser", Process.关闭_4.CloseUser); dbParams.Add("CloseUserLoginCode", Process.关闭_4.Close_UserLoginCode); dbParams.Add("CloseSituation", Process.关闭_4.Close_Situation); dbParams.Add("CloseType", Process.关闭_4.Close_Type); dbParams.Add("NoNormalCloseReasons", Process.关闭_4.NoNormalClose_Reasons); //非关原因 dbParams.Add("CloseDateTime", Process.关闭_4.Close_DateTime); return(DAccess.DataTable(dbParams)); } catch (Exception ex) { throw; } }
/// <summary> /// 报事完成 /// </summary> /// <param name="Process"></param> /// <param name="strConnectionString"></param> /// <param name="strIncidentUserCode"></param> /// <returns></returns> private DataTable IncidentComplete(Process_ToDealWith Process, string strConnectionString, string strIncidentUserCode) { try { Process.完成_3.FinishUserCode = strIncidentUserCode; DataAccess DAccess = new DataAccess(strConnectionString); DbParamters dbParams = new DbParamters(); dbParams.CommandText = "Proc_HSPR_IncidentAccept_IncidentFinish_Crm"; dbParams.CommandType = CommandType.StoredProcedure; dbParams.ProcParamters = @"@IncidentID,@DealSituation,@OverdueReason,@FineTypeID,@FinishMan,@FinishUserCode,@FinishUserLoginCode,@FinishDateTime"; dbParams.Add("IncidentID", Process.Incident_Id); dbParams.Add("DealSituation", Process.完成_3.Deal_Situation); dbParams.Add("OverdueReason", Process.完成_3.Over_dueReason); dbParams.Add("FineTypeID", Process.完成_3.FineTypeID); dbParams.Add("FinishMan", Process.完成_3.FinishMan); dbParams.Add("FinishUserCode", Process.完成_3.FinishUserCode); dbParams.Add("FinishUserLoginCode", Process.完成_3.Finish_UserLoginCode); dbParams.Add("FinishDateTime", Process.完成_3.Finish_DateTime); return(DAccess.DataTable(dbParams)); } catch (Exception ex) { throw; } }
/// <summary> /// 报事分派 /// </summary> /// <param name="Process"></param> /// <param name="strConnectionString"></param> /// <param name="strIncidentUserCode"></param> /// <returns></returns> private DataTable IncidentDisp(Process_ToDealWith Process, string strConnectionString, string strIncidentUserCode) { try { Process.分派_2.DispUserCode = strIncidentUserCode; Process.分派_2.DealUserCode = strIncidentUserCode; DataAccess DAccess = new DataAccess(strConnectionString); DbParamters dbParams = new DbParamters(); dbParams.CommandText = "Proc_HSPR_IncidentAccept_Assigned_Crm"; dbParams.CommandType = CommandType.StoredProcedure; dbParams.ProcParamters = @"@IncidentID,@DispMan,@DispUserCode,@DispUserLoginCode,@DispDateTime,@DispRemarks,@DealMan,@DealUserCode,@DealUserLoginCode"; dbParams.Add("IncidentID", Process.Incident_Id); dbParams.Add("DispMan", Process.分派_2.DispMan); //分派人 dbParams.Add("DispUserCode", Process.分派_2.DispUserCode); dbParams.Add("DispUserLoginCode", Process.分派_2.Disp_UserLoginCode); dbParams.Add("DispDateTime", Process.分派_2.Disp_DateTime); dbParams.Add("DispRemarks", Process.分派_2.Disp_Remarks); dbParams.Add("DealMan", Process.分派_2.DealMan); //责任人 dbParams.Add("DealUserCode", Process.分派_2.DealUserCode); dbParams.Add("DealUserLoginCode", Process.分派_2.Deal_UserLoginCode); return(DAccess.DataTable(dbParams)); } catch (Exception ex) { throw; } }
/// <summary> /// 报事废弃 /// </summary> /// <param name="Process"></param> /// <param name="strConnectionString"></param> /// <param name="strIncidentUserCode"></param> /// <returns></returns> private DataTable IncidentAbandoned(Process_ToDealWith Process, string strConnectionString, string strIncidentUserCode) { try { //废弃_6 Process.废弃_6.DeleteUserCode = strIncidentUserCode; DataAccess DAccess = new DataAccess(strConnectionString); DbParamters dbParams = new DbParamters(); dbParams.CommandText = "Proc_HSPR_IncidentAccept_Delete_Crm"; dbParams.CommandType = CommandType.StoredProcedure; dbParams.ProcParamters = @"@IncidentID,@DeleteDateTime,@DeleteReasons,@DeleteMan,@DeleteUserCode,@DeleteUserLoginCode"; dbParams.Add("IncidentID", Process.Incident_Id); dbParams.Add("DeleteDateTime", Process.废弃_6.Delete_DateTime); dbParams.Add("DeleteReasons", Process.废弃_6.Delete_Reasons); dbParams.Add("DeleteMan", Process.废弃_6.DeleteMan); dbParams.Add("DeleteUserCode", Process.废弃_6.DeleteUserCode); dbParams.Add("DeleteUserLoginCode", Process.废弃_6.Delete_UserLoginCode); return(DAccess.DataTable(dbParams)); } catch (Exception ex) { throw; } }
/// <summary> /// 报事流程跟进 /// </summary> /// <param name="strParameter"></param> /// <returns></returns> private string InspectManage_IncidentProcess(string strParameter) { JavaScriptSerializer jsonSet = new JavaScriptSerializer(); jsonSet.MaxJsonLength = int.MaxValue; string strReturn = string.Empty; Process_ToDealWith Process = null; try { string strConnectionString = PubConstant.ZTWYConnectionString; string strIncidentUserCode = PubConstant.ZTWYIncidentUserCode; Process = jsonSet.Deserialize <Process_ToDealWith>(strParameter); string strDealInfoParameter = jsonSet.Serialize(Process.DealInfo); try { DataTable dtTable = null; object retParameter = null; switch (Process.DealType) { case "报事分派": Process.分派_2 = jsonSet.Deserialize <进程处理_分派_2>(strDealInfoParameter); dtTable = IncidentDisp(Process, strConnectionString, strIncidentUserCode); break; case "报事完成": Process.完成_3 = jsonSet.Deserialize <进程处理_完成_3>(strDealInfoParameter); dtTable = IncidentComplete(Process, strConnectionString, strIncidentUserCode); break; case "报事关闭": Process.关闭_4 = jsonSet.Deserialize <进程处理_关闭_4>(strDealInfoParameter); dtTable = IncidentClose(Process, strConnectionString, strIncidentUserCode); break; case "报事回访": Process.回访_5 = jsonSet.Deserialize <进程处理_回访_5>(strDealInfoParameter); dtTable = IncidentReply(Process, strConnectionString, strIncidentUserCode); //retParameter = jsonSet.Deserialize<进程处理_回访_5_BackParameter>(JsonConvert.SerializeObject(dtTable).Replace("[", "").Replace("]", "")); break; case "报事废弃": Process.废弃_6 = jsonSet.Deserialize <进程处理_废弃_6>(strDealInfoParameter); dtTable = IncidentAbandoned(Process, strConnectionString, strIncidentUserCode); break; case "报事回退": Process.回退_7 = jsonSet.Deserialize <进程处理_回退_7>(strDealInfoParameter); dtTable = IncidentCancleFinish(Process, strConnectionString, strIncidentUserCode); break; case "转派责任方": Process.转发_8 = jsonSet.Deserialize <进程处理_转发_8>(strDealInfoParameter); dtTable = IncidentTransmit(Process, strConnectionString, strIncidentUserCode); break; default: strReturn = new ExecResult(-20, $"此类进程不受理,进程编码【{Process.DealType}】", ErrType.System).ToJson(); break; } if (dtTable != null && dtTable.Rows.Count > 0) { Internal_BackParameter backParameter = jsonSet.Deserialize <Internal_BackParameter>(JsonConvert.SerializeObject(dtTable).Replace("[", "").Replace("]", "")); if (backParameter.Code == 0) { if (retParameter == null) { strReturn = new ExecResult(backParameter.Code, backParameter.Message, ErrType.Normal).ToJson(); } else { strReturn = jsonSet.Serialize(new ExecResult(backParameter.Code, backParameter.Message, ErrType.Normal, retParameter)); } } else { strReturn = new ExecResult(backParameter.Code, backParameter.Message, ErrType.Verification).ToJson(); } } } catch (Exception ex) { strReturn = new ExecResult(-20, ex.Message, ErrType.System).ToJson(); } } catch (Exception ex) { strReturn = new ExecResult(-21, $"数据解析异常【{ex.Message}】", ErrType.System).ToJson(); } return(strReturn); }