/// <summary>
/// 修改采集设备信息
/// </summary>
/// <param name="mac"></param>
/// <returns></returns>
public int UpdateMacFById(MacInfo mac)
{
string sql = "UPDATE Fench_DevInfo SET NETBAR_WACODE = (SELECT nbi.NETBAR_WACODE FROM Fench_NetBarInfo nbi WHERE nbi.ID=@NETBAR_ID),COLLECTION_EQUIPMENT_NAME = @COLLECTION_EQUIPMENT_NAME,COLLECTION_EQUIPMENT_ADDRESS = @COLLECTION_EQUIPMENT_ADDRESS,COLLECTION_EQUIPMENT_TYPE = @COLLECTION_EQUIPMENT_TYPE,SECURITY_SOFTWARE_ORGCODE = @SECURITY_SOFTWARE_ORGCODE,COLLECTION_EQUIPMENT_LONGITUDE = @COLLECTION_EQUIPMENT_LONGITUDE,COLLECTION_EQUIPMENT_LATITUDE = @COLLECTION_EQUIPMENT_LATITUDE,UPLOAD_TIME_INTERVAL = @UPLOAD_TIME_INTERVAL,COLLECTION_RADIUS = @COLLECTION_RADIUS,VEHICLE_CODE = @VEHICLE_CODE,SUBWAY_LINE_INFO = @SUBWAY_LINE_INFO,SUBWAY_VEHICLE_INFO = @SUBWAY_VEHICLE_INFO,SUBWAY_COMPARTMENT_NUMBER = @SUBWAY_COMPARTMENT_NUMBER,NETBAR_ID = @NETBAR_ID,Verified = 1,IsTrial = @IsTrial,supplier = @supplier,ProjectType = @ProjectType,CasesType = @CasesType,ModeType = @ModeType,LogCapture = @LogCapture WHERE ID=@ID";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@NETBAR_ID", mac.NETBAR_ID),
new SqlParameter("@COLLECTION_EQUIPMENT_NAME", mac.COLLECTION_EQUIPMENT_NAME),
new SqlParameter("@COLLECTION_EQUIPMENT_ADDRESS", mac.COLLECTION_EQUIPMENT_ADDRESS),
new SqlParameter("@COLLECTION_EQUIPMENT_TYPE", mac.COLLECTION_EQUIPMENT_TYPE),
new SqlParameter("@SECURITY_SOFTWARE_ORGCODE", mac.SECURITY_SOFTWARE_ORGCODE),
new SqlParameter("@COLLECTION_EQUIPMENT_LONGITUDE", mac.COLLECTION_EQUIPMENT_LONGITUDE),
new SqlParameter("@COLLECTION_EQUIPMENT_LATITUDE", mac.COLLECTION_EQUIPMENT_LATITUDE),
new SqlParameter("@UPLOAD_TIME_INTERVAL", mac.UPLOAD_TIME_INTERVAL),
new SqlParameter("@COLLECTION_RADIUS", mac.COLLECTION_RADIUS),
new SqlParameter("@VEHICLE_CODE", mac.VEHICLE_CODE),
new SqlParameter("@SUBWAY_LINE_INFO", mac.SUBWAY_LINE_INFO),
new SqlParameter("@SUBWAY_VEHICLE_INFO", mac.SUBWAY_VEHICLE_INFO),
new SqlParameter("@SUBWAY_COMPARTMENT_NUMBER", mac.SUBWAY_COMPARTMENT_NUMBER),
new SqlParameter("@IsTrial", mac.IsTrial),
new SqlParameter("@supplier", mac.supplier),
new SqlParameter("@ProjectType", mac.ProjectType),
new SqlParameter("@CasesType", mac.CasesType),
new SqlParameter("@ModeType", mac.ModeType),
new SqlParameter("@LogCapture", mac.LogCapture),
new SqlParameter("@ID", mac.ID)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.DBConnStr, CommandType.Text, sql, param));
}
public int UpdateMac(MacInfo mac)
{
string sql = "";
try
{
sql = "UPDATE DevInfo SET COLLECTION_EQUIPMENT_ID = @COLLECTION_EQUIPMENT_ID, AP_MAC = @AP_MAC WHERE ID=@ID";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@COLLECTION_EQUIPMENT_ID", mac.COLLECTION_EQUIPMENT_ID),
new SqlParameter("@AP_MAC", mac.AP_MAC),
new SqlParameter("@ID", mac.ID)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.DBConnStr, CommandType.Text, sql, param));
}
catch (Exception ex)
{
Logger.ErrorLog(ex, new Dictionary <string, string>()
{
{ "Function", "MacDAL.UpdateMac(MACInfo mac)" },
{ "SQL", sql }
});
throw ex;
}
}
public static string GetMacInfo()
{
string cPUID = GetCPUID();
string baseBoard = GetBaseBoard();
string biosID = GetBiosID();
List <MacInfo> list2 = new List <MacInfo>();
MacInfo item = new MacInfo {
Name = "CPU",
Value = cPUID
};
list2.Add(item);
MacInfo info2 = new MacInfo {
Name = "BaseBoard",
Value = baseBoard
};
list2.Add(info2);
MacInfo info3 = new MacInfo {
Name = "Bios",
Value = biosID
};
list2.Add(info3);
List <MacInfo> list = list2;
return(null);
//return new JavaScriptSerializer().Serialize(list);
}
public int UpdateMacById(MacInfo mac)
{
//COLLECTION_EQUIPMENT_ID=@SECURITY_SOFTWARE_ORGCODE+REPLACE(AP_MAC,'-','')
string sql =
"UPDATE DevInfo SET NETBAR_WACODE = (SELECT nbi.NETBAR_WACODE FROM NetBarInfo nbi WHERE nbi.ID=@NETBAR_ID),NETBAR_ID = @NETBAR_ID,Verified = 1,APType = @APType,ModeType = @ModeType,LogCapture = @LogCapture,supplier = @supplier,ProjectType = @ProjectType,CasesType = @CasesType,AP_ACSSES_IP=@AP_ACSSES_IP,IsTrial=@IsTrial,APName=@APName,LONGITUDE = @LONGITUDE,LATITUDE = @LATITUDE,[FLOOR] = @FLOOR,SUBWAY_STATION = @SUBWAY_STATION,SUBWAY_LINE_INFO = @SUBWAY_LINE_INFO,SUBWAY_VEHICLE_INFO = @SUBWAY_VEHICLE_INFO,SUBWAY_COMPARTMENT_NUMBER = @SUBWAY_COMPARTMENT_NUMBER,CAR_CODE = @CAR_CODE,Channel = @Channel,FenceOffTime = @FenceOffTime,ForcedOfflineTime = @ForcedOfflineTime,IsReboot = @IsReboot,V3CID=@V3CID WHERE ID=@ID";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@LONGITUDE", mac.LONGITUDE),
new SqlParameter("@LATITUDE", mac.LATITUDE),
new SqlParameter("@FLOOR", mac.FLOOR),
new SqlParameter("@SUBWAY_STATION", mac.SUBWAY_STATION),
new SqlParameter("@SUBWAY_LINE_INFO", mac.SUBWAY_LINE_INFO),
new SqlParameter("@SUBWAY_VEHICLE_INFO", mac.SUBWAY_VEHICLE_INFO),
new SqlParameter("@SUBWAY_COMPARTMENT_NUMBER", mac.SUBWAY_COMPARTMENT_NUMBER),
new SqlParameter("@CAR_CODE", mac.CAR_CODE),
new SqlParameter("@ID", mac.ID),
new SqlParameter("@NETBAR_ID", mac.NETBAR_ID),
new SqlParameter("@APType", mac.APType),
new SqlParameter("@ModeType", mac.ModeType),
new SqlParameter("@LogCapture", mac.LogCapture),
new SqlParameter("@supplier", mac.supplier),
new SqlParameter("@ProjectType", mac.ProjectType),
new SqlParameter("@CasesType", mac.CasesType),
new SqlParameter("@IsTrial", mac.IsTrial),
new SqlParameter("@APName", mac.APName),
new SqlParameter("@Channel", mac.Channel),
new SqlParameter("@FenceOffTime", mac.FenceOffTime),
new SqlParameter("@ForcedOfflineTime", mac.ForcedOfflineTime),
new SqlParameter("@V3CID", mac.V3CID),
new SqlParameter("@SECURITY_SOFTWARE_ORGCODE", mac.SECURITY_SOFTWARE_ORGCODE),
new SqlParameter("@IsReboot", mac.IsReboot),
new SqlParameter("@AP_ACSSES_IP", mac.AP_ACSSES_IP),
//new SqlParameter("@COLLECTION_EQUIPMENT_ID",mac.COLLECTION_EQUIPMENT_ID)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.DBConnStr, CommandType.Text, sql, param));
}
public int InsertMac(MacInfo mac)
{
string sql = "";
try
{
sql = " INSERT INTO DevInfo(COLLECTION_EQUIPMENT_ID,AP_MAC,CreateTime)VALUES(@COLLECTION_EQUIPMENT_ID,@AP_MAC,GETDATE());SELECT @@IDENTITY;";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@AP_MAC", mac.AP_MAC),
new SqlParameter("@COLLECTION_EQUIPMENT_ID", mac.COLLECTION_EQUIPMENT_ID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.DBConnStr, CommandType.Text, sql, param)));
}
catch (Exception ex)
{
Logger.ErrorLog(ex, new Dictionary <string, string>()
{
{ "Function", "MacDAL.InsertMac(MacInfo mac)" },
{ "SQL", sql }
});
throw ex;
}
}
