// --- Submit form
private void btn_okUW_Click(object sender, RoutedEventArgs e)
{
bool t = validator.HasErrors;
Ex_Pass = grid_Passport_EX.DataContext as wsPassportExtended;
if (check_newProducer.IsChecked == true)
{
wsProducerType producer = Ex_Pass.extractProducerType();
wc.ws_checkPassportProducerAsync(producer);
}
else
{
Ex_Pass.ProducerID = (cbox_ProducersList.SelectedItem as wsProducerType).ProducerID;
//Ex_Pass.downgradeToDataOnly();
switch (ucMode)
{
case 'U': // mode_U
wc.ws_updatePassportAsync(Ex_Pass);
break;
case 'W': // mode_W
wc.ws_insertPassportAsync(Ex_Pass, (int)ucPID);
break;
}
}
}
private void btn_selFilterCalibrate_Click(object sender, RoutedEventArgs e)
{
devicesCollection.Filter = delegate(object filterObject)
{
wsPassportExtended Pass = (wsPassportExtended)filterObject;
return(Pass.IsCalibrated == true);
};
}
private void dg_Devices_KeyDown(object sender, System.Windows.Input.KeyEventArgs e)
{
if (e.Key == System.Windows.Input.Key.Space)
{
if (dg_Devices.SelectedItem != null)
{
wsPassportExtended P = dg_Devices.SelectedItem as wsPassportExtended;
cwnd_Passport w = new cwnd_Passport(P.DevID);
w.Show();
}
}
}
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 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);
}
}
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);
}
void wc_ws_selectPassport_EXCompleted(object sender, ws_selectPassport_EXCompletedEventArgs e)
{
if (e.Result != null)
{
Ex_Pass = e.Result;
grid_Passport_EX.DataContext = Ex_Pass;
DBTree DBTREEmodels = new DBTree();
DBTREEmodels.DBDATA = e.Result.tbl_Models;
Node treeModels = new Node(DBTREEmodels.GetAnyNodeinDB);
globalTreeModels = treeModels;
globalListModels = globalTreeModels.getListByLevel(1, null);
cbox_ModelsList.ItemsSource = globalListModels;
//cbox_ProducersList.ItemsSource = Ex_Pass.list_Producers;
//auto_DevDescrRU.ItemsSource = Ex_Pass.helper_DevDescr;
if (cbox_ModelsList.Items.Count > 0)
{
cbox_ModelsList.SelectedIndex = ScoDe.SetBoxIndex_wsSimpleItem(cbox_ModelsList, Ex_Pass.DevModelID);
}
if (cbox_ProducersList.Items.Count > 0)
{
cbox_ProducersList.SelectedIndex = ScoDe.SetBoxIndex_wsProducerType(cbox_ProducersList, Ex_Pass.ProducerID);
}
}
else
{
cwnd_ShitHappens w = new cwnd_ShitHappens(ErrorResources.err_SELECT, e.OpStatus.ToString());
w.Show();
}
}
public int updatePassport(wsPassportExtended pT)//lp_upd_DevicePassport
{
int ret = 999;
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_upd_DevicePassport");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ReturnVal", SqlDbType.Int);
cmd.Parameters["@ReturnVal"].Direction = ParameterDirection.ReturnValue;
cmd.Parameters.AddWithValue("@DevID", pT.DevID);
cmd.Parameters.AddWithValue("@LongDescrRu", pT.DevDescrRU);
cmd.Parameters.AddWithValue("@PassportNo", pT.DevPassportNo);
cmd.Parameters.AddWithValue("@InvNo", pT.DevInvNo);
cmd.Parameters.AddWithValue("@ProduceDate", pT.ProduceDate);
cmd.Parameters.AddWithValue("@PurchaseDate", pT.PurchaseDate);
cmd.Parameters.AddWithValue("@ImplementationDate", pT.ImplementationDate);
cmd.Parameters.AddWithValue("@Model", pT.DevModel);
cmd.Parameters.AddWithValue("@ProducerID", pT.ProducerID);
cmd.Parameters.AddWithValue("@Name", pT.ProducerName);
cmd.Parameters.AddWithValue("@Country", pT.ProducerCountry);
cmd.Parameters.AddWithValue("@State", pT.ProducerState);
cmd.Parameters.AddWithValue("@City", pT.ProducerCity);
cmd.Parameters.AddWithValue("@StreetBuilding", pT.ProducerStreetBuilding);
cmd.Parameters.AddWithValue("@Phone", pT.ProducerPhone);
cmd.Parameters.AddWithValue("@PlaceID", pT.DevPlaceID);
//cmd.Parameters.AddWithValue("@CalibrationPeriod", pT.CalibrationPeriod;
cmd.ExecuteNonQuery();
ret = (int)cmd.Parameters["@ReturnVal"].Value;
conn.Close();
}
return(ret);
}
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 List <wsPassportExtended> selectDevicesPassports(int?TypeID, int?PlaceID) // lp_sel_DevicesPassport
{
List <wsPassportExtended> list = new List <wsPassportExtended>();
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_DevicesPassport");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TypeID", objectOrNull(TypeID));
cmd.Parameters.AddWithValue("@PlaceID", objectOrNull(PlaceID));
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
wsPassportExtended device = new wsPassportExtended();
if (!Reader.IsDBNull(Reader.GetOrdinal("DevID")))
{
device.DevID = (int)Reader["DevID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PassportNo")))
{
device.DevPassportNo = (string)Reader["PassportNo"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("InvNo")))
{
device.DevInvNo = (string)Reader["InvNo"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("LongDescrRU")))
{
device.DevDescrRU = (string)Reader["LongDescrRU"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Model_ID")))
{
device.DevModelID = (int)Reader["Model_ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Model")))
{
device.DevModel = (string)Reader["Model"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ProducerID")))
{
device.ProducerID = (int)Reader["ProducerID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ProducerName")))
{
device.ProducerName = (string)Reader["ProducerName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Country")))
{
device.ProducerCountry = (string)Reader["Country"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("State")))
{
device.ProducerState = (string)Reader["State"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("City")))
{
device.ProducerCity = (string)Reader["City"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("StreetBuilding")))
{
device.ProducerStreetBuilding = (string)Reader["StreetBuilding"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Phone")))
{
device.ProducerPhone = (string)Reader["Phone"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ProduceDate")))
{
device.ProduceDate = (DateTime)Reader["ProduceDate"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PurchaseDate")))
{
device.PurchaseDate = (DateTime)Reader["PurchaseDate"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ImplementationDate")))
{
device.ImplementationDate = (DateTime)Reader["ImplementationDate"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("CurrentStateID")))
{
device.CurrentStateID = (int)Reader["CurrentStateID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("StateName")))
{
device.CurrentStateName = (string)Reader["StateName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("DevPlaceID")))
{
device.DevPlaceID = (int)Reader["DevPlaceID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("DevTypeID")))
{
device.DevTypeID = (int)Reader["DevTypeID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("TypeName")))
{
device.DevTypeName = (string)Reader["TypeName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PlaceName")))
{
device.DevPlaceName = (string)Reader["PlaceName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("IsCalibration")))
{
device.IsCalibrated = (bool)Reader["IsCalibration"];
}
//--- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
device.DevPath = selectDeviceParents(device.DevTypeID);
device.DevPlacePath = selectPlaceParents(device.DevPlaceID);
list.Add(device);
}
Reader.Close();
conn.Close();
}
return(list);
}
//------ PASSPORTS --------------------------------------------------------------
public wsPassportExtended selectPasport(int ID)
{
wsPassportExtended l = new wsPassportExtended();
using (SqlConnection conn = new SqlConnection(Configuration.ConnectionString))
{
SqlCommand cmd = new SqlCommand("lp_sel_DevicePassport");
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", ID);
SqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
if (!Reader.IsDBNull(Reader.GetOrdinal("DevID")))
{
l.DevID = (int)Reader["DevID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PassportNo")))
{
l.DevPassportNo = (string)Reader["PassportNo"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("InvNo")))
{
l.DevInvNo = (string)Reader["InvNo"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("LongDescrRU")))
{
l.DevDescrRU = (string)Reader["LongDescrRU"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Model_ID")))
{
l.DevModelID = (int)Reader["Model_ID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Model")))
{
l.DevModel = (string)Reader["Model"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ProducerID")))
{
l.ProducerID = (int)Reader["ProducerID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ProducerName")))
{
l.ProducerName = (string)Reader["ProducerName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Country")))
{
l.ProducerCountry = (string)Reader["Country"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("State")))
{
l.ProducerState = (string)Reader["State"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("City")))
{
l.ProducerCity = (string)Reader["City"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("StreetBuilding")))
{
l.ProducerStreetBuilding = (string)Reader["StreetBuilding"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("Phone")))
{
l.ProducerPhone = (string)Reader["Phone"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ProduceDate")))
{
l.ProduceDate = (DateTime)Reader["ProduceDate"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("PurchaseDate")))
{
l.PurchaseDate = (DateTime)Reader["PurchaseDate"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("ImplementationDate")))
{
l.ImplementationDate = (DateTime)Reader["ImplementationDate"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("CurrentStateID")))
{
l.CurrentStateID = (int)Reader["CurrentStateID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("StateName")))
{
l.CurrentStateName = (string)Reader["StateName"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("DevPlaceID")))
{
l.DevPlaceID = (int)Reader["DevPlaceID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("DevTypeID")))
{
l.DevTypeID = (int)Reader["DevTypeID"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("IsCalibration")))
{
l.IsCalibrated = (bool)Reader["IsCalibration"];
}
if (!Reader.IsDBNull(Reader.GetOrdinal("CalibrationPeriod")))
{
l.CalibrationPeriod = (int)Reader["CalibrationPeriod"];
}
}
}
return(l);
}
