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