Пример #1
0
        public M_Order_Invoice GetModelFromReader(DbDataReader rdr)
        {
            M_Order_Invoice model = new M_Order_Invoice();

            model.ID         = ConvertToInt(rdr["ID"]);
            model.OrderID    = ConvertToInt(rdr["OrderID"]);
            model.InvType    = ConvertToInt(rdr["InvType"]);
            model.InvHead    = ConverToStr(rdr["InvHead"]);
            model.InvContent = ConverToStr(rdr["InvContent"]);
            model.UserCode   = ConverToStr(rdr["UserCode"]);
            model.UserMobile = ConverToStr(rdr["UserMobile"]);
            model.UserEmail  = ConverToStr(rdr["UserEmail"]);
            model.CDate      = ConvertToDate(rdr["CDate"]);
            model.UserID     = ConvertToInt(rdr["UserID"]);
            model.InvClass   = ConverToStr(model.InvClass);
            rdr.Close();
            return(model);
        }
Пример #2
0
        public override SqlParameter[] GetParameters()
        {
            M_Order_Invoice model = this;

            SqlParameter[] sp = GetSP();
            if (model.CDate <= DateTime.MinValue)
            {
                model.CDate = DateTime.Now;
            }
            sp[0].Value  = model.ID;
            sp[1].Value  = model.OrderID;
            sp[2].Value  = model.InvType;
            sp[3].Value  = model.InvHead;
            sp[4].Value  = model.InvContent;
            sp[5].Value  = model.UserCode;
            sp[6].Value  = model.UserMobile;
            sp[7].Value  = model.UserEmail;
            sp[8].Value  = model.CDate;
            sp[9].Value  = model.UserID;
            sp[10].Value = model.InvClass;
            return(sp);
        }