using ClassLibrary1;
|
using Newtonsoft.Json;
|
using System;
|
using System.Collections;
|
using System.Collections.Generic;
|
using System.Diagnostics;
|
using System.IO;
|
using System.Linq;
|
using System.Net;
|
using System.Text;
|
|
namespace DeviceITisation
|
{
|
public class DeviceOnline
|
{
|
public bool AddDevice(out string msg, string test_date, string device_type, string device_name, string device_sn,
|
string device_fw, string location, string user_name, string assets_no, string device_status, string remark = "",
|
string pc_name = "", string pc_ip = "", string pc_mac = "", string bom = "", string odf = "")
|
{
|
try
|
{
|
if (string.IsNullOrEmpty(pc_name))
|
pc_name = SystemInfoHelper.GetComputerName();
|
|
if (string.IsNullOrEmpty(pc_ip))
|
pc_ip = SystemInfoHelper.GetLocalIPAddress();
|
|
if (string.IsNullOrEmpty(pc_mac))
|
pc_mac = SystemInfoHelper.GetFirstMacAddress();
|
|
string[] colsName = new string[]
|
{
|
"bom","odf","test_date","device_type","device_name","device_sn",
|
"device_fw","location","pc_name","pc_ip","pc_mac","user_name",
|
"assets_no","device_status","remark"
|
};
|
|
if (MySqlCommand.CheckRecordExists("device_ol_log", new string[] { "device_sn" }, colsName,
|
bom, odf, test_date, device_type, device_name, device_sn,
|
device_fw, location, pc_name, pc_ip, pc_mac, user_name,
|
assets_no, device_status, remark))
|
{
|
string last_location = MySqlCommand.FindValueFromIndexName("device_ol_log", "device_sn", device_sn, "location");
|
string last_remark = MySqlCommand.FindValueFromIndexName("device_ol_log", "device_sn", device_sn, "remark");
|
string last_date = MySqlCommand.FindValueFromIndexName("device_ol_log", "device_sn", device_sn, "date");
|
|
//if (!string.IsNullOrEmpty(last_remark))
|
//{
|
// if (!string.IsNullOrEmpty(remark))
|
// remark += $"[{last_remark}]";
|
// else
|
// remark += $"{last_remark}";
|
//}
|
|
if (last_location != location)
|
remark += $"[{last_date}位置为{last_location}]";
|
|
if (MySqlCommand.AddRow("device_ol_log", colsName, new string[] { "device_sn" },
|
bom, odf, test_date, device_type, device_name, device_sn,
|
device_fw, location, pc_name, pc_ip, pc_mac, user_name,
|
assets_no, device_status, remark))
|
{
|
Debug.WriteLine($"{device_sn}更新成功");
|
msg = $"{device_sn}更新成功";
|
return true;
|
}
|
else
|
{
|
Debug.WriteLine($"{device_sn}更新失败");
|
msg = $"{device_sn}更新失败";
|
return false;
|
}
|
}
|
else
|
{
|
if (MySqlCommand.AddRow("device_ol_log", colsName, new string[] { "device_sn" },
|
bom, odf, test_date, device_type, device_name, device_sn,
|
device_fw, location, pc_name, pc_ip, pc_mac, user_name,
|
assets_no, device_status, remark))
|
{
|
Debug.WriteLine($"{device_sn}添加成功");
|
msg = $"{device_sn}添加成功";
|
return true;
|
}
|
else
|
{
|
Debug.WriteLine($"{device_sn}添加失败");
|
msg = $"{device_sn}添加失败";
|
return false;
|
}
|
}
|
}
|
catch (Exception e)
|
{
|
Debug.WriteLine($"添加{device_sn}时发生异常:{e.Message}【{e.StackTrace}】");
|
msg = $"添加{device_sn}时发生异常:{e.Message}【{e.StackTrace}】";
|
return false;
|
}
|
}
|
|
public bool AddDeviceBySN(out string msg, string test_date, string device_type, string device_name, string device_sn,
|
string device_fw, string location, string user_name, string assets_no, string device_status, string sn, string remark = "",
|
string pc_name = "", string pc_ip = "", string pc_mac = "")
|
{
|
try
|
{
|
if (string.IsNullOrEmpty(pc_name))
|
pc_name = SystemInfoHelper.GetComputerName();
|
|
if (string.IsNullOrEmpty(pc_ip))
|
pc_ip = SystemInfoHelper.GetLocalIPAddress();
|
|
if (string.IsNullOrEmpty(pc_mac))
|
pc_mac = SystemInfoHelper.GetFirstMacAddress();
|
|
string[] colsName = new string[]
|
{
|
"bom","odf","test_date","device_type","device_name","device_sn",
|
"device_fw","location","pc_name","pc_ip","pc_mac","user_name",
|
"assets_no","device_status","remark"
|
};
|
|
GetBomAndOdf(sn, out string bom, out string odf);
|
|
if (MySqlCommand.CheckRecordExists("device_ol_log", new string[] { "device_sn" }, colsName,
|
bom, odf, test_date, device_type, device_name, device_sn,
|
device_fw, location, pc_name, pc_ip, pc_mac, user_name,
|
assets_no, device_status, remark))
|
{
|
string last_location = MySqlCommand.FindValueFromIndexName("device_ol_log", "device_sn", device_sn, "location");
|
string last_remark = MySqlCommand.FindValueFromIndexName("device_ol_log", "device_sn", device_sn, "remark");
|
string last_date = MySqlCommand.FindValueFromIndexName("device_ol_log", "device_sn", device_sn, "date");
|
|
//if (!string.IsNullOrEmpty(last_remark))
|
//{
|
// if (!string.IsNullOrEmpty(remark))
|
// remark += $"[{last_remark}]";
|
// else
|
// remark += $"{last_remark}";
|
//}
|
|
if (last_location != location)
|
remark += $"[{last_date}位置为{last_location}]";
|
|
if (MySqlCommand.AddRow("device_ol_log", colsName, new string[] { "device_sn" },
|
bom, odf, test_date, device_type, device_name, device_sn,
|
device_fw, location, pc_name, pc_ip, pc_mac, user_name,
|
assets_no, device_status, remark))
|
{
|
Debug.WriteLine($"{device_sn}更新成功");
|
msg = $"{device_sn}更新成功";
|
return true;
|
}
|
else
|
{
|
Debug.WriteLine($"{device_sn}更新失败");
|
msg = $"{device_sn}更新失败";
|
return false;
|
}
|
}
|
else
|
{
|
if (MySqlCommand.AddRow("device_ol_log", colsName, new string[] { "device_sn" },
|
bom, odf, test_date, device_type, device_name, device_sn,
|
device_fw, location, pc_name, pc_ip, pc_mac, user_name,
|
assets_no, device_status, remark))
|
{
|
Debug.WriteLine($"{device_sn}添加成功");
|
msg = $"{device_sn}添加成功";
|
return true;
|
}
|
else
|
{
|
Debug.WriteLine($"{device_sn}添加失败");
|
msg = $"{device_sn}添加失败";
|
return false;
|
}
|
}
|
}
|
catch (Exception e)
|
{
|
Debug.WriteLine($"添加{device_sn}时发生异常:{e.Message}【{e.StackTrace}】");
|
msg = $"添加{device_sn}时发生异常:{e.Message}【{e.StackTrace}】";
|
return false;
|
}
|
}
|
|
public bool GetBomAndOdf(string sn, out string bom, out string odf)
|
{
|
try
|
{
|
bom = string.Empty;
|
odf = string.Empty;
|
string GetTVInfoMessage = ClassLibrary1.Class1.GetTVinfo(sn);
|
if (GetTVInfoMessage != "null")
|
{
|
try
|
{
|
List<GetTVInfo> GetTVInfo1 = JsonConvert.DeserializeObject<List<GetTVInfo>>("[" + GetTVInfoMessage + "]");
|
foreach (GetTVInfo l in GetTVInfo1)
|
{
|
bom = l.ProductCode;
|
odf = l.ODF;
|
}
|
return true;
|
}
|
catch
|
{
|
bom = string.Empty;
|
odf = string.Empty;
|
return false;
|
}
|
}
|
else
|
{
|
try
|
{
|
string sHtml = ClassLibrary1.Class1.PostXml(" http://10.222.16.22:9002/SAPService.asmx?op=GetMaInfo", sn);
|
RootObject5 rb = JsonConvert.DeserializeObject<RootObject5>(sHtml);
|
|
bom = rb.BOM;
|
odf = rb.ODF;
|
return true;
|
}
|
catch
|
{
|
bom = string.Empty;
|
odf = string.Empty;
|
return false;
|
}
|
}
|
|
}
|
catch
|
{
|
bom = string.Empty;
|
odf = string.Empty;
|
return false;
|
}
|
}
|
}
|
}
|
