WFormSynchronizeData_SMR.git

			@@ -265,6 +265,7 @@
			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;
			@@ -290,6 +291,7 @@
			try
			{

			//获取所有设备数据
			JsonEquipmentData jsonResult =await FindDeviceList(url, token);

			if (jsonResult.code != "0")
			@@ -300,7 +302,7 @@
			else
			{
			string nos = "";
			//获取去设备编码
			//获取设备编码
			for (int i = 0; i < jsonResult.data.Count; i++)
			{
			if (jsonResult.data[i].no == this.cmbEquipFile.SelectedValue.ToString())
			@@ -308,8 +310,11 @@
			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")
			{
			@@ -326,7 +331,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 +346,10 @@
			HUnRightQty = jsonResult.data[i].sum;
			}
			}
			//通过双方讨论最终采纳检验数量=合格+不合格+可疑
			HInSpectQty = HRightQty + HUnKnowQty + HUnRightQty;



			string HNumber = "";
			int HSourceID = 0;
			string HSourceNumber = "";
			@@ -403,9 +410,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 +437,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 +459,7 @@
			HInSpectResult = int.Parse(HInSpectValue.ToString());
			}


			//如果当前结论为合格并且历史结论也是合格则继续保持合格
			if (HInSpectResult == 1 && HLastResult != 0)
			{
			HLastResult = 1;
			@@ -484,7 +497,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;
			@@ -747,6 +760,19 @@
			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;
			JsonResult jsonResult = await EquipResultList(urls, postData, "POST");
			return jsonResult;
			}


			//下拉框绑定数据
			private void bindCbox()
			{
			@@ -781,7 +807,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 +832,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)
			{
			@@ -906,9 +932,10 @@
			}
			//this.timer.Enabled = false;

			//TimeDate = "2024-08-19 19:38:14.540";
			//time = "2024-08-19 19:39:14.540";
			//TimeDate = "2025-02-10 13:10:50";
			//time = "2025-02-10 13:11:50";

			//获取所有设备数据
			JsonEquipmentData jsonResult = await FindDeviceList(Url, token);
			if (jsonResult.code != "0")
			{
			@@ -917,7 +944,7 @@
			else {

			string nos = "";
			//获取去设备编码
			//获取设备编码
			for (int i = 0; i < jsonResult.data.Count; i++)
			{
			nos += jsonResult.data[i].no + ",";
			@@ -931,19 +958,32 @@
			//}
			}
			nos = nos.Substring(0, nos.Length - 1);
			//获取参数获取每个设备对应的所有参数
			JsonEquipmentData jsonEquipment = await FindAllDevicePropsDetailByTimeRange(Url, token, nos, TimeDate, time);

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

			CustomWriteLog("01" , DateTime.Now.ToString("yyyy-MM-dd"));
			//通过每个设备进行循环赋值
			for (int i = 0; i < jsonEquipment.data.Count; i++)
			{
			//获取设备对应的编码判断编码是否满足为螺母压装设备
			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 + "\"},";
			@@ -973,14 +1013,17 @@
			}
			}
			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++)
			@@ -991,15 +1034,23 @@
			}
			}

			var EquipmentStaus = await FindDeviceStatusByNos(Url, token, nos);
			CustomWriteLog("02", 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);

			@@ -1008,6 +1059,22 @@
			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 + "\"},";
			}
			//卷绕注塑浸渍组装的设备运行开关停机时间
			//if (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");

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

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

			// 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 + "\"},";
			//}


			string staus = "";
			switch (EquipmentStaus.data[i].status)
			@@ -1039,8 +1106,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("03", DateTime.Now.ToString("yyyy-MM-dd"));

			JsonData = JsonData.Substring(0, JsonData.Length - 1);
			JsonData += "]}";

			//保存数据
			DataSave(JsonData);
			if (TimeDate != "")
			{
			@@ -1082,6 +1170,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")
			@@ -1107,10 +1197,12 @@

			//this.Time_CLHB.Enabled = false;

			//查询开工的设备信息以及查询当天设备对应的开工时间和完工时间
			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++)
			{
			@@ -1120,12 +1212,14 @@
			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 (ds.Tables[1].Rows.Count > 0)
			{
			{
			//根据当天开工并且完工对应的产量数据生成产量汇报单
			DataTable dt = ds.Tables[1];
			for (int i = 0; i < dt.Rows.Count; i++)
			{
			@@ -1136,6 +1230,7 @@
			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 + "'");
			}
			}
			@@ -1210,6 +1305,48 @@
			{
			//光标选中制单人
			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)
			{
			}
			}
			}

			@@ -1302,8 +1439,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 +1450,5 @@
			public string Id { get; set; }
			public string Name { get; set; }
			}


			}