public int ws_deleteNode(int NodeID, out string OpStatus) { try { int code = 0; DeviceDataManager DDM = new DeviceDataManager(); code = DDM.deleteNode(NodeID); if (code == 0) { OpStatus = Resources.Messages.m_OpStatusDone; } else { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += code; } return(1); } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return(0); } }
public int ws_deleteTreeItem(List <int> IDlist, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); string s = "Удалены устройства: \n"; foreach (int _id in IDlist) { DDM.deleteDevice(_id); s += "id = " + _id + "\n"; } OpStatus = Resources.Messages.m_OpStatusDone; //---- Создать оповещение через сервер оповещений-------------------------------------- NotifyServerClient.unClientClass notifyClient = new NotifyServerClient.unClientClass(); notifyClient.sendNotify(s); //-------------------------------------------------------------------------------------- return(1); } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return(0); } }
public int ws_updateNode(int NodeID, string NodeName, int?ParentID, string LinkToIcon, bool IsCalibrated, out string OpStatus) { try { int code = 0; DeviceDataManager DDM = new DeviceDataManager(); code = DDM.modifyType(NodeID, NodeName, ParentID, LinkToIcon, IsCalibrated); if (code == 0) { OpStatus = Resources.Messages.m_OpStatusDone; } else { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += code; } return(1); } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return(0); } }
static void Main(string[] args) { //DateTime beginDate = DateTime.Now.AddDays(-7); //DateTime endDate = DateTime.Now; //int id = 77; //wsWorkState WSt = new wsWorkState(); //WorkDataManager WDM = new WorkDataManager(); //WSt.list_SCADAMessages = WDM.selectDevWorkStates(id, beginDate, endDate); //WSt.ID = id; //WSt.startDate = beginDate; //WSt.finishDate = endDate; //WSt.list_StatesDurations = WDM.selectDevWorkStatesDuration(id, beginDate, endDate); DeviceDataManager DDM = new DeviceDataManager(); wsPassportExtended P_EX = new wsPassportExtended(); P_EX = DDM.selectPasport(77); P_EX.DevPath = DDM.selectDeviceParents(P_EX.DevTypeID); P_EX.DevPlacePath = DDM.selectPlaceParents(P_EX.DevPlaceID); }
public int ws_checkPassportProducer(wsProducerType P, out int OpValue, out string OpStatus) { OpValue = 555; wsProducerType RP = new wsProducerType(); try { DeviceDataManager DDM = new DeviceDataManager(); DDM.checkPassport(P, out OpValue, out OpStatus); if (OpValue == 50018) { return(1); // Можно вставлять паспорт } else { return(0); } } catch (Exception err) { OpStatus = "Ошибка SQL: " + err.Message.ToString(); return(0); } }
//---- for calibrations report private DataTable LoadDS_CNext() { DeviceDataManager DDM = new DeviceDataManager(); var result = from item in DDM.selectNextCalibrations() where item.plannedDate > DateTime.Now select item; Utility objUtility = new Utility(); DataTable dt = new DataTable(); dt = objUtility.LINQToDataTable(result); return(dt.DefaultView.Table); }
public List <wsPassportExtended> ws_selectPassportsList(int?TypeID, int?PlaceID, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = "Done"; return(DDM.selectDevicesPassports(TypeID, PlaceID)); } catch (Exception err) { OpStatus = err.Message.ToString(); return(null); } }
public List <wsSimpleItem> ws_selectModificationsList(int?ID, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = "Выполнено"; return(DDM.selectModelsList(ID)); } catch (Exception err) { OpStatus = err.Message.ToString(); return(null); } }
public List <wsModelItem> ws_selectModels(out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = "Выполнено"; return(DDM.selectModels()); } catch (Exception err) { OpStatus = err.Message.ToString(); return(null); } }
public List <wsBaseItem> ws_selectPlaces(int?_ID, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); return(DDM.selectPlaces(_ID)); } catch (Exception err) { OpStatus = err.Message.ToString(); return(null); } }
public string ws_selectPlaceParents(int?ID, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = "Выполнено"; return(DDM.selectPlaceParents(ID)); } catch (Exception err) { OpStatus = err.Message.ToString(); return(null); } }
public List <wsMaintenance> ws_selectDeviceMaintenances(int id, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); return(DDM.selectDeviceMaintenances(id)); } catch (Exception err) { OpStatus = err.Message.ToString(); return(null); } }
public List <wsSimpleItem> ws_selectCalibrationTypes(out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); return(DDM.selectCalibrationTypes()); } catch (Exception err) { OpStatus = err.Message.ToString(); return(null); } }
public int ws_insertCalibration(wsCalibration c, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); DDM.insertCalibration(c); return(1); } catch (Exception err) { OpStatus = err.Message.ToString(); return(0); } }
public int ws_deletePlace(int ID, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); DDM.deletePlace(ID); return(1); } catch (Exception err) { OpStatus = err.Message.ToString(); return(0); } }
public int ws_ins_upd_Period(int _id, int period, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); DDM.ins_upd_Period(_id, period); return(1); } catch (Exception err) { OpStatus = err.Message.ToString(); return(0); } }
public int ws_insertPlace(string Name, int?parentID, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); DDM.insertPlace(Name, parentID); return(1); } catch (Exception err) { OpStatus = err.Message.ToString(); return(0); } }
//---- for passport report private DataTable LoadDS_ServiceData() { int PID = Convert.ToInt32(Request.QueryString["PID"]); DeviceDataManager DDM = new DeviceDataManager(); var result = DDM.selectDeviceCalibrations(PID); Utility objUtility = new Utility(); DataTable dt = new DataTable(); dt = objUtility.LINQToDataTable(result); return(dt.DefaultView.Table); }
public List <string> ws_helperTypesList(out string OpStatus) { try { List <string> s = new List <string>(); DeviceDataManager DDM = new DeviceDataManager(); s = DDM.selectAllTypes(); OpStatus = Resources.Messages.m_OpStatusDone; return(s); } catch (Exception err) { OpStatus = err.Message.ToString(); return(null); } }
public List <wsBaseItem> ws_selectDevListByPlace(int?ID, out string OpStatus, out string Path) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); Path = DDM.selectPlaceParents(ID); return(DDM.selectDevListByPlace(ID)); } catch (Exception err) { OpStatus = err.Message.ToString(); Path = ""; return(null); } }
public List <wsBaseItem> ws_selectTreeItemsList(int?ID, out string OpStatus, out string Path) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = Resources.Messages.m_OpStatusDone; Path = DDM.selectDeviceParents(ID); return(DDM.selectItemsList(ID)); } catch (Exception err) { OpStatus = err.Message.ToString(); Path = ""; return(null); } }
public int ws_moveItems(int ID, string xml, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); DDM.moveItems(ID, xml); OpStatus = Resources.Messages.m_OpStatusDone; return(1); } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return(0); } }
public int ws_updatePassport(wsPassportExtended p, out string OpStatus) { try { int code = 0; DeviceDataManager DDM = new DeviceDataManager(); code = DDM.updatePassport(p); OpStatus = "Выполнено с кодом " + code.ToString(); return(1); } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return(0); } }
//---- for passport report private DataTable LoadDS_PassportData() { int PID = Convert.ToInt32(Request.QueryString["PID"]); DeviceDataManager DDM = new DeviceDataManager(); var result = from Passport in DDM.selectDevicesPassports(null, null).AsQueryable() where Passport.DevID == PID select Passport; Utility objUtility = new Utility(); DataTable dt = new DataTable(); dt = objUtility.LINQToDataTable(result); return(dt.DefaultView.Table); }
public wsPassportExtended ws_selectPassport(int ID, out string OpStatus) { try { wsPassportExtended P = new wsPassportExtended(); DeviceDataManager DDM = new DeviceDataManager(); P = DDM.selectPasport(ID); P.DevPath = DDM.selectDeviceParents(P.DevTypeID); P.DevPlacePath = DDM.selectPlaceParents(P.DevPlaceID); OpStatus = Resources.Messages.m_OpStatusDone; return(P); } catch (Exception err) { OpStatus = err.ToString(); return(null); } }
public wsPassportExtended ws_selectPassport_EX(int?ID, out string OpStatus) { try { wsPassportExtended P_EX = new wsPassportExtended(); CatalogsDataManager CDM = new CatalogsDataManager(); DeviceDataManager DDM = new DeviceDataManager(); if (ID != null) { P_EX = DDM.selectPasport((int)ID); P_EX.DevPath = DDM.selectDeviceParents(P_EX.DevTypeID); P_EX.DevPlacePath = DDM.selectPlaceParents(P_EX.DevPlaceID); } P_EX.list_Producers = CDM.GetProducerList(); DBTree DBT = new DBTree(2); // 2 = models tree //wsNode NNODE = new wsNode(DBTREE.GetAnyNodeinDB); P_EX.tbl_Models = DBT.DBDATA; List <string> s = new List <string>(); List <wsBaseItem> blist = new List <wsBaseItem>(); blist = DDM.selectItemsList(null); foreach (wsBaseItem b in blist) { s.Add(b.Description); } P_EX.helper_DevDescr = s; OpStatus = Resources.Messages.m_OpStatusDone; return(P_EX); } catch (Exception err) { OpStatus = err.ToString(); return(null); } }
public List <string> ws_selectDevDescrList(out string OpStatus) { try { List <string> s = new List <string>(); List <wsBaseItem> blist = new List <wsBaseItem>(); DeviceDataManager DDM = new DeviceDataManager(); blist = DDM.selectItemsList(null); foreach (wsBaseItem b in blist) { s.Add(b.Description); } OpStatus = Resources.Messages.m_OpStatusDone; return(s); } catch (Exception err) { OpStatus = err.Message.ToString(); return(null); } }
public int ws_insertPassport(wsPassportExtended p, int ID, out string OpStatus) { try { int code = 0; DeviceDataManager DDM = new DeviceDataManager(); code = DDM.insertPassport(p, ID); if (code == 0) { OpStatus = Resources.Messages.m_OpStatusDone; } else { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += code; } //---- Создать оповещение через сервер оповещений-------------------------------------- string s = "Добавлен новый паспорт в базу устройств \n"; s += "Наименование: " + p.DevDescrRU + "\n"; s += "инв.№ = " + p.DevInvNo + "\n"; s += "№ паспорта = " + p.DevPassportNo + "\n"; NotifyServerClient.unClientClass notifyClient = new NotifyServerClient.unClientClass(); notifyClient.sendNotify(s); //-------------------------------------------------------------------------------------- return(1); } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return(0); } }
public int ws_checkPassportProducer(wsProducerType P, out int OpValue, out string OpStatus) { OpValue = 555; wsProducerType RP = new wsProducerType(); try { DeviceDataManager DDM = new DeviceDataManager(); DDM.checkPassport(P, out OpValue, out OpStatus); if (OpValue == 50018) return 1; // Можно вставлять паспорт else return 0; } catch (Exception err) { OpStatus = "Ошибка SQL: " + err.Message.ToString(); return 0; } }
public wsPassportExtended ws_selectPassport_EX(int? ID, out string OpStatus) { try { wsPassportExtended P_EX = new wsPassportExtended(); CatalogsDataManager CDM = new CatalogsDataManager(); DeviceDataManager DDM = new DeviceDataManager(); if (ID != null) { P_EX = DDM.selectPasport((int)ID); P_EX.DevPath = DDM.selectDeviceParents(P_EX.DevTypeID); P_EX.DevPlacePath = DDM.selectPlaceParents(P_EX.DevPlaceID); } P_EX.list_Producers = CDM.GetProducerList(); DBTree DBT = new DBTree(2); // 2 = models tree //wsNode NNODE = new wsNode(DBTREE.GetAnyNodeinDB); P_EX.tbl_Models = DBT.DBDATA; List<string> s = new List<string>(); List<wsBaseItem> blist = new List<wsBaseItem>(); blist = DDM.selectItemsList(null); foreach (wsBaseItem b in blist) { s.Add(b.Description); } P_EX.helper_DevDescr = s; OpStatus = Resources.Messages.m_OpStatusDone; return P_EX; } catch (Exception err) { OpStatus = err.ToString(); return null; } }
public wsPassportExtended ws_selectPassport(int ID, out string OpStatus) { try { wsPassportExtended P = new wsPassportExtended(); DeviceDataManager DDM = new DeviceDataManager(); P = DDM.selectPasport(ID); P.DevPath = DDM.selectDeviceParents(P.DevTypeID); P.DevPlacePath = DDM.selectPlaceParents(P.DevPlaceID); OpStatus = Resources.Messages.m_OpStatusDone; return P; } catch (Exception err) { OpStatus = err.ToString(); return null; } }
public int ws_moveItems(int ID, string xml, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); DDM.moveItems(ID, xml); OpStatus = Resources.Messages.m_OpStatusDone; return 1; } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return 0; } }
public List<string> ws_helperTypesList(out string OpStatus) { try { List<string> s = new List<string>(); DeviceDataManager DDM = new DeviceDataManager(); s = DDM.selectAllTypes(); OpStatus = Resources.Messages.m_OpStatusDone; return s; } catch (Exception err) { OpStatus = err.Message.ToString(); return null; } }
//---- for passport report private DataTable LoadDS_ServiceData() { int PID = Convert.ToInt32(Request.QueryString["PID"]); DeviceDataManager DDM = new DeviceDataManager(); var result = DDM.selectDeviceCalibrations(PID); Utility objUtility = new Utility(); DataTable dt = new DataTable(); dt = objUtility.LINQToDataTable(result); return dt.DefaultView.Table; }
public List<wsPassportExtended> ws_selectPassportsList(int? TypeID, int? PlaceID, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = "Done"; return DDM.selectDevicesPassports(TypeID,PlaceID); } catch (Exception err) { OpStatus = err.Message.ToString(); return null; } }
public int ws_insertCalibration(wsCalibration c, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); DDM.insertCalibration(c); return 1; } catch (Exception err) { OpStatus = err.Message.ToString(); return 0; } }
public string ws_selectPlaceParents(int? ID, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = "Выполнено"; return DDM.selectPlaceParents(ID); } catch (Exception err) { OpStatus = err.Message.ToString(); return null; } }
public int ws_insertPlace(string Name, int? parentID, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); DDM.insertPlace(Name, parentID); return 1; } catch (Exception err) { OpStatus = err.Message.ToString(); return 0; } }
public List<wsModelItem> ws_selectModels(out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = "Выполнено"; return DDM.selectModels(); } catch (Exception err) { OpStatus = err.Message.ToString(); return null; } }
public int ws_insertPassport(wsPassportExtended p, int ID, out string OpStatus) { try { int code = 0; DeviceDataManager DDM = new DeviceDataManager(); code = DDM.insertPassport(p,ID); if (code == 0) { OpStatus = Resources.Messages.m_OpStatusDone; } else { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += code; } //---- Создать оповещение через сервер оповещений-------------------------------------- string s = "Добавлен новый паспорт в базу устройств \n"; s += "Наименование: " + p.DevDescrRU + "\n"; s += "инв.№ = " + p.DevInvNo + "\n"; s += "№ паспорта = " + p.DevPassportNo + "\n"; NotifyServerClient.unClientClass notifyClient = new NotifyServerClient.unClientClass(); notifyClient.sendNotify(s); //-------------------------------------------------------------------------------------- return 1; } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return 0; } }
public int ws_deleteNode(int NodeID, out string OpStatus) { try { int code = 0; DeviceDataManager DDM = new DeviceDataManager(); code = DDM.deleteNode(NodeID); if (code == 0) { OpStatus = Resources.Messages.m_OpStatusDone; } else { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += code; } return 1; } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return 0; } }
public int ws_updatePassport(wsPassportExtended p, out string OpStatus) { try { int code = 0; DeviceDataManager DDM = new DeviceDataManager(); code = DDM.updatePassport(p); OpStatus = "Выполнено с кодом " + code.ToString(); return 1; } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return 0; } }
public List<string> ws_selectDevDescrList(out string OpStatus) { try { List<string> s = new List<string>(); List<wsBaseItem> blist = new List<wsBaseItem>(); DeviceDataManager DDM = new DeviceDataManager(); blist = DDM.selectItemsList(null); foreach (wsBaseItem b in blist) { s.Add(b.Description); } OpStatus = Resources.Messages.m_OpStatusDone; return s; } catch (Exception err) { OpStatus = err.Message.ToString(); return null; } }
public List<wsSimpleItem> ws_selectModificationsList(int? ID, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = "Выполнено"; return DDM.selectModelsList(ID); } catch (Exception err) { OpStatus = err.Message.ToString(); return null; } }
public int ws_ins_upd_Period(int _id, int period, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); DDM.ins_upd_Period(_id, period); return 1; } catch (Exception err) { OpStatus = err.Message.ToString(); return 0; } }
public List<wsBaseItem> ws_selectPlaces(int? _ID, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); return DDM.selectPlaces(_ID); } catch (Exception err) { OpStatus = err.Message.ToString(); return null; } }
//---- for calibrations report private DataTable LoadDS_CNext() { DeviceDataManager DDM = new DeviceDataManager(); var result = from item in DDM.selectNextCalibrations() where item.plannedDate > DateTime.Now select item; Utility objUtility = new Utility(); DataTable dt = new DataTable(); dt = objUtility.LINQToDataTable(result); return dt.DefaultView.Table; }
public int ws_deletePlace(int ID, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); DDM.deletePlace(ID); return 1; } catch (Exception err) { OpStatus = err.Message.ToString(); return 0; } }
public List<wsBaseItem> ws_selectTreeItemsList(int? ID, out string OpStatus, out string Path) { try { DeviceDataManager DDM = new DeviceDataManager(); OpStatus = Resources.Messages.m_OpStatusDone; Path = DDM.selectDeviceParents(ID); return DDM.selectItemsList(ID); } catch (Exception err) { OpStatus = err.Message.ToString(); Path = ""; return null; } }
public List<wsBaseItem> ws_selectDevListByPlace(int? ID, out string OpStatus, out string Path) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); Path = DDM.selectPlaceParents(ID); return DDM.selectDevListByPlace(ID); } catch (Exception err) { OpStatus = err.Message.ToString(); Path = ""; return null; } }
public int ws_deleteTreeItem(List<int> IDlist, out string OpStatus) { try { DeviceDataManager DDM = new DeviceDataManager(); string s = "Удалены устройства: \n"; foreach (int _id in IDlist) { DDM.deleteDevice(_id); s += "id = "+ _id + "\n"; } OpStatus = Resources.Messages.m_OpStatusDone; //---- Создать оповещение через сервер оповещений-------------------------------------- NotifyServerClient.unClientClass notifyClient = new NotifyServerClient.unClientClass(); notifyClient.sendNotify(s); //-------------------------------------------------------------------------------------- return 1; } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return 0; } }
public List<wsSimpleItem> ws_selectCalibrationTypes(out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); return DDM.selectCalibrationTypes(); } catch (Exception err) { OpStatus = err.Message.ToString(); return null; } }
public int ws_updateNode(int NodeID, string NodeName, int? ParentID, string LinkToIcon, bool IsCalibrated, out string OpStatus) { try { int code = 0; DeviceDataManager DDM = new DeviceDataManager(); code = DDM.modifyType(NodeID, NodeName, ParentID, LinkToIcon, IsCalibrated); if (code == 0) { OpStatus = Resources.Messages.m_OpStatusDone; } else { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += code; } return 1; } catch (Exception err) { OpStatus = Resources.Messages.m_OpStatusFail; OpStatus += err.Message.ToString(); return 0; } }
public List<wsMaintenance> ws_selectDeviceMaintenances(int id, out string OpStatus) { try { OpStatus = "Выполнено"; DeviceDataManager DDM = new DeviceDataManager(); return DDM.selectDeviceMaintenances(id); } catch (Exception err) { OpStatus = err.Message.ToString(); return null; } }
//---- for passport report private DataTable LoadDS_PassportData() { int PID = Convert.ToInt32(Request.QueryString["PID"]); DeviceDataManager DDM = new DeviceDataManager(); var result = from Passport in DDM.selectDevicesPassports(null, null).AsQueryable() where Passport.DevID == PID select Passport; Utility objUtility = new Utility(); DataTable dt = new DataTable(); dt = objUtility.LINQToDataTable(result); return dt.DefaultView.Table; }