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;
}
