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