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