modeltemplate.cs

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

            {
                connection.Close();
            }
            return list;
        }

        public ModelTemplatesInfo GetInfoById(int id)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@TemplateId", DbType.Int32, id);
            using (NullableDataReader reader = DBHelper.ExecuteReaderProc("PR_Contents_ModelTemplates_GetInfoById", cmdParams))
            {
                if (reader.Read())
                {
                    return ModelTemplatesInfoFromDataReader(reader);
                }
                return new ModelTemplatesInfo(true);
            }
        }

        private static int GetMaxId()
        {
            return DBHelper.GetMaxId("PE_ModelTemplates", "TemplateId");
        }

        public IList<ModelTemplatesInfo> GetModelTemplateInfoList(int startRowIndexId, int maxNumberRows)
        {
            Database database = DatabaseFactory.CreateDatabase();
            IList<ModelTemplatesInfo> list = new List<ModelTemplatesInfo>();
            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, "TemplateID");
            database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "*");
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
            database.AddInParameter(storedProcCommand, "@Filter", DbType.String, "");
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_ModelTemplates");
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    list.Add(ModelTemplatesInfoFromDataReader(reader));
                }
            }
            this.m_CountNumber = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public IList<ModelTemplatesInfo> GetModelTemplateInfoList(int startRowIndexId, int maxNumberRows, ModelType type)
        {
            Database database = DatabaseFactory.CreateDatabase();
            IList<ModelTemplatesInfo> list = new List<ModelTemplatesInfo>();
            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, "TemplateID");
            database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "*");
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
            switch (type)
            {
                case ModelType.Content:
                    database.AddInParameter(storedProcCommand, "@Filter", DbType.String, " IsEshop = 0");
                    break;

                case ModelType.Shop:
                    database.AddInParameter(storedProcCommand, "@Filter", DbType.String, " IsEshop = 1");
                    break;
            }
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_ModelTemplates");
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    list.Add(ModelTemplatesInfoFromDataReader(reader));
                }
            }
            this.m_CountNumber = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        private static void GetParameters(ModelTemplatesInfo modelTemplateInfo, Parameters parms)
        {
            parms.AddInParameter("@TemplateId", DbType.Int32, modelTemplateInfo.TemplateId);
            parms.AddInParameter("@TemplateName", DbType.String, modelTemplateInfo.TemplateName);
            parms.AddInParameter("@TemplateDescription", DbType.String, modelTemplateInfo.TemplateDescription);
            parms.AddInParameter("@Field", DbType.String, modelTemplateInfo.Field);
            if (modelTemplateInfo.IsEshop == ModelType.Content)
            {
                parms.AddInParameter("@IsEshop", DbType.Int32, 0);
            }
            else
            {
                parms.AddInParameter("@IsEshop", DbType.Int32, 1);
            }
        }

        private static DbCommand GetProcdbComm(Database db, string proName, ModelTemplatesInfo modelTemplate)
        {
            DbCommand storedProcCommand = db.GetStoredProcCommand(proName);
            db.AddInParameter(storedProcCommand, "@TemplateId", DbType.Int32, modelTemplate.TemplateId);
            db.AddInParameter(storedProcCommand, "@TemplateName", DbType.String, modelTemplate.TemplateName);
            db.AddInParameter(storedProcCommand, "@TemplateDescription", DbType.String, modelTemplate.TemplateDescription);
            db.AddInParameter(storedProcCommand, "@Field", DbType.String, modelTemplate.Field);
            int num = (modelTemplate.IsEshop == ModelType.Shop) ? 1 : 0;
            db.AddInParameter(storedProcCommand, "@IsEshop", DbType.Int32, num);
            return storedProcCommand;
        }

        public bool ImportData(string templateId, string importPath)
        {
            bool flag;
            Database db = DatabaseFactory.CreateDatabase();
            StringBuilder builder = new StringBuilder("");
            builder.Append(" SELECT * FROM PE_ModelTemplates ");
            OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + importPath);
            try
            {
                connection.Open();
                builder.Append("Where TemplateID in (" + templateId + ") order by templateId");
                OleDbCommand command = new OleDbCommand(builder.ToString(), connection);
                NullableDataReader reader = new NullableDataReader(command.ExecuteReader(CommandBehavior.CloseConnection));
                while (reader.Read())
                {
                    ModelTemplatesInfo modelTemplate = new ModelTemplatesInfo();
                    modelTemplate.TemplateId = GetMaxId() + 1;
                    modelTemplate.TemplateName = reader.GetString("TemplateName");
                    modelTemplate.TemplateDescription = reader.GetString("TemplateDescription");
                    modelTemplate.Field = reader.GetString("Field");
                    modelTemplate.IsEshop = reader.GetBoolean("IsEshop") ? ModelType.Shop : ModelType.Content;
                    DbCommand command2 = GetProcdbComm(db, "PR_Contents_ModelTemplates_Add", modelTemplate);
                    try
                    {
                        db.ExecuteNonQuery(command2);
                        continue;
                    }
                    catch
                    {
                        reader.Close();
                        return false;
                    }
                }
                flag = true;
            }
            catch
            {
                flag = false;
            }
            finally
            {
                connection.Close();
            }
            return flag;
        }

        private static ModelTemplatesInfo ModelTemplatesInfoFromDataReader(NullableDataReader rdr)
        {
            ModelTemplatesInfo info = new ModelTemplatesInfo();
            info.TemplateId = rdr.GetInt32("TemplateID");
            info.TemplateName = rdr.GetString("TemplateName");
            info.TemplateDescription = rdr.GetString("TemplateDescription");
            info.Field = rdr.GetString("Field");
            info.IsEshop = rdr.GetBoolean("IsEshop") ? ModelType.Shop : ModelType.Content;
            return info;
        }

        public bool Update(ModelTemplatesInfo modelTemplatesInfo)
        {
            Parameters parms = new Parameters();
            GetParameters(modelTemplatesInfo, parms);
            return DBHelper.ExecuteProc("PR_Contents_ModelTemplates_Update", parms);
        }

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