コード例 #1
0
        private void AddItemToINVTransferItemEntity()
        {
            try
            {
                INVTransferItemEntity iNVTransferItemEntity = CurrentINVTransferItemEntity;

                iNVTransferItemEntity.TransferID = INVTransferID;
                iNVTransferItemEntity.ItemID     = Int64.Parse(hdEmpID.Value);

                String fe_StoreUnitID   = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnit.StoreID", CurrentINVTransferEntity.TransferFromStoreID.ToString(), SQLMatchType.Equal);
                String fe_ItemID        = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnitItem.ItemID", iNVTransferItemEntity.ItemID.ToString(), SQLMatchType.Equal);
                String fe_StoreUnitItem = SqlExpressionBuilder.PrepareFilterExpression(fe_StoreUnitID, SQLJoinType.AND, fe_ItemID);
                IList <INVStoreUnitItem_DetailedEntity> lst = FCCINVStoreUnitItem_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_StoreUnitItem);

                if (lst != null && lst.Count > 0)
                {
                    iNVTransferItemEntity.BrandID   = lst[0].BrandID;
                    iNVTransferItemEntity.RegionID  = lst[0].RegionID;
                    iNVTransferItemEntity.CountryID = lst[0].CountryID;
                }

                iNVTransferItemEntity.RequestQty = 0;

                Int64 result = -1;

                result = FCCINVTransferItem.GetFacadeCreate().Add(iNVTransferItemEntity, DatabaseOperationType.Add, TransactionRequired.No);

                BindList();
            }

            catch (Exception ex)
            {
            }
        }
コード例 #2
0
        public IList <INVStoreUnitItem_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression)
        {
            IList <INVStoreUnitItem_DetailedEntity> iNVStoreUnitItem_DetailedEntityList = new List <INVStoreUnitItem_DetailedEntity>();

            try
            {
                if (String.IsNullOrEmpty(sortExpression))
                {
                    sortExpression = "StoreUnitItemID";
                }

                Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1;
                //startRowIndex = Convert.ToInt32(  startRowIndex / pageSize) + 1;

                if (pageSize == -1)
                {
                    pageSize = 1000000000;
                }

                iNVStoreUnitItem_DetailedEntityList = FCCINVStoreUnitItem_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);

                if (iNVStoreUnitItem_DetailedEntityList != null && iNVStoreUnitItem_DetailedEntityList.Count > 0)
                {
                    totalRowCount = iNVStoreUnitItem_DetailedEntityList[0].TotalRowCount;
                }
            }
            catch (Exception ex)
            {
            }

            return(iNVStoreUnitItem_DetailedEntityList ?? new List <INVStoreUnitItem_DetailedEntity>());
        }
コード例 #3
0
        public static IList <INVStoreUnitItem_DetailedEntity> GetAllItemsInStore(Int64 storeID)
        {
            IList <INVStoreUnitItem_DetailedEntity> lst = new List <INVStoreUnitItem_DetailedEntity>();

            try
            {
                String filterExpression = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnit." + INVStoreUnitItem_DetailedEntity.FLD_NAME_INVStoreUnitStoreID, storeID.ToString(), SQLMatchType.Equal);

                lst = FCCINVStoreUnitItem_Detailed.GetFacadeCreate().GetIL(10000000, 1, String.Empty, filterExpression);
            }
            catch (Exception ex)
            {
            }

            return(lst);
        }
