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