Esempio n. 1
0
        public override SqlParameter[] GetParameters()
        {
            M_Promotion model = this;

            if (model.StartTime == DateTime.MinValue)
            {
                model.StartTime = DateTime.Now;
            }
            if (model.EndTime == DateTime.MinValue)
            {
                model.EndTime = DateTime.Now;
            }
            if (model.CreateTime == DateTime.MinValue)
            {
                model.CreateTime = DateTime.Now;
            }
            SqlParameter[] sp = GetSP();
            sp[0].Value  = model.ID;
            sp[1].Value  = model.UserID;
            sp[2].Value  = model.PromoName;
            sp[3].Value  = model.StartTime;
            sp[4].Value  = model.EndTime;
            sp[5].Value  = model.MoneyUL;
            sp[6].Value  = model.MoneyLL;
            sp[7].Value  = model.ProIds;
            sp[8].Value  = model.UserGroup;
            sp[9].Value  = model.ZType;
            sp[10].Value = model.CreateTime;
            return(sp);
        }
Esempio n. 2
0
        public M_Promotion GetModelFromReader(DbDataReader rdr)
        {
            M_Promotion model = new M_Promotion();

            model.ID        = Convert.ToInt32(rdr["ID"]);
            model.UserID    = ConvertToInt(rdr["UserID"]);
            model.PromoName = ConverToStr(rdr["PromoName"]);
            model.StartTime = ConvertToDate(rdr["StartTime"]);
            model.EndTime   = ConvertToDate(rdr["EndTime"]);
            model.MoneyUL   = ConverToDouble(rdr["MoneyUL"]);
            model.MoneyLL   = ConverToDouble(rdr["MoneyLL"]);
            model.ProIds    = ConverToStr(rdr["ProIds"]);
            model.UserGroup = ConverToStr(rdr["UserGroup"]);
            model.ZType     = ConvertToInt(rdr["ZType"]);
            rdr.Close();
            return(model);
        }