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