public string GetFormId(WXAppletEvent eventId, string eventValue) { DbCommand sqlStringCommand = base.database.GetSqlStringCommand("SELECT TOP 1 FormId FROM Hishop_WXAppletFormDatas WHERE EventId = @EventId AND EventValue = @EventValue AND ExpireTime >= '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' ORDER BY Id DESC"); base.database.AddInParameter(sqlStringCommand, "EventId", DbType.Int32, (int)eventId); base.database.AddInParameter(sqlStringCommand, "EventValue", DbType.String, eventValue); return(base.database.ExecuteScalar(sqlStringCommand).ToNullString()); }
public WXAppletFormDataInfo GetWxFormData(WXAppletEvent eventId, string eventValue) { DbCommand sqlStringCommand = base.database.GetSqlStringCommand("SELECT TOP 1 * FROM Hishop_WXAppletFormDatas WHERE EventId = @EventId AND EventValue = @EventValue AND ExpireTime >= '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' ORDER BY Id DESC"); base.database.AddInParameter(sqlStringCommand, "EventId", DbType.Int32, (int)eventId); base.database.AddInParameter(sqlStringCommand, "EventValue", DbType.String, eventValue); WXAppletFormDataInfo result = null; using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand)) { result = DataHelper.ReaderToModel <WXAppletFormDataInfo>(objReader); } return(result); }
public static bool AddFormData(WXAppletEvent eventId, string eventValue, string formId) { if (!Enum.IsDefined(typeof(WXAppletEvent), eventId)) { return(false); } if (string.IsNullOrEmpty(eventValue) || string.IsNullOrEmpty(formId)) { return(false); } WXAppletFormDataInfo wXAppletFormDataInfo = new WXAppletFormDataInfo(); wXAppletFormDataInfo.EventId = eventId; wXAppletFormDataInfo.EventTime = DateTime.Now; wXAppletFormDataInfo.EventValue = eventValue; wXAppletFormDataInfo.ExpireTime = DateTime.Now.AddDays(7.0); wXAppletFormDataInfo.FormId = formId; return(new WeChatAppletDao().Add(wXAppletFormDataInfo, null) > 0); }
public static WXAppletFormDataInfo GetWxFormData(WXAppletEvent eventId, string eventValue) { return(new WeChatAppletDao().GetWxFormData(eventId, eventValue)); }