/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.AMS_EnterOutLogStatus GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,SchoolId,EnterOutLogNo,LastEnterOutID,CardNo,SeatNo,ReadingRoomNo,SelectSeatMode,LeaveModel,SelectSeatTime,LeaveSeatTime,SeatTime,ShortLeaveCount,ContinueTimeCount,AllOperationCount,AdminOperationCount,ReaderOperationCount,OtherOperationCount,ServerOperationCount,IsViolation from AMS_EnterOutLogStatus "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; AMS.Model.AMS_EnterOutLogStatus model = new AMS.Model.AMS_EnterOutLogStatus(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["SchoolId"] != null && ds.Tables[0].Rows[0]["SchoolId"].ToString() != "") { model.SchoolId = ds.Tables[0].Rows[0]["SchoolId"].ToString(); } if (ds.Tables[0].Rows[0]["EnterOutLogNo"] != null && ds.Tables[0].Rows[0]["EnterOutLogNo"].ToString() != "") { model.EnterOutLogNo = ds.Tables[0].Rows[0]["EnterOutLogNo"].ToString(); } if (ds.Tables[0].Rows[0]["LastEnterOutID"] != null && ds.Tables[0].Rows[0]["LastEnterOutID"].ToString() != "") { model.LastEnterOutID = int.Parse(ds.Tables[0].Rows[0]["LastEnterOutID"].ToString()); } if (ds.Tables[0].Rows[0]["CardNo"] != null && ds.Tables[0].Rows[0]["CardNo"].ToString() != "") { model.CardNo = ds.Tables[0].Rows[0]["CardNo"].ToString(); } if (ds.Tables[0].Rows[0]["SeatNo"] != null && ds.Tables[0].Rows[0]["SeatNo"].ToString() != "") { model.SeatNo = ds.Tables[0].Rows[0]["SeatNo"].ToString(); } if (ds.Tables[0].Rows[0]["ReadingRoomNo"] != null && ds.Tables[0].Rows[0]["ReadingRoomNo"].ToString() != "") { model.ReadingRoomNo = ds.Tables[0].Rows[0]["ReadingRoomNo"].ToString(); } if (ds.Tables[0].Rows[0]["SelectSeatMode"] != null && ds.Tables[0].Rows[0]["SelectSeatMode"].ToString() != "") { model.SelectSeatMode = int.Parse(ds.Tables[0].Rows[0]["SelectSeatMode"].ToString()); } if (ds.Tables[0].Rows[0]["LeaveModel"] != null && ds.Tables[0].Rows[0]["LeaveModel"].ToString() != "") { model.LeaveModel = int.Parse(ds.Tables[0].Rows[0]["LeaveModel"].ToString()); } if (ds.Tables[0].Rows[0]["SelectSeatTime"] != null && ds.Tables[0].Rows[0]["SelectSeatTime"].ToString() != "") { model.SelectSeatTime = DateTime.Parse(ds.Tables[0].Rows[0]["SelectSeatTime"].ToString()); } if (ds.Tables[0].Rows[0]["LeaveSeatTime"] != null && ds.Tables[0].Rows[0]["LeaveSeatTime"].ToString() != "") { model.LeaveSeatTime = DateTime.Parse(ds.Tables[0].Rows[0]["LeaveSeatTime"].ToString()); } if (ds.Tables[0].Rows[0]["SeatTime"] != null && ds.Tables[0].Rows[0]["SeatTime"].ToString() != "") { model.SeatTime = int.Parse(ds.Tables[0].Rows[0]["SeatTime"].ToString()); } if (ds.Tables[0].Rows[0]["ShortLeaveCount"] != null && ds.Tables[0].Rows[0]["ShortLeaveCount"].ToString() != "") { model.ShortLeaveCount = int.Parse(ds.Tables[0].Rows[0]["ShortLeaveCount"].ToString()); } if (ds.Tables[0].Rows[0]["ContinueTimeCount"] != null && ds.Tables[0].Rows[0]["ContinueTimeCount"].ToString() != "") { model.ContinueTimeCount = int.Parse(ds.Tables[0].Rows[0]["ContinueTimeCount"].ToString()); } if (ds.Tables[0].Rows[0]["AllOperationCount"] != null && ds.Tables[0].Rows[0]["AllOperationCount"].ToString() != "") { model.AllOperationCount = int.Parse(ds.Tables[0].Rows[0]["AllOperationCount"].ToString()); } if (ds.Tables[0].Rows[0]["AdminOperationCount"] != null && ds.Tables[0].Rows[0]["AdminOperationCount"].ToString() != "") { model.AdminOperationCount = int.Parse(ds.Tables[0].Rows[0]["AdminOperationCount"].ToString()); } if (ds.Tables[0].Rows[0]["ReaderOperationCount"] != null && ds.Tables[0].Rows[0]["ReaderOperationCount"].ToString() != "") { model.ReaderOperationCount = int.Parse(ds.Tables[0].Rows[0]["ReaderOperationCount"].ToString()); } if (ds.Tables[0].Rows[0]["OtherOperationCount"] != null && ds.Tables[0].Rows[0]["OtherOperationCount"].ToString() != "") { model.OtherOperationCount = int.Parse(ds.Tables[0].Rows[0]["OtherOperationCount"].ToString()); } if (ds.Tables[0].Rows[0]["ServerOperationCount"] != null && ds.Tables[0].Rows[0]["ServerOperationCount"].ToString() != "") { model.ServerOperationCount = int.Parse(ds.Tables[0].Rows[0]["ServerOperationCount"].ToString()); } if (ds.Tables[0].Rows[0]["IsViolation"] != null && ds.Tables[0].Rows[0]["IsViolation"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsViolation"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsViolation"].ToString().ToLower() == "true")) { model.IsViolation = true; } else { model.IsViolation = false; } } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AMS.Model.AMS_EnterOutLogStatus model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AMS_EnterOutLogStatus("); strSql.Append("SchoolId,EnterOutLogNo,LastEnterOutID,CardNo,SeatNo,ReadingRoomNo,SelectSeatMode,LeaveModel,SelectSeatTime,LeaveSeatTime,SeatTime,ShortLeaveCount,ContinueTimeCount,AllOperationCount,AdminOperationCount,ReaderOperationCount,OtherOperationCount,ServerOperationCount,IsViolation)"); strSql.Append(" values ("); strSql.Append("@SchoolId,@EnterOutLogNo,@LastEnterOutID,@CardNo,@SeatNo,@ReadingRoomNo,@SelectSeatMode,@LeaveModel,@SelectSeatTime,@LeaveSeatTime,@SeatTime,@ShortLeaveCount,@ContinueTimeCount,@AllOperationCount,@AdminOperationCount,@ReaderOperationCount,@OtherOperationCount,@ServerOperationCount,@IsViolation)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SchoolId", SqlDbType.NVarChar, 20), new SqlParameter("@EnterOutLogNo", SqlDbType.NVarChar, 100), new SqlParameter("@LastEnterOutID", SqlDbType.Int, 4), new SqlParameter("@CardNo", SqlDbType.NVarChar, 20), new SqlParameter("@SeatNo", SqlDbType.NVarChar, 100), new SqlParameter("@ReadingRoomNo", SqlDbType.NVarChar, 50), new SqlParameter("@SelectSeatMode", SqlDbType.Int, 4), new SqlParameter("@LeaveModel", SqlDbType.Int, 4), new SqlParameter("@SelectSeatTime", SqlDbType.DateTime), new SqlParameter("@LeaveSeatTime", SqlDbType.DateTime), new SqlParameter("@SeatTime", SqlDbType.Int, 4), new SqlParameter("@ShortLeaveCount", SqlDbType.Int, 4), new SqlParameter("@ContinueTimeCount", SqlDbType.Int, 4), new SqlParameter("@AllOperationCount", SqlDbType.Int, 4), new SqlParameter("@AdminOperationCount", SqlDbType.Int, 4), new SqlParameter("@ReaderOperationCount", SqlDbType.Int, 4), new SqlParameter("@OtherOperationCount", SqlDbType.Int, 4), new SqlParameter("@ServerOperationCount", SqlDbType.Int, 4), new SqlParameter("@IsViolation", SqlDbType.Bit, 1) }; parameters[0].Value = model.SchoolId; parameters[1].Value = model.EnterOutLogNo; parameters[2].Value = model.LastEnterOutID; parameters[3].Value = model.CardNo; parameters[4].Value = model.SeatNo; parameters[5].Value = model.ReadingRoomNo; parameters[6].Value = model.SelectSeatMode; parameters[7].Value = model.LeaveModel; parameters[8].Value = model.SelectSeatTime; parameters[9].Value = model.LeaveSeatTime; parameters[10].Value = model.SeatTime; parameters[11].Value = model.ShortLeaveCount; parameters[12].Value = model.ContinueTimeCount; parameters[13].Value = model.AllOperationCount; parameters[14].Value = model.AdminOperationCount; parameters[15].Value = model.ReaderOperationCount; parameters[16].Value = model.OtherOperationCount; parameters[17].Value = model.ServerOperationCount; parameters[18].Value = model.IsViolation; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AMS.Model.AMS_EnterOutLogStatus model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_EnterOutLogStatus set "); strSql.Append("SchoolId=@SchoolId,"); strSql.Append("EnterOutLogNo=@EnterOutLogNo,"); strSql.Append("LastEnterOutID=@LastEnterOutID,"); strSql.Append("CardNo=@CardNo,"); strSql.Append("SeatNo=@SeatNo,"); strSql.Append("ReadingRoomNo=@ReadingRoomNo,"); strSql.Append("SelectSeatMode=@SelectSeatMode,"); strSql.Append("LeaveModel=@LeaveModel,"); strSql.Append("SelectSeatTime=@SelectSeatTime,"); strSql.Append("LeaveSeatTime=@LeaveSeatTime,"); strSql.Append("SeatTime=@SeatTime,"); strSql.Append("ShortLeaveCount=@ShortLeaveCount,"); strSql.Append("ContinueTimeCount=@ContinueTimeCount,"); strSql.Append("AllOperationCount=@AllOperationCount,"); strSql.Append("AdminOperationCount=@AdminOperationCount,"); strSql.Append("ReaderOperationCount=@ReaderOperationCount,"); strSql.Append("OtherOperationCount=@OtherOperationCount,"); strSql.Append("ServerOperationCount=@ServerOperationCount,"); strSql.Append("IsViolation=@IsViolation"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@SchoolId", SqlDbType.NVarChar, 20), new SqlParameter("@EnterOutLogNo", SqlDbType.NVarChar, 100), new SqlParameter("@LastEnterOutID", SqlDbType.Int, 4), new SqlParameter("@CardNo", SqlDbType.NVarChar, 20), new SqlParameter("@SeatNo", SqlDbType.NVarChar, 100), new SqlParameter("@ReadingRoomNo", SqlDbType.NVarChar, 50), new SqlParameter("@SelectSeatMode", SqlDbType.Int, 4), new SqlParameter("@LeaveModel", SqlDbType.Int, 4), new SqlParameter("@SelectSeatTime", SqlDbType.DateTime), new SqlParameter("@LeaveSeatTime", SqlDbType.DateTime), new SqlParameter("@SeatTime", SqlDbType.Int, 4), new SqlParameter("@ShortLeaveCount", SqlDbType.Int, 4), new SqlParameter("@ContinueTimeCount", SqlDbType.Int, 4), new SqlParameter("@AllOperationCount", SqlDbType.Int, 4), new SqlParameter("@AdminOperationCount", SqlDbType.Int, 4), new SqlParameter("@ReaderOperationCount", SqlDbType.Int, 4), new SqlParameter("@OtherOperationCount", SqlDbType.Int, 4), new SqlParameter("@ServerOperationCount", SqlDbType.Int, 4), new SqlParameter("@IsViolation", SqlDbType.Bit, 1), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.SchoolId; parameters[1].Value = model.EnterOutLogNo; parameters[2].Value = model.LastEnterOutID; parameters[3].Value = model.CardNo; parameters[4].Value = model.SeatNo; parameters[5].Value = model.ReadingRoomNo; parameters[6].Value = model.SelectSeatMode; parameters[7].Value = model.LeaveModel; parameters[8].Value = model.SelectSeatTime; parameters[9].Value = model.LeaveSeatTime; parameters[10].Value = model.SeatTime; parameters[11].Value = model.ShortLeaveCount; parameters[12].Value = model.ContinueTimeCount; parameters[13].Value = model.AllOperationCount; parameters[14].Value = model.AdminOperationCount; parameters[15].Value = model.ReaderOperationCount; parameters[16].Value = model.OtherOperationCount; parameters[17].Value = model.ServerOperationCount; parameters[18].Value = model.IsViolation; parameters[19].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }