signincontent.cs

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

namespace PowerEasy.SqlServerDal.Contents
{
    using PowerEasy.Enumerations;
    using PowerEasy.IDal.Contents;
    using PowerEasy.Model.Contents;
    using PowerEasy.SqlServerDal;
    using System;
    using System.Data;

    public class SigninContent : ISigninContent
    {
        public bool Add(SigninContentInfo signinContentInfo)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, signinContentInfo.GeneralId);
            cmdParams.AddInParameter("@EndTime", DbType.DateTime, signinContentInfo.EndTime);
            cmdParams.AddInParameter("@Priority", DbType.Int32, signinContentInfo.Priority);
            cmdParams.AddInParameter("@SigninType", DbType.Int32, signinContentInfo.SigninType);
            cmdParams.AddInParameter("@Status", DbType.Int32, signinContentInfo.Status);
            cmdParams.AddInParameter("@Title", DbType.String, signinContentInfo.Title);
            return DBHelper.ExecuteSql("INSERT INTO PE_SigninContent (GeneralId,EndTime,Priority,SigninType,Status,Title)VALUES(@GeneralId,@EndTime,@Priority,@SigninType,@Status,@Title)", cmdParams);
        }

        public bool Delete(int generalId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            return DBHelper.ExecuteSql("DELETE FROM PE_SigninContent WHERE GeneralId=@GeneralId", cmdParams);
        }

        public SigninContentInfo GetSigninContentByGeneralId(int generalId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT * FROM PE_SigninContent WHERE GeneralId=@GeneralId", cmdParams))
            {
                if (reader.Read())
                {
                    return SigninContentInfoFromDataReader(reader);
                }
                return new SigninContentInfo(true);
            }
        }

        private static SigninContentInfo SigninContentInfoFromDataReader(NullableDataReader dr)
        {
            SigninContentInfo info = new SigninContentInfo();
            info.GeneralId = dr.GetInt32("GeneralId");
            info.EndTime = dr.GetDateTime("EndTime");
            info.Priority = dr.GetInt32("Priority");
            info.SigninType = (SigninType) dr.GetInt32("SigninType");
            info.Status = (SigninStatus) dr.GetInt32("Status");
            info.Title = dr.GetString("Title");
            return info;
        }

        public bool Update(SigninContentInfo signinContentInfo)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, signinContentInfo.GeneralId);
            cmdParams.AddInParameter("@EndTime", DbType.DateTime, signinContentInfo.EndTime);
            cmdParams.AddInParameter("@Priority", DbType.Int32, signinContentInfo.Priority);
            cmdParams.AddInParameter("@SigninType", DbType.Int32, signinContentInfo.SigninType);
            cmdParams.AddInParameter("@Title", DbType.String, signinContentInfo.Title);
            return DBHelper.ExecuteSql("UPDATE PE_SigninContent SET Title=@Title,SigninType=@SigninType,Priority=@Priority,EndTime=@EndTime WHERE GeneralId=@GeneralId", cmdParams);
        }

        public bool UpdateContentSigninType(int generalId, SigninType signinType)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@GeneralId", DbType.Int32, generalId);
            cmdParams.AddInParameter("@SigninType", DbType.Int32, signinType);
            return DBHelper.ExecuteSql("UPDATE PE_CommonModel SET SigninType=@SigninType WHERE GeneralId=@GeneralId", cmdParams);
        }
    }
}