コード例 #1
0
ファイル: M_Stock.cs プロジェクト: baixue001/IPS
        public M_Stock GetModelFromReader(DbDataReader rdr)
        {
            M_Stock model = new M_Stock();

            model.id        = Convert.ToInt32(rdr["id"]);
            model.stocktype = ConvertToInt(rdr["stocktype"]);
            model.danju     = ConverToStr(rdr["danju"]);
            model.proname   = ConverToStr(rdr["proname"]);
            model.addtime   = ConvertToDate(rdr["addtime"]);
            model.adduser   = ConverToStr(rdr["adduser"]);
            model.content   = ConverToStr(rdr["content"]);
            model.proid     = ConvertToInt(rdr["proid"]);
            model.Pronum    = ConvertToInt(rdr["pronum"]);
            model.UserID    = ConvertToInt(rdr["UserID"]);
            model.AdminID   = ConvertToInt(rdr["AdminID"]);
            model.StoreID   = ConvertToInt(rdr["StoreID"]);
            rdr.Close();
            rdr.Dispose();
            return(model);
        }
コード例 #2
0
ファイル: M_Stock.cs プロジェクト: baixue001/IPS
        public override SqlParameter[] GetParameters()
        {
            M_Stock model = this;

            if (model.addtime <= DateTime.MinValue)
            {
                model.addtime = DateTime.Now;
            }
            SqlParameter[] sp = GetSP();
            sp[0].Value  = model.id;
            sp[1].Value  = model.stocktype;
            sp[2].Value  = model.danju;
            sp[3].Value  = model.proname;
            sp[4].Value  = model.addtime;
            sp[5].Value  = model.adduser;
            sp[6].Value  = model.content;
            sp[7].Value  = model.proid;
            sp[8].Value  = model.Pronum;
            sp[9].Value  = model.UserID;
            sp[10].Value = model.AdminID;
            sp[11].Value = model.StoreID;
            return(sp);
        }