/// <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.VoteRecord GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 [ID],VoteID,UserID,IP,VoteTime from VoteRecord,UserType ");
strSql.Append(" where [ID]=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
LabMS.Model.VoteRecord model = new LabMS.Model.VoteRecord();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["VoteID"].ToString() != "")
{
model.VoteID = int.Parse(ds.Tables[0].Rows[0]["VoteID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
model.IP = ds.Tables[0].Rows[0]["IP"].ToString();
if (ds.Tables[0].Rows[0]["VoteTime"].ToString() != "")
{
model.VoteTime = DateTime.Parse(ds.Tables[0].Rows[0]["VoteTime"].ToString());
}
model.UserType = int.Parse(ds.Tables[0].Rows[0]["UserType"].ToString());
return model;
}
else
{
return null;
}
}
