/// <summary> /// 获得投票信息 /// </summary> /// <param name="wid"></param> /// <param name="id"></param> /// <returns></returns> public Model.wx_vote_base GetVoteBaseByWid(int wid, int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1"); strSql.Append(" * "); strSql.Append(" from wx_vote_base where id=@id and wId=@wId"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@wId", SqlDbType.Int, 4) }; parameters[0].Value = id; parameters[1].Value = wid; SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters); Model.wx_vote_base category = new Model.wx_vote_base(); while (sr.Read()) { category = new Model.wx_vote_base(); category.id = MyCommFun.Obj2Int(sr["id"]); category.title = MyCommFun.ObjToStr(sr["title"]); category.votepic = MyCommFun.ObjToStr(sr["votepic"]); category.picdisplay = MyCommFun.ObjBool(sr["picdisplay"]); category.votecontent = MyCommFun.ObjToStr(sr["votecontent"]); category.isRadio = MyCommFun.ObjBool(sr["isRadio"]); category.beginTime = MyCommFun.Obj2DateTime(sr["beginTime"]); category.endTime = MyCommFun.Obj2DateTime(sr["endTime"]); category.resultShowtype = MyCommFun.Obj2Int(sr["resultShowtype"]); category.actUrl = MyCommFun.ObjToStr(sr["actUrl"]); category.voteType = MyCommFun.Obj2Int(sr["voteType"]); category.sort_id = MyCommFun.Obj2Int(sr["sort_id"]); category.creatDate = MyCommFun.Obj2DateTime(sr["creatDate"]); } sr.Close(); return(category); }