/// <summary> /// 得到一个对象实体 /// </summary> public WeiXinPF.Model.wx_qp_base GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,wid,bName,actBegin,actEnd,yyRemark,qpRemark,maxPersonNum,cyPersonNum,isSnSendsms,yyQPBeginDate,yyQPEndDate,yyGouPiaoBeginDate,yyGouPiaoEndDate,remark,createDate,sort_id,beginPic,haibaoPic from wx_qp_base "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; WeiXinPF.Model.wx_qp_base model = new WeiXinPF.Model.wx_qp_base(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model = DataRowToModel(ds.Tables[0].Rows[0]); DAL.wx_qp_img imgDal = new wx_qp_img(); IList <Model.wx_qp_img> imglist = imgDal.GetModelList("bId=" + id + " and itype=2"); if (imglist != null) { model.yingyuanlist = (from a in imglist where a.iType == 2 select a).ToArray <Model.wx_qp_img>(); } return(model); } else { return(null); } }