public static bool PPCClose(SysMonitoring monitorInfo)
{
try
{
List<SysMonitoring> lists = SysMonitoringBL.GetInstance().GetRecords(monitorInfo);
if (lists != null && lists.Count > 0)
{
monitorInfo.sym_dMarkTime = System.DateTime.Now;
monitorInfo.sym_dUpdateTime = System.DateTime.Now;
monitorInfo.sym_cSystemIP = NetUtil.GetIPAddress();
monitorInfo.sym_MACAddress = NetUtil.GetMACAddress();
monitorInfo.sym_iStatus = (int)CustEnum.SysState.關閉;
return SysMonitoringBL.GetInstance().Update(monitorInfo).boolValue;
}
else
{
SysMonitoringBL.GetInstance().RegisterPPC(monitorInfo);
return true;
}
}
catch (Exception ex)
{
Common.General.BLLoger.Info("PPCStatusManage.UpdatePPCStatus", ex);
}
return false;
}
public ReturnValueInfo Delete(SysMonitoring objInfo)
{
ReturnValueInfo returnInfo = new ReturnValueInfo(false);
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
var delTab = db.SystemMonitoring_sym.Where(t => t.sym_MACAddress == objInfo.sym_MACAddress);
if (delTab != null)
{
foreach (var item in delTab)
{
db.SystemMonitoring_sym.DeleteOnSubmit(item);
}
db.SubmitChanges();
returnInfo.boolValue = true;
}
}
}
catch (Exception Ex)
{
returnInfo.messageText = Ex.Message;
}
return returnInfo;
}
public ReturnValueInfo Update(SysMonitoring objInfo)
{
Common.General.DALoger.Debug("call SysMonitoringDA.Update");
MainDBDataContext db = null;
ReturnValueInfo returnValue = new ReturnValueInfo();
if (objInfo != null)
{
try
{
using (db = new MainDBDataContext())
{
SystemMonitoring_sym query = db.SystemMonitoring_sym.SingleOrDefault(t => t.sym_iSystemID == objInfo.sym_iSystemID);
if (query != null)
{
query.sym_cProcessName = objInfo.sym_cProcessName;
query.sym_cSystemName = objInfo.sym_cSystemName;
query.sym_cSystemType = objInfo.sym_cSystemType;
query.sym_cVersion = objInfo.sym_cVersion;
query.sym_dLastTime = objInfo.sym_dLastTime;
query.sym_dMarkTime = objInfo.sym_dMarkTime;
query.sym_dStartTime = objInfo.sym_dStartTime;
query.sym_dUpdateTime = objInfo.sym_dUpdateTime;
query.sym_iStatus = objInfo.sym_iStatus;
query.sym_lIsPLCConnection = objInfo.sym_lIsPLCConnection;
query.sym_cSoftwareNo = objInfo.sym_cSoftwareNo;
query.sym_cSystemIP = objInfo.sym_cSystemIP;
query.sym_MACAddress = objInfo.sym_MACAddress;
query.sym_cMachineID = objInfo.sym_cMachineID;
db.SubmitChanges(System.Data.Linq.ConflictMode.ContinueOnConflict);
}
returnValue.boolValue = true;
returnValue.isError = false;
returnValue.ValueObject = query;
returnValue.messageText = "保存成功";
}
}
catch (System.Data.Linq.ChangeConflictException ex)
{
Common.General.DALoger.Error(ex);
}
}
return returnValue;
}
public List<SysMonitoring> GetRecords(SysMonitoring objInfo)
{
try
{
if (objInfo == null)
{
return null;
}
using (MainDBDataContext db = new MainDBDataContext())
{
db.Log = Console.Out;
var qur = from Sysm in db.SystemMonitoring_sym
where (objInfo.sym_iStatus == 0 || objInfo.sym_iStatus == Sysm.sym_iStatus) &&
(objInfo.sym_MACAddress.Length == 0 || objInfo.sym_MACAddress == Sysm.sym_MACAddress) &&
(objInfo.sym_cSystemIP.Length == 0 || objInfo.sym_cSystemIP == Sysm.sym_cSystemIP) &&
(objInfo.sym_iSystemID == 0 || objInfo.sym_iSystemID == Sysm.sym_iSystemID)
select new SysMonitoring
{
sym_MACAddress = Sysm.sym_MACAddress,
sym_iSystemID = Sysm.sym_iSystemID,
sym_cSystemType = Sysm.sym_cSystemType,
sym_cSystemName = Sysm.sym_cSystemName,
sym_cSystemIP = Sysm.sym_cSystemIP,
sym_dStartTime = Sysm.sym_dStartTime,
sym_iStatus = Sysm.sym_iStatus,
sym_dUpdateTime = Sysm.sym_dUpdateTime,
sym_cVersion = Sysm.sym_cVersion,
sym_cProcessName = Sysm.sym_cProcessName,
sym_lIsPLCConnection = Sysm.sym_lIsPLCConnection,
sym_dMarkTime = Sysm.sym_dMarkTime,
sym_dAddTime = Sysm.sym_dAddTime,
sym_dLastTime = Sysm.sym_dLastTime,
sym_cMachineID = Sysm.sym_cMachineID,
sym_cSoftwareNo = Sysm.sym_cSoftwareNo
};
return qur.ToList();
}
}
catch (Exception ex)
{
Common.General.DALoger.Error(ex);
throw ex;
}
}
public ReturnValueInfo Insert(SysMonitoring objInfo)
{
ReturnValueInfo returnValue = new ReturnValueInfo();
if (objInfo != null)
{
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
//objInfo.not_RecordID = Guid.NewGuid();
LinqToSQLModel.SystemMonitoring_sym newTab = Common.General.CopyObjectValue<Model.HBPMS.BusinessModel.SysMonitoring, LinqToSQLModel.SystemMonitoring_sym>(objInfo);
newTab.sym_dAddTime = DateTime.Now;
newTab.sym_dLastTime = DateTime.Now;
newTab.sym_dMarkTime = DateTime.Now;
newTab.sym_dUpdateTime = DateTime.Now;
newTab.sym_dStartTime = DateTime.Now;
db.SystemMonitoring_sym.InsertOnSubmit(newTab);
db.SubmitChanges();
objInfo.sym_iSystemID = newTab.sym_iSystemID;
}
}
catch (Exception ex)
{
Common.General.DALoger.Debug("保存系統監控狀態記錄失败", ex);
}
}
return null;
}
public ReturnValueInfo RegisterPPC(SysMonitoring objInfo)
{
throw new NotImplementedException();
//ReturnValueInfo returnValueInfo = null;
//try
//{
// objInfo.sym_cSystemIP = NetUtil.GetIPAddress();
// objInfo.sym_MACAddress = NetUtil.GetMACAddress();
// objInfo.sym_dUpdateTime = DateTime.Now;
// objInfo.sym_dLastTime = DateTime.Now;
// objInfo.sym_dMarkTime = DateTime.Now;
// objInfo.sym_dStartTime = DateTime.Now;
// objInfo.sym_cSoftwareNo = string.Empty;
// ReturnValueInfo result = this._ISysMonitoringDA.Insert(objInfo);
// if (result.boolValue)
// {
// ICRUD crud = new CRUD();
// LocalInfomation_lcif_Info info = new LocalInfomation_lcif_Info();
// info.lcif_cKey = CustEnum.LocalInfoCacheKey.SystemID.ToString();
// info.lcif_cValue = objInfo.sym_iSystemID.ToString();
// return crud.Update(info);
// }
//}
//catch (Exception ex)
//{
// returnValueInfo = new ReturnValueInfo();
// returnValueInfo.boolValue = false;
// returnValueInfo.messageText = ex.Message;
//}
//return returnValueInfo;
}
public ReturnValueInfo Insert(SysMonitoring objInfo)
{
return this._ISysMonitoringDA.Insert(objInfo);
}
public List<SysMonitoring> GetRecords(SysMonitoring objInfo)
{
return this._ISysMonitoringDA.GetRecords(objInfo);
}
public ReturnValueInfo Delete(SysMonitoring objInfo)
{
return this._ISysMonitoringDA.Delete(objInfo);
}
public ReturnValueInfo Update(SysMonitoring objInfo)
{
Common.General.BLLoger.Debug("call SysMonitoringBL.Update");
return this._ISysMonitoringDA.Update(objInfo);
}