modeldal.cs

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

            parms.AddInParameter("@DefaultTemplateFile", DbType.String, modelInfo.DefaultTemplateFile);
            parms.AddInParameter("@EnableCharge", DbType.Boolean, modelInfo.EnableCharge);
            parms.AddInParameter("@EnableSignin", DbType.Boolean, modelInfo.EnableSignin);
            parms.AddInParameter("@EnableVote", DbType.Boolean, modelInfo.EnbaleVote);
            parms.AddInParameter("@AddInfoFilePath", DbType.String, modelInfo.AddInfoFilePath);
            parms.AddInParameter("@ManageInfoFilePath", DbType.String, modelInfo.ManageInfoFilePath);
            parms.AddInParameter("@PreviewInfoFilePath", DbType.String, modelInfo.PreviewInfoFilePath);
            parms.AddInParameter("@BatchInfoFilePath", DbType.String, modelInfo.BatchInfoFilePath);
            parms.AddInParameter("@Character", DbType.Int32, (int) modelInfo.Character);
            parms.AddInParameter("@MaxPerUser", DbType.Int32, modelInfo.MaxPerUser);
            parms.AddInParameter("@PrintTemplate", DbType.String, modelInfo.PrintTemplate);
            parms.AddInParameter("@SearchTemplate", DbType.String, modelInfo.SearchTemplate);
            parms.AddInParameter("@AdvanceSearchFormTemplate", DbType.String, modelInfo.AdvanceSearchFormTemplate);
            parms.AddInParameter("@AdvanceSearchTemplate", DbType.String, modelInfo.AdvanceSearchTemplate);
        }

        public DataTable GetShopModelListByNodeId(int nodeId, bool enable)
        {
            bool flag = false;
            if (!enable)
            {
                flag = true;
            }
            DataTable table = new DataTable();
            table.Columns.Add("NodeId");
            table.Columns.Add("ModelId");
            table.Columns.Add("DefaultTemplateFile");
            table.Columns.Add("ModelName");
            table.Columns.Add("ItemName");
            table.Columns.Add("IsEshop");
            table.Columns.Add("AddInfoFilePath");
            table.Columns.Add("ManageInfoFilePath");
            table.Columns.Add("PreviewInfoFilePath");
            table.Columns.Add("BatchInfoFilePath");
            table.Columns.Add("MaxPerUser");
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
            cmdParams.AddInParameter("@Disabled", DbType.Boolean, flag);
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT R.NodeId,R.ModelId,R.DefaultTemplateFile,M.ModelName,M.ItemName,M.IsEshop,M.AddInfoFilePath,M.ManageInfoFilePath,M.PreviewInfoFilePath,M.BatchInfoFilePath,M.MaxPerUser FROM PE_Nodes_Model_Template R INNER JOIN PE_Model M ON R.ModelId=M.ModelID WHERE R.NodeId=@NodeId AND M.Disabled=@Disabled AND M.IsEshop=1", cmdParams))
            {
                while (reader.Read())
                {
                    DataRow row = table.NewRow();
                    row["NodeId"] = reader.GetInt32("NodeId");
                    row["ModelId"] = reader.GetInt32("ModelId");
                    row["DefaultTemplateFile"] = reader.GetString("DefaultTemplateFile");
                    row["ModelName"] = reader.GetString("ModelName");
                    row["ItemName"] = reader.GetString("ItemName");
                    row["IsEshop"] = reader.GetBoolean("IsEshop");
                    row["AddInfoFilePath"] = reader.GetString("AddInfoFilePath");
                    row["ManageInfoFilePath"] = reader.GetString("ManageInfoFilePath");
                    row["PreviewInfoFilePath"] = reader.GetString("PreviewInfoFilePath");
                    row["BatchInfoFilePath"] = reader.GetString("BatchInfoFilePath");
                    row["MaxPerUser"] = reader.GetInt32("MaxPerUser");
                    table.Rows.Add(row);
                }
            }
            return table;
        }

        public IList<int> GetTemplateIdList(int nodeId)
        {
            List<int> list = new List<int>();
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@NodeID", DbType.Int32, nodeId);
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT TemplateID FROM PE_Nodes_Template WHERE NodeID=@NodeID", cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(reader.GetInt32("TemplateID"));
                }
            }
            return list;
        }

        public string GetXmlFieldByModelId(int id)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@Id", DbType.Int32, id);
            object obj2 = DBHelper.ExecuteScalarSql("SELECT Field FROM PE_Model WHERE ModelId=@Id", cmdParams);
            if (obj2 == null)
            {
                return null;
            }
            return Convert.ToString(obj2);
        }

        public bool ModelIdExists(int nodeId, int modelId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
            cmdParams.AddInParameter("@ModelId", DbType.Int32, modelId);
            return DBHelper.ExistsProc("PR_Contents_Model_ModelIdExists", cmdParams);
        }

        private static ModelInfo ModelInfoFromDataReader(NullableDataReader rdr)
        {
            ModelInfo info = new ModelInfo();
            info.ModelId = rdr.GetInt32("ModelID");
            info.ModelName = rdr.GetString("ModelName");
            info.IsEshop = rdr.GetBoolean("IsEshop");
            info.Description = rdr.GetString("Description");
            info.TableName = rdr.GetString("TableName");
            info.ItemName = rdr.GetString("ItemName");
            info.ItemUnit = rdr.GetString("ItemUnit");
            info.ItemIcon = rdr.GetString("ItemIcon");
            info.IsCountHits = rdr.GetBoolean("IsCountHits");
            info.Disabled = rdr.GetBoolean("Disabled");
            info.Field = rdr.GetString("Field");
            info.DefaultTemplateFile = rdr.GetString("DefaultTemplateFile");
            info.EnableCharge = rdr.GetBoolean("EnableCharge");
            info.EnableSignin = rdr.GetBoolean("EnableSignin");
            info.EnbaleVote = rdr.GetBoolean("EnableVote");
            info.AddInfoFilePath = rdr.GetString("AddInfoFilePath");
            info.ManageInfoFilePath = rdr.GetString("ManageInfoFilePath");
            info.PreviewInfoFilePath = rdr.GetString("PreviewInfoFilePath");
            info.BatchInfoFilePath = rdr.GetString("BatchInfoFilePath");
            info.MaxPerUser = rdr.GetInt32("MaxPerUser");
            info.PrintTemplate = rdr.GetString("PrintTemplate");
            info.SearchTemplate = rdr.GetString("SearchTemplate");
            info.AdvanceSearchFormTemplate = rdr.GetString("AdvanceSearchFormTemplate");
            info.AdvanceSearchTemplate = rdr.GetString("AdvanceSearchTemplate");
            info.Character = (ProductCharacter) rdr.GetInt32("Character");
            return info;
        }

        public bool ModelNameExists(string modelName)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ModelName", DbType.String, modelName);
            return DBHelper.ExistsProc("PR_Contents_Model_IsModelNameExists", cmdParams);
        }

        private static bool TableExists(string tableName)
        {
            string strSql = "SELECT Count(*) FROM [PE_Model] WHERE TableName=@TableName";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@TableName", DbType.String, tableName);
            return DBHelper.ExistsSql(strSql, cmdParams);
        }

        public bool TableNameExists(string tableName)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@TableName", DbType.String, tableName);
            return DBHelper.ExistsProc("PR_Contents_Model_IsTableNameExists", cmdParams);
        }

        public bool TemplateIdExists(int nodeId, int templateId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@NodeId", DbType.Int32, nodeId);
            cmdParams.AddInParameter("@TemplateId", DbType.Int32, templateId);
            return DBHelper.ExistsProc("PR_Contents_Model_TemplateIdExists", cmdParams);
        }

        public bool Update(ModelInfo modelInfo)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ModelID", DbType.Int32, modelInfo.ModelId);
            cmdParams.AddInParameter("@ModelName", DbType.String, modelInfo.ModelName);
            cmdParams.AddInParameter("@IsEshop", DbType.Boolean, modelInfo.IsEshop);
            cmdParams.AddInParameter("@Description", DbType.String, modelInfo.Description);
            cmdParams.AddInParameter("@TableName", DbType.String, modelInfo.TableName);
            cmdParams.AddInParameter("@ItemName", DbType.String, modelInfo.ItemName);
            cmdParams.AddInParameter("@ItemUnit", DbType.String, modelInfo.ItemUnit);
            cmdParams.AddInParameter("@ItemIcon", DbType.String, modelInfo.ItemIcon);
            cmdParams.AddInParameter("@IsCountHits", DbType.Boolean, modelInfo.IsCountHits);
            cmdParams.AddInParameter("@Disabled", DbType.Boolean, modelInfo.Disabled);
            cmdParams.AddInParameter("@DefaultTemplateFile", DbType.String, modelInfo.DefaultTemplateFile);
            cmdParams.AddInParameter("@EnableCharge", DbType.Boolean, modelInfo.EnableCharge);
            cmdParams.AddInParameter("@EnableSignin", DbType.Boolean, modelInfo.EnableSignin);
            cmdParams.AddInParameter("@EnableVote", DbType.Boolean, modelInfo.EnbaleVote);
            cmdParams.AddInParameter("@AddInfoFilePath", DbType.String, modelInfo.AddInfoFilePath);
            cmdParams.AddInParameter("@ManageInfoFilePath", DbType.String, modelInfo.ManageInfoFilePath);
            cmdParams.AddInParameter("@PreviewInfoFilePath", DbType.String, modelInfo.PreviewInfoFilePath);
            cmdParams.AddInParameter("@BatchInfoFilePath", DbType.String, modelInfo.BatchInfoFilePath);
            cmdParams.AddInParameter("@MaxPerUser", DbType.Int32, modelInfo.MaxPerUser);
            cmdParams.AddInParameter("@PrintTemplate", DbType.String, modelInfo.PrintTemplate);
            cmdParams.AddInParameter("@SearchTemplate", DbType.String, modelInfo.SearchTemplate);
            cmdParams.AddInParameter("@AdvanceSearchFormTemplate", DbType.String, modelInfo.AdvanceSearchFormTemplate);
            cmdParams.AddInParameter("@AdvanceSearchTemplate", DbType.String, modelInfo.AdvanceSearchTemplate);
            return DBHelper.ExecuteProc("PR_Contents_Model_Update", cmdParams);
        }

        public bool UpdateField(int modelId, string fieldList)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ModelID", DbType.Int32, modelId);
            cmdParams.AddInParameter("@Field", DbType.String, fieldList);
            return DBHelper.ExecuteSql("UPDATE PE_Model SET Field = @Field WHERE ModelID = @ModelID", cmdParams);
        }

        public bool UpdateTableField(FieldInfo fieldInfo, string tableName)
        {
            string alterColumnToTableSql = Query.GetAlterColumnToTableSql(fieldInfo, tableName);
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand sqlStringCommand = database.GetSqlStringCommand(alterColumnToTableSql);
            try
            {
                database.ExecuteNonQuery(sqlStringCommand);
                return true;
            }
            catch
            {
                return false;
            }
        }
    }
}