public static void GetInfor(ref PC_Infor PI)
{
getOutMessage();
PI.OutIp = getOutIp();
PI.Provider = getOutProvider();
PI.Province = getOutProvince();
PI.City = getOutCity();
}
public static void GetInfor(ref PC_Infor PI)
{
PI.MAC = GetMacAddress();
PI.PCName = GetComputerName();
PI.DiskType = GetDiskID();
PI.MemorySize = GetTotalPhysicalMemory();
PI.UserName = GetUserName();
PI.SysType = GetSystemType();
PI.InIp = GetLocalHost();
}
public static void AddRecord(string FileName)
{
PC_Infor PI = new PC_Infor();
string Com;
GetIpInfor.GetInfor(ref PI);
Tools.GetInfor(ref PI);
Tools.JoinRecord(FileName, ref PI);
Com = CreateAddCommand(PI);
MessageBox.Show(Com);
MySql.SqlCommand(Com);
}
public static void JoinRecord(string FileName, ref PC_Infor PI)
{
FileStream fs = new FileStream(FileName, FileMode.Open);
StreamReader m_streamReader = new StreamReader(fs);
m_streamReader.BaseStream.Seek(0, SeekOrigin.Begin); // 从数据流中读取每一行，直到文件的最后一行
string strLine = m_streamReader.ReadToEnd();
m_streamReader.Close();
PI.Record = strLine;
}
public static string CreateAddCommand(PC_Infor PI)
{
try
{
string Com = "insert into PC_Infor (Record,UserName,InIP,SysType,Memory,DateTime,OutIp,Province,PCName,City,Provider,Mac) VALUES(" +
Tools.AddHead(PI.Record) + "," +
Tools.AddHead(PI.UserName) + "," +
Tools.AddHead(PI.InIp) + "," +
Tools.AddHead(PI.SysType) + "," +
Tools.AddHead(PI.MemorySize) + "," +
Tools.AddHead(DateTime.Now.ToString()) + "," +
Tools.AddHead(PI.OutIp) + "," +
Tools.AddHead(PI.Province) + "," +
Tools.AddHead(PI.PCName) + "," +
Tools.AddHead(PI.City) + "," +
Tools.AddHead(PI.Provider) + "," +
Tools.AddHead(PI.MAC) + ")";
return(Com);
}
catch (Exception E) { MessageBox.Show(E.Message); }
return("");
}
