Exemple #1
0
        public M_Shop_ProOrderList GetModelFromReader(DbDataReader rdr)
        {
            M_Shop_ProOrderList model = new M_Shop_ProOrderList();

            model.ID          = Convert.ToInt32(rdr["ID"]);
            model.OrderListID = ConvertToInt(rdr["OrderListID"]);
            model.ProID       = ConvertToInt(rdr["ProID"]);
            model.ProName     = ConverToStr(rdr["ProName"]);
            model.ProPrice    = ConverToDouble(rdr["ProPrice"]);
            model.Pronum      = ConvertToInt(rdr["Pronum"]);
            model.Pronum_Rece = ConvertToInt(rdr["Pronum_Rece"]);
            model.ProArrive   = ConverToDouble(rdr["ProArrive"]);
            model.Remind      = ConverToStr(rdr["Remind"]);
            model.ZStatus     = ConverToStr(rdr["ZStatus"]);
            model.CDate       = ConvertToDate(rdr["CDate"]);
            model.UserID      = ConvertToInt(rdr["UserID"]);
            model.AllMoney    = ConverToDouble(rdr["AllMoney"]);
            rdr.Close();
            return(model);
        }
Exemple #2
0
        public override SqlParameter[] GetParameters()
        {
            M_Shop_ProOrderList model = this;

            if (model.CDate <= DateTime.MinValue)
            {
                model.CDate = DateTime.Now;
            }
            SqlParameter[] sp = GetSP();
            sp[0].Value  = model.ID;
            sp[1].Value  = model.OrderListID;
            sp[2].Value  = model.ProID;
            sp[3].Value  = model.ProName;
            sp[4].Value  = model.ProPrice;
            sp[5].Value  = model.Pronum;
            sp[6].Value  = model.Pronum_Rece;
            sp[7].Value  = model.ProArrive;
            sp[8].Value  = model.Remind;
            sp[9].Value  = model.ZStatus;
            sp[10].Value = model.CDate;
            sp[11].Value = model.UserID;
            sp[12].Value = model.AllMoney;
            return(sp);
        }