Hidistro.SqlDal/Weibo/SendAllDao.cs

（开头部分） 11KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

namespace Hidistro.SqlDal.Weibo
{
    using Hidistro.Core;
    using Hidistro.Core.Entities;
    using Hidistro.Entities.VShop;
    using Hidistro.Entities.WeiXin;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Data;
    using System.Data.Common;
    using System.Runtime.InteropServices;
    using System.Text;

    public class SendAllDao
    {
        private Database database = DatabaseFactory.CreateDatabase();

        public string ClearWeiXinMediaID()
        {
            string query = "update vshop_Article set mediaid=null where len(mediaid)>0;update vshop_ArticleItems set mediaid=null where len(mediaid)>0;delete from WeiXin_RecentOpenID";
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
            return this.database.ExecuteNonQuery(sqlStringCommand).ToString();
        }

        public bool DeleteOldQRCode(string AppID)
        {
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("Delete from vshop_ScanOpenID where 1=1 or AppID=@AppID");
            this.database.AddInParameter(sqlStringCommand, "AppID", DbType.String, AppID);
            return (Globals.ToNum(this.database.ExecuteScalar(sqlStringCommand)) > 0);
        }

        public bool DelOldSendAllList()
        {
            string query = "update WeiXin_SendAll set SendState=2 where SendState=0 and DATEADD(HOUR,2, SendTime)<getdate()";
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
            return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
        }

        public bool GetQRCodeScanInfo(string AppID, bool IsClearAfterRead, out string SCannerUserOpenID, out string SCannerUserNickName, out string UserHead)
        {
            bool flag = false;
            SCannerUserOpenID = "";
            SCannerUserNickName = "";
            UserHead = "";
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(" select a.SCannerUserOpenID, b.UserName as NickName, b.UserHead    from  vshop_ScanOpenID  a  left join aspnet_Members b  on a.SCannerUserOpenID= b.OpenId   where 1=1 or a.AppID= @AppID  order by AutoID desc ");
            this.database.AddInParameter(sqlStringCommand, "AppID", DbType.String, AppID);
            using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
            {
                if (reader.Read())
                {
                    flag = true;
                    object obj2 = reader["SCannerUserOpenID"];
                    if ((obj2 != null) && (obj2 != DBNull.Value))
                    {
                        SCannerUserOpenID = (string) obj2;
                        flag = true;
                    }
                    obj2 = reader["NickName"];
                    if ((obj2 != null) && (obj2 != DBNull.Value))
                    {
后面还有 162 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。