contentmanage.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

            return commonModelInfoList;
        }

        public IList<CommonModelInfo> GetCommonModelInfoList(string nodeIdArray, int number)
        {
            IList<CommonModelInfo> commonModelInfoList = new List<CommonModelInfo>();
            Parameters parms = new Parameters();
            string strSql = "SELECT TOP " + number + " M.* FROM PE_CommonModel M LEFT JOIN PE_ContentCharge C ON C.GeneralId IS NULL \r\n                                WHERE M.Status = 99 ";
            strSql = GetNodeBound(nodeIdArray, parms, strSql) + " ORDER BY M.GeneralId DESC";
            GetCommonModelInfo(commonModelInfoList, parms, strSql);
            return commonModelInfoList;
        }

        public IList<CommonModelInfo> GetCommonModelInfoList(string nodeIdArray, string generalIdArray)
        {
            IList<CommonModelInfo> commonModelInfoList = new List<CommonModelInfo>();
            Parameters parms = new Parameters();
            string strSql = "SELECT M.* FROM PE_CommonModel M LEFT JOIN PE_ContentCharge C ON C.GeneralId IS NULL \r\n                                WHERE M.Status=99 ";
            strSql = GetNodeBound(nodeIdArray, parms, strSql);
            if (generalIdArray.IndexOf(',') > 0)
            {
                strSql = strSql + " AND  M.GeneralId in (" + generalIdArray + ") ";
            }
            else
            {
                strSql = strSql + " AND  M.GeneralId =@GeneralId ";
                parms.AddInParameter("@GeneralId", DbType.Int32, generalIdArray);
            }
            strSql = strSql + " ORDER BY M.GeneralId DESC";
            GetCommonModelInfo(commonModelInfoList, parms, strSql);
            return commonModelInfoList;
        }

        public IList<CommonModelInfo> GetCommonModelInfoList(string nodeIdArray, DateTime beginTime, DateTime endTime)
        {
            IList<CommonModelInfo> commonModelInfoList = new List<CommonModelInfo>();
            Parameters parms = new Parameters();
            string strSql = "SELECT M.* FROM PE_CommonModel M LEFT JOIN PE_ContentCharge C ON C.GeneralId IS NULL \r\n                                WHERE M.Status=99 ";
            object obj2 = GetNodeBound(nodeIdArray, parms, strSql);
            strSql = string.Concat(new object[] { obj2, " AND M.UpdateTime BETWEEN '", beginTime, "' AND '", endTime, "' ORDER BY M.GeneralId DESC" });
            GetCommonModelInfo(commonModelInfoList, parms, strSql);
            return commonModelInfoList;
        }

        public IList<CommonModelInfo> GetCommonModelInfoList(string nodeIdArray, int minId, int maxId)
        {
            IList<CommonModelInfo> commonModelInfoList = new List<CommonModelInfo>();
            Parameters parms = new Parameters();
            string strSql = "SELECT M.* FROM PE_CommonModel M LEFT JOIN PE_ContentCharge C ON C.GeneralId IS NULL \r\n                                WHERE M.Status=99 ";
            object obj2 = GetNodeBound(nodeIdArray, parms, strSql);
            strSql = string.Concat(new object[] { obj2, " AND M.GeneralId BETWEEN ", minId, " AND ", maxId, " ORDER BY M.GeneralId DESC " });
            GetCommonModelInfo(commonModelInfoList, parms, strSql);
            return commonModelInfoList;
        }

        public IList<CommonModelInfo> GetCommonModelInfoList(int startRowIndexId, int maxNumberRows, string nodeIds, ContentSortType sortType, int status, string roleIds)
        {
            return this.GetCommonModelInfoList(startRowIndexId, maxNumberRows, nodeIds, sortType, status, roleIds, false);
        }

        private IList<CommonModelInfo> GetCommonModelInfoList(int startRowIndexId, int maxNumberRows, string nodeIds, ContentSortType sortType, int status, string roleIds, bool isEshop)
        {
            Database database = DatabaseFactory.CreateDatabase();
            List<CommonModelInfo> list = new List<CommonModelInfo>();
            string sortColumn = "C.GeneralId";
            string str2 = "C.*,M.IsEshop";
            string sorts = "DESC";
            string str4 = "";
            string str5 = "";
            if (!string.IsNullOrEmpty(nodeIds))
            {
                str4 = " C.NodeId IN (" + nodeIds.ToString() + ") ";
                str5 = " and ";
            }
            if ((status < 100) && (status > -4))
            {
                str4 = string.Concat(new object[] { str4, str5, "C.Status=", status, " " });
            }
            if (status == 100)
            {
                str4 = str4 + str5 + "C.Status <= 99 AND C.Status >=0 ";
            }
            if (status == 0x65)
            {
                if (!string.IsNullOrEmpty(roleIds))
                {
                    string str6 = "SELECT   StatusCode\r\n                     FROM      PE_ProcessStatusCode AS psc\r\n                     WHERE   (FlowID =\r\n                                         (SELECT   WorkFlowID\r\n                                          FROM      PE_Nodes\r\n                                          WHERE   (NodeID = C.NodeID))) AND (ProcessID IN\r\n                                         (SELECT   ProcessID\r\n                                          FROM      PE_Process_Roles\r\n                                          WHERE   (FlowID = psc.FlowID) AND (RoleID IN (" + roleIds + "))))";
                    str4 = str4 + str5 + "C.Status < 99 AND C.Status >=0 AND C.Status IN(" + str6 + ") ";
                }
                else
                {
                    str4 = str4 + str5 + "C.Status < 99 AND C.Status >=0 ";
                }
            }
            InitContentSortColumnAndSort(sortType, ref sortColumn, ref sorts);
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetListBySortColumn");
            database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
            database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
            database.AddInParameter(storedProcCommand, "@PrimaryColumn", DbType.String, "C.GeneralId");
            database.AddInParameter(storedProcCommand, "@SortColumnDbType", DbType.String, "int");
            database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, sortColumn);
            database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, str2);
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, sorts);
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_CommonModel C inner join PE_Model M on C.ModelID = M.ModelID AND M.IsEshop=" + (isEshop ? "1" : "0"));
            database.AddInParameter(storedProcCommand, "@Filter", DbType.String, str4);
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    CommonModelInfo item = new CommonModelInfo();
                    item = CommonModelInfoFromDataReader(reader);
                    item.IsEshop = reader.GetBoolean("IsEshop");
                    list.Add(item);
                }
            }
            this.m_TotalOfCommonModelInfo = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public IList<CommonModelInfo> GetCommonModelInfoListByShop(int startRowIndexId, int maxNumberRows, string nodeIds, ContentSortType sortType, int status, string roleIds)
        {
            return this.GetCommonModelInfoList(startRowIndexId, maxNumberRows, nodeIds, sortType, status, roleIds, true);
        }

        public DataTable GetCommonModelInfoListBySigninLog(int startRowIndexId, int maxNumberRows, string userName)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DataTable table = new DataTable();
            table.Columns.Add("GeneralId");
            table.Columns.Add("NodeId");
            table.Columns.Add("Title");
            table.Columns.Add("LinkType");
            table.Columns.Add("Inputer");
            table.Columns.Add("Hits");
            table.Columns.Add("EliteLevel");
            table.Columns.Add("Priority");
            table.Columns.Add("IsSignin");
            table.Columns.Add("ModelId");
            string str = "C.GeneralId";
            string str2 = "C.*,M.GeneralId,M.UserName,M.IsSignin,M.SigninTime,M.IP";
            string str3 = "DESC";
            string str4 = "M.UserName ='" + userName + "'";
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetList");
            database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
            database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
            database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, str);
            database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, str2);
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, str3);
            database.AddInParameter(storedProcCommand, "@Filter", DbType.String, str4);
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_CommonModel C inner join PE_SigninLog M on C.GeneralId = M.GeneralId ");
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    DataRow row = table.NewRow();
                    row["GeneralId"] = reader.GetInt32("GeneralId");
                    row["NodeId"] = reader.GetInt32("NodeId");
                    row["Title"] = reader.GetString("Title");
                    row["LinkType"] = reader.GetInt32("LinkType");
                    row["Inputer"] = reader.GetString("Inputer");
                    row["Hits"] = reader.GetInt32("Hits");
                    row["EliteLevel"] = reader.GetInt32("EliteLevel");
                    row["Priority"] = reader.GetInt32("Priority");
                    row["IsSignin"] = reader.GetBoolean("IsSignin");
                    row["ModelId"] = reader.GetInt32("ModelID");
                    table.Rows.Add(row);
                }
            }
            this.m_TotalOfCommonModelInfo = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return table;
        }

        public IList<CommonModelInfo> GetCommonModelInfoListBySigninStatus(int startRowIndexId, int maxNumberRows, string userName, int signin)
        {
            Database database = DatabaseFactory.CreateDatabase();
            List<CommonModelInfo> list = new List<CommonModelInfo>();
            string str = "C.GeneralId";
            string str2 = "C.*,M.IsEshop";
            string str3 = "DESC";
            string str4 = "";
            if (!string.IsNullOrEmpty(userName))
            {
                string str5 = "";
                switch (signin)
                {
                    case 0:
                        str5 = "";
                        break;

                    case 1:
                        str5 = " AND IsSignin=1";
                        break;

                    case 2:
                        str5 = " AND IsSignin=0";
                        break;
                }
                str4 = " C.GeneralId IN (SELECT GeneralId FROM PE_SigninLog WHERE UserName='" + userName + "' " + str5 + " ) ";
                DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetList");
                database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
                database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
                database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, str);
                database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, str2);
                database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, str3);
                database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_CommonModel C inner join PE_Model M on C.ModelID = M.ModelID");
                database.AddInParameter(storedProcCommand, "@Filter", DbType.String, str4);
                database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
                using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
                {
                    while (reader.Read())
                    {
                        CommonModelInfo item = new CommonModelInfo();
                        item = CommonModelInfoFromDataReader(reader);
                        list.Add(item);
                    }
                }
                this.m_TotalOfCommonModelInfo = (int) database.GetParameterValue(storedProcCommand, "@Total");
            }
            return list;
        }

        public IList<CommonModelInfo> GetCommonModelInfoListBySigninType(int startRowIndexId, int maxNumberRows, string nodeIds, int signinType, ContentSortType sortType, int status, string searchType, string keyword)
        {
            Database database;
            string str = "";
            keyword = DataSecurity.FilterBadChar(keyword);
            if (!string.IsNullOrEmpty(keyword))
            {
                string str8 = searchType;
                if (str8 == null)
                {
                    goto Label_0065;
                }
                if (!(str8 == "Title"))
                {
                    if (str8 == "Inputer")
                    {
                        str = "C.Inputer Like '%" + keyword + "%'";
                        goto Label_0077;
                    }
                    goto Label_0065;
                }