//保存antenna信息 private static bool SaveAntennaInfo(ref ReaderMain rm, int iReaderId) { DataSet stDs; DataTable stDt; Log.WriteLog(LogType.Trace, "come in SaveAntennaInfo"); string sSql = "select * from Antenna where ReaderID = " + iReaderId + " order by AntennaID;"; try { stDs = SqlAccess.GetDataSet(sSql); Log.WriteLog(LogType.Trace, "success to get reader[" + iReaderId + "] antenna info from db"); stDt = stDs.Tables[0]; if (stDt.Rows.Count > 0) { for (int iIdx = 0; iIdx < stDt.Rows.Count; iIdx++) { DataRow stDr = stDt.Rows[iIdx]; LTS.Antenna stAnt = new LTS.Antenna(); stAnt.AntennaID = Int32.Parse(stDr["AntennaID"].ToString()); stAnt.ReaderID = Int32.Parse(stDr["ReaderID"].ToString()); stAnt.RxPower = decimal.Parse(stDr["RxPower"].ToString()); stAnt.TxPower = decimal.Parse(stDr["TxPower"].ToString()); stAnt.AntennaNumber = Int32.Parse(stDr["AntennaNumber"].ToString()); rm.antennas.Add(stAnt); Log.WriteLog(LogType.Trace, "success to save reader[" + iReaderId + "] antenna[" + stAnt.AntennaNumber + "] info:antennid[" + stAnt.AntennaID + "], " + "RxPower[" + stAnt.RxPower + "], TxPower[" + stAnt.TxPower + "]"); } } else { Log.WriteLog(LogType.Trace, "info:there is not antenna with reader[" + iReaderId + "]"); return(true); } } catch (Exception ex) { Log.WriteLog(LogType.Error, "error to call GetDataSet"); return(false); } return(true); }
public static LTS.Antenna GetAntennaItemByID(int?AntennaID) { LTS.Antenna antenna = new LTS.Antenna(); try { using (LTS.LTSBase access = new LTS.LTSDC()) { antenna = access.Antenna.Where(o => o.AntennaID == AntennaID).FirstOrDefault(); } } catch (Exception ex) { } return(antenna); }
public static int AddAntenna(LTS.Antenna antenna) { int?AntennaID = -1; try { using (LTS.LTSBase access = new LTS.LTSDC()) { access.InsertAntenna(antenna.AntennaNumber, antenna.ReaderID, antenna.RxPower, antenna.TxPower, ref AntennaID); } } catch (Exception ex) { } return(AntennaID.Value); }
public static bool UpdateAntenna(LTS.Antenna antenna) { bool completed = false; try { using (LTS.LTSBase access = new LTS.LTSDC()) { access.UpdateAntenna(antenna.AntennaNumber, antenna.ReaderID, antenna.RxPower, antenna.TxPower, antenna.AntennaID); completed = true; } } catch (Exception ex) { completed = false; } return(completed); }
/*向reader增加一个天线信息*/ public static bool SA_AddAntenna(antenna stAntenna, int iReaderId) { StringBuilder sLogStr = new StringBuilder(); int iAntennaId; sLogStr.AppendFormat("come in SA_AddAntennas \r\n antennaNumber[{0}], txPower[{1}], rxPower[{2}], readerId[{3}] ", stAntenna.antennaNumber, stAntenna.txPower, stAntenna.rxPower, iReaderId); Log.WriteLog(LogType.Trace, sLogStr); try { LTS.Antenna oAntenna = new LTS.Antenna(); //lts下的数据类型,用来保存将要和数据库交互的数据 oAntenna.AntennaNumber = stAntenna.antennaNumber; oAntenna.TxPower = stAntenna.txPower; oAntenna.RxPower = stAntenna.rxPower; oAntenna.ReaderID = iReaderId; iAntennaId = DAT.DataAccess.AddAntenna(oAntenna); if (iAntennaId == -1) { Log.WriteLog(LogType.Error, "error to call DataAccess.AddAntenna"); return(false); } sLogStr.Length = 0; sLogStr.AppendFormat("success to add antenna record with id[{0}],AntennaNumber[{1}],TxPower[{2}],RxPower[{3}],ReaderID[{4}]", iAntennaId, oAntenna.AntennaNumber, oAntenna.TxPower, oAntenna.RxPower, oAntenna.ReaderID); Log.WriteLog(LogType.Trace, sLogStr); return(true); } catch (Exception ex) { Log.WriteLog(LogType.Error, "TraceLog Error:" + ex.Message.ToString()); return(false); } }
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!"); } }