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