Esempio n. 1
0
        public M_PlanSql GetModelFromReader(DbDataReader rdr)
        {
            M_PlanSql model = new M_PlanSql();

            model.ID         = Convert.ToInt32(rdr["ID"]);
            model.PlanID     = Convert.ToInt32(rdr["PlanID"]);
            model.txtSql     = rdr["txtSql"].ToString();
            model.CreateTime = Convert.ToDateTime(rdr["CreateTime"]);
            model.statu      = Convert.ToInt32(rdr["statu"]);
            rdr.Close();
            return(model);
        }
Esempio n. 2
0
        public override SqlParameter[] GetParameters()
        {
            M_PlanSql model = this;

            SqlParameter[] sp = GetSP();
            sp[0].Value = model.ID;
            sp[1].Value = model.PlanID;
            sp[2].Value = model.txtSql;
            sp[3].Value = model.CreateTime;
            sp[4].Value = model.statu;
            return(sp);
        }