public void Insert(LabMS.Model.VoteJson voteJson) { LabMS.Model.Vote voteInfo = new LabMS.Model.Vote(); voteInfo.VoteTitle = voteJson.Title; voteInfo.VoteStartTime = DateTime.Now; voteInfo.VoteLimit = voteJson.Limit; voteInfo.key = base.Add(voteInfo); // Insert vote foreach (LabMS.Model.VoteItemJson item in voteJson.Items) { LabMS.Model.VoteItem voteItemInfo = new LabMS.Model.VoteItem(); LabMS.BLL.VoteItem voteItem = new LabMS.BLL.VoteItem(); voteItemInfo.VoteID = voteInfo.key; voteItemInfo.VoteItemContent = item.Title; voteItemInfo.key = voteItem.Add(voteItemInfo); // Insert Item foreach (LabMS.Model.VoteAnswerJson answer in item.Answers) { LabMS.Model.VoteAnswer voteAnswerInfo = new LabMS.Model.VoteAnswer(); LabMS.BLL.VoteAnswer voteAnswer = new LabMS.BLL.VoteAnswer(); voteAnswerInfo.VoteItemID = voteItemInfo.key; voteAnswerInfo.VoteAnswerContent = answer.Name; voteAnswer.Add(voteAnswerInfo); // Insert answer } } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public LabMS.Model.VoteItem GetModel(int key) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 key,VoteItemContent,VoteID from VoteItem "); strSql.Append(" where [key]=@key "); SqlParameter[] parameters = { new SqlParameter("@key", SqlDbType.Int,4)}; parameters[0].Value = key; LabMS.Model.VoteItem model=new LabMS.Model.VoteItem(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["key"].ToString()!="") { model.key=int.Parse(ds.Tables[0].Rows[0]["key"].ToString()); } model.VoteItemContent=ds.Tables[0].Rows[0]["VoteItemContent"].ToString(); if(ds.Tables[0].Rows[0]["VoteID"].ToString()!="") { model.VoteID=int.Parse(ds.Tables[0].Rows[0]["VoteID"].ToString()); } return model; } else { return null; } }