| | |
|---|
| | | using System; |
|---|
| | | using Newtonsoft.Json; |
|---|
| | | using System; |
|---|
| | | using System.Collections.Generic; |
|---|
| | | using System.ComponentModel; |
|---|
| | | using System.Data; |
|---|
| | | using System.Drawing; |
|---|
| | | using System.IO; |
|---|
| | | using System.Linq; |
|---|
| | | using System.Text; |
|---|
| | | using System.Threading.Tasks; |
|---|
| | |
|---|
| | | MessageBox.Show("设å¤é误!"); |
|---|
| | | break; |
|---|
| | | } |
|---|
| | | |
|---|
| | | var sql = @"select top 1 HTechParamName,HResult,HCreateTime from Sb_EquipMentCollectionTechParam_Temp |
|---|
| | | where HSourceCode = '" + HNumber + @"' and HTechParamName = '顶é¨ç¹è¶éé' and HCreateTime in( |
|---|
| | | select max(HCreateTime) from Sb_EquipMentCollectionTechParam_Temp |
|---|
| | | where HSourceCode = '" + HNumber + @"' and HTechParamName = '顶é¨ç¹è¶éé') |
|---|
| | | union |
|---|
| | | select top 1 HTechParamName,HResult,HCreateTime from Sb_EquipMentCollectionTechParam_Temp |
|---|
| | | where HSourceCode = '" + HNumber + @"' and HTechParamName = 'åºé¨ç¹è¶éé' and HCreateTime in( |
|---|
| | | select max(HCreateTime) from Sb_EquipMentCollectionTechParam_Temp |
|---|
| | | where HSourceCode = '" + HNumber + @"' and HTechParamName = 'åºé¨ç¹è¶éé')"; |
|---|
| | | CustomWriteLog("æ¥è¯¢"+ sql, DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | //æ¥è¯¢ 顶é¨ç¹è¶éé å åºé¨ç¹è¶éé å½åæ大çæ°æ® |
|---|
| | | DataSet ds = oCN.RunProcReturn(@"select top 1 HTechParamName,HResult,HCreateTime from Sb_EquipMentCollectionTechParam_Temp |
|---|
| | | where HSourceCode = '" + HNumber + @"' and HTechParamName = '顶é¨ç¹è¶éé' and HCreateTime in( |
|---|
| | |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count > 0) |
|---|
| | | { |
|---|
| | | CustomWriteLog("æ¥è¯¢å°æ°æ®", DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | //æ¥è¯¢ 顶é¨ç¹è¶éé å åºé¨ç¹è¶éé å½åæ大çæ°æ® |
|---|
| | | //è·å 顶é¨ç¹è¶éé å åºé¨ç¹è¶éé |
|---|
| | | for (int i = 0; i < ds.Tables[0].Rows.Count; i++) |
|---|
| | | { |
|---|
| | |
|---|
| | | { |
|---|
| | | string HResult = ds.Tables[0].Rows[i]["HResult"].ToString(); |
|---|
| | | dataTable.Rows[j]["Actual"] = HResult; |
|---|
| | | |
|---|
| | | CustomWriteLog("æ¥è¯¢å°æ°æ®1", DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | switch (HTechParamName) |
|---|
| | | { |
|---|
| | | case "顶é¨ç¹è¶éé": |
|---|
| | |
|---|
| | | MessageBox.Show("设å¤é误!"); |
|---|
| | | break; |
|---|
| | | } |
|---|
| | | |
|---|
| | | CustomWriteLog("æ¥è¯¢å°æ°æ®2" + this.BeforeWeigh.Text + this.AfterWeigh.Text, DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | //switch (HTechParamName) |
|---|
| | | //{ |
|---|
| | | // case "èºçæ£æµæ°æ®": |
|---|
| | |
|---|
| | | dataTable.Columns.Add("HInspectInstruMentID"); |
|---|
| | | dataTable.Columns.Add("HQCCheckItemHName"); |
|---|
| | | |
|---|
| | | |
|---|
| | | var sql = @"select b.HInspectInstruMentID,a.HInterID HQCSchemeID,b.HQCCheckItemID, ch.HNumber HQCCheckItemNumber,ch.HName HQCCheckItemHName,m.HNumber,HUpLimit,HDownLimit,HTargetVal |
|---|
| | | from Sc_ProcessExchangeBillMain pr with(nolock) |
|---|
| | | inner join Gy_QCCheckProjectMain a with(nolock) on pr.HMaterID=a.HMaterID |
|---|
| | | inner join Gy_QCCheckProjectSub b with(nolock) on a.HInterID=b.HInterID |
|---|
| | | inner join Gy_InspectInstruMent men with(nolock) on b.HInspectInstruMentID=men.HItemID and men.HNumber='" + HNumber + @"' |
|---|
| | | left join Gy_Material m with(nolock) on a.HMaterID=m.HItemID |
|---|
| | | left join Gy_QCCheckItem ch with(nolock) on b.HQCCheckItemID=ch.HItemID |
|---|
| | | where pr.HBillNo='" + this.txtLzk.Text + "'"; |
|---|
| | | CustomWriteLog("æ¥è¯¢"+ sql, DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | //ä¿®æ¹æ¯å¨åªä¸ªè®¾å¤ä¸è¿è¡çæ°æ®éé b.HInspectInstruMentID=1 ä¸åæ 1 è½®å»ä»ª2 |
|---|
| | | DataSet dataSet = oCN.RunProcReturn(@"select b.HInspectInstruMentID,a.HInterID HQCSchemeID,b.HQCCheckItemID, ch.HNumber HQCCheckItemNumber,ch.HName HQCCheckItemHName,m.HNumber,HUpLimit,HDownLimit,HTargetVal |
|---|
| | | from Sc_ProcessExchangeBillMain pr with(nolock) |
|---|
| | |
|---|
| | | //å
æ éä¸å¶å人 |
|---|
| | | 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) |
|---|
| | | { |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | } |
|---|
