Exemple #1
0
        /// <summary>
        /// Get start-end time list
        /// </summary>
        /// <param name="DBline"></param>
        /// <param name="rangeDate"></param>
        /// <param name="assy"></param>
        /// <param name="unit"></param>
        /// <returns></returns>
        private List <DtData> GetDtData(string DBline, List <DateTime> rangeDate, string assy, string unit)
        {
            List <DtData> dtDataRet = new List <DtData>();

            try
            {
                XDocument XMLdoc = XDocument.Load(Application.StartupPath + @"\Parameter\Display.xml");
                //string url = XMLdoc.Descendants("url").FirstOrDefault().Value;
                string url = "";
                switch (DBHelper.DBremark)
                {
                case "kk09":
                    url = XMLdoc.Descendants("urlkk09").FirstOrDefault().Value;
                    break;

                case "kk08":
                    url = XMLdoc.Descendants("urlkk08").FirstOrDefault().Value;
                    break;
                    //case "kk07":
                    //    url = XMLdoc.Descendants("url").FirstOrDefault().Value;
                    //    break;
                }
                string start_time = rangeDate[0].ToString("yyyy-MM-dd HH:mm:ss");
                string end_time   = rangeDate[1].ToString("yyyy-MM-dd HH:mm:ss");

                //// 测试用start
                //string start_time = "2019-07-19 08:00:00";
                //string end_time = "2019-07-19 16:00:00";
                //DBline = "L03";
                //assy = "Final";


                SummaryDataModel summaryDataModel = new SummaryDataModel()
                {
                    line_cd = DBline,
                    assy_cd = assy,
                    unit_cd = unit,
                    start   = start_time,
                    end     = end_time
                };
                string summaryDataModelStr = SerializeObject <SummaryDataModel>(summaryDataModel);
                string res = PostHttp(url, summaryDataModelStr);
                ResObjModel <List <DtData> > resObj = DeserializeJsonToObject <ResObjModel <List <DtData> > >(res);
                foreach (DtData item in resObj.data)
                {
                    dtDataRet.Add(new DtData {
                        start = item.start, end = item.end
                    });
                }
                return(dtDataRet);
            }
            catch (Exception ex)
            {
                string str = LogHelper.GetExceptionMsg(ex, "獲取API數據失敗!");
                LogHelper.WriteErrorLog(str);
                return(dtDataRet);
            }
        }
Exemple #2
0
        /// <summary>
        /// 数据库查询出数据
        /// </summary>
        /// <param name="inputName"></param>
        /// <param name="outputName"></param>
        /// <param name="process_cd"></param>
        /// <param name="DBline"></param>
        /// <param name="dayOrNight"></param>
        /// <param name="nowShifList"></param>
        /// <returns></returns>
        //private DataTable QueryDT(string inputName, string outputName, string[] process_cd, string DBline, List<DateTime> rangeDate)
        //{
        //    string process_cd_in = string.Format("'{0}', '{1}', '{2}'", inputName, outputName, String.Join("','", process_cd));

        //    // 查询数据
        //    //测试用
        //    string sql = string.Format(@"
        //        SELECT AA.proc_uuid, process_at, judge_text,
        //      ROW_NUMBER() OVER (PARTITION BY AA.proc_uuid ORDER BY process_at) AS rid
        //        FROM(
        //         SELECT proc_uuid,process_cd
        //         FROM m_process
        //         WHERE process_cd in('AE-1')
        //         AND line_cd='L03'
        //        )PP
        //        LEFT JOIN t_insp_kk07 AA ON AA.proc_uuid = pp.proc_uuid
        //        WHERE process_at >= '2018-06-30 20:00' and  process_at < '2018-07-01 05:00'
        //    ");

        //    //string sql = string.Format(@"
        //    //    SELECT AA.proc_uuid, process_at, judge_text,
        //    //  ROW_NUMBER() OVER (PARTITION BY AA.proc_uuid ORDER BY process_at) AS rid
        //    //    FROM(
        //    //     SELECT proc_uuid,process_cd
        //    //     FROM m_process
        //    //     WHERE process_cd in({0})
        //    //     AND line_cd='{1}'
        //    //    )PP
        //    //    LEFT JOIN t_insp_{2} AA ON AA.proc_uuid = pp.proc_uuid
        //    //    WHERE process_at >= '{3}' and  process_at < '{4}'
        //    //", process_cd_in, DBline, DBHelper.DBremark, rangeDate[0].ToString("yyyy-MM-dd HH:mm"), rangeDate[1].ToString("yyyy-MM-dd HH:mm"));

        //    DataTable dt = new DataTable();
        //    Console.WriteLine(sql);
        //    new DBHelper().ExecuteDataTable(1, sql, ref dt);
        //    return dt;
        //}

        private DataTable QueryDT(string inputName, string outputName, string[] process_cd, string DBline, List <DateTime> rangeDate, string assy)
        {
            //string start_time = rangeDate[0].ToString("yyyy-MM-dd HH:mm:ss");
            //string end_time = rangeDate[1].ToString("yyyy-MM-dd HH:mm:ss");

            string start_time = "http://10.107.171.57:8000";
            string end_time   = "2019-07-17 17:00:00";

            assy = "TUB";
            SummaryDataModel summaryDataModel = new SummaryDataModel()
            {
                line_cd = DBline,
                assy_cd = assy,
                start   = start_time,
                end     = end_time
            };

            string summaryDataModelStr = SerializeObject <SummaryDataModel>(summaryDataModel);
            string url = "http://10.107.171.57:8000/get_status_data_api";
            string res = PostHttp(url, summaryDataModelStr);
            ResObjModel <List <SummaryDataModel> > resObj = DeserializeJsonToObject <ResObjModel <List <SummaryDataModel> > >(res);
            DataTable dt = new DataTable();

            if (resObj.state)
            {
                dt.Columns.Add("proc_uuid");
                dt.Columns.Add("process_at");
                dt.Columns.Add("judge_text");
                dt.Columns.Add("rid");
                foreach (SummaryDataModel item in resObj.data)
                {
                    DataRow dr = dt.NewRow();
                    dr["line_cd"] = item.line_cd.ToString();
                    dr["assy_cd"] = item.assy_cd.ToString();
                    dr["start"]   = item.start.ToString();
                    dr["end"]     = item.end.ToString();
                    dt.Rows.Add(dr);
                }
                return(dt);
            }
            return(dt);
        }