/// <summary>
/// ������ۼ�¼
/// </summary>
/// <param name="json">json</param>
/// <param name="ip">IP</param>
public void Insert(LabMS.Model.VoteRecordJson json)
{
if (json == null)
{
throw new Exception("�����ύ�յļ�¼");
}
ValidateVote(json);
LabMS.Model.VoteRecord voteRecordInfo = new LabMS.Model.VoteRecord();
voteRecordInfo.IP = json.IP;
voteRecordInfo.UserID = json.UserID;
voteRecordInfo.VoteID = json.VoteID;
voteRecordInfo.UserType = json.UserType;
voteRecordInfo.VoteTime = DateTime.Now;
voteRecordInfo.ID = base.Add(voteRecordInfo); // insert vote record
foreach (LabMS.Model.VoteRecordDetailJson detail in json.Details)
{
LabMS.Model.VoteRecordDetail vrdInfo = new LabMS.Model.VoteRecordDetail();
LabMS.BLL.VoteRecordDetail vrd = new LabMS.BLL.VoteRecordDetail();
vrdInfo.VoteAnswerID = detail.VoteAnswerID;
vrdInfo.VoteItemID = detail.VoteItemID;
vrdInfo.VoteRecordID = voteRecordInfo.ID;
vrd.Add(vrdInfo); // Insert detail
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.VoteRecordDetail GetModel(int VoteRecordDetailID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 VoteRecordDetailID,VoteRecordID,VoteItemID,VoteAnswerID from VoteRecordDetail ");
strSql.Append(" where VoteRecordDetailID=@VoteRecordDetailID ");
SqlParameter[] parameters = {
new SqlParameter("@VoteRecordDetailID", SqlDbType.Int,4)};
parameters[0].Value = VoteRecordDetailID;
LabMS.Model.VoteRecordDetail model=new LabMS.Model.VoteRecordDetail();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["VoteRecordDetailID"].ToString()!="")
{
model.VoteRecordDetailID=int.Parse(ds.Tables[0].Rows[0]["VoteRecordDetailID"].ToString());
}
if(ds.Tables[0].Rows[0]["VoteRecordID"].ToString()!="")
{
model.VoteRecordID=int.Parse(ds.Tables[0].Rows[0]["VoteRecordID"].ToString());
}
if(ds.Tables[0].Rows[0]["VoteItemID"].ToString()!="")
{
model.VoteItemID=int.Parse(ds.Tables[0].Rows[0]["VoteItemID"].ToString());
}
if(ds.Tables[0].Rows[0]["VoteAnswerID"].ToString()!="")
{
model.VoteAnswerID=int.Parse(ds.Tables[0].Rows[0]["VoteAnswerID"].ToString());
}
return model;
}
else
{
return null;
}
}
