contentmanage.cs

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

            this.m_TotalOfCommonModelInfo = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public DataTable GetContentDataById(int generalId)
        {
            CommonModelInfo commonModelInfoById = this.GetCommonModelInfoById(generalId);
            if (commonModelInfoById.IsNull)
            {
                DataTable table = new DataTable();
                table.Columns.Add("FieldName");
                table.Columns.Add("FieldValue");
                table.Columns.Add("FieldType");
                table.Columns.Add("FieldLevel");
                return table;
            }
            string tableName = commonModelInfoById.TableName;
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            return DBHelper.ExecuteDataSetSql("SELECT C.*,C.ItemId AS InfoId,C.ItemId AS SpecialId,T.* FROM PE_CommonModel C INNER JOIN " + tableName + " T ON C.ItemID=T.ID WHERE GeneralId=@GeneralId", cmdParams).Tables[0];
        }

        public DataSet GetContentList(int modelId, string nodeIds)
        {
            string str = string.Empty;
            if (!string.IsNullOrEmpty(nodeIds))
            {
                str = " AND C.NodeID IN (" + nodeIds + ")";
            }
            ModelInfo modelInfoById = new ModelDal().GetModelInfoById(modelId);
            return DBHelper.ExecuteDataSetSql("SELECT * FROM PE_CommonModel C INNER JOIN " + modelInfoById.TableName + " T ON C.GeneralId=T.Id WHERE C.ModelId=" + modelId.ToString() + str);
        }

        public int GetContentNodeId(int generalId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            object obj2 = DBHelper.ExecuteScalarSql("SELECT NodeID FROM PE_CommonModel WHERE GeneralId=@GeneralId", cmdParams);
            if (obj2 != null)
            {
                return (int) obj2;
            }
            return 0;
        }

        public string GetContentTemplate(int infoid)
        {
            string str = string.Empty;
            if (infoid > 0)
            {
                int num = 0;
                int num2 = 0;
                string strSql = "select top 1 GeneralID, NodeId, ModelId, TemplateFile FROM PE_CommonModel where GeneralID=@GeneralId";
                Parameters cmdParams = new Parameters();
                cmdParams.AddInParameter("@GeneralId", DbType.Int32, infoid);
                using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams))
                {
                    if (reader.Read())
                    {
                        str = reader.GetString("TemplateFile");
                        num = reader.GetInt32("NodeId");
                        num2 = reader.GetInt32("ModelId");
                    }
                }
                if (!string.IsNullOrEmpty(str))
                {
                    return str;
                }
                strSql = "select top 1 NodeID, ModelID, DefaultTemplateFile FROM PE_Nodes_Model_Template Where NodeID=@NodeID and ModelID=@ModelID";
                cmdParams = new Parameters();
                cmdParams.AddInParameter("@NodeID", DbType.Int32, num);
                cmdParams.AddInParameter("@ModelID", DbType.Int32, num2);
                using (NullableDataReader reader2 = DBHelper.ExecuteReaderSql(strSql, cmdParams))
                {
                    if (reader2.Read())
                    {
                        str = reader2.GetString("DefaultTemplateFile");
                    }
                }
            }
            return str;
        }

        public DataTable GetCountByEditorAndMonth(int nodeId, string editor, DateTime beginDate, DateTime endDate)
        {
            string format = "SELECT  Editor,CONVERT(char(4),year(PassedTime))+'-'+CONVERT(char(2),month(PassedTime)) AS Date,COUNT(*) AS count\r\n                              FROM     PE_CommonModel\r\n                              WHERE    ( PassedTime >= @BeginDate AND PassedTime< = @EndDate) AND Status=99 {0}\r\n                              GROUP BY Editor,CONVERT(char(4),year(PassedTime))+'-'+CONVERT(char(2),month(PassedTime))";
            Parameters cmdParams = new Parameters();
            string str2 = string.Empty;
            if (!string.IsNullOrEmpty(editor))
            {
                str2 = str2 + " AND Editor=@Editor";
                cmdParams.AddInParameter("@Editor", DbType.String, editor);
            }
            if (nodeId > 0)
            {
                str2 = str2 + " AND NodeID = @NodeId ";
                cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
            }
            format = string.Format(format, str2);
            cmdParams.AddInParameter("@BeginDate", DbType.DateTime, beginDate);
            cmdParams.AddInParameter("@EndDate", DbType.DateTime, endDate);
            DataTable table = new DataTable();
            DataColumn column = new DataColumn("Editor", typeof(string));
            table.Columns.Add(column);
            column = new DataColumn("InputTime", typeof(string));
            table.Columns.Add(column);
            column = new DataColumn("Count", typeof(int));
            table.Columns.Add(column);
            using (NullableDataReader reader = new NullableDataReader(DBHelper.ExecuteReaderSql(format, cmdParams)))
            {
                while (reader.Read())
                {
                    DataRow row = table.NewRow();
                    row["Editor"] = reader.GetString("Editor");
                    row["InputTime"] = reader.GetString("Date");
                    row["Count"] = reader.GetInt32("Count");
                    table.Rows.Add(row);
                }
            }
            return table;
        }

        public DataTable GetCountByInputerMonth(int nodeId, string userName, DateTime beginDate, DateTime endDate)
        {
            string format = "SELECT  Inputer,CONVERT(char(4),year(InputTime))+'-'+CONVERT(char(2),month(InputTime)) AS Date,COUNT(*) AS count\r\n                              FROM     PE_CommonModel\r\n                              WHERE    ( InputTime >= @BeginDate AND InputTime< = @EndDate) AND Status=99 {0}\r\n                              GROUP BY Inputer,CONVERT(char(4),year(InputTime))+'-'+CONVERT(char(2),month(InputTime))";
            Parameters cmdParams = new Parameters();
            string str2 = string.Empty;
            if (!string.IsNullOrEmpty(userName))
            {
                str2 = str2 + " AND Inputer=@UserName";
                cmdParams.AddInParameter("@UserName", DbType.String, userName);
            }
            if (nodeId > 0)
            {
                str2 = str2 + " AND NodeID = @NodeId ";
                cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
            }
            format = string.Format(format, str2);
            cmdParams.AddInParameter("@BeginDate", DbType.DateTime, beginDate);
            cmdParams.AddInParameter("@EndDate", DbType.DateTime, endDate);
            DataTable table = new DataTable();
            DataColumn column = new DataColumn("Inputer", typeof(string));
            table.Columns.Add(column);
            column = new DataColumn("InputTime", typeof(string));
            table.Columns.Add(column);
            column = new DataColumn("Count", typeof(int));
            table.Columns.Add(column);
            using (NullableDataReader reader = new NullableDataReader(DBHelper.ExecuteReaderSql(format, cmdParams)))
            {
                while (reader.Read())
                {
                    DataRow row = table.NewRow();
                    row["Inputer"] = reader.GetString("Inputer");
                    row["InputTime"] = reader.GetString("Date");
                    row["Count"] = reader.GetInt32("Count");
                    table.Rows.Add(row);
                }
            }
            return table;
        }

        public DataTable GetCountByNodeAndEditor(int nodeId, string editor, DateTime beginDate, DateTime endDate)
        {
            string format = "SELECT  Editor,NodeName,COUNT(*) AS count\r\n                              FROM    PE_CommonModel M INNER JOIN PE_Nodes C ON M.NodeId=C.NodeId\r\n                              WHERE   ( PassedTime >= @BeginDate AND PassedTime< = @EndDate) AND Status=99 {0}\r\n                              GROUP BY Editor,NodeName";
            Parameters cmdParams = new Parameters();
            string str2 = string.Empty;
            if (!string.IsNullOrEmpty(editor))
            {
                str2 = str2 + " AND M.Editor=@Editor";
                cmdParams.AddInParameter("@Editor", DbType.String, editor);
            }
            if (nodeId > 0)
            {
                str2 = str2 + " AND C.NodeId=@NodeId";
                cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
            }
            cmdParams.AddInParameter("@BeginDate", DbType.DateTime, beginDate);
            cmdParams.AddInParameter("@EndDate", DbType.DateTime, endDate);
            format = string.Format(format, str2);
            DataTable table = new DataTable();
            DataColumn column = new DataColumn("Editor", typeof(string));
            table.Columns.Add(column);
            column = new DataColumn("NodeName", typeof(string));
            table.Columns.Add(column);
            column = new DataColumn("Count", typeof(int));
            table.Columns.Add(column);
            using (NullableDataReader reader = new NullableDataReader(DBHelper.ExecuteReaderSql(format, cmdParams)))
            {
                while (reader.Read())
                {
                    DataRow row = table.NewRow();
                    row["Editor"] = reader.GetString("Editor");
                    row["NodeName"] = reader.GetString("NodeName");
                    row["Count"] = reader.GetInt32("Count");
                    table.Rows.Add(row);
                }
            }
            return table;
        }

        public DataTable GetCountByNodeAndInputer(int nodeId, string userName, DateTime beginDate, DateTime endDate)
        {
            string format = "SELECT  Inputer,NodeName,COUNT(*) AS count\r\n                              FROM    PE_CommonModel M INNER JOIN PE_Nodes C ON M.NodeId=C.NodeId\r\n                              WHERE   ( InputTime >= @BeginDate AND InputTime< = @EndDate) AND Status=99 {0}\r\n                              GROUP BY Inputer,NodeName";
            Parameters cmdParams = new Parameters();
            string str2 = string.Empty;
            if (!string.IsNullOrEmpty(userName))
            {
                str2 = str2 + " AND M.Inputer=@UserName";
                cmdParams.AddInParameter("@UserName", DbType.String, userName);
            }
            if (nodeId > 0)
            {
                str2 = str2 + " AND C.NodeId=@NodeId";
                cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
            }
            cmdParams.AddInParameter("@BeginDate", DbType.DateTime, beginDate);
            cmdParams.AddInParameter("@EndDate", DbType.DateTime, endDate);
            format = string.Format(format, str2);
            DataTable table = new DataTable();
            DataColumn column = new DataColumn("UserName", typeof(string));
            table.Columns.Add(column);
            column = new DataColumn("NodeName", typeof(string));
            table.Columns.Add(column);
            column = new DataColumn("Count", typeof(int));
            table.Columns.Add(column);
            using (NullableDataReader reader = new NullableDataReader(DBHelper.ExecuteReaderSql(format, cmdParams)))
            {
                while (reader.Read())
                {
                    DataRow row = table.NewRow();
                    row["UserName"] = reader.GetString("Inputer");
                    row["NodeName"] = reader.GetString("NodeName");
                    row["Count"] = reader.GetInt32("Count");
                    table.Rows.Add(row);
                }
            }
            return table;
        }