modeltemplate.cs

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

namespace PowerEasy.SqlServerDal.CommonModel
{
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using PowerEasy.Enumerations;
    using PowerEasy.IDal.CommonModel;
    using PowerEasy.Model.CommonModel;
    using PowerEasy.SqlServerDal;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Data.OleDb;
    using System.Text;

    public class ModelTemplate : IModelTemplate
    {
        private int m_CountNumber;

        public bool Add(ModelTemplatesInfo templateInfo)
        {
            Parameters parms = new Parameters();
            templateInfo.TemplateId = GetMaxId() + 1;
            GetParameters(templateInfo, parms);
            return DBHelper.ExecuteProc("PR_Contents_ModelTemplates_Add", parms);
        }

        public bool Delete(string id)
        {
            return DBHelper.ExecuteSql("DELETE FROM PE_ModelTemplates WHERE TemplateId in (" + id + ")");
        }

        public bool ExportData(string templateId, string importPath, bool chkFormatConn)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Contents_ModelTemplates_GetExportList");
            OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + importPath);
            if (chkFormatConn)
            {
                OleDbCommand command2 = new OleDbCommand("DELETE FROM [PE_ModelTemplates]", connection);
                command2.CommandType = CommandType.Text;
                connection.Open();
                try
                {
                    command2.ExecuteNonQuery();
                }
                catch
                {
                    return false;
                }
                finally
                {
                    command2.Cancel();
                    connection.Close();
                }
            }
            database.AddInParameter(storedProcCommand, "@TemplateID", DbType.String, templateId);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                connection.Open();
                object obj2 = new OleDbCommand("select max(templateId) from PE_ModelTemplates", connection).ExecuteScalar();
                int num = Convert.IsDBNull(obj2) ? 1 : (Convert.ToInt32(obj2) + 1);
                bool flag = false;
                OleDbCommand command4 = new OleDbCommand("INSERT INTO PE_ModelTemplates (templateId,TemplateName,TemplateDescription,Field,IsEshop) VALUES (@TemplateID,@TemplateName,@TemplateDescription,@Field,@IsEshop)", connection);
                OleDbParameter parameter = new OleDbParameter();
                OleDbParameter parameter2 = new OleDbParameter();
                OleDbParameter parameter3 = new OleDbParameter();
                OleDbParameter parameter4 = new OleDbParameter();
                OleDbParameter parameter5 = new OleDbParameter();
                parameter.ParameterName = "@TemplateID";
                parameter2.ParameterName = "@TemplateName";
                parameter3.ParameterName = "@TemplateDescription";
                parameter4.ParameterName = "@Field";
                parameter5.ParameterName = "@IsEshop";
                command4.Parameters.Add(parameter);
                command4.Parameters.Add(parameter2);
                command4.Parameters.Add(parameter3);
                command4.Parameters.Add(parameter4);
                command4.Parameters.Add(parameter5);
                while (reader.Read())
                {
                    if (!flag)
                    {
                        flag = true;
                    }
                    else
                    {
                        num++;
                    }
                    try
                    {
                        parameter.Value = num;
                        parameter2.Value = reader.GetString("TemplateName");
                        parameter3.Value = reader.GetString("TemplateDescription");
                        parameter4.Value = reader.GetString("Field");
                        parameter5.Value = reader.GetBoolean("IsEshop");
                        command4.ExecuteNonQuery();
                        continue;
                    }
                    catch
                    {
                        connection.Close();
                        return false;
                    }
                }
                connection.Close();
                return true;
            }
        }

        public int GetCountNumber()
        {
            return this.m_CountNumber;
        }

        public string GetField(int id)
        {
            string str = "";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@TemplateId", DbType.Int32, id);
            using (NullableDataReader reader = DBHelper.ExecuteReaderProc("PR_Contents_ModelTemplates_GetField", cmdParams))
            {
                if (reader.Read())
                {
                    str = reader.GetString("Field");
                }
            }
            return str;
        }

        public IList<ModelTemplatesInfo> GetImportList(string importPath)
        {
            OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + importPath);
            IList<ModelTemplatesInfo> list = new List<ModelTemplatesInfo>();
            try
            {
                connection.Open();
                OleDbCommand command = new OleDbCommand(" SELECT * FROM PE_ModelTemplates ORDER BY TemplateID ASC", connection);
                NullableDataReader rdr = new NullableDataReader(command.ExecuteReader(CommandBehavior.CloseConnection));
                while (rdr.Read())
                {
                    list.Add(ModelTemplatesInfoFromDataReader(rdr));
                }
            }
            catch
            {
            }
            finally
            {
                connection.Close();
            }
            return list;
        }

        public IList<ModelTemplatesInfo> GetImportList(string importPath, ModelType type)
        {
            OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + importPath);
            IList<ModelTemplatesInfo> list = new List<ModelTemplatesInfo>();
            string cmdText = string.Empty;
            switch (type)
            {
                case ModelType.Content:
                    cmdText = " SELECT * FROM PE_ModelTemplates WHERE IsEshop=False ORDER BY TemplateID ASC";
                    break;

                case ModelType.Shop:
                    cmdText = " SELECT * FROM PE_ModelTemplates WHERE IsEshop=True ORDER BY TemplateID ASC";
                    break;

                default:
                    cmdText = " SELECT * FROM PE_ModelTemplates ORDER BY TemplateID ASC";
                    break;
            }
            try
            {
                connection.Open();
                OleDbCommand command = new OleDbCommand(cmdText, connection);
                NullableDataReader rdr = new NullableDataReader(command.ExecuteReader(CommandBehavior.CloseConnection));
                while (rdr.Read())
                {
                    list.Add(ModelTemplatesInfoFromDataReader(rdr));
                }
            }
            catch
            {
            }
            finally