コード例 #4
0
    public string[] GetCompletionItemList(string prefixText, int count, string contextKey)
    {
        #region GET ITEM

        Int64 storeUnitID;
        Int64.TryParse(contextKey.ToString(), out storeUnitID);
        List <string> items = new List <string>(count);

        #region Store Unit Item


        String fe       = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnit.StoreID", storeUnitID.ToString(), SQLMatchType.LikeWithSuffixMath);
        String fePrefix = SqlExpressionBuilder.PrepareFilterExpression("MDItem.ItemName", prefixText, SQLMatchType.LikeWithSuffixMath);
        fePrefix = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fePrefix);
        IList <INVStoreUnitItem_DetailedEntity> itemListBySuffix = FCCINVStoreUnitItem_Detailed.GetFacadeCreate().GetIL(1000000, 1, String.Empty, fePrefix);
        String feBothfix = SqlExpressionBuilder.PrepareFilterExpression("MDItem.ItemName", prefixText, SQLMatchType.LikeWithBothMath);
        feBothfix = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, feBothfix);
        IList <INVStoreUnitItem_DetailedEntity> itemListByBoth = FCCINVStoreUnitItem_Detailed.GetFacadeCreate().GetIL(1000000, 1, String.Empty, feBothfix);

        if (itemListBySuffix == null || itemListBySuffix.Count <= 0)
        {
            itemListBySuffix = new List <INVStoreUnitItem_DetailedEntity>();
        }

        if (itemListByBoth == null || itemListByBoth.Count <= 0)
        {
            itemListByBoth = new List <INVStoreUnitItem_DetailedEntity>();
        }

        IList <INVStoreUnitItem_DetailedEntity> tempBOQItemList = itemListByBoth.Except(itemListBySuffix, new INVStoreUnitItemComparer()).ToList();
        IList <INVStoreUnitItem_DetailedEntity> itemList        = new List <INVStoreUnitItem_DetailedEntity>();

        itemList = itemListBySuffix;

        if (tempBOQItemList != null && tempBOQItemList.Count > 0)
        {
            foreach (INVStoreUnitItem_DetailedEntity ent in tempBOQItemList)
            {
                itemList.Add(ent);
            }
        }

        if (itemList != null && itemList.Count > 0)
        {
            foreach (INVStoreUnitItem_DetailedEntity entItem in itemList)
            {
                if (prefixText.Equals(entItem.MDItemItemName))
                {
                    return(new string[0]);
                }

                items.Add(AutoCompleteExtender.CreateAutoCompleteItem(entItem.MDItemItemName.ToString(), entItem.ItemID.ToString()));
            }
        }
        else
        {
            items.Add(AutoCompleteExtender.CreateAutoCompleteItem("No Items Available", "0"));
        }


        #endregion

        //if (projectID > 0 && projectID != MasterDataConstants.Project.DEFAULT_PROJECT)
        //{
        //    String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, projectID.ToString(), SQLMatchType.Equal);
        //    IList<PRMPreBOQEntity> preBOQList = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);

        //    if (preBOQList != null && preBOQList.Count > 0)
        //    {
        //        Int64 preBOQID = preBOQList[0].PreBOQID;

        //        switch (preBOQList[0].IsLocked)
        //        {
        //            case true:
        //                #region GET Item From BOQ

        //                String feBOQSufix1 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQDetail_DetailedCustomEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal);
        //                String feBOQSuffix2 = SqlExpressionBuilder.PrepareFilterExpression("MDItem." + PRMPreBOQDetail_DetailedCustomEntity.FLD_NAME_ItemName, prefixText, SQLMatchType.LikeWithSuffixMath);
        //                String fiterExpressionBysuffix = SqlExpressionBuilder.PrepareFilterExpression(feBOQSufix1, SQLJoinType.AND, feBOQSuffix2);
        //                IList<PRMBOQDetail_DetailedCustomEntity> prmBOQDetailListBySuffix = FCCPRMBOQDetail_DetailedCustom.GetFacadeCreate().GetIL(fiterExpressionBysuffix);

        //                String feBothBOQ = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQDetail_DetailedCustomEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal);
        //                String feBOQBoth = SqlExpressionBuilder.PrepareFilterExpression("MDItem." + MDItemEntity.FLD_NAME_ItemName, prefixText, SQLMatchType.LikeWithBothMath);
        //                String filterExpressionBoth = SqlExpressionBuilder.PrepareFilterExpression(feBothBOQ, SQLJoinType.AND, feBOQBoth);
        //                IList<PRMBOQDetail_DetailedCustomEntity> prmBOQDetailListByBoth = FCCPRMBOQDetail_DetailedCustom.GetFacadeCreate().GetIL(filterExpressionBoth);

        //                if (prmBOQDetailListBySuffix == null || prmBOQDetailListBySuffix.Count <= 0)
        //                {
        //                    prmBOQDetailListBySuffix = new List<PRMBOQDetail_DetailedCustomEntity>();
        //                }

        //                if (prmBOQDetailListByBoth == null || prmBOQDetailListByBoth.Count <= 0)
        //                {
        //                    prmBOQDetailListByBoth = new List<PRMBOQDetail_DetailedCustomEntity>();
        //                }

        //                IList<PRMBOQDetail_DetailedCustomEntity> tempBOQItemList = prmBOQDetailListByBoth.Except(prmBOQDetailListBySuffix, new BOQItemComparer()).ToList();
        //                IList<PRMBOQDetail_DetailedCustomEntity> BOQItemList = new List<PRMBOQDetail_DetailedCustomEntity>();

        //                BOQItemList = prmBOQDetailListBySuffix;

        //                if (tempBOQItemList != null && tempBOQItemList.Count > 0)
        //                {
        //                    foreach (PRMBOQDetail_DetailedCustomEntity ent in tempBOQItemList)
        //                    {
        //                        //If Zero Qty is not need to show or We can manage it From DB
        //                        //if (ent.TotalQty > 0)
        //                        //{
        //                        BOQItemList.Add(ent);
        //                        //}
        //                    }
        //                }

        //                if (BOQItemList != null && BOQItemList.Count > 0)
        //                {
        //                    foreach (PRMBOQDetail_DetailedCustomEntity entItem in BOQItemList)
        //                    {

        //                        if (prefixText.Equals(entItem.ItemName))
        //                        {
        //                            return new string[0];
        //                        }

        //                        items.Add(AutoCompleteExtender.CreateAutoCompleteItem(entItem.ItemName.ToString(), entItem.ItemID.ToString()));
        //                    }
        //                }
        //                else
        //                {
        //                    items.Add(AutoCompleteExtender.CreateAutoCompleteItem("No Items Available", "0"));
        //                }

        //                #endregion
        //                break;

        //            case false:
        //                #region Get Item From Pre-BOQ

        //                String fePreBOQSufix1 = SqlExpressionBuilder.PrepareFilterExpression("PRMPreBOQDetail." + PRMPreBOQDetail_DetailedCustomEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal);
        //                String fePreBOQSufix2 = SqlExpressionBuilder.PrepareFilterExpression("MDItem." + PRMPreBOQDetail_DetailedCustomEntity.FLD_NAME_ItemName, prefixText, SQLMatchType.LikeWithSuffixMath);
        //                String filterExpressionSuffix = SqlExpressionBuilder.PrepareFilterExpression(fePreBOQSufix1, SQLJoinType.AND, fePreBOQSufix2);
        //                IList<PRMPreBOQDetail_DetailedCustomEntity> preBOQDetailListBySuffix = FCCPRMPreBOQDetail_DetailedCustom.GetFacadeCreate().GetIL(filterExpressionSuffix);

        //                String feBothPreBOQ = SqlExpressionBuilder.PrepareFilterExpression("PRMPreBOQDetail." + PRMPreBOQDetail_DetailedCustomEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal);
        //                String feBoth1 = SqlExpressionBuilder.PrepareFilterExpression("MDItem." + MDItemEntity.FLD_NAME_ItemName, prefixText, SQLMatchType.LikeWithBothMath);
        //                String feBoth = SqlExpressionBuilder.PrepareFilterExpression(feBothPreBOQ, SQLJoinType.AND, feBoth1);
        //                IList<PRMPreBOQDetail_DetailedCustomEntity> preBOQDetailListByBoth = FCCPRMPreBOQDetail_DetailedCustom.GetFacadeCreate().GetIL(feBoth);

        //                if (preBOQDetailListBySuffix == null || preBOQDetailListBySuffix.Count <= 0)
        //                {
        //                    preBOQDetailListBySuffix = new List<PRMPreBOQDetail_DetailedCustomEntity>();
        //                }

        //                if (preBOQDetailListByBoth == null || preBOQDetailListByBoth.Count <= 0)
        //                {
        //                    preBOQDetailListByBoth = new List<PRMPreBOQDetail_DetailedCustomEntity>();
        //                }

        //                IList<PRMPreBOQDetail_DetailedCustomEntity> tempPreBOQItemList = preBOQDetailListByBoth.Except(preBOQDetailListBySuffix, new PreBOQItemComparer()).ToList();
        //                IList<PRMPreBOQDetail_DetailedCustomEntity> PreBOQItemList = new List<PRMPreBOQDetail_DetailedCustomEntity>();

        //                PreBOQItemList = preBOQDetailListBySuffix;

        //                if (tempPreBOQItemList != null && tempPreBOQItemList.Count > 0)
        //                {
        //                    foreach (PRMPreBOQDetail_DetailedCustomEntity ent in tempPreBOQItemList)
        //                    {
        //                        //If Zero Qty is not need to show or We can manage it From DB
        //                        //if (ent.TotalQty > 0)
        //                        //{
        //                        PreBOQItemList.Add(ent);
        //                        // }
        //                    }
        //                }

        //                if (PreBOQItemList != null && PreBOQItemList.Count > 0)
        //                {
        //                    foreach (PRMPreBOQDetail_DetailedCustomEntity entItem in PreBOQItemList)
        //                    {

        //                        if (prefixText.Equals(entItem.ItemName))
        //                        {
        //                            return new string[0];
        //                        }

        //                        items.Add(AutoCompleteExtender.CreateAutoCompleteItem(entItem.ItemName.ToString(), entItem.ItemID.ToString()));
        //                    }
        //                }
        //                else
        //                {
        //                    items.Add(AutoCompleteExtender.CreateAutoCompleteItem("No Items Available", "0"));
        //                }

        //                #endregion
        //                break;

        //            default:
        //                break;
        //        }
        //    }

        //    else
        //    {
        //        items.Add(AutoCompleteExtender.CreateAutoCompleteItem("Pre-BOQ Is Not Ready Yet.", "0"));
        //    }
        //}

        #endregion

        return(items.ToArray());
    }