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