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