public void WriteStartLog(string logID)
{
string strSql = "update intcrm_transferlog set transfertime='" + DateTime.Today.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToLongTimeString() +
"' where id=" + logID;
ConnectionPool_mysql.UpdateQuery(strSql);
}
/// <summary>
/// 取出待传输日志
/// </summary>
/// <param name="mycon"></param>
/// <param name="entityname"></param>
/// <param name="token"></param>
/// <param name="direct">传输方向：0为微信->CRM，1为CRM->微信</param>
/// <param name="isclosed"></param>
/// <returns></returns>
public DataTable TransferLog(string entityname, string token, string direct = "0", string isclosed = "0")
{
string strSql = "select * from intcrm_transferlog where token='" + token + "' and (issuccess is NULL or issuccess=0) and direct=" + direct +
" and isclosed=" + isclosed + " and entityname='" + entityname + "'";
if (entityname.Length == 0)
{
throw new Exception("传输实体名不能为空！");
}
DataTable reader = ConnectionPool_mysql.GetQuery(strSql);
return(reader);
}
/// <summary>
/// 获取公众号与CRM组织映射关系
/// </summary>
/// <param name="mycon"></param>
/// <param name="state">启用状态，1：启用，0：停用</param>
/// <returns></returns>
public DataTable WXUserCRMOrg(MySqlConnection mycon, string state = "1")
{
//mycon.Open();
DataTable dtTmp;
string strSql = "select * from intcrm_wxuser";
if (state.Length > 0)
{
strSql += " where state=" + state;
}
dtTmp = ConnectionPool_mysql.GetQuery(strSql);
return(dtTmp);
}
public void CreateLog(string entityname, string operatetype, string crmrecordid, string wxrecordid, string direct, string token)
{
string strInsertSql, strValueSql;
strInsertSql = "insert into intcrm_transferlog(createtime";
strValueSql = " values('" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "'";
if (entityname.Length > 0)
{
strInsertSql += ",entityname";
strValueSql += ",'" + entityname + "'";
}
if (operatetype.Length > 0)
{
strInsertSql += ",operatetype";
strValueSql += ",'" + operatetype + "'";
}
if (crmrecordid.Length > 0)
{
strInsertSql += ",crmrecordid";
strValueSql += ",'" + crmrecordid + "'";
}
if (wxrecordid.Length > 0)
{
strInsertSql += ",wxrecordid";
strValueSql += ",'" + wxrecordid + "'";
}
if (direct.Length > 0)
{
if (direct == "True" || direct == "False" || direct == "true" || direct == "false")
{
strInsertSql += ",direct";
strValueSql += "," + direct + "";
}
}
if (token.Length > 0)
{
strInsertSql += ",token";
strValueSql += ",'" + token + "'";
}
strInsertSql += ")";
strValueSql += ")";
ConnectionPool_mysql.UpdateQuery(strInsertSql + strValueSql);
}
/// <summary>
/// 执行任务后，回写Log
/// </summary>
/// <param name="mycon"></param>
/// <param name="logID"></param>
/// <param name="crmGUID">CRM中的记录ID，它与wxID参数只能其中一个有值</param>
/// <param name="wxID">微信中的记录ID，它与crmGUID参数只能其中一个有值</param>
/// <param name="IsSuccess">1 为成功 0为失败</param>
public void WriteBackLog(string logID, string crmGUID, string wxID, string IsSuccess)
{
string strSql;
if (IsSuccess == "1")
{
strSql = "update intcrm_transferlog set issuccess=1,isclosed=1,successtime='" +
DateTime.Today.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToLongTimeString() + "'" +
(crmGUID.Length > 0 ? ", crmrecordid='" + crmGUID + "'" : "") +
(wxID.Length > 0 ? ", wxrecordid='" + wxID + "'" : "") +
" where id=" + logID;
}
else
{
strSql = "update intcrm_transferlog set issuccess=0 where id=" + logID;
}
ConnectionPool_mysql.UpdateQuery(strSql);
}
private string FindIDForDelete(DataRow transferlog)
{
string strSql, strReturn = "";
DataTable tmpReader;
if (transferlog["operatetype"].ToString() == "1")
{
if (transferlog["wxrecordid"].ToString().Length > 0)
{
strSql = "select * from intcrm_transferlog where direct=0 and operatetype<>1 and wxrecordid='" +
transferlog["wxrecordid"].ToString() +
"' and entityname='" + transferlog["entityname"].ToString() +
"' and token='" + transferlog["token"].ToString() + "'";
tmpReader = ConnectionPool_mysql.GetQuery(strSql);
if (tmpReader.Rows.Count > 0)
{
strReturn = tmpReader.Rows[0]["crmrecordid"].ToString();
return(strReturn);
}
else
{
return(strReturn);
}
}
if (transferlog["crmrecordid"].ToString().Length > 0)
{
strSql = "select * from intcrm_transferlog where direct=1 and operatetype<>1 and crmrecordid='" + transferlog["crmrecordid"].ToString() + "'";
tmpReader = ConnectionPool_mysql.GetQuery(strSql);
if (tmpReader.Rows.Count > 0)
{
strReturn = tmpReader.Rows[0]["wxrecordid"].ToString();
return(strReturn);
}
else
{
return(strReturn);
}
}
}
return(strReturn);
}
public DataTable TransferRull(string transferflag, string token)
{
try
{
string strSql = "select * from intcrm_transferrull where token='" + token + "'";
if (transferflag.Length > 0)
{
strSql += " and transferflag=" + transferflag;
}
DataTable reader = ConnectionPool_mysql.GetQuery(strSql);
return(reader);
}
catch (Exception ex)
{
DataAccess.ErrorLog.WriteValue(DateTime.Today.ToString(), DateTime.Now.ToLongTimeString(), "获取传输规则异常：" + ex.Message);
return(null);
}
}
