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