Beispiel #1
0
        /// <summary>
        /// 取得設備明細檔 RP_Flowchart_Detail_ME_Equipment 清單
        /// </summary>
        /// <param name="search">搜尋條件集合</param>
        /// <param name="page">分頁參數</param>
        /// <returns></returns>
        public PagedListModel <RP_ME_D_Equipment> GetME_D_Equipments(ME_EquipmentSearchVM search, Page page)
        {
            var totalCount      = 0;
            var ME_D_Equipments = rP_Flowchart_MasterRepository.GetME_D_Equipments(search, page, out totalCount);

            return(new PagedListModel <RP_ME_D_Equipment>(totalCount, ME_D_Equipments));
        }
Beispiel #2
0
        public ActionResult GetME_D_Equipments(ME_EquipmentSearchVM search, Page page)
        {
            var apiUrl = string.Format("ProductionResourcePlan/GetME_D_EquipmentsAPI");
            HttpResponseMessage responMessage = APIHelper.APIPostAsync(search, page, apiUrl);
            var result = responMessage.Content.ReadAsStringAsync().Result;

            return(Content(result, "application/json"));
        }
Beispiel #3
0
        /// <summary>
        /// 取得設備明細檔 RP_Flowchart_Detail_ME_Equipment
        /// </summary>
        /// <param name="search">搜尋條件集合</param>
        /// <param name="page">分頁參數</param>
        /// <returns></returns>
        public List <RP_ME_D_Equipment> GetME_D_Equipments(ME_EquipmentSearchVM search, Page page, out int count)
        {
            List <RP_ME_D_Equipment> query = new List <RP_ME_D_Equipment>();
            var RP_Flowchart_Master_UID    = new SqlParameter("@RP_Flowchart_Master_UID", search.RP_Flowchart_Master_UID);
            var Equipment_Type             = new SqlParameter("@Equipment_Type", search.Equipment_Type);

            object[] parameter = new object[] { RP_Flowchart_Master_UID, Equipment_Type };

            using (var context = new SPPContext())
            {
                var sql_str = string.Empty;
                sql_str += @"
--DECLARE @RP_Flowchart_Master_UID int = 33,
--		@Equipment_Type nvarchar(50) = N''
--;
SELECT b.RP_Flowchart_Detail_ME_Equipment_UID,
       a.[Process_Seq],
	   a.[Process_Station],
	   c.Organization_Name as FunPlant_Organization_Name,
	   a.[Process],
	   b.[Equipment_Name],
	   b.Equipment_Spec,
	   b.Equipment_Qty,
	   b.Ratio,
	   b.Request_Qty,
	   b.EQP_Variable_Qty,
	   b.NPI_Current_Qty,
	   b.MP_Current_Qty,
	   a.[Capacity_ByDay],
	   a.[Capacity_ByHour],
	   a.ME_Estimate_Yield,
	   b.Plan_CT
FROM [dbo].[RP_Flowchart_Detail_ME] a
INNER JOIN [dbo].[RP_Flowchart_Detail_ME_Equipment] b ON a.[RP_Flowchart_Detail_ME_UID] = b.[RP_Flowchart_Detail_ME_UID]
INNER JOIN [dbo].[System_Organization] c ON a.[FunPlant_Organization_UID] = c.Organization_UID
WHERE a.[RP_Flowchart_Master_UID] = @RP_Flowchart_Master_UID AND ([Equipment_Type] = @Equipment_Type OR ISNULL(@Equipment_Type,'') = '')

";
                query    = context.Database.SqlQuery <RP_ME_D_Equipment>(sql_str, parameter).ToList();
            }
            count = query.Count();
            return(query.Skip(page.Skip).Take(page.PageSize).ToList());
        }