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