工序单品过站
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zrg
2025-09-17 e9046aea8de84c7b82167f4c05d82d2702203195 
 WFormSynchronizeData_SMR/EquipmentCollectionForm/EquipmentCollectionForm.cs


@@ -40,10 +40,10 @@


            this.txtHMaker.Text = "请输入用户编码!";




            bindCbox();


          




        }




        private  void btnBegin_Click(object sender, EventArgs e)


        private void btnBegin_Click(object sender, EventArgs e)


        {


            if (this.txtHBathNo.Text == "" || this.txtHBathNo.ReadOnly == false)


            //if (false)


@@ -119,7 +119,7 @@


                                    ",有无螺牙检测结果:" + dt.Rows[i]["DetectionResult"].ToString() +


                                ",时间:" + dt.Rows[i]["HDate"].ToString());


                            }


                           




                        }


                    }


                }


@@ -175,7 +175,8 @@


                    for (int j = 0; j < 2; j++)


                    {


                        DateTime Now = DateTime.Parse(dt2.Rows[i][dt2.Columns[6]].ToString() + " " + dt2.Rows[i][dt2.Columns[7]].ToString());


                        if (Now >= HBegin && Now <= HEnd) {


                        if (Now >= HBegin && Now <= HEnd)


                        {


                            DataRow dr = dt.NewRow();


                            dr["BottomHoleDiameter"] = dt2.Rows[i][dt2.Columns[j]].ToString();


                            dr["TestingData"] = dt2.Rows[i][dt2.Columns[j + 2]].ToString();


@@ -211,16 +212,18 @@


                {


                    MessageBox.Show("请输入制单人信息!");


                }


                else {


                else


                {


                    Get_DisplayBard();


                }


                //this.txtHBathNo.ReadOnly = true;


               




            }


        }




        //查询条码数据


        public void Get_DisplayBard() {


        public void Get_DisplayBard()


        {


            string HBarCode = this.txtHBathNo.Text;


            DataSet ds = oCN.RunProcReturn("select HBatchNo,m.HNumber,a.HMaterID from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID = m.HItemID where HBarCode='" + HBarCode + "'", "Gy_BarCodeBill");




@@ -228,7 +231,8 @@


            {


                MessageBox.Show("条码查无数据!");


            }


            else {


            else


            {


                this.txtHBathNo.Text = ds.Tables[0].Rows[0]["HBatchNo"].ToString();


                this.txtHMaterNumber.Text = ds.Tables[0].Rows[0]["HNumber"].ToString();


                this.HMaterID.Text = ds.Tables[0].Rows[0]["HMaterID"].ToString();


@@ -262,9 +266,11 @@


        {


            DialogResult dr = MessageBox.Show("确认保存?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);




            if (dr == DialogResult.Yes) {


            if (dr == DialogResult.Yes)


            {




                string Url = DBHelper.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "Config/SQLAPI.config", "sUrl");


                //通过接口 获取token


                JsonResult jsonResult = await FindAccessToken(Url);




                string EquipFile = this.cmbEquipFile.Text;


@@ -286,11 +292,13 @@


        }




        //螺母全检保存


        public async void SaveFullInspectionOfNuts(string token,string url) {


        public async void SaveFullInspectionOfNuts(string token, string url)


        {


            try


            {


               


                JsonEquipmentData jsonResult =await FindDeviceList(url, token);




                //获取所有设备数据


                JsonEquipmentData jsonResult = await FindDeviceList(url, token);




                if (jsonResult.code != "0")


                {


@@ -300,7 +308,7 @@


                else


                {


                    string nos = "";


                    //获取去设备编码


                    //获取设备编码


                    for (int i = 0; i < jsonResult.data.Count; i++)


                    {


                        if (jsonResult.data[i].no == this.cmbEquipFile.SelectedValue.ToString())


@@ -308,15 +316,19 @@


                            nos = jsonResult.data[i].no;


                        }


                    }


                    //开始时间


                    string HBegin = this.txtBegin.Text;


                    //结束时间


                    string HEnd = this.txtEnd.Text;


                    //获取不良数，合数数，可疑数 总数


                    jsonResult = await FindDevicePropCalc(url, token, nos, HBegin, HEnd);


                    if (jsonResult.code != "0")


                    {


                        this.btnSave.Enabled = true;


                        MessageBox.Show("数量获取报错:" + jsonResult.message);


                    }


                    else {


                    else


                    {


                        double HInSpectQty = 0;//检验数量


                        double HRightQty = 0;//合格


                        double HUnRightQty = 0;//不合格


@@ -326,7 +338,7 @@


                        {


                            if (jsonResult.data[i].propId == 173)


                            {


                                HInSpectQty = jsonResult.data[i].sum;


                                //HInSpectQty = jsonResult.data[i].sum;


                            }


                            else if (jsonResult.data[i].propId == 469)


                            {


@@ -341,8 +353,10 @@


                                HUnRightQty = jsonResult.data[i].sum;


                            }


                        }


                        //通过双方讨论 最终采纳 检验数量=合格+不合格+可疑


                        HInSpectQty = HRightQty + HUnKnowQty + HUnRightQty;




                      




                        string HNumber = "";


                        int HSourceID = 0;


                        string HSourceNumber = "";


@@ -366,7 +380,8 @@


                            this.btnSave.Enabled = true;


                            MessageBox.Show("生产资源查无数据!");


                        }


                        else {


                        else


                        {




                            HSourceID = int.Parse(dsSouce.Tables[0].Rows[0]["HItemID"].ToString());




@@ -403,9 +418,12 @@


                                        decimal HUpLimit = 0;


                                        decimal HDownLimit = 0;




                                        //分析方法 为定量分析


                                        if (HAnalysisMethod == "2")


                                        {


                                            //获取上限


                                            HUpLimit = decimal.Parse(dataSet.Tables[0].Rows[i]["HTargetVal"].ToString()) + decimal.Parse(dataSet.Tables[0].Rows[i]["HUpLimit"].ToString());


                                            //获取下限


                                            HDownLimit = decimal.Parse(dataSet.Tables[0].Rows[i]["HTargetVal"].ToString()) + decimal.Parse(dataSet.Tables[0].Rows[i]["HDownLimit"].ToString());


                                        }




@@ -427,16 +445,19 @@


                                                    break;


                                            }


                                            //SRM@101.2@VEN00005@CGDD000167@1.02.002.002@20231129@1000


                                            //判断检验项目的代码 跟列名是否一致


                                            if (dataSet.Tables[0].Rows[i]["HQCCheckItemNumber"].ToString().Contains(HQCCheckItemName))


                                            {


                                                for (int k = 0; k < dt.Rows.Count; k++)


                                                {




                                                    //只取时间范围内的数据


                                                    if (DateTime.Parse(dt.Rows[k]["HDate"].ToString()) >= DateTime.Parse(HBegin) && DateTime.Parse(dt.Rows[k]["HDate"].ToString()) <= DateTime.Parse(HEnd))


                                                    {


                                                        //获取检验值


                                                        decimal HInSpectValue = decimal.Parse(dt.Rows[k][dt.Columns[j].ColumnName].ToString());




                                                        //默认值结论为合格


                                                        int HInSpectResult = 1;


                                                        //定量分析 进行判断是否满足上下限


                                                        if (HAnalysisMethod == "2")


                                                        {


                                                            HInSpectResult = (HInSpectValue > HUpLimit || HDownLimit > HInSpectValue) ? 0 : 1;


@@ -446,7 +467,7 @@


                                                            HInSpectResult = int.Parse(HInSpectValue.ToString());


                                                        }






                                                        //如果当前结论为合格 并且历史结论也是合格 则继续保持合格


                                                        if (HInSpectResult == 1 && HLastResult != 0)


                                                        {


                                                            HLastResult = 1;


@@ -484,7 +505,7 @@


                        ",0,0,'',0,'','" + dataSet.Tables[0].Rows[i]["HTargetVal"].ToString() + "'" +


                        ",'" + dataSet.Tables[0].Rows[i]["HUpLimit"].ToString() + "','" + dataSet.Tables[0].Rows[i]["HDownLimit"].ToString() + "','','',0,'" + HAnalysisMethod + "'," + dataSet.Tables[0].Rows[i]["HInspectInstruMentID"].ToString() + ",'" + HLastResult + "'" +


                        ") ");




                                        //如果当前结论为合格 并且历史结论也是合格 则继续保持合格


                                        if (HLastResult == 1 && HLastResults != 0)


                                        {


                                            HLastResults = 1;


@@ -568,13 +589,13 @@


            }


        }




      /// <summary>


      /// 获取设备列表


      /// </summary>


      /// <param name="url"></param>


      /// <param name="postData"></param>


      /// <returns></returns>


        public async Task<JsonEquipmentData> EquipmentList(string url, StringContent postData,string Type)


        /// <summary>


        /// 获取设备列表


        /// </summary>


        /// <param name="url"></param>


        /// <param name="postData"></param>


        /// <returns></returns>


        public async Task<JsonEquipmentData> EquipmentList(string url, StringContent postData, string Type)


        {




            // 创建 HttpClient 实例


@@ -593,8 +614,8 @@


                        // 发起 get 请求


                        response = await client.GetAsync(url);


                    }


                  


                  






                    // 确保请求成功


                    if (response.IsSuccessStatusCode)


                    {


@@ -604,7 +625,7 @@


                    }


                    else


                    {


                        MessageBox.Show($"请求失败，: {response.StatusCode}");


                        MessageBox.Show($"请求失败：{response.StatusCode} - {url} - 当前时间：{DateTime.Now:yyyy-MM-dd HH:mm:ss}");


                    }




                }


@@ -646,7 +667,7 @@


                    }


                    else


                    {


                        MessageBox.Show($"请求失败，: {response.StatusCode}");


                        MessageBox.Show($"请求失败：{response.StatusCode} - {url} - 当前时间：{DateTime.Now:yyyy-MM-dd HH:mm:ss}");


                    }




                }


@@ -675,7 +696,8 @@


        }




        //获取设备列表


        public async Task<JsonEquipmentData> FindDeviceList(string url,string token) {


        public async Task<JsonEquipmentData> FindDeviceList(string url, string token)


        {


            //设备列表接口


            string urls = url + EquipmentType.Two;


            // 准备要发送的表单数据


@@ -685,7 +707,7 @@


        }




        //获取良品、不良品明细


        public async Task<JsonEquipmentData> FindAllDevicePropsDetailByTimeRange(string url, string token,string nos, string HBegin, string HEnd)


        public async Task<JsonEquipmentData> FindAllDevicePropsDetailByTimeRange(string url, string token, string nos, string HBegin, string HEnd)


        {


            string basePropIds = DBHelper.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "Config/SQLAPI.config", "basePropIds");


            basePropIds = "[" + basePropIds + "]";


@@ -694,6 +716,8 @@


            //设备列表接口


            string urls = url + EquipmentType.Nine;




            CustomWriteLog("工艺参数接口：'" + urls + "' 参数值： '" + stringJson + "'", DateTime.Now.ToString("yyyy-MM-dd"));




            // 准备要发送的表单数据


            var postData = new StringContent(stringJson, System.Text.Encoding.UTF8, "application/json");


            JsonEquipmentData jsonEquipment = await EquipmentList(urls, postData, "POST");


@@ -701,11 +725,12 @@


        }




        //获取不良数，合数数，可疑数 总数


        public async Task<JsonEquipmentData> FindDevicePropCalc(string url, string token,string nos,string HBegin,string HEnd)


        public async Task<JsonEquipmentData> FindDevicePropCalc(string url, string token, string nos, string HBegin, string HEnd)


        {


            string stringJson = "{\"token\":\"" + token + "\",\"deviceNo\":\"" + nos + "\",\"propIds\":[606,173,469,470],\"beginTime\":\"" + HBegin + "\",\"endTime\":\"" + HEnd + "\"}";


            var postData = new StringContent(stringJson, System.Text.Encoding.UTF8, "application/json");


            string urls = url + EquipmentType.Seven;


            CustomWriteLog("获取不良数，合数数，可疑数 总数：'" + urls + "' 参数值： '" + stringJson + "'", DateTime.Now.ToString("yyyy-MM-dd"));


            JsonEquipmentData jsonResult = await EquipmentList(urls, postData, "POST");


            return jsonResult;


        }


@@ -719,6 +744,7 @@


            string stringJson = "{\"token\":\"" + token + "\",\"nos\":[" + nos + "]}";


            var postData = new StringContent(stringJson, System.Text.Encoding.UTF8, "application/json");


            string urls = url + EquipmentType.Three;


            CustomWriteLog("设备运行状态：'" + urls + "' 参数值： '" + stringJson + "'", DateTime.Now.ToString("yyyy-MM-dd"));


            JsonEquipmentData jsonResult = await EquipmentList(urls, postData, "POST");


            return jsonResult;


        }


@@ -731,6 +757,7 @@


            string stringJson = "{\"token\":\"" + token + "\",\"nos\":[" + nos + "],\"startTime\":\"" + HBegin + "\",\"endTime\":\"" + HEnd + "\"}";


            var postData = new StringContent(stringJson, System.Text.Encoding.UTF8, "application/json");


            string urls = url + EquipmentType.Four;


            CustomWriteLog("设备时间段产量：'" + urls + "' 参数值： '" + stringJson + "'", DateTime.Now.ToString("yyyy-MM-dd"));


            JsonEquipmentData jsonResult = await EquipmentList(urls, postData, "POST");


            return jsonResult;


        }


@@ -743,15 +770,30 @@


            string stringJson = "{\"token\":\"" + token + "\",\"no\":" + nos + ",\"startTime\":\"" + HBegin + "\",\"endTime\":\"" + HEnd + "\"}";


            var postData = new StringContent(stringJson, System.Text.Encoding.UTF8, "application/json");


            string urls = url + EquipmentType.Five;


            CustomWriteLog("设备运行时间接口：'" + urls + "' 参数值： '" + stringJson + "'", DateTime.Now.ToString("yyyy-MM-dd"));


            JsonResult jsonResult = await EquipResultList(urls, postData, "POST");


            return jsonResult;


        }




        //获取注塑机的 开机


        public async Task<JsonResult> FindDeviceStatusTimeByNosAndOperationMode(string url, string token, string nos, string HBegin, string HEnd)


        {


            nos = nos.Replace(",", "\",\"");


            nos = "\"" + nos + "\"";


            string stringJson = "{\"token\":\"" + token + "\",\"no\":" + nos + ",\"startTime\":\"" + HBegin + "\",\"endTime\":\"" + HEnd + "\"}";


            var postData = new StringContent(stringJson, System.Text.Encoding.UTF8, "application/json");


            string urls = url + EquipmentType.Ten;


            CustomWriteLog("注塑机的 开机接口：'" + urls + "' 参数值： '" + stringJson + "'", DateTime.Now.ToString("yyyy-MM-dd"));


            JsonResult jsonResult = await EquipResultList(urls, postData, "POST");


            return jsonResult;


        }






        //下拉框绑定数据


        private void bindCbox()


        {


            IList<Info> infoList = new List<Info>();


            Info info1 = new Info() { Id = "CMR-QC-SE-001", Name = "螺母全检" }; 


            Info info1 = new Info() { Id = "CMR-QC-SE-001", Name = "螺母全检" };


            Info info2 = new Info() { Id = "CMR-ZZ-SE-001", Name = "螺母压装" };


            Info info3 = new Info() { Id = "ZSJ07", Name = "注塑机#07" };


            //Info info3 = new Info() { Id = "3", Name = "王五" };


@@ -773,7 +815,7 @@


                this.btnLj.Enabled = true;


                this.timer.Enabled = false;


            }


            else 


            else


            {


                this.btnLj.Enabled = false;


                DialogResult dr = MessageBox.Show("是否确认开始采集?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);


@@ -781,7 +823,7 @@


                if (dr == DialogResult.Yes)


                {


                    this.txtHBathNo.ReadOnly = true;


                    this.txtBegin.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");


                    this.txtBegin.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:00");


                    //this.txtBegin.Text = "2024-11-21 13:40:27";


                    this.btnBegin.Enabled = false;


                    this.timer.Enabled = true;


@@ -806,7 +848,7 @@


                    // 添加更多键值对，根据您的需要


                });


            JsonResult jsonResult = await getUrl(urls, formData);


            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");


            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:00");




            if (cmbEquipFile.SelectedIndex == 1)


            {


@@ -821,7 +863,8 @@


        }




        //螺母压装采集数据 保存


        public async void SaveNutPressFit(string Url , string token, string time) {


        public async void SaveNutPressFit(string Url, string token, string time)


        {


            if (TimeDate == "")


            {


                TimeDate = this.txtBegin.Text;


@@ -835,7 +878,7 @@


            }


            else


            {


                 string nos = "";


                string nos = "";


                //获取去设备编码


                for (int i = 0; i < jsonResult.data.Count; i++)


                {


@@ -877,8 +920,8 @@


                    //合格数


                    if (jsonEquipment.data[i].propId == 469)


                    {


                        JsonData += "{\"HDate\":\"" + time + "\",\"HTechParamName\":\"良品数\",\"HResult\":\"OK\",\"HCount\":" + jsonEquipment.data[i].sum + ",\"HSourceCode\":\""+ nos + "\"},";


                    }   


                        JsonData += "{\"HDate\":\"" + time + "\",\"HTechParamName\":\"良品数\",\"HResult\":\"OK\",\"HCount\":" + jsonEquipment.data[i].sum + ",\"HSourceCode\":\"" + nos + "\"},";


                    }


                    //不良数


                    else if (jsonEquipment.data[i].propId == 470)


                    {


@@ -897,27 +940,25 @@


        }




        //注塑机采集数据 保存


        public async void SaveInjectionMoldingMachine(string token, string Url,  string time)


        public async void SaveInjectionMoldingMachine(string token, string Url, string time)


        {


            ListData.Items.Clear();


            if (TimeDate == "")


            {


                TimeDate = this.txtBegin.Text;


            }


            //this.timer.Enabled = false;




            //TimeDate = "2024-08-19 19:38:14.540";


            //time = "2024-08-19 19:39:14.540";




           


            //获取所有设备数据


            JsonEquipmentData jsonResult = await FindDeviceList(Url, token);


            if (jsonResult.code != "0")


            {


                MessageBox.Show("设备列表报错:" + jsonResult.message);


            }


            else {


            else


            {




                string nos = "";


                //获取去设备编码


                //获取设备编码


                for (int i = 0; i < jsonResult.data.Count; i++)


                {


                    nos += jsonResult.data[i].no + ",";


@@ -931,84 +972,151 @@


                    //}


                }


                nos = nos.Substring(0, nos.Length - 1);


                //获取参数 获取每个设备对应的所有参数


                JsonEquipmentData jsonEquipment = await FindAllDevicePropsDetailByTimeRange(Url, token, nos, TimeDate, time);




                var JsonData = "{\"data\":[";




                for (int i = 0; i < jsonEquipment.data.Count; i++)


                if (jsonEquipment == null)


                {


                    if (jsonEquipment.data[i].deviceNo.Contains("CMR-ZZ-SE-"))


                    {


                        for (int j = 0; j < jsonEquipment.data[i].props.Count; j++)


                        {


                            for (int k = 0; k < jsonEquipment.data[i].props[j].datas.Count; k++)


                            {


                                valueData value = JsonConvert.DeserializeObject<valueData>(jsonEquipment.data[i].props[j].datas[k].value);


                                if (value.type == "良品")


                                {


                                    JsonData += "{\"HDate\":\"" + jsonEquipment.data[i].props[j].datas[k].createTime + "\",\"HTechParamName\":\"螺母是否凸出\",\"HResult\":\"OK\",\"HCount\":1,\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                                }


                                else


                                {


                                    JsonData += "{\"HDate\":\"" + jsonEquipment.data[i].props[j].datas[k].createTime + "\",\"HTechParamName\":\"螺母是否凸出\",\"HResult\":\"NG\",\"HCount\":1,\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                                }


                                JsonData += "{\"HDate\":\"" + jsonEquipment.data[i].props[j].datas[k].createTime + "\",\"HTechParamName\":\"生产周期\",\"HResult\":\"" + value.beat + "\",\"HCount\":1,\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                            }


                        }




                        JsonEquipmentData data = await FindDevicePropCalc(Url, token, jsonEquipment.data[i].deviceNo, TimeDate, time);




                        for (int j = 0; j < data.data.Count; j++)


                        {


                            //合格数


                            if (data.data[j].propId == 469)


                            {


                                JsonData += "{\"HDate\":\"" + time + "\",\"HTechParamName\":\"良品数\",\"HResult\":\"OK\",\"HCount\":" + data.data[j].sum + ",\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                            }


                            //不良数


                            else if (data.data[j].propId == 470)


                            {


                                JsonData += "{\"HDate\":\"" + time + "\",\"HTechParamName\":\"NG数量\",\"HResult\":\"NG\",\"HCount\":" + data.data[j].sum + ",\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                            }


                        }


                    }


                    else {


                        for (int j = 0; j < jsonEquipment.data[i].props.Count; j++)


                        {


                            for (int k = 0; k < jsonEquipment.data[i].props[j].datas.Count; k++)


                            {


                                JsonData += "{\"HDate\":\"" + jsonEquipment.data[i].props[j].datas[k].createTime + "\",\"HTechParamName\":\"" + jsonEquipment.data[i].props[j].propName + "\",\"HResult\":\""+ jsonEquipment.data[i].props[j].datas[k].value + "\",\"HCount\":1,\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                            }


                        }




                        JsonEquipmentData data = await FindProdByNosAndTime(Url, token, jsonEquipment.data[i].deviceNo, TimeDate, time);




                        for (int j = 0; j < data.data.Count; j++)


                        {




                            JsonData += "{\"HDate\":\"" + time + "\",\"HTechParamName\":\"生产数量\",\"HResult\":\"OK\",\"HCount\":" + data.data[j].prod + ",\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                        }


                    }


                    CustomWriteLog("jsonEquipment对象为空", DateTime.Now.ToString("yyyy-MM-dd"));


                }




                var  EquipmentStaus = await FindDeviceStatusByNos(Url, token, nos);


                if (jsonEquipment.data == null)


                {


                    CustomWriteLog("jsonEquipment.data属性为空", DateTime.Now.ToString("yyyy-MM-dd"));


                }


                else


                {


                    CustomWriteLog("开始循环工艺参数总数为：：'" + jsonEquipment.data.Count + "'", DateTime.Now.ToString("yyyy-MM-dd"));




                    //通过每个设备进行循环赋值


                    for (int i = 0; i < jsonEquipment.data.Count; i++)


                    {


                        CustomWriteLog("当前循环 第  '" + i + "'  次", DateTime.Now.ToString("yyyy-MM-dd"));


                        //获取设备对应的编码 判断编码是否满足为螺母压装设备


                        if (jsonEquipment.data[i].deviceNo.Contains("CMR-ZZ-SE-"))


                        {


                            //循环 螺母压装设备对应的所有工艺参数


                            for (int j = 0; j < jsonEquipment.data[i].props.Count; j++)


                            {


                                //循环 每个参数对应的所有数据


                                for (int k = 0; k < jsonEquipment.data[i].props[j].datas.Count; k++)


                                {


                                    //日志


                                    CustomWriteLog("1-" + k + ":" + jsonEquipment.data[i].props[j].datas[k].value, DateTime.Now.ToString("yyyy-MM-dd"));




                                    //获取参数的类型


                                    valueData value = JsonConvert.DeserializeObject<valueData>(jsonEquipment.data[i].props[j].datas[k].value);




                                    //日志


                                    CustomWriteLog("2", DateTime.Now.ToString("yyyy-MM-dd"));




                                    if (value.type == "良品")


                                    {


                                        JsonData += "{\"HDate\":\"" + jsonEquipment.data[i].props[j].datas[k].createTime + "\",\"HTechParamName\":\"螺母是否凸出\",\"HResult\":\"OK\",\"HCount\":1,\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                                    }


                                    else


                                    {


                                        JsonData += "{\"HDate\":\"" + jsonEquipment.data[i].props[j].datas[k].createTime + "\",\"HTechParamName\":\"螺母是否凸出\",\"HResult\":\"NG\",\"HCount\":1,\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                                    }


                                    JsonData += "{\"HDate\":\"" + jsonEquipment.data[i].props[j].datas[k].createTime + "\",\"HTechParamName\":\"生产周期\",\"HResult\":\"" + value.beat + "\",\"HCount\":1,\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                                }


                            }




                            JsonEquipmentData data = await FindDevicePropCalc(Url, token, jsonEquipment.data[i].deviceNo, TimeDate, time);




                            for (int j = 0; j < data.data.Count; j++)


                            {


                                //合格数


                                if (data.data[j].propId == 469)


                                {


                                    JsonData += "{\"HDate\":\"" + time + "\",\"HTechParamName\":\"良品数\",\"HResult\":\"OK\",\"HCount\":" + data.data[j].sum + ",\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                                }


                                //不良数


                                else if (data.data[j].propId == 470)


                                {


                                    JsonData += "{\"HDate\":\"" + time + "\",\"HTechParamName\":\"NG数量\",\"HResult\":\"NG\",\"HCount\":" + data.data[j].sum + ",\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                                }


                            }


                        }


                        else


                        {


                            //循环 螺母压装以外的设备对应的所有工艺参数


                            for (int j = 0; j < jsonEquipment.data[i].props.Count; j++)


                            {


                                //循环 每个参数对应的所有数据


                                for (int k = 0; k < jsonEquipment.data[i].props[j].datas.Count; k++)


                                {


                                    JsonData += "{\"HDate\":\"" + jsonEquipment.data[i].props[j].datas[k].createTime + "\",\"HTechParamName\":\"" + jsonEquipment.data[i].props[j].propName + "\",\"HResult\":\"" + jsonEquipment.data[i].props[j].datas[k].value + "\",\"HCount\":1,\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                                    //CustomWriteLog("工艺参数具体值：{\"HDate\":\"" + jsonEquipment.data[i].props[j].datas[k].createTime + "\",\"HTechParamName\":\"" + jsonEquipment.data[i].props[j].propName + "\",\"HResult\":\"" + jsonEquipment.data[i].props[j].datas[k].value + "\",\"HCount\":1,\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"}", DateTime.Now.ToString("yyyy-MM-dd"));


                                }


                            }




                            //获取设备时间段产量


                            JsonEquipmentData data = await FindProdByNosAndTime(Url, token, jsonEquipment.data[i].deviceNo, TimeDate, time);


                            for (int j = 0; j < data.data.Count; j++)


                            {




                                JsonData += "{\"HDate\":\"" + time + "\",\"HTechParamName\":\"生产数量\",\"HResult\":\"OK\",\"HCount\":" + data.data[j].prod + ",\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"},";


                                //CustomWriteLog("设备产量值：{\"HDate\":\"" + time + "\",\"HTechParamName\":\"生产数量\",\"HResult\":\"OK\",\"HCount\":" + data.data[j].prod + ",\"HSourceCode\":\"" + jsonEquipment.data[i].deviceNo + "\"}", DateTime.Now.ToString("yyyy-MM-dd"));


                            }


                        }


                    }




                    CustomWriteLog("工艺参数与产量循环结束", DateTime.Now.ToString("yyyy-MM-dd"));


                }




                CustomWriteLog("1", DateTime.Now.ToString("yyyy-MM-dd"));






                //获取设备运行状态


                var EquipmentStaus = await FindDeviceStatusByNos(Url, token, nos);




                for (int i = 0; i < EquipmentStaus.data.Count; i++)


                {


                    //卷绕的设备运行 开关停机时间


                    if (EquipmentStaus.data[i].no.Contains("CMR-JR-SD-"))


                    //卷绕  注塑  浸渍  组装  的设备运行 开关停机时间


                    if (EquipmentStaus.data[i].no.Contains("CMR-JR-SD-") || EquipmentStaus.data[i].no.Contains("CMR-JZ-SD-") || EquipmentStaus.data[i].no.Contains("CMR-HX-SD-")


                        || EquipmentStaus.data[i].no.Contains("CMR-ZD-SD") || EquipmentStaus.data[i].no.Contains("CMR-ZS-SE-"))


                    {


                        string HBegDate = DateTime.Now.ToString("yyyy-MM-dd 00:00:00");


                        string HEndDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");


                        string HEndDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:00");




                        if (DateTime.Parse(HEndDate).AddMinutes(1).ToString("yyyy-MM-dd") != DateTime.Parse(HEndDate).ToString("yyyy-MM-dd"))


                        {


                            HEndDate = DateTime.Parse(HEndDate).AddMinutes(1).ToString("yyyy-MM-dd HH:mm:00");


                        }




                        JsonResult HEqDate = await FindDeviceStatusTimeByNo(Url, token, EquipmentStaus.data[i].no, HBegDate, HEndDate);


                        if (HEqDate != null && HEqDate.data != null)


                        {




                        JsonData += "{\"HDate\":\"" + HEndDate + "\",\"HTechParamName\":\"开机时长\",\"HResult\":\"" + ((float)(HEqDate.data.onlineTime / 60 / 60)).ToString("0.00") + "\",\"HCount\":1,\"HSourceCode\":\"" + EquipmentStaus.data[i].no + "\"},";


                        JsonData += "{\"HDate\":\"" + HEndDate + "\",\"HTechParamName\":\"关机时长\",\"HResult\":\"" + ((float)(HEqDate.data.offlineTime / 60 / 60)).ToString("0.00") + "\",\"HCount\":1,\"HSourceCode\":\"" + EquipmentStaus.data[i].no + "\"},";


                        JsonData += "{\"HDate\":\"" + HEndDate + "\",\"HTechParamName\":\"停机时长\",\"HResult\":\"" + ((float)(HEqDate.data.standbyTime / 60 / 60)).ToString("0.00") + "\",\"HCount\":1,\"HSourceCode\":\"" + EquipmentStaus.data[i].no + "\"},";


                        JsonData += "{\"HDate\":\"" + HEndDate + "\",\"HTechParamName\":\"运行时长\",\"HResult\":\"" + ((float)(HEqDate.data.runTime / 60 / 60)).ToString("0.00") + "\",\"HCount\":1,\"HSourceCode\":\"" + EquipmentStaus.data[i].no + "\"},";


                            // 记录开机时长


                            CustomWriteLog("设备开机时长: 开机时长" + ((float)(HEqDate.data.onlineTime / 60 / 60)).ToString("0.00") + "  " + EquipmentStaus.data[i].no + "",


                                            DateTime.Now.ToString("yyyy-MM-dd"));




                            // 记录关机时长


                            CustomWriteLog("设备关机时长: 关机时长" + ((float)(HEqDate.data.offlineTime / 60 / 60)).ToString("0.00") + "  " + EquipmentStaus.data[i].no + "",


                                            DateTime.Now.ToString("yyyy-MM-dd"));




                            // 记录停机时长


                            CustomWriteLog("设备停机时长: 停机时长" + ((float)(HEqDate.data.standbyTime / 60 / 60)).ToString("0.00") + "  " + EquipmentStaus.data[i].no + "",


                                            DateTime.Now.ToString("yyyy-MM-dd"));




                            // 记录运行时长


                            CustomWriteLog("设备运行时长: 运行时长" + ((float)(HEqDate.data.runTime / 60 / 60)).ToString("0.00") + "  " + EquipmentStaus.data[i].no + "",


                                            DateTime.Now.ToString("yyyy-MM-dd"));




                            JsonData += "{\"HDate\":\"" + HEndDate + "\",\"HTechParamName\":\"开机时长\",\"HResult\":\"" + ((float)(HEqDate.data.onlineTime / 60 / 60)).ToString("0.00") + "\",\"HCount\":1,\"HSourceCode\":\"" + EquipmentStaus.data[i].no + "\"},";


                            JsonData += "{\"HDate\":\"" + HEndDate + "\",\"HTechParamName\":\"关机时长\",\"HResult\":\"" + ((float)(HEqDate.data.offlineTime / 60 / 60)).ToString("0.00") + "\",\"HCount\":1,\"HSourceCode\":\"" + EquipmentStaus.data[i].no + "\"},";


                            JsonData += "{\"HDate\":\"" + HEndDate + "\",\"HTechParamName\":\"停机时长\",\"HResult\":\"" + ((float)(HEqDate.data.standbyTime / 60 / 60)).ToString("0.00") + "\",\"HCount\":1,\"HSourceCode\":\"" + EquipmentStaus.data[i].no + "\"},";


                            JsonData += "{\"HDate\":\"" + HEndDate + "\",\"HTechParamName\":\"运行时长\",\"HResult\":\"" + ((float)(HEqDate.data.runTime / 60 / 60)).ToString("0.00") + "\",\"HCount\":1,\"HSourceCode\":\"" + EquipmentStaus.data[i].no + "\"},";


                        }


                        else


                        {


                            // 记录运行时长


                            CustomWriteLog("设备开停机时长为空 HEqDate：" + HEqDate + " , HEqDate.data " + HEqDate.data + "", DateTime.Now.ToString("yyyy-MM-dd"));


                        }


                    }




                    string staus = "";


                    switch (EquipmentStaus.data[i].status)


                    {


@@ -1029,7 +1137,11 @@


                            staus = "告警";


                            break;


                    }


                    if (jsonEquipment.data.Count > 0)


                    if (jsonEquipment == null || jsonEquipment.data == null)


                    {


                        JsonData += "{\"HDate\":\"" + time + "\",\"HTechParamName\":\"开关机状态\",\"HResult\":\"" + staus + "\",\"HCount\":0,\"HSourceCode\":\"" + EquipmentStaus.data[i].no + "\"},";


                    }


                    else if (jsonEquipment.data.Count > 0)


                    {


                        JsonData += "{\"HDate\":\"" + time + "\",\"HTechParamName\":\"开关机状态\",\"HResult\":\"" + staus + "\",\"HCount\":1,\"HSourceCode\":\"" + EquipmentStaus.data[i].no + "\"},";


                    }


@@ -1039,8 +1151,29 @@


                    }


                }




                //查询当前开工的设备 获取对应的物料信息


                DataSet datable = oCN.RunProcReturn(@"select m.HNumber,eq.HEquipFileNo from Sc_ICMOBillStatus_Tmp a


                                            inner join Gy_EquipFileBillMain eq on a.HSourceID = eq.HSourceID


                                            inner join Gy_Material m on a.HMaterID = m.HItemID


                                            where a.HICMOStatus = '1' ", "Sc_ICMOBillStatus_Tmp");




                if (datable.Tables[0].Rows.Count > 0)


                {


                    for (int i = 0; i < datable.Tables[0].Rows.Count; i++)


                    {


                        string HSourceCode = datable.Tables[0].Rows[i]["HEquipFileNo"].ToString();


                        string HNumber = datable.Tables[0].Rows[i]["HNumber"].ToString();




                        JsonData += "{\"HDate\":\"" + DateTime.Now.ToString() + "\",\"HTechParamName\":\"物料代码\",\"HResult\":\"" + HNumber + "\",\"HCount\":1,\"HSourceCode\":\"" + HSourceCode + "\"},";


                    }


                }




                CustomWriteLog("结束所有", DateTime.Now.ToString("yyyy-MM-dd"));




                JsonData = JsonData.Substring(0, JsonData.Length - 1);


                JsonData += "]}";




                //保存数据


                DataSave(JsonData);


                if (TimeDate != "")


                {


@@ -1050,20 +1183,18 @@


        }




        //数据保存


        public void DataSave(string JsonData) {


            JsonEquipmentData  data  = JsonConvert.DeserializeObject<JsonEquipmentData>(JsonData);


        public void DataSave(string JsonData)


        {


            JsonEquipmentData data = JsonConvert.DeserializeObject<JsonEquipmentData>(JsonData);




            for (int i = 0; i < data.data.Count; i++)


            {


                oCN.RunProc(@"insert into Sb_EquipMentCollectionTechParam_Temp(HDate,HSourceCode,HTechParamID,HTechParamName,HCount


,HCreateTime,HResult,HProcNumber,HFlag)


values(getdate(),'"+ data.data[i].HSourceCode + "',0,'" + data.data[i].HTechParamName + "'," + data.data[i].HCount


values(getdate(),'" + data.data[i].HSourceCode + "',0,'" + data.data[i].HTechParamName + "'," + data.data[i].HCount


+ ",'" + data.data[i].HDate + "','" + data.data[i].HResult + "','" + data.data[i].HProcNumber + "',0)");




                ListData.Items.Add("时间:" + data.data[i].HDate +


                                  ",工艺参数:" + data.data[i].HTechParamName +


                                  ",工艺参数值:" + data.data[i].HResult);


            }


            ListData.Items.Add($"时间: {DateTime.Now:yyyy-MM-dd HH:mm:ss}，加载成功");


        }




        //定时生成产量汇报单


@@ -1082,6 +1213,8 @@


            JsonResult jsonResult = await getUrl(urls, formData);


            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");


            string token = jsonResult.data.token;




            //获取所有的设备数据


            JsonEquipmentData jsonEquipment = await FindDeviceList(Url, token);




            if (jsonEquipment.code != "0")


@@ -1106,11 +1239,13 @@


                nos = nos.Substring(0, nos.Length - 1);




                //this.Time_CLHB.Enabled = false;




                CustomWriteLog("产量汇报单，设备编码：'" + nos + "'", DateTime.Now.ToString("yyyy-MM-dd"));


                //查询开工的设备信息 以及 查询当天设备对应的开工时间 和完工时间


                DataSet ds = oCN.RunProcReturn("exec h_p_Sc_TimeICMOReporList '" + nos + "'", "h_p_Sc_TimeICMOReporList");


               




                if (ds.Tables[0].Rows.Count > 0)


                {


                    //根据当天只开工没有完工对应的产量数据 生成产量汇报单


                    DataTable dt = ds.Tables[0];


                    for (int i = 0; i < dt.Rows.Count; i++)


                    {


@@ -1119,13 +1254,17 @@


                        string HBegDate = DateTime.Parse(dt.Rows[i]["日期"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");


                        string HEndDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");


                        jsonEquipment = await FindProdByNosAndTime(Url, token, nos, HBegDate, HEndDate);


                        if (decimal.Parse(jsonEquipment.data[0].prod) > 0) {


                            oCN.RunProc("exec h_p_Sc_AddTimeICMORepor " + HICMInterID + "," + jsonEquipment.data[0].prod+",'"+ HEndDate + "'");


                        if (decimal.Parse(jsonEquipment.data[0].prod) > 0)


                        {


                            //生成产量汇报单


                            oCN.RunProc("exec h_p_Sc_AddTimeICMORepor " + HICMInterID + "," + jsonEquipment.data[0].prod + ",'" + HEndDate + "'");


                            CustomWriteLog("生成产量汇报单1：'exec h_p_Sc_AddTimeICMORepor " + HICMInterID + "," + jsonEquipment.data[0].prod + ",'" + HEndDate + "''", DateTime.Now.ToString("yyyy-MM-dd"));


                        }


                    }


                }


                if (ds.Tables[1].Rows.Count > 0)


                {


                    //根据当天开工并且完工对应的产量数据 生成产量汇报单


                    DataTable dt = ds.Tables[1];


                    for (int i = 0; i < dt.Rows.Count; i++)


                    {


@@ -1136,7 +1275,9 @@


                        jsonEquipment = await FindProdByNosAndTime(Url, token, nos, HBegDate, HEndDate);


                        if (decimal.Parse(jsonEquipment.data[0].prod) > 0)


                        {


                            //生成产量汇报单


                            oCN.RunProc("exec h_p_Sc_AddTimeICMORepor " + HICMInterID + "," + jsonEquipment.data[0].prod + ",'" + HEndDate + "'");


                            CustomWriteLog("生成产量汇报单2：'exec h_p_Sc_AddTimeICMORepor " + HICMInterID + "," + jsonEquipment.data[0].prod + ",'" + HEndDate + "''", DateTime.Now.ToString("yyyy-MM-dd"));


                        }


                    }


                }


@@ -1211,10 +1352,53 @@


            //光标选中制单人


            this.txtHMaker.Focus();


        }




        private static readonly object lockObj = new object();


        //写日志


        public static void CustomWriteLog(object obj, string FileName, string filePath = "Vlog", bool isAppend = true)


        {


            try


            {


                lock (lockObj)


                {


                    filePath = $@"{filePath}\{FileName}.txt";




                    filePath = AppDomain.CurrentDomain.BaseDirectory + filePath;




                    if (!System.IO.Directory.Exists(Path.GetDirectoryName(filePath)))


                    {


                        System.IO.Directory.CreateDirectory(Path.GetDirectoryName(filePath));


                    }




                    bool fileExists = System.IO.File.Exists(filePath);


                    //不存在 则创建该文件


                    if (!fileExists)


                    {


                        System.IO.File.Create(filePath).Close();


                    }




                    using (StreamWriter writer = new StreamWriter(filePath, isAppend))


                    {


                        //存在的时候才写一行


                        if (fileExists && isAppend)


                        {


                            writer.WriteLine();


                        }




                        var content = obj is string ? obj : JsonConvert.SerializeObject(obj);


                        writer.WriteLine($"{DateTime.Now} {content}");


                    }


                }


            }


            catch (Exception ex)


            {


            }


        }


    }






    public class JsonResult {


    public class JsonResult


    {


        public string code { get; set; }


        public string message { get; set; }


        public string expirationTime { get; set; }


@@ -1261,7 +1445,7 @@


        public double sum { get; set; }


        public string createTime { get; set; }


        public string happenTime { get; set; }


        public string HDate{ get; set; }


        public string HDate { get; set; }


        public string HTechParamName { get; set; }


        public string HResult { get; set; }


        public string HCount { get; set; }


@@ -1269,7 +1453,8 @@


        public string HProcNumber { get; set; }


    }




    public class propsData {


    public class propsData


    {


        public string propName { get; set; }


        public List<JsonData> datas { get; set; }


        public string basePropId { get; set; }


@@ -1302,8 +1487,8 @@


        public static string Eight = "/api/third/dayDeviceStatusTimeline";


        //良品 不良品 明细 注塑机数据


        public static string Nine = "/api/third/findAllDevicePropsDetailByTimeRange_v1";


        //注塑机数据


        //public static string Ten = "/api/third/findAllDevicePropsDetailByTimeRange";


        //注塑机开机时长 根据 操作模式采集


        public static string Ten = "/api/third/findDeviceStatusTimeByNosAndOperationMode";


        //public static string Eleven = "Monday";


        //public static string Twelve = "Monday";


    }


@@ -1313,5 +1498,5 @@


        public string Id { get; set; }


        public string Name { get; set; }


    }


   




}