public override void ExecuteQueueLogic(I_DataSynQueue queueData, string responseDataStr, StringBuilder interfaceSb)
{
var sql = string.Empty;
if (queueData.SynType == SynType.Save.ToString())
{
var responseData = JsonHelper.ToObject(responseDataStr);
var synID = responseData.GetValue("ID");
var synData = JsonHelper.ToObject <BaseEnumRequestData>(queueData.RequestData);
if (synID == synData.id)
{
synID = string.Empty;
}
sql = @"if exists(select 1 from S_A_BaseEnum where ID='{0}' or SynID='{0}')
update S_A_BaseEnum set Code = '{1}', Name='{2}', SynTime='{6}',SynData='{7}' where ID='{0}' or SynID='{0}'
else
insert into S_A_BaseEnum(ID,Code,Name,State,Type,SynID,SynTime,SynData) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')" ;
sql = string.Format(sql, queueData.RelateID, synData.code, synData.name.Replace("'", "''"), DataState.Normal.ToString(), queueData.RelateType,
synID, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), queueData.RequestData.Replace("'", "''"));
}
else if (queueData.SynType == SynType.Remove.ToString())
{
sql = "update S_A_BaseEnum set State='" + DataState.Deleted.ToString() + "' where id='" + queueData.RelateID + "'";
}
interfaceSb.AppendLine(sql);
}
public override void ExecuteQueueLogic(I_DataSynQueue queueData, string responseDataStr, StringBuilder interfaceSb)
{
var sql = string.Empty;
if (queueData.SynType == SynType.Save.ToString())
{
var responseData = JsonHelper.ToObject(responseDataStr);
sql = @"if exists(select 1 from S_P_MileStone where ID='{0}')
update S_P_MileStone set Type = '{1}', Name='{2}', SynTime='{5}',SynData='{6}' where ID='{0}'
else
insert into S_P_MileStone(ID,Type,Name,State,SynID,SynTime,SynData,ProjectInfoID) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')" ;
if (queueData.RelateType.ToLower() == "major")
{
var synData = JsonHelper.ToObject <PlanRequestData>(queueData.RequestData);
sql = string.Format(sql, queueData.RelateID, queueData.RelateType, synData.name.Replace("'", "''"), DataState.Normal.ToString(), ""
, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), queueData.RequestData.Replace("'", "''"), synData.projectId);
}
else
{
var synData = JsonHelper.ToObject <ExchangeRequestData>(queueData.RequestData);
sql = string.Format(sql, queueData.RelateID, queueData.RelateType, synData.name.Replace("'", "''"), DataState.Normal.ToString(), ""
, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), queueData.RequestData.Replace("'", "''"), synData.projectId);
}
}
else if (queueData.SynType == SynType.Remove.ToString())
{
sql = "update S_P_MileStone set State='" + DataState.Deleted.ToString() + "' where id='" + queueData.RelateID + "'";
}
interfaceSb.AppendLine(sql);
}
/// <summary>
/// 接口正常返回处理
/// </summary>
/// <param name="queueData"></param>
private void ComplateSync(I_DataSynQueue queueData, StringBuilder interfaceSb)
{
queueData.SynTime = DateTime.Now;
interfaceSb.AppendLine(@" delete from I_DataSynQueue where ID='" + queueData.ID.ToString() + "'");
if (interfaceSb.Length > 0)
{
this.SQLHelperInterface.ExecuteNonQuery(interfaceSb.ToString());
}
}
public override bool ValidateRequeset(I_DataSynQueue queueData)
{
if (queueData.SynType == SynType.Remove.ToString())
{
return(true);
}
//判断文件夹是否存在，不存在文件夹不同步数据
var synData = JsonHelper.ToObject <InputDocumentRequestData>(queueData.RequestData);
var folder = this.SQLHelperInterface.ExecuteObject <S_D_Input>("select * from S_D_Input where id='" + synData.folderId + "'");
return(folder != null);
}
/// <summary>
/// 接口错误处理
/// </summary>
/// <param name="queueData"></param>
/// <param name="msg"></param>
private void ErrorSync(I_DataSynQueue queueData, string msg)
{
queueData.SynState = SynState.Error.ToString();
queueData.SynTime = DateTime.Now;
queueData.ErrorMsg = msg;
if (string.IsNullOrEmpty(queueData.Response))
{
queueData.Response = string.Empty;
}
string sql = @" update I_DataSynQueue set SynTime = '{1}', Response='{2}',ErrorMsg='{3}' ,SynState='{4}'
where ID='{0}'";
sql = string.Format(sql, queueData.ID.ToString(), queueData.SynTime.Value.ToString("yyyy-MM-dd HH:mm:ss")
, queueData.Response.Replace("'", "''"), queueData.ErrorMsg.Replace("'", "''"), queueData.SynState.ToString());
this.SQLHelperInterface.ExecuteNonQuery(sql);
}
public override void ExecuteQueueLogic(I_DataSynQueue queueData, string responseDataStr, StringBuilder interfaceSb)
{
if (queueData.SynType == SynType.Save.ToString())
{
var responseData = JsonHelper.ToObject(responseDataStr);
var synData = JsonHelper.ToObject <DesignInputRequestData>(queueData.RequestData);
var sql = createDesignInputString(synData, synData.ProjectInfoID, queueData.RelateType, queueData.RequestData.Replace("'", "''"));
interfaceSb.AppendLine(sql);
}
else if (queueData.SynType == SynType.BatchSave.ToString())
{
var synData = JsonHelper.ToObject <DesignInputBatchRequestData>(queueData.RequestData);
reccreateDesignInputString(interfaceSb, synData.folders, synData.parentId);
}
else if (queueData.SynType == SynType.Remove.ToString())
{
var delsql = "update S_D_Input set State='" + DataState.Deleted.ToString() + "' where id='" + queueData.RelateID + "'";
interfaceSb.AppendLine(delsql);
}
}
//校审意见库
public override void ExecuteQueueLogic(I_DataSynQueue queueData, string responseDataStr, StringBuilder interfaceSb)
{
var sql = string.Empty;
if (queueData.SynType == SynType.Save.ToString())
{
var synData = JsonHelper.ToObject <AuditAdviceRequestData>(queueData.RequestData);
sql = @"if exists(select 1 from S_AE_AuditAdvice where ID='{0}')
update S_AE_AuditAdvice set Name='{1}', SynTime='{4}',SynData='{5}' where ID='{0}'
else
insert into S_AE_AuditAdvice(ID,Name,State,SynID,SynTime,SynData) values ('{0}','{1}','{2}','{3}','{4}','{5}')";
sql = string.Format(sql, queueData.RelateID, synData.content.Replace("'", "''"), DataState.Normal.ToString(), ""
, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), queueData.RequestData.Replace("'", "''"));
}
else if (queueData.SynType == SynType.Remove.ToString())
{
sql = "update S_AE_AuditAdvice set State='" + DataState.Deleted.ToString() + "' where id='" + queueData.RelateID + "'";
}
interfaceSb.AppendLine(sql);
}
public override void ExecuteQueueLogic(I_DataSynQueue queueData, string responseDataStr, StringBuilder interfaceSb)
{
var sql = string.Empty;
if (queueData.SynType == SynType.Save.ToString())
{
var responseData = JsonHelper.ToObject(responseDataStr);
var synID = responseData.GetValue("ID");
var synData = JsonHelper.ToObject <AuditAdviceCatalogRequestData>(queueData.RequestData);
if (synID == synData.id)
{
synID = string.Empty;
}
sql = @"insert into S_AE_AuditAdviceCatalog(ID,MajorCode,Name,State,SynID,SynTime,SynData) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')";
sql = string.Format(sql, queueData.RelateID, synData.specialtyCode, synData.title.Replace("'", "''"), DataState.Normal.ToString(),
synID, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), queueData.RequestData.Replace("'", "''"));
}
else if (queueData.SynType == SynType.Remove.ToString())
{
sql = "update S_AE_AuditAdviceCatalog set State='" + DataState.Deleted.ToString() + "' where id='" + queueData.RelateID + "'";
}
interfaceSb.AppendLine(sql);
}
public virtual void ExecuteQueueLogic(I_DataSynQueue queueData, string responseDataStr, StringBuilder interfaceSb)
{
throw new NotImplementedException();
}
public virtual bool ValidateRequeset(I_DataSynQueue queueData)
{
return(true);
}