private void LoadRepeater() { using (AppDataContext db = new AppDataContext()) { if (Session["TagLogFilter"] != null) { tagLogFilter = (NetRadio.LocatingMonitor.Controls.__TagLogFilter)Session["TagLogFilter"]; string tagFilterCondition = tagLogFilter.ConditionDescription; } //过滤条件 //tagLogFilter.SelectedGroupIdArray = new int[1] { (int)_userType }; //20091228 add string strWhere = LocatingMonitorUtils.ConstructSQLWhere(tagLogFilter); strWhere += (strWhere.Trim() == "") ? "IsDisappeared<0" : " AND IsDisappeared<0"; strWhere += " AND hostgroupid= " + ((int)_userType).ToString(); string zSortDir = "desc"; if (_sortDir == SortDirection.Ascending) { zSortDir = ""; } int totalCount = 0; DataSet ds = DBPositionLog.GetPositionLog(strWhere, _zSortKey, zSortDir, p.PageSize, p.PageIndex, out totalCount); p.RecordCount = totalCount; if (ds.Tables.Count != 0) { list.DataSource = ds.Tables[0].DefaultView; list.DataBind(); } } }
private void LoadRepeater() { //---add by tan 2009-10-5---// using (AppDataContext db = new AppDataContext()) { if (Session["TagLogFilter"] != null) { tagLogFilter = (NetRadio.LocatingMonitor.Controls.__TagLogFilter)Session["TagLogFilter"]; string tagFilterCondition = tagLogFilter.ConditionDescription; } string strWhere = LocatingMonitorUtils.ConstructSQLWhere(tagLogFilter); strWhere += (strWhere.Trim() == "") ? "hostgroupid= " + ((int)_userType).ToString() : " AND hostgroupid= " + ((int)_userType).ToString(); //if (strWhere.Trim().Length <= 0) //{ // itotalrecords = db.pNetRadio_AllRecords("view_TagPositionLogView", ref itotalrecords); // p.RecordCount = Convert.ToInt32(itotalrecords); //} string zSortDir = "desc"; if (_sortDir == SortDirection.Ascending) { zSortDir = ""; } //SqlCommand myCommand; //SqlConnection myConnection = (SqlConnection)db.Connection; //myCommand = new SqlCommand("pNetRadio_PageRecords", myConnection); //myCommand.CommandType = CommandType.StoredProcedure; //myCommand.CommandTimeout = 600; //int? itotalrecords = 0; //myCommand.Parameters.Add("@tblName", "DBViewTagPositionLog as A JOIN object_HostGroup as B ON A.hostid=B.hostid and B.hostgroupid= " + (int)_userType + " and " + strWhere); //myCommand.Parameters.Add("@strGetFields", "A.TagId,A.hostid,A.HostName,A.FacilityName,A.CoordinatesName,A.IsDisappeared,A.WriteTime,A.MapId"); //myCommand.Parameters.Add("@fldName", " "+_zSortKey); //myCommand.Parameters.Add("@strWhere", ""); //myCommand.Parameters.Add("@PageSize", p.PageSize); //myCommand.Parameters.Add("@PageIndex", p.PageIndex); //myCommand.Parameters.Add("@Sort", zSortDir); //myCommand.Parameters.Add("@totalRecords", itotalrecords); //SqlDataAdapter adapter = new SqlDataAdapter(); //SqlParameter Par = myCommand.Parameters.AddWithValue("@rowcount", SqlDbType.Int); //Par.Direction = ParameterDirection.Output; //myConnection.Open(); //myCommand.ExecuteNonQuery(); //adapter.SelectCommand = myCommand; //DataSet ds = new DataSet(); //adapter.Fill(ds, "view_TagPositionLogView"); //myConnection.Close(); ////取得过滤后的总记录数 //if (strWhere != "") // p.RecordCount = Int32.Parse(Par.Value.ToString()); int totalCount = 0; DataSet ds = DBPositionLog.GetPositionLog(strWhere, _zSortKey, zSortDir, p.PageSize, p.PageIndex, out totalCount); p.RecordCount = totalCount; if (ds.Tables.Count != 0) { list.DataSource = ds.Tables[0].DefaultView; list.DataBind(); } } /*using (AppDataContext db = new AppDataContext()) { * * var query = db.TagPositionLogViews * .OrderByDescending(x => x.Id) * .Select(x => new TagPositionLogView { * TagId = x.TagId, * TagName = x.TagName, * FacilityId = x.FacilityId, * FacilityName = x.FacilityName, * MapId = x.MapId, * CoordinatesId = x.CoordinatesId, * CoordinatesName = x.CoordinatesName, * WriteTime = x.WriteTime * }); * * query = query.Where(x => x.WriteTime >= tagLogFilter.FromTime); * query = query.Where(x => x.WriteTime < tagLogFilter.ToTime); * * if (tagLogFilter.TagNameKeyword.Length > 0) { * query = query.Where(x => x.TagName.Contains(tagLogFilter.TagNameKeyword)); * } * * if (tagLogFilter.SelectedGroupIdArray != null) { * int[] coveredTagIdArray = TagGroupCoverage.GetCoveredTagIdArray(tagLogFilter.SelectedGroupIdArray); * query = query.Where(x => coveredTagIdArray.Contains(x.TagId)); * } * * if (tagLogFilter.FacilityFilterRowVisible && tagLogFilter.MapId > 0) { * query = query.Where(x => x.MapId == tagLogFilter.MapId); * } * * switch ((TagUserType)Fetch.QueryUrlAsIntegerOrDefault("userType", 1)) { * default: * break; * case TagUserType.Cop: * var arr1 = HostTagGroupStatus.All().Where(u => u.TagId != 0 && u.HostGroupId == (byte)TagUserType.Cop).Select(u => u.TagId).ToArray(); * query = query.Where(x => arr1.Contains(x.TagId)); * break; * case TagUserType.Culprit: * var arr2 = HostTagGroupStatus.All().Where(u => u.TagId != 0 && u.HostGroupId == (byte)TagUserType.Culprit).Select(u => u.TagId).ToArray(); * query = query.Where(x => arr2.Contains(x.TagId)); * break; * } * * p.RecordCount = query.Count(); * query = query.Skip(p.RecordOffset).Take(p.PageSize); * * list.DataSource = query.ToList(); * list.DataBind(); * }*/ }
private void LoadDefaultView() { //tagSelector.SelectedGroupId = -1; string zSortDir = "desc"; if (_sortDir == SortDirection.Ascending) { zSortDir = ""; } string strWhere = ""; if (tagSelector.SelectedUserIds != null && tagSelector.SelectedUserIds.Length > 0) { string hostIds = "("; List <int> lGroupIds = new List <int>(); for (int i = 0; i < tagSelector.SelectedUserIds.Length; i++) { hostIds += tagSelector.SelectedUserIds[i].ToString(); HostTagGroupStatus hostGroup = HostTagGroupStatus.SelectByHostId(tagSelector.SelectedUserIds[i]); if (hostGroup != null && !lGroupIds.Contains(hostGroup.HostGroupId)) { lGroupIds.Add(hostGroup.HostGroupId); } if (i != (tagSelector.SelectedUserIds.Length - 1)) { hostIds += ", "; } } hostIds += ")"; strWhere = "A.HostId in " + hostIds; if (lGroupIds.Count > 0) { string zGroupIds = "("; int j = 0; foreach (int groupId in lGroupIds) { if (j == 0) { zGroupIds += groupId.ToString(); } else { zGroupIds += ", " + groupId.ToString(); } j++; } zGroupIds += ")"; strWhere += " AND HostGroupId in " + zGroupIds; } DateTime dtFrom = DateTime.Parse(fromDate.Text); dtFrom = new DateTime(dtFrom.Year, dtFrom.Month, dtFrom.Day, fromHour.SelectedIndex, fromMinute.SelectedIndex, 0); strWhere += " AND WriteTime >= '" + dtFrom.ToString("M/d/yyyy H:m:s") + "'"; DateTime dtTo = DateTime.Parse(toDate.Text); dtTo = new DateTime(dtTo.Year, dtTo.Month, dtTo.Day, toHour.SelectedIndex, toMinute.SelectedIndex, 59); strWhere += " AND WriteTime <= '" + dtTo.ToString("M/d/yyyy H:m:s") + "'"; int totalCount = 0; DataSet ds = DBPositionLog.GetPositionLog(strWhere, _zSortKey, zSortDir, p.PageSize, p.PageIndex, out totalCount); p.RecordCount = totalCount; if (ds.Tables.Count != 0) { list.DataSource = ds.Tables[0].DefaultView; list.DataBind(); } } }
private void LoadRepeater() { List <string> PatrolList = new List <string>(); //int hostId = Fetch.QueryUrlAsIntegerOrDefault("hostId", 0); //int[] hostIds = tagSelector.SelectedUserIds; string[] hostnames = tagSelector.SelectedTagUsers.Select(_d => _d.UserName).ToArray(); //---add by tan 2009-10-5---// using (AppDataContext db = new AppDataContext()) { PatrolList = db.LocationGroups.Where(t => t.GroupId == (int)PrisonCoordinatesGroup.PatrolCorridor).Select(t => t.LocationId.ToString()).ToList(); if (Session["TagLogFilter"] != null) { //tagLogFilter = (NetRadio.LocatingMonitor.Controls.__TagLogFilter)Session["TagLogFilter"]; //string tagFilterCondition = tagLogFilter.ConditionDescription; } string coordinates = string.Join(",", PatrolList.ToArray()); //string strWhere = ""; //LocatingMonitorUtils.ConstructSQLWhere(tagLogFilter); string strWhere = "hostgroupid= " + ((int)TagUserType.Cop).ToString() + " and CoordinatesId in (" + coordinates + ")"; //if (strWhere.Trim().Length <= 0) //{ // itotalrecords = db.pNetRadio_AllRecords("view_TagPositionLogView", ref itotalrecords); // p.RecordCount = Convert.ToInt32(itotalrecords); //} /*if (hostId > 0) * { * HostTag hostTag = db.HostTags.Where(t => t.HostId == hostId).FirstOrDefault(); * * if (hostTag != null) * { * strWhere += " and HostName='" + hostTag.HostName + "'"; * } * }*/ #region where string __where = ""; foreach (string str in hostnames) { if (__where.Length == 0) { __where += " HostName='" + str + "' "; } else { __where += " or HostName='" + str + "' "; } } if (__where.Length != 0) { strWhere += " and ( " + __where + " )"; } #endregion where end strWhere += " and ( writetime between '" + (fromDate.Text + " " + fromHour.SelectedValue + ":00:00") + "' and '" + (toDate.Text + " " + toHour.SelectedValue + ":59:59") + "' ) "; string zSortDir = "desc"; if (_sortDir == SortDirection.Ascending) { zSortDir = ""; } //SqlCommand myCommand; //SqlConnection myConnection = (SqlConnection)db.Connection; //myCommand = new SqlCommand("pNetRadio_PageRecords", myConnection); //myCommand.CommandType = CommandType.StoredProcedure; //myCommand.CommandTimeout = 600; //int? itotalrecords = 0; //myCommand.Parameters.Add("@tblName", "DBViewTagPositionLog as A JOIN object_HostGroup as B ON A.hostid=B.hostid and B.hostgroupid= " + (int)_userType + " and " + strWhere); //myCommand.Parameters.Add("@strGetFields", "A.TagId,A.hostid,A.HostName,A.FacilityName,A.CoordinatesName,A.IsDisappeared,A.WriteTime,A.MapId"); //myCommand.Parameters.Add("@fldName", " "+_zSortKey); //myCommand.Parameters.Add("@strWhere", ""); //myCommand.Parameters.Add("@PageSize", p.PageSize); //myCommand.Parameters.Add("@PageIndex", p.PageIndex); //myCommand.Parameters.Add("@Sort", zSortDir); //myCommand.Parameters.Add("@totalRecords", itotalrecords); //SqlDataAdapter adapter = new SqlDataAdapter(); //SqlParameter Par = myCommand.Parameters.AddWithValue("@rowcount", SqlDbType.Int); //Par.Direction = ParameterDirection.Output; //myConnection.Open(); //myCommand.ExecuteNonQuery(); //adapter.SelectCommand = myCommand; //DataSet ds = new DataSet(); //adapter.Fill(ds, "view_TagPositionLogView"); //myConnection.Close(); ////取得过滤后的总记录数 //if (strWhere != "") // p.RecordCount = Int32.Parse(Par.Value.ToString()); try { int totalCount = 0; DataSet ds = DBPositionLog.GetPositionLog(strWhere, _zSortKey, zSortDir, p.PageSize, p.PageIndex, out totalCount); p.RecordCount = totalCount; if (ds.Tables.Count != 0) { list.DataSource = ds.Tables[0].DefaultView; list.DataBind(); } } catch (Exception E) { String ll = E.Source + ";" + E.Message; } } /*using (AppDataContext db = new AppDataContext()) { * * var query = db.TagPositionLogViews * .OrderByDescending(x => x.Id) * .Select(x => new TagPositionLogView { * TagId = x.TagId, * TagName = x.TagName, * FacilityId = x.FacilityId, * FacilityName = x.FacilityName, * MapId = x.MapId, * CoordinatesId = x.CoordinatesId, * CoordinatesName = x.CoordinatesName, * WriteTime = x.WriteTime * }); * * query = query.Where(x => x.WriteTime >= tagLogFilter.FromTime); * query = query.Where(x => x.WriteTime < tagLogFilter.ToTime); * * if (tagLogFilter.TagNameKeyword.Length > 0) { * query = query.Where(x => x.TagName.Contains(tagLogFilter.TagNameKeyword)); * } * * if (tagLogFilter.SelectedGroupIdArray != null) { * int[] coveredTagIdArray = TagGroupCoverage.GetCoveredTagIdArray(tagLogFilter.SelectedGroupIdArray); * query = query.Where(x => coveredTagIdArray.Contains(x.TagId)); * } * * if (tagLogFilter.FacilityFilterRowVisible && tagLogFilter.MapId > 0) { * query = query.Where(x => x.MapId == tagLogFilter.MapId); * } * * switch ((TagUserType)Fetch.QueryUrlAsIntegerOrDefault("userType", 1)) { * default: * break; * case TagUserType.Cop: * var arr1 = HostTagGroupStatus.All().Where(u => u.TagId != 0 && u.HostGroupId == (byte)TagUserType.Cop).Select(u => u.TagId).ToArray(); * query = query.Where(x => arr1.Contains(x.TagId)); * break; * case TagUserType.Culprit: * var arr2 = HostTagGroupStatus.All().Where(u => u.TagId != 0 && u.HostGroupId == (byte)TagUserType.Culprit).Select(u => u.TagId).ToArray(); * query = query.Where(x => arr2.Contains(x.TagId)); * break; * } * * p.RecordCount = query.Count(); * query = query.Skip(p.RecordOffset).Take(p.PageSize); * * list.DataSource = query.ToList(); * list.DataBind(); * }*/ }