/*向数据库添加一条reader记录*/ public static bool SA_AddReader(Reader stReader, int iSettingsId) { StringBuilder sLogStr = new StringBuilder(); int iReaderId; int iAntennasIdx; sLogStr.AppendFormat("come in SA_AddReader \r\n the reader info:ipaddress[{0}], numAntennas[{1}], rxPower[{2}] ", stReader.IPaddress, stReader.numAntennas, stReader.rxPower); Log.WriteLog(LogType.Trace, sLogStr); try { //生成lts的reader节点 LTS.Reader oReader = new LTS.Reader(); oReader.SettingsID = iSettingsId; oReader.IPaddress = stReader.IPaddress; oReader.NumAntennas = stReader.numAntennas; oReader.ReaderType = stReader.iReaderType; //通过dat接口将reader节点数据插入数据库 iReaderId = DAT.DataAccess.AddReader(oReader); if (iReaderId == -1) { Log.WriteLog(LogType.Error, "error to call DataAccess.AddReader"); return(false); } sLogStr.Length = 0; sLogStr.AppendFormat("success to add reader record with id[{0}], IPaddress[{1}],NumAntennas[{2}],SettingsID[{3}]", iReaderId, oReader.IPaddress, oReader.NumAntennas, oReader.SettingsID); Log.WriteLog(LogType.Trace, sLogStr); for (iAntennasIdx = 0; iAntennasIdx < stReader.numAntennas; iAntennasIdx++) { if (!SA_AddAntenna(stReader.antenna[iAntennasIdx], iReaderId)) { Log.WriteLog(LogType.Error, "call AddAntenna error"); return(false); } } return(true); } catch (Exception ex) { Log.WriteLog(LogType.Error, "TraceLog Error:" + ex.Message.ToString()); return(false); } }
public static LTS.Reader GetReaderItemByID(int?ReaderID) { LTS.Reader reader = new LTS.Reader(); try { using (LTS.LTSBase access = new LTS.LTSDC()) { reader = access.Reader.Where(o => o.ReaderID == ReaderID).FirstOrDefault(); } } catch (Exception ex) { } return(reader); }
public static int AddReader(LTS.Reader reader) { int?ReaderID = -1; try { using (LTS.LTSBase access = new LTS.LTSDC()) { access.InsertReader(reader.IPaddress, reader.NumAntennas, reader.SettingsID, ref ReaderID); } } catch (Exception ex) { } return(ReaderID.Value); }
public static bool UpdateReader(LTS.Reader reader) { bool completed = false; try { using (LTS.LTSBase access = new LTS.LTSDC()) { access.UpdateReader(reader.IPaddress, reader.NumAntennas, reader.SettingsID, reader.ReaderID); completed = true; } } catch (Exception ex) { completed = false; } return(completed); }
private void btnAdd_Click(object sender, EventArgs e) { try { lblReader.Visible = false; lblName.Visible = false; lblStore.Visible = false; int readerNum = dataGridViewReaders.Rows.Count; int antToAdd = 0; int antAdded = 0; int antToDel = 0; int antDeleted = 0; int rToDel = 0; int rDeleted = 0; bool done = false; LTS.Settings s; bool fail = false; if (comboBoxStore.DataSource != null && listS.Where(u => u.StoreName == comboBoxStore.SelectedItem.ToString()).FirstOrDefault() != null) { if (comboBoxSettingsName.DataSource != null && setList.Where(u => u.SettingsName == comboBoxSettingsName.SelectedItem.ToString()).FirstOrDefault() != null) { if (txtNewSettingsName.Text == "") { int index = comboBoxSettingsName.SelectedIndex; s = setList[index]; done = true; } else { int index = comboBoxSettingsName.SelectedIndex; s = setList[index]; s.SettingsName = txtNewSettingsName.Text; done = DAT.DataAccess.UpdateSettings(s); } if (done) { if (readerNum > 0) { List <Reader> toAdd = reader.Where(i => i.readerID == 0).ToList(); if (toAdd != null) { for (int q = 0; q < toAdd.Count; q++) { LTS.Reader r = new LTS.Reader(); r.IPaddress = toAdd[q].IPaddress; r.NumAntennas = toAdd[q].numAntennas; r.SettingsID = s.SettingsID; antToAdd = antToAdd + toAdd[q].antenna.Count; int rid = DAT.DataAccess.AddReader(r); if (rid != -1) { for (int y = 0; y < toAdd[q].antenna.Count; y++) { LTS.Antenna a = new LTS.Antenna(); a.AntennaNumber = toAdd[q].antenna[y].antennaNumber; a.ReaderID = rid; a.TxPower = toAdd[q].antenna[y].txPower; a.RxPower = toAdd[q].antenna[y].rxPower; int aid = DAT.DataAccess.AddAntenna(a); if (aid != -1) { antAdded++; } else { MessageBox.Show("Sorry, something went wrong, the setting was not updated!"); ((Main)this.Parent.Parent).ChangeView <Settings.Settings>(); } } } else { MessageBox.Show("Sorry, something went wrong, the setting was not updated!"); ((Main)this.Parent.Parent).ChangeView <Settings.Settings>(); } } if (antAdded == antToAdd) { List <Reader> stay = new List <Reader>(); stay = reader.Where(i => i.readerID != 0).ToList(); for (int x = 0; x < stay.Count; x++) { Reader b = new Reader(); b = stay[x]; Reader c = new Reader(); c = readerBackUp.Where(t => t.readerID == b.readerID).FirstOrDefault(); if (c != null) { int ind = readerBackUp.IndexOf(c); readerBackUp.RemoveAt(ind); } } if (readerBackUp.Count != 0) { rToDel = readerBackUp.Count; for (int r = 0; r < readerBackUp.Count; r++) { antToDel = antToDel + readerBackUp[r].numAntennas; for (int z = 0; z < readerBackUp[r].antenna.Count; z++) { int aid = readerBackUp[r].antenna[z].antennaID; bool remA = DAT.DataAccess.RemoveAntenna(aid); if (remA) { antDeleted++; } else { MessageBox.Show("Sorry, something went wrong, the setting was not updated!"); ((Main)this.Parent.Parent).ChangeView <Settings.Settings>(); } } int reID = readerBackUp[r].readerID; bool remR = DAT.DataAccess.RemoveReader(reID); if (remR) { rDeleted++; } else { MessageBox.Show("Sorry, something went wrong, the setting was not updated!"); ((Main)this.Parent.Parent).ChangeView <Settings.Settings>(); } } if (antDeleted == antToDel && rDeleted == rToDel) { MessageBox.Show("The setting was updated succesfully!"); ((Main)this.Parent.Parent).ChangeView <Settings.Settings>(); } else { MessageBox.Show("Sorry, something went wrong, the setting was not updated!"); ((Main)this.Parent.Parent).ChangeView <Settings.Settings>(); } } else { MessageBox.Show("The setting was updated succesfully!"); ((Main)this.Parent.Parent).ChangeView <Settings.Settings>(); } } else { MessageBox.Show("Sorry, something went wrong, the setting was not updated!"); ((Main)this.Parent.Parent).ChangeView <Settings.Settings>(); } } else { MessageBox.Show("Sorry, something went wrong, the setting was not updated!"); ((Main)this.Parent.Parent).ChangeView <Settings.Settings>(); } } else { lblReader.Visible = true; } } else { MessageBox.Show("Sorry, something went wrong, the setting was not updated!"); ((Main)this.Parent.Parent).ChangeView <Settings.Settings>(); } } else { lblName.Visible = true; if (readerNum > 0) { } else { lblReader.Visible = true; } } } else { lblStore.Visible = true; if (comboBoxSettingsName.DataSource != null && setList.Where(u => u.SettingsName == comboBoxSettingsName.SelectedItem.ToString()).FirstOrDefault() != null) { } else { lblName.Visible = true; } if (readerNum > 0) { } else { lblReader.Visible = true; } } } catch (Exception ex) { MessageBox.Show("Sorry Something went wrong, the action was not completed!"); } }
private void btnAdd_Click(object sender, EventArgs e) { try { int totalNum = 0; lblName.Visible = false; lblReader.Visible = false; lblStore.Visible = false; lblAntenna.Visible = false; lblIP.Visible = false; string name = txtSettingsName.Text; if (name != "") { if (comboBoxStore.DataSource != null && listS.Where(u => u.StoreName == comboBoxStore.SelectedItem.ToString()).FirstOrDefault() != null) { if (reader.Count != 0) { int index = comboBoxStore.SelectedIndex; int storeID = listS[index].StoreID; sm.StoreID = storeID; sm.SettingsName = name; sm.SettingsSelect = false; for (int x = 0; x < reader.Count; x++) { ReaderMain rm = new ReaderMain(); rm.IPaddress = reader[x].IPaddress; rm.NumAntennas = reader[x].numAntennas; for (int y = 0; y < reader[x].antenna.Count; y++) { LTS.Antenna a = new LTS.Antenna(); a.AntennaNumber = reader[x].antenna[y].antennaNumber; a.RxPower = reader[x].antenna[y].rxPower; a.TxPower = reader[x].antenna[y].txPower; rm.antennas.Add(a); } sm.Readers.Add(rm); } LTS.Settings set = new LTS.Settings(); set.SettingsName = sm.SettingsName; set.SettingsSelect = sm.SettingsSelect; set.StoreID = sm.StoreID; int setDone = DAT.DataAccess.AddSettings(set); if (setDone != -1) { sm.SettingsID = setDone; for (int a = 0; a < sm.Readers.Count; a++) { LTS.Reader r = new LTS.Reader(); r.IPaddress = sm.Readers[a].IPaddress; r.NumAntennas = sm.Readers[a].NumAntennas; r.SettingsID = sm.SettingsID; int rid = DAT.DataAccess.AddReader(r); if (rid != -1) { sm.Readers[a].ReaderID = rid; for (int b = 0; b < sm.Readers[a].antennas.Count; b++) { LTS.Antenna ant = new LTS.Antenna(); ant.AntennaNumber = sm.Readers[a].antennas[b].AntennaNumber; ant.RxPower = sm.Readers[a].antennas[b].RxPower; ant.TxPower = sm.Readers[a].antennas[b].TxPower; ant.ReaderID = sm.Readers[a].ReaderID; int aid = DAT.DataAccess.AddAntenna(ant); if (aid != -1) { totalNum = totalNum + 1; } else { MessageBox.Show("Sorry, something went wrong, the setting was not added!"); ((Main)this.Parent.Parent).ChangeView <Settings>(); break; } } if (totalNum == sm.TotalAmountAntennas()) { MessageBox.Show("The setting was added successfully!"); ((Main)this.Parent.Parent).ChangeView <Settings>(); } else { MessageBox.Show("Sorry, something went wrong, the setting was not added!"); ((Main)this.Parent.Parent).ChangeView <Settings>(); } } else { MessageBox.Show("Sorry, something went wrong, the setting was not added!"); ((Main)this.Parent.Parent).ChangeView <Settings>(); break; } } } else { MessageBox.Show("Sorry, something went wrong, the setting was not added!"); ((Main)this.Parent.Parent).ChangeView <Settings>(); } } else { lblReader.Visible = true; } } else { lblStore.Visible = true; } } else { lblName.Visible = true; } } catch (Exception ex) { MessageBox.Show("Sorry Something went wrong, the action was not completed!"); } }