/// <summary>
/// 在标记表中返回
/// </summary>
private void ResetPushResult(string slbhs, string ret)
{
string sql = string.Empty;
if (ret == "1")//返回成功
{
sql = string.Format("update FC_SPFHX_TAG set SFTS =-1 where slbh in({0})", slbhs);
}
else
{
sql = string.Format("update FC_SPFHX_TAG set SFTS =SFTS+1 where slbh in({0})", slbhs);
}
OleDBHelper.ExecuteCommand(sql);
}
private DataSet GetPushData(string flag, string where)
{
string sql = string.Empty;
if (flag == "CF")
{
sql = string.Format("select * from fc_updateseal where slbh in({0})", where);
}
else if (flag == "DY")
{
sql = string.Format("select * from fc_updatemortage where slbh in({0})", where);
}
else if (flag == "YG")
{
sql = string.Format("select * from fc_updateygdj where slbh in({0})", where);
}
else if (flag == "CS")
{
sql = string.Format("select * from fc_updateinitcert where slbh in({0})", where);
}
return(OleDBHelper.GetDataSet(sql));
}
/// <summary>
/// 获取需要推送的数据
/// </summary>
/// <returns></returns>
private DataTable GetPushDataInfos()
{
string sql = "select SLBH,DJLX from FC_SPFHX_TAG where SFTS<>1";
return(OleDBHelper.GetDataTable(sql));
}
