choiceset.cs

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

namespace PowerEasy.SqlServerDal.Accessories
{
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using PowerEasy.IDal.Accessories;
    using PowerEasy.Model.Accessories;
    using PowerEasy.SqlServerDal;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;

    public class Choiceset : IChoiceset
    {
        private static ChoicesetInfo ChoicesetInfoFromrdr(NullableDataReader rdr)
        {
            ChoicesetInfo info = new ChoicesetInfo();
            info.FieldId = rdr.GetInt32("FieldID");
            info.Title = rdr.GetString("Title");
            info.TableName = rdr.GetString("TableName");
            info.FieldName = rdr.GetString("FieldName");
            info.FieldValue = rdr.GetString("FieldValue");
            return info;
        }

        public ChoicesetInfo GetChoicesetInfoByFieldAndTableName(string tableName, string fieldName)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Accessories_Choiceset_GetChoicesetFieldValueByName");
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, tableName);
            database.AddInParameter(storedProcCommand, "@FieldName", DbType.String, fieldName);
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                if (reader.Read())
                {
                    return ChoicesetInfoFromrdr(reader);
                }
                return new ChoicesetInfo(true);
            }
        }

        public IList<ChoicesetInfo> GetChoicesetList()
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Accessories_Choiceset_GetList");
            IList<ChoicesetInfo> list = new List<ChoicesetInfo>();
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    list.Add(ChoicesetInfoFromrdr(reader));
                }
            }
            return list;
        }

        public bool SetFieldValue(string fieldValue, string tableName, string fieldName)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@FieldValue", DbType.String, fieldValue);
            cmdParams.AddInParameter("@TableName", DbType.String, tableName);
            cmdParams.AddInParameter("@FieldName", DbType.String, fieldName);
            return DBHelper.ExecuteProc("PR_Accessories_Choiceset_SetFieldValue", cmdParams);
        }
    }
}