public bool isSign(string openid, string appid, string city)
{
bool _isSign = false;
var edc = new Tb_Wx_Entrustinfo(this.DataSource);
var Entrustinfo = GetEntrustinfo(openid, appid, WxPayConfig.getMCHID(city));
if (Entrustinfo != null)
{
if (Entrustinfo.FldQuerydate.ToString("yyyy-MM-dd") == ("1753-01-01"))
{
//一天调一次
string outxml = string.Empty;
_isSign = this.QueryContract(city, Entrustinfo.FldContractId, out outxml);
if (_isSign)
{
Entrustinfo.DataDriver = this.DataSource;
Entrustinfo.FldQuerydate = DateTime.Now;
Entrustinfo.FldChangeType = 1;
Entrustinfo.Store();
}
else
{
if (Entrustinfo.FldChangeType == 1)
{
Entrustinfo.DataDriver = this.DataSource;
Entrustinfo.FldChangeType = 0;
Entrustinfo.Store();
}
}
}
else
{
if (Entrustinfo.FldChangeType == 1 && DateTime.Compare(Entrustinfo.FldContractExpiredTime, DateTime.Now) > 0)
{
_isSign = true;
}
}
}
return(_isSign);
}
public Tb_Wx_Entrustinfo GetEntrustinfo(string openid, string appid, string mch_id)
{
var edc = new Tb_Wx_Entrustinfo(this.DataSource);
string condition = string.Format("fld_openid='{0}' and fld_appid='{1}'", openid, appid);
if (!string.IsNullOrEmpty(mch_id))
{
condition += string.Format(" and fld_mch_id='{0}'", mch_id);
}
var Entrustinfo = edc.FindFirst <Tb_Wx_Entrustinfo>(condition);
if (Entrustinfo == null)
{
Entrustinfo = new Tb_Wx_Entrustinfo(this.DataSource);
Entrustinfo.Id = edc.Create();
Entrustinfo.FldOpenid = openid;
Entrustinfo.FldAppid = appid;
Entrustinfo.FldChangeType = 0;
Entrustinfo.FldMchId = mch_id;
Entrustinfo.Store();
}
return(Entrustinfo);
}
