Example #1
0
 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;
 }
Example #2
0
        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;
        }
Example #3
0
 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;
 }
Example #4
0
 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;
 }
Example #5
0
            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;
            }
Example #6
0
 public void SetSortColumn(int index, BrowseColumn col)
 {
     if (index >= m_SortCol.Length) RedimSortColList(index);
     m_SortCol[index] = col;
 }
Example #7
0
 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();
     }
 }
Example #8
0
 public string GetColSQLName(BrowseColumn col)
 {
     int _index = (int)col;
     if (_index >= 0 && _index < m_SQLColName.Length) return m_SQLColName[_index];
     else return string.Empty;
 }
Example #9
0
 public bool IsCustomColumn(BrowseColumn col)
 {
     int _index = (int)col;
     if (_index < 8 || _index > 24) return false;
     else return true;
 }
Example #10
0
 public bool IsCustomColOn(BrowseColumn col)
 {
     if (!IsCustomColumn(col)) return false;
     else return m_CustomOn[(int)col - 8];
 }
Example #11
0
 public string GetColSQLName(BrowseColumn col)
 {
     return m_SQLColName[(int)col];
 }
Example #12
0
 public string GetColSQLAlias(BrowseColumn col)
 {
     return m_SQLColAlias[(int)col];
 }
Example #13
0
 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];
     }
 }