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); }
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); }