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