Exemple #1
0
        public override SqlParameter[] GetParameters()//用于插入数据,将模型作为参数传入
        {
            M_DataSource model = this;

            SqlParameter[] sp = GetSP();
            sp[0].Value = model.ID;
            sp[1].Value = model.DSName;
            sp[2].Value = model.Type;
            sp[3].Value = model.ConnectionString;
            sp[4].Value = model.CreateTime;
            sp[5].Value = model.CreateMan;
            sp[6].Value = model.Status;
            sp[7].Value = model.Remind;
            return(sp);
        }
Exemple #2
0
        public M_DataSource GetModelFromReader(DbDataReader rdr)
        {
            M_DataSource model = new M_DataSource();

            model.ID               = Convert.ToInt32(rdr["ID"]);
            model.DSName           = ConverToStr(rdr["DSName"]);
            model.Type             = ConverToStr(rdr["Type"]);
            model.ConnectionString = ConverToStr(rdr["ConnectionString"]);
            model.CreateTime       = ConvertToDate(rdr["CreateTime"]);
            model.CreateMan        = ConverToStr(rdr["CreateMan"]);
            model.Status           = ConverToStr(rdr["Status"]);
            model.Remind           = ConverToStr(rdr["Remind"]);
            rdr.Close();
            rdr.Dispose();
            return(model);
        }