private void InitObjectFromQueryString(string querystr) { string[] _state = querystr.ToString().Split('&'); System.Collections.Specialized.StringDictionary _sd = new System.Collections.Specialized.StringDictionary(); for (int i = 0; i < _state.Length; i++) { if (_state[i].Length == 0) continue; string[] _item = _state[i].Split('='); if (_item.Length > 1) _sd.Add(_item[0], _item[1]); else _sd.Add(_item[0], string.Empty); } if (_sd.ContainsKey("ci") && _sd["ci"].Length > 0) m_Id = int.Parse(_sd["ci"]); if (_sd.ContainsKey("cn")) m_Name = HttpUtility.UrlDecode(_sd["cn"]); if (_sd.ContainsKey("c1") && _sd["c1"].Length > 0) m_Col1 = (BrowseColumn)int.Parse(_sd["c1"]); if (_sd.ContainsKey("c2") && _sd["c2"].Length > 0) m_Col2 = (BrowseColumn)int.Parse(_sd["c2"]); if (_sd.ContainsKey("c3") && _sd["c3"].Length > 0) m_Col3 = (BrowseColumn)int.Parse(_sd["c3"]); if (_sd.ContainsKey("c4") && _sd["c4"].Length > 0) m_Col4 = (BrowseColumn)int.Parse(_sd["c4"]); if (_sd.ContainsKey("c5") && _sd["c5"].Length > 0) m_Col5 = (BrowseColumn)int.Parse(_sd["c5"]); if (_sd.ContainsKey("c6") && _sd["c6"].Length > 0) m_Col6 = (BrowseColumn)int.Parse(_sd["c6"]); if (_sd.ContainsKey("c7") && _sd["c7"].Length > 0) m_Col7 = (BrowseColumn)int.Parse(_sd["c7"]); if (_sd.ContainsKey("c8") && _sd["c8"].Length > 0) m_Col8 = (BrowseColumn)int.Parse(_sd["c8"]); if (_sd.ContainsKey("sc1") && _sd["sc1"].Length > 0) m_SortCol1 = (BrowseColumn)int.Parse(_sd["sc1"]); if (_sd.ContainsKey("sc2") && _sd["sc2"].Length > 0) m_SortCol2 = (BrowseColumn)int.Parse(_sd["sc2"]); if (_sd.ContainsKey("sc3") && _sd["sc3"].Length > 0) m_SortCol3 = (BrowseColumn)int.Parse(_sd["sc3"]); if (_sd.ContainsKey("oc1") && _sd["oc1"] == "1") m_SortOrdDesc1 = true; if (_sd.ContainsKey("oc2") && _sd["oc2"] == "1") m_SortOrdDesc2 = true; if (_sd.ContainsKey("oc3") && _sd["oc3"] == "1") m_SortOrdDesc3 = true; }
public static string GetColumnName(int departmentId, ColumnTypeInfo columnInfo, BrowseColumn columnObject, bool addDelimiter, bool isRealDates) { string result = string.Empty; if (columnObject != Data.Assets.BrowseColumn.Blank) { switch (columnObject) { case BrowseColumn.AssetName: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Assets.Name AS AssetName"; break; case ColumnTypeInfo.Field: result += "AssetName"; break; case ColumnTypeInfo.Header: result += "Asset Name"; break; } break; case BrowseColumn.DateAquired: switch (columnInfo) { case ColumnTypeInfo.Table: if (isRealDates) result += "Assets.DateAquired"; else result += "Convert(nvarchar(50),Assets.DateAquired,120) as DateAquired"; break; case ColumnTypeInfo.Field: result += "DateAquired"; break; case ColumnTypeInfo.Header: result += "Date Acquired"; break; } break; case BrowseColumn.DateDeployed: switch (columnInfo) { case ColumnTypeInfo.Table: if (isRealDates) result += "Assets.DateDeployed"; else result += "Convert(nvarchar(50),Assets.DateDeployed,120) as DateDeployed"; break; case ColumnTypeInfo.Field: result += "DateDeployed"; break; case ColumnTypeInfo.Header: result += "Date Deployed"; break; } break; case BrowseColumn.DateUpdated: switch (columnInfo) { case ColumnTypeInfo.Table: if (isRealDates) result += "Assets.dtUpdated"; else result += "Convert(nvarchar(50),Assets.dtUpdated,120) as dtUpdated"; break; case ColumnTypeInfo.Field: result += "dtUpdated"; break; case ColumnTypeInfo.Header: result += "Date Updated"; break; } break; case BrowseColumn.DateDisposed: switch (columnInfo) { case ColumnTypeInfo.Table: if (isRealDates) result += "Assets.DateDisposed"; else result += "Convert(nvarchar(50),Assets.DateDisposed,120) as DateDisposed"; break; case ColumnTypeInfo.Field: result += "DateDisposed"; break; case ColumnTypeInfo.Header: result += "Date Disposed"; break; } break; case BrowseColumn.DateEntered: switch (columnInfo) { case ColumnTypeInfo.Table: if (isRealDates) result += "Assets.DateEntered"; else result += "Convert(nvarchar(50),Assets.DateEntered,120) as DateEntered"; break; case ColumnTypeInfo.Field: result += "DateEntered"; break; case ColumnTypeInfo.Header: result += "Date Entered"; break; } break; case BrowseColumn.DateOutOfService: switch (columnInfo) { case ColumnTypeInfo.Table: if (isRealDates) result += "Assets.DateOutOfService"; else result += "Convert(nvarchar(50),Assets.DateOutOfService,120) as DateOutOfService"; break; case ColumnTypeInfo.Field: result += "DateOutOfService"; break; case ColumnTypeInfo.Header: result += "Date Out Of Service"; break; } break; case BrowseColumn.DatePurchased: switch (columnInfo) { case ColumnTypeInfo.Table: if (isRealDates) result += "Assets.DatePurchased"; else result += "Convert(nvarchar(50),Assets.DatePurchased,120) as DatePurchased"; break; case ColumnTypeInfo.Field: result += "DatePurchased"; break; case ColumnTypeInfo.Header: result += "Date Purchased"; break; } break; case BrowseColumn.DateReceived: switch (columnInfo) { case ColumnTypeInfo.Table: if (isRealDates) result += "Assets.DateReceived"; else result += "Convert(nvarchar(50),Assets.DateReceived,120) as DateReceived"; break; case ColumnTypeInfo.Field: result += "DateReceived"; break; case ColumnTypeInfo.Header: result += "Date Received"; break; } break; case BrowseColumn.DisposalCost: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Assets.DisposalCost"; break; case ColumnTypeInfo.Field: result += "DisposalCost"; break; case ColumnTypeInfo.Header: result += "Disposal Cost"; break; } break; case BrowseColumn.FundingCode: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Assets.FundingCode"; break; case ColumnTypeInfo.Field: result += "FundingCode"; break; case ColumnTypeInfo.Header: result += "Funding Code"; break; } break; case BrowseColumn.Location: switch (columnInfo) { case ColumnTypeInfo.Table: //result += "Locations.Name as LocationName"; result += "dbo.fxGetUserLocationName(" + departmentId + ", Assets.LocationId) as LocationName"; break; case ColumnTypeInfo.Field: result += "LocationName"; break; case ColumnTypeInfo.Header: result += "Location Name"; break; } break; case BrowseColumn.Owner: switch (columnInfo) { case ColumnTypeInfo.Table: result += "dbo.fxGetUserName(lo_owner.FirstName, lo_owner.LastName, lo_owner.Email) as OwnerName"; break; case ColumnTypeInfo.Field: result += "OwnerName"; break; case ColumnTypeInfo.Header: result += "Owner Name"; break; } break; case BrowseColumn.PONumber: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Assets.PONumber"; break; case ColumnTypeInfo.Field: result += "PONumber"; break; case ColumnTypeInfo.Header: result += "PO Number"; break; } break; case BrowseColumn.ValueCurrent: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Assets.ValueCurrent"; break; case ColumnTypeInfo.Field: result += "ValueCurrent"; break; case ColumnTypeInfo.Header: result += "Value Current"; break; } break; case BrowseColumn.ValueDepreciated: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Assets.ValueDepreciated"; break; case ColumnTypeInfo.Field: result += "ValueDepreciated"; break; case ColumnTypeInfo.Header: result += "Value Depreciated"; break; } break; case BrowseColumn.ValueReplacement: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Assets.ValueReplacement"; break; case ColumnTypeInfo.Field: result += "ValueReplacement"; break; case ColumnTypeInfo.Header: result += "Value Replacement"; break; } break; case BrowseColumn.ValueSalvage: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Assets.ValueSalvage"; break; case ColumnTypeInfo.Field: result += "ValueSalvage"; break; case ColumnTypeInfo.Header: result += "Value Salvage"; break; } break; case BrowseColumn.Vendor: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Vendors.Name as VendorName"; break; case ColumnTypeInfo.Field: result += "VendorName"; break; case ColumnTypeInfo.Header: result += "Vendor Name"; break; } break; case BrowseColumn.WarrantyVendor: switch (columnInfo) { case ColumnTypeInfo.Table: result += "WarrantyVendors.Name as WarrantyVendorName"; break; case ColumnTypeInfo.Field: result += "WarrantyVendorName"; break; case ColumnTypeInfo.Header: result += "Warranty Vendor"; break; } break; case BrowseColumn.SerialNumber: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Assets.SerialNumber as SerialNumber"; break; case ColumnTypeInfo.Field: result += "SerialNumber"; break; case ColumnTypeInfo.Header: result += "Serial Number"; break; } break; case BrowseColumn.Status: switch (columnInfo) { case ColumnTypeInfo.Table: result += "AssetStatus.vchStatus as StatusName"; break; case ColumnTypeInfo.Field: result += "StatusName"; break; case ColumnTypeInfo.Header: result += "Status"; break; } break; case BrowseColumn.CheckedOutTo: switch (columnInfo) { case ColumnTypeInfo.Table: result += "CheckoutName"; break; case ColumnTypeInfo.Field: result += "CheckoutName"; break; case ColumnTypeInfo.Header: result += "CheckOut To"; break; } break; case BrowseColumn.AuditNote: switch (columnInfo) { case ColumnTypeInfo.Table: result += "Assets.AuditNote AS AuditNote"; break; case ColumnTypeInfo.Field: result += "AuditNote"; break; case ColumnTypeInfo.Header: result += "Audit Note"; break; } break; } } if (addDelimiter) { if (result.Length > 0) result = result + ","; } return result; }
protected void RedimColList(int index) { BrowseColumn[] _list = new BrowseColumn[index + 1]; m_Col.CopyTo(_list, 0); for (int i = m_Col.Length; i <= index; i++) _list[i] = BrowseColumn.Blank; m_Col = _list; }
protected void RedimSortColList(int index) { BrowseColumn[] _list = new BrowseColumn[index + 1]; m_SortCol.CopyTo(_list, 0); for (int i = m_SortCol.Length; i <= index; i++) _list[i] = BrowseColumn.Blank; m_SortCol = _list; bool[] _list2 = new bool[index + 1]; m_SortOrder.CopyTo(_list2, 0); m_SortOrder = _list2; }
public int GetSortColumn(BrowseColumn browseColumn) { if (browseColumn == BrowseColumn.Blank) return -1; for (int i = 0; i < m_SortCol.Length; i++) if (m_SortCol[i] == browseColumn) return i; return -1; }
public void SetSortColumn(int index, BrowseColumn col) { if (index >= m_SortCol.Length) RedimSortColList(index); m_SortCol[index] = col; }
public string GetBrowseColCaption(BrowseColumn col) { switch (col) { case BrowseColumn.DateCreated: return "Date Created"; case BrowseColumn.SupportGroup: return "Support Group"; case BrowseColumn.EndUser: return "End User"; case BrowseColumn.SLACompletion: return "SLA Completion"; case BrowseColumn.SLAResponse: return "SLA Response"; default: return col.ToString(); } }
public string GetColSQLName(BrowseColumn col) { int _index = (int)col; if (_index >= 0 && _index < m_SQLColName.Length) return m_SQLColName[_index]; else return string.Empty; }
public bool IsCustomColumn(BrowseColumn col) { int _index = (int)col; if (_index < 8 || _index > 24) return false; else return true; }
public bool IsCustomColOn(BrowseColumn col) { if (!IsCustomColumn(col)) return false; else return m_CustomOn[(int)col - 8]; }
public string GetColSQLName(BrowseColumn col) { return m_SQLColName[(int)col]; }
public string GetColSQLAlias(BrowseColumn col) { return m_SQLColAlias[(int)col]; }
public string GetBrowseColCaption(BrowseColumn col) { switch (col) { case BrowseColumn.LocCity: return "City"; case BrowseColumn.LocState: return "State/Prov"; case BrowseColumn.LocPostalCode: return "Postal Code"; case BrowseColumn.LocCountry: return "Country"; case BrowseColumn.LocTimeZone: return "Time Zone"; case BrowseColumn.LocPhone1: return "Phone1"; case BrowseColumn.LocPhone2: return "Phone2"; case BrowseColumn.OpenTickets: return "Open Tickets"; default: if (!IsCustomColumn(col)) return string.Empty; else return m_CustomCup[(int)col - 8]; } }