private static DataSet GetChildren(SuperKeyDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.SuperKeyChildrenGet " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, SuperKeyDataModel.DataColumns.SuperKeyId);
var oDT = new DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
static public DataSet DeleteChildren(ReleaseLogStatusDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ReleaseLogStatusChildrenDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ReleaseLogStatusDataModel.DataColumns.ReleaseLogStatusId);
var oDT = new DBDataSet("Delete Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
private static DataSet GetChildren(FunctionalityImageInstanceDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FunctionalityImageInstanceChildrenGet " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FunctionalityImageInstanceDataModel.DataColumns.FunctionalityImageInstanceId);
var oDT = new DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataSet DeleteChildren(ActivityDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ActivityChildrenDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ActivityDataModel.DataColumns.ActivityId);
var oDT = new DBDataSet("Activity.DeleteChildren", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataSet DeleteChildren(FunctionalityXFunctionalityDevelopmentStepDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FunctionalityXFunctionalityDevelopmentStepChildrenDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FunctionalityXFunctionalityDevelopmentStepDataModel.DataColumns.FunctionalityXFunctionalityDevelopmentStepId);
var oDT = new DBDataSet("FunctionalityXFunctionalityDevelopmentStep.DeleteChildren", sql, DataStoreKey);
return(oDT.DBDataset);
}
private static DataSet GetChildren(ApplicationRoleDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ApplicationRoleChildrenGet " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, ApplicationRoleDataModel.DataColumns.ApplicationRoleId);
var oDT = new DBDataSet("ApplicationRole.GetChildren", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static DataSet DeleteChildren(TaskStatusTypeDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.TaskStatusTypeChildrenDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, TaskStatusTypeDataModel.DataColumns.TaskStatusTypeId);
var oDT = new DBDataSet("TaskStatusType.DeleteChildren", sql, DataStoreKey);
return(oDT.DBDataset);
}
public bool OpenMainDataSet(string sCon)
{
bool bIsOK = false;
string strX = "";
string sSql = "";
string sErr = "";
bDSIsOpenForMain = false;
grdList.AutoGenerateColumns = false;
grdList.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DBDataSet.Clear();
sSql = "select * from " + strTbNameMain + sCon; //SQL语句 或 存储过程名 若有参数，另外在参数集里增加
DBDataSet = SunEast.App.PubDBCommFuns.GetDataBySql(sSql, strTbNameMain, 0, 0, out sErr);
bIsOK = DBDataSet != null;
if (bIsOK)
{
bIsOK = DBDataSet.Tables[0].Rows[0][0].ToString().Trim() == "0";
}
//if (bIsOK)
//{
// DBDataSet.Clear();
// tbX = new DataTable(strTbNameMain);
// tbX = dsX.Tables["data"].Copy();
// DBDataSet.Tables.Add(tbX);
//}
if (!bIsOK)
{
MessageBox.Show(sErr);
}
else
{
try
{
bDSIsOpenForMain = true;
this.bdsMain.DataSource = DBDataSet.Tables[strTbNameMain];
BindDataSetToCtrls();
ClearUIValues(pnlEdit);
if (bdsMain.Count > 0)
{
DataRowViewToUI((DataRowView)bdsMain.Current, pnlEdit);
}
bIsOK = true;
optMain = OperateType.optNone;
btn_SetPwd.Visible = false;
btn_SetPwd.Enabled = false;
}
catch (Exception e)
{
MessageBox.Show(e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
bIsOK = false;
}
}
return(bIsOK);
}
private IEnumerable<UnitWrapper> getUnitsFromDataTable(DBDataSet.UnitDataTable tbl)
{
DiciplineAccess da = new DiciplineAccess();
return tbl.Select(unit => new UnitWrapper()
{
UnitCode = unit.UnitCode,
Dicipline = da.GetDicipline(unit.UnitCode),
Name = unit.Name,
Description = unit.Description,
Response = GetResponses(unit.UnitCode).ToList()
});
}
public static DataSet ReleaseNotesSearch(ReleaseLogDetailDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.ReleaseNotesSearch" +
" " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMax) +
", " + ToSQLParameter(data, ReleaseLogDetailDataModel.DataColumns.ReleaseDateMin) +
SearchParameter(data, requestProfile);
var oDs = new DBDataSet("ReleaseLog.ReleaseNotesSearch", sql, DataStoreKey);
return(oDs.DBDataset);
}
public static DataSet SearchByKey(SearchKeyDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.SearchKeySearchByKey " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, SearchKeyDataModel.DataColumns.SearchKeyId);
var oDT = new DBDataSet("SearchKey.Search", sql, DataStoreKey);
return(oDT.DBDataset);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
DBDataSet ds = new DBDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public void ButtonAddTemplate(object sender, RoutedEventArgs e)
{
DBDataSet dataSet = new DBDataSet();
dataSet.AccessRights = 0;
dataSet.FingerID = m_SEN0188SQLite.getFreeFingerId();
dataSet.FirstName = "John";
dataSet.SecondName = "Doe";
System.Text.ASCIIEncoding enc = new System.Text.ASCIIEncoding();
dataSet.SensorId = enc.GetBytes(SensorIDValue.Text);
m_SEN0188SQLite.InsertDataSet(dataSet);
m_SEN0188SQLite.GetDataSets();
DataSets.SelectedItem = m_SEN0188SQLite.getDatabyId(dataSet.FingerID);
}
public static void FillDataSet(DBDataSet aDBDataSet)
{
try
{
Helper.Instance.con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from Customer ", Helper.Instance.con);
da.Fill(aDBDataSet, "Customer");
Helper.Instance.con.Close();
}
catch (Exception ex)
{
MessageBox.Show("ERROR IN *Customers* MGMT (FillDataSet FUNCTION) EX=" + ex.Message.ToString());
}
}
public static DataSet SearchView(ScheduleDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.ScheduleViewSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, ScheduleDataModel.DataColumns.ScheduleId) +
", " + ToSQLParameter(data, ScheduleDataModel.DataColumns.PersonId) +
", " + ToSQLParameter(data, ScheduleDataModel.DataColumns.ScheduleStateId) +
", " + ToSQLParameter(data, ScheduleDataModel.DataColumns.FromSearchDate) +
", " + ToSQLParameter(data, ScheduleDataModel.DataColumns.ToSearchDate);
var oDs = new DBDataSet("Schedule.Search", sql, DataStoreKey);
return(oDs.DBDataset);
}
public async void ButtonEditTemplate(object sender, RoutedEventArgs e)
{
if (DataSets.SelectedItem == null)
{
return;
}
DBDataSet dataSet = DataSets.SelectedItem as DBDataSet;
if (dataSet != null)
{
m_SEN0188SQLite.UpdateDataSet(dataSet);
// m_SEN0188SQLite.GetDataSets();
m_Environment.IsAuthorized = m_Environment.IsLoggedIn && await m_Environment.checkAuthorizationAsync(m_Environment.User);
}
}
/*
#region 私有变量
* string strTbNameMain = "TWC_WareHouse";
* string strKeyFld = "cWHId";
* bool bDSIsOpenForMain = false;
* //主表操作
* OperateType optMain = OperateType.optNone;
* //记录当前数据列表的 条件
* StringBuilder sbConndition = new StringBuilder("");
#endregion
*/
//public
private bool BandDataSet(string SqlStrConditon, DataGridView FDataGridView)
{
bool Result = true;
try
{
string SqlStr = "";
string ErrStr = "";
bDSIsOpenForMain = false;
FDataGridView.AutoGenerateColumns = false;
FDataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DBDataSet.Clear();
SqlStr = "SELECT * FROM " + strTbNameMain + " " + SqlStrConditon;
Cursor.Current = Cursors.WaitCursor;
DBDataSet = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, false, SqlStr, strTbNameMain, 0, 0, "dDate,dCreateDate,dCheckDate", out ErrStr);
Result = DBDataSet != null;
bindingSource_Main.DataSource = DBDataSet.Tables[strTbNameMain];;
FDataGridView.DataSource = bindingSource_Main;
Cursor.Current = Cursors.Default;
string sId = "";
if (bindingSource_Main.Count > 0)
{
DataRowView drv = (DataRowView)bindingSource_Main.Current;
sId = drv[strKeyFld].ToString().Trim();
try
{
bDSIsOpenForMain = true;
DataRowViewToUI(drv, panel_Edit);
OptMain = OperateType.optNone;
}
catch (Exception e)
{
bDSIsOpenForMain = false;
MessageBox.Show(e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
Result = false;
}
}
BandDataSetDetail(" where cBNo='" + sId.Trim() + "'", dataGridView_Detail);
}
catch (Exception ei)
{
MessageBox.Show(ei.Message);
}
return(Result);
}
private void btnguncelle_Click(object sender, EventArgs e)
{
int index = 1;
adapter = new OleDbDataAdapter("SELECT * FROM [LISTE]", baglanti);
ds = new DBDataSet();
baglanti.Open();
adapter.Fill(ds, "LISTE");
baglanti.Close();
cmdb = new OleDbCommandBuilder(adapter);
foreach (TextBox txt in this.Controls.OfType <TextBox>())
{
cmdb = new OleDbCommandBuilder(adapter);
row = ds.Tables["LISTE"].Rows[comboBox1.SelectedIndex];
MessageBox.Show(row[index] + "");
index++;
}
}
//Wczytywanie pliku XML z operacjami na pozycji magazynowej i sprawdzenie danych
private void loadDatabase()
{
try
{
string filePath = "db.xml";
DBDataSet.ReadXml(filePath);
dataGridWarehouse.DataSource = DBDataSet;
dataGridWarehouse.DataMember = "transakcja";
}
catch (FileNotFoundException ex)
{
MessageBox.Show("Nie można załadować bazy danych." + ex);
}
catch (ArgumentException ex)
{
MessageBox.Show("Nie można załadować bazy danych." + ex);
}
}
public async void ButtonAddLoggedInUserTemplate(object sender, RoutedEventArgs e)
{
if (m_Environment.User == null)
{
return;
}
DBDataSet dataSet = new DBDataSet();
dataSet.AccessRights = 0x01; // Master Access
dataSet.FingerID = m_SEN0188SQLite.getFreeFingerId();
dataSet.FirstName = m_Environment.User.GivenName;
dataSet.SecondName = m_Environment.User.Surname;
System.Text.ASCIIEncoding enc = new System.Text.ASCIIEncoding();
dataSet.SensorId = enc.GetBytes(SensorIDValue.Text);
m_SEN0188SQLite.InsertDataSet(dataSet);
m_SEN0188SQLite.GetDataSets();
DataSets.SelectedItem = m_SEN0188SQLite.getDatabyId(dataSet.FingerID);
m_Environment.IsAuthorized = m_Environment.IsLoggedIn && await m_Environment.checkAuthorizationAsync(m_Environment.User);
}
public void ButtonDeleteTemplate(object sender, Windows.UI.Xaml.RoutedEventArgs e)
{
if (DataSets.SelectedItem == null)
{
return;
}
DBDataSet dataSet = DataSets.SelectedItem as DBDataSet;
if (dataSet != null)
{
m_SEN0188SQLite.DelDataSetByFingerId(dataSet.FingerID);
if (m_Environment.SensorInitialized)
{
SensorCMDs.DeleteFingerId(m_Sensorinputconfigoptions, (UInt16)dataSet.FingerID);
}
m_SEN0188SQLite.GetDataSets();
}
}
public List <Dictionary <string, string> > GetODBCData(string connectionString, string queryString)
{
var data = new List <Dictionary <string, string> >();
using (var dbConnection = new ODBConnection(connectionString))
using (var dataSet = new DBDataSet(dbConnection, queryString))
{
var cols = dataSet.ColumnNames;
while (dataSet.MoveNext())
{
var dic = new Dictionary <string, string>();
foreach (var col in cols)
{
dic[col] = dataSet.GetValue(col);
}
data.Add(dic);
}
}
return(data);
}
void Update_SEN0188_NotifyChangeState(IPropertySet Outputpropertys)
{
ProcessGPIOEvents ev;
Object Valout;
Int16 state = -1;
String cmdState = "...";
bool doactFilledSensorId = false;
if (Outputpropertys.TryGetValue("FingerPrint.CMDState", out Valout))
{
if (Valout != null)
{
state = (Int16)Valout;
}
}
if (Outputpropertys.TryGetValue("FingerPrint.CMDTextState", out Valout))
{
String cmd = Valout as String;
if (cmd != null)
{
cmdState = cmd;
}
}
if (Outputpropertys.TryGetValue("FingerPrint.CMD", out Valout))
{
if (Valout != null)
{
Int32 CMD = (Int32)Valout;
if (CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerSensorInitialize"))
{
if (state == 0)
{
m_Environment.SensorInitialized = true;
// m_SensorInitialized = true;
doactFilledSensorId = true;
}
}
else if (CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerAutoVerifiying"))
{
if (m_EventQueue.Count > 0)
{
ev = m_EventQueue.Dequeue(); // get Event
}
else
{
return;
}
if (state == 0)
{
if (Outputpropertys.TryGetValue("FingerPrint.FingerID", out Valout))
{
if (Valout != null)
{
UInt16 fingerId = (UInt16)Valout;
if (Outputpropertys.TryGetValue("FingerPrint.Search_MatchScore", out Valout))
{
UInt16 MatchScore = (UInt16)Valout;
DBDataSet dataset = m_SEN0188SQLite.getDatabyId(fingerId);
if (dataset != null)
{
FingerEvent eventSet;
if (dataset.AccessRights_Bit0 || (dataset.AccessRights & ev.AccessRights) != 0) // Master Bit
{
ev.UpdateState(0); // update inativ setzen
ev.ProcessOutput();
cmdState = String.Format("Permission to Access: {0}", ev.Ident);
eventSet = createSensorEvent(dataset.FirstName, dataset.SecondName, MatchScore, fingerId, ev.Ident, state, cmdState);
ProcessGPIOEvents evOk = getProcessGPIOEventsByIdent("State_OK");
if (evOk != null)
{
evOk.ProcessOutput();
}
ev.UpdateState(1); // update aktiv setzen
}
else
{
cmdState = String.Format("no Permission to Access: {0}", ev.Ident);
state = -2;
eventSet = createSensorEvent(dataset.FirstName, dataset.SecondName, MatchScore, fingerId, ev.Ident, state, cmdState);
ProcessGPIOEvents evNoPermiss = getProcessGPIOEventsByIdent("State_NoPermiss");
if (evNoPermiss != null)
{
evNoPermiss.UpdateState(0); // update inativ setzen
evNoPermiss.ProcessOutput();
evNoPermiss.UpdateState(1); // update aktiv setzen
}
}
bool insert = m_FingertEventDatabase.InsertFingerEvent(eventSet);
NotifyEvent?.Invoke(this, eventSet);
}
}
}
}
}
else
{
FingerEvent eventSet = createSensorEvent("John", "Doe", -1, -1, ev.Ident, state, cmdState);
ProcessGPIOEvents evStateError = getProcessGPIOEventsByIdent("State_Error");
if (evStateError != null)
{
evStateError.UpdateState(0); // update inativ setzen
evStateError.ProcessOutput();
evStateError.UpdateState(1); // update aktiv setzen
}
;
bool insert = m_FingertEventDatabase.InsertFingerEvent(eventSet);
NotifyEvent?.Invoke(this, eventSet);
}
}
}
}
if (doactFilledSensorId)
{
// m_SensorId.Clear();
if (Outputpropertys.TryGetValue("FingerPrint.SensorID", out Valout))
{
if (Valout != null)
{
byte[] array = Valout as byte[];
if (array != null)
{
m_SensorID = System.Text.Encoding.UTF8.GetString(array, 0, array.Length);
}
}
}
}
}
private void ReadDB(string _strfilename, int _irobotid)
{
this.iRobotID = _irobotid;
this.strDBPath = _strfilename;
DSDatabase = new DBDataSet();
DSDatabase.Disposed += new EventHandler(DSDatabase_Disposed);
if (this.bDataSetFilled = dbHandler.bFillDataSet(DSDatabase, this.strDBPath))
{
SetStatusText("DB succesfully loaded!");
if (robotSerialPort.IsOpen) connectionButton_Click(null, null);
refreshPortsButton_Click(null, null);
refreshBaudRatesButton_Click(null, null);
Reading();
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
DBDataSet ds = new DBDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
void Update_SEN0188_NotifyChangeState(IPropertySet Outputpropertys)
{
bool doactFilledFingerLib = false;
bool doactFilledSensorId = false;
Object Valout;
Int16 state = -1;
if (Outputpropertys.TryGetValue("FingerPrint.CMDState", out Valout))
{
if (Valout != null)
{
state = (Int16)Valout;
}
}
if (Outputpropertys.TryGetValue("FingerPrint.CMD", out Valout))
{
if (Valout != null)
{
Int32 CMD = (Int32)Valout;
if (CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerSensorInitialize"))
{
if (state == 0)
{
doactFilledFingerLib = true;
doactFilledSensorId = true;
m_Environment.SensorInitialized = true;
}
}
else if (CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerRegistration") || CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerAutoRegistration"))
{
if (Outputpropertys.TryGetValue("FingerPrint.RegististrationState", out Valout))
{
if (Valout != null)
{
Int32 regState = (Int32)Valout;
if (regState >= 5)
{
if (Outputpropertys.TryGetValue("FingerPrint.Registration_FingerID", out Valout))
{
UInt16 PageId = (UInt16)Valout;
if (state == 0)
{
if (Outputpropertys.TryGetValue("FingerPrint.CHARUpLoad", out Valout))
{
if (Valout != null)
{
byte[] array = Valout as byte[];
if (array != null)
{
DBDataSet dataset = m_SEN0188SQLite.getDatabyId(PageId);
if (dataset != null)
{
dataset.FingerTemplate = array;
if (SensorIDValue.Text.Length > 0)
{
dataset.SensorId = System.Text.Encoding.UTF8.GetBytes(SensorIDValue.Text);
}
this.m_SEN0188SQLite.UpdateFingerTemplateDataSet(dataset);
DataSets.SelectedItem = dataset;
doactFilledFingerLib = true;
}
}
}
}
}
}
}
}
}
}
else if (CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerDeleteId"))
{
if (state == 0)
{
doactFilledFingerLib = true;
}
}
else if (CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerAutoVerifiying"))
{
if (state == 0)
{
if (Outputpropertys.TryGetValue("FingerPrint.FingerID", out Valout))
{
if (Valout != null)
{
UInt16 fingerId = (UInt16)Valout;
if (Outputpropertys.TryGetValue("FingerPrint.Search_MatchScore", out Valout))
{
UInt16 MatchScore = (UInt16)Valout;
DBDataSet dataset = m_SEN0188SQLite.getDatabyId(fingerId);
if (dataset != null)
{
if (MatchScore > dataset.MatchScore)
{
dataset.MatchScore = MatchScore;
this.m_SEN0188SQLite.UpdateMatchScoreDataSet(dataset);
}
DataSets.SelectedItem = dataset;
}
else
{
DataSets.SelectedItem = null;
}
}
}
}
}
}
else if (CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerCharDownLoad"))
{
if (state == 0)
{ // dowwload succesfull
if (Outputpropertys.TryGetValue("FingerPrint.Registration_FingerID", out Valout))
{
UInt16 FingerId = (UInt16)Valout;
if (state == 0)
{
DBDataSet dataset = m_SEN0188SQLite.getDatabyId(FingerId);
if (dataset != null)
{
DataSets.SelectedItem = dataset;
doactFilledFingerLib = true;
}
else
{
DataSets.SelectedItem = null;
}
}
}
}
}
else if (CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerWriteSensorID"))// write Sensor-ID
{
if (state == 0)
{ // dowwload succesfull
doactFilledSensorId = true;
}
}
}
}
if (doactFilledSensorId)
{
// m_SensorId.Clear();
if (Outputpropertys.TryGetValue("FingerPrint.SensorID", out Valout))
{
if (Valout != null)
{
byte[] array = Valout as byte[];
if (array != null)
{
/*
* for (uint i = 0; i < array.Length; i++)
* {
* m_SensorId.Add(array[i]);
* }
*/
SensorIDValue.Text = System.Text.Encoding.UTF8.GetString(array, 0, array.Length);
}
}
}
}
if (doactFilledFingerLib)
{
m_FilledFingerLib.Clear();
if (Outputpropertys.TryGetValue("FingerPrint.FilledFingerLib", out Valout))
{
if (Valout != null)
{
UInt32[] array = Valout as UInt32[];
if (array != null)
{
for (uint i = 0; i < array.Length; i++)
{
m_FilledFingerLib.Add(array[i]);
}
}
}
}
}
if (Outputpropertys.TryGetValue("FingerPrint.CMDTextState", out Valout))
{
String cmd = Valout as String;
if (cmd != null)
{
SensorCmdState.Text = cmd;
}
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
DBDataSet ds = new DBDataSet();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "ProductosDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public virtual int Update(DBDataSet.ProductosDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
public bool OpenMainDataSet()
{
if (UserInformation.UType != UserType.utSupervisor)
{
strConnFix = " and cCmptId='" + UserInformation.UnitId + "'";
}
bool bIsOK = false;
string strX = "";
grdList.AutoGenerateColumns = false;
grdList.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DBDataSet.Clear();
DBCommInfo.DBSQLCommandInfo cmdInfo = new DBSQLCommandInfo(); //执行命令的对象
cmdInfo.SqlText = "select * from " + strTbNameMain + " where 1=1 " + sCondition + strConnFix; //SQL语句 或 存储过程名 若有参数，另外在参数集里增加
//if (UserInformation.UType != UserType.utSupervisor)
//{
// cmdInfo.SqlText = cmdInfo.SqlText + " where "+strKeyFld+"='"+ UserInformation.UnitId +"'"; //仅显示当前用户的单位
//}
cmdInfo.SqlType = SqlCommandType.sctSql; //SQL命令类型 SqlCommandType.sctSql SQL 语句 SqlCommandType.sctProcedure 表存储过程
cmdInfo.PageIndex = 0; //需要分页时的页号
cmdInfo.PageSize = 0; //需要分页时的每页记录条数
cmdInfo.FromSysType = "dotnet"; //采用处理结果数据的方式：php 表按照<tr><td></td></tr> xml 否则 直接采用ado 的记录集方式
cmdInfo.DataTableName = strTbNameMain; //指定结果数据记录集表名
SunEast.SeDBClient sdcX = new SeDBClient(); //获取服务器数据的类型对象
//sdcX.DBSTServer = DBSocketServerType.dbsstNormal; //自动根据配置文件读
string sErr = "";
//DataSet dsX = null;
//DataTable tbX= null ;
DBDataSet = sdcX.GetDataSet(cmdInfo, out sErr); //通过获取服务器数据对象的GetDataSet方法获取数据
bIsOK = DBDataSet != null;
//if (bIsOK)
//{
// DBDataSet.Clear();
// tbX = new DataTable(strTbNameMain);
// tbX = dsX.Tables["data"].Copy();
// DBDataSet.Tables.Add(tbX);
//}
if (!bIsOK)
{
MessageBox.Show(sErr);
}
else
{
try
{
//DBDataSet.Tables["data"].TableName = strTbNameMain;
//DataSetUnBind(pnlEdit);
ClearUIValues(pnlEdit);
bIsMainOpened = false;
this.bdsMain.DataSource = DBDataSet.Tables[strTbNameMain];
bIsMainOpened = true;
grdList.DataSource = bdsMain;
bdsMain_PositionChanged(null, null);
//if (bdsMain != null && bdsMain.Count > 0)
//{
// DataRowView drv = (DataRowView)bdsMain.Current;
// object objX = drv["cCmptId"];
// //DataRowViewToUI(drv, pnlEdit);
//}
bIsOK = true;
optMain = OperateType.optNone;
}
catch (Exception e)
{
MessageBox.Show(e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
bIsOK = false;
}
}
return(bIsOK);
}
void ButtonComWithSensor(Object sender, Windows.UI.Xaml.RoutedEventArgs e)
{
AppBarButton buttton = sender as AppBarButton;
if (buttton != null)
{
if (buttton.Name == "InitSensor")
{
SensorCMDs.InitSensor(m_Sensorinputconfigoptions);
m_Environment.SensorInitialized = false;
SensorIDValue.Text = "";
}
else if (buttton.Name == "RegisterFingerId")
{
if (DataSets.SelectedItem != null)
{
DBDataSet dataSet = DataSets.SelectedItem as DBDataSet;
if (dataSet != null)
{
SensorCMDs.RegisterFingerId(m_Sensorinputconfigoptions, (UInt16)dataSet.FingerID);
DataSets.SelectedItem = null;
}
}
}
else if (buttton.Name == "VerifyFingerId")
{
SensorCMDs.VerifyFingerId(m_Sensorinputconfigoptions);
DataSets.SelectedItem = null;
}
else if (buttton.Name == "DeleteallFingerIs")
{
SensorCMDs.DeleteFingerId(m_Sensorinputconfigoptions, (UInt16)10000);
}
else if (buttton.Name == "DownloadFingerId")
{
if (DataSets.SelectedItem != null)
{
DBDataSet dataSet = DataSets.SelectedItem as DBDataSet;
if (dataSet != null)
{
SensorCMDs.DownloadFingerId(m_Sensorinputconfigoptions, (UInt16)dataSet.FingerID, dataSet.FingerTemplate);
}
DataSets.SelectedItem = null;
}
}
else if (buttton.Name == "DownloadallFingerIds")
{
SensorCMDs.DeleteFingerId(m_Sensorinputconfigoptions, 10000); // delete complete FingerLib into Sensor
for (int i = 0; i < this.m_DataSets.Count; i++)
{
DBDataSet dataSet = m_DataSets[i];
SensorCMDs.DownloadFingerId(m_Sensorinputconfigoptions, (UInt16)dataSet.FingerID, dataSet.FingerTemplate);
}
DataSets.SelectedItem = null;
}
else if (buttton.Name == "SetSensorID")
{
byte[] SensorId = Encoding.ASCII.GetBytes(SensorIDValue.Text);
SensorCMDs.SetSensorID(m_Sensorinputconfigoptions, SensorId); // Set Sensor ID
SensorIDValue.Text = "";
DataSets.SelectedItem = null;
}
SensorCmdState.Text = "...";
}
}
public virtual int Fill(DBDataSet.ProductosDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
void Update_SEN0188_NotifyChangeState(IPropertySet Outputpropertys)
{
ProcessFingerEvent ev = m_EventQueue.Dequeue(); // get Event
Object Valout;
Int16 state = -1;
String cmdState = "...";
bool doactFilledSensorId = false;
if (Outputpropertys.TryGetValue("FingerPrint.CMDState", out Valout))
{
if (Valout != null)
{
state = (Int16)Valout;
}
}
if (Outputpropertys.TryGetValue("FingerPrint.CMDTextState", out Valout))
{
String cmd = Valout as String;
if (cmd != null)
{
cmdState = cmd;
}
}
if (Outputpropertys.TryGetValue("FingerPrint.CMD", out Valout))
{
if (Valout != null)
{
Int32 CMD = (Int32)Valout;
if (CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerSensorInitialize"))
{
if (state == 0)
{
// SensorInitialized = true;
doactFilledSensorId = true;
}
}
else if (CMD == Connector_SEN0188_CMDs.getFingerPrintCmd("_doFingerAutoVerifiying"))
{
if (state == 0)
{
if (Outputpropertys.TryGetValue("FingerPrint.FingerID", out Valout))
{
if (Valout != null)
{
UInt16 fingerId = (UInt16)Valout;
if (Outputpropertys.TryGetValue("FingerPrint.Search_MatchScore", out Valout))
{
UInt16 MatchScore = (UInt16)Valout;
DBDataSet dataset = m_SEN0188SQLite.getDatabyId(fingerId);
if (dataset != null)
{
if (dataset.AccessRights_Bit0 || (dataset.AccessRights & ev.AccessRights) != 0) // Master Bit
{
for (int i = 0; i < ev.GPIOOutputs.Count; i++)
{
// ev.GPIOOutputs[i].GPIOEnvironmentConnector.UpdateState(0);
ev.GPIOOutputs[i].GPIOObject.SetValue = (ev.GPIOOutputs[i].GPIOObject.InitValue > 0) ? 1:0;
ev.GPIOOutputs[i].GPIOEnvironmentConnector.UpdateInputPropertySets(ev.GPIOOutputs[i].GPIOObject);
}
FingerEvent eventSet = new FingerEvent();
eventSet.FirstName = dataset.FirstName;
eventSet.SecondName = dataset.SecondName;
eventSet.MatchScore = MatchScore;
eventSet.FingerID = fingerId;
eventSet.EventType = 0;
eventSet.SensorState = state;
eventSet.SensorTxtState = cmdState;
System.Text.ASCIIEncoding enc = new System.Text.ASCIIEncoding();
eventSet.SensorId = enc.GetBytes(m_SensorID);
bool insert = m_FingertEventDatabase.InsertFingerEvent(eventSet);
ConfigProcessItem outstate = m_ConfigProcessItems.getConfigItemByIdent("State_OK");
if (outstate != null)
{
for (int i = 0; i < outstate.GPIOOutputProcessItems.Count; i++)
{
// outstate.GPIOOutputProcessItems[i].GPIOName
}
}
// GetEventData();
}
else
{
ConfigProcessItem outstate = m_ConfigProcessItems.getConfigItemByIdent("State_NoPermiss");
if (outstate != null)
{
for (int i = 0; i < outstate.GPIOOutputProcessItems.Count; i++)
{
// outstate.GPIOOutputProcessItems[i].GPIOName
}
}
}
}
}
}
}
}
}
}
}
if (doactFilledSensorId)
{
// m_SensorId.Clear();
if (Outputpropertys.TryGetValue("FingerPrint.SensorID", out Valout))
{
if (Valout != null)
{
byte[] array = Valout as byte[];
if (array != null)
{
m_SensorID = System.Text.Encoding.UTF8.GetString(array, 0, array.Length);
}
}
}
}
}
private UserWrapper getUserWrapper(DBDataSet.UserRow tbl)
{
DiciplineAccess da=new DiciplineAccess();
UserWrapper uw = new UserWrapper
{
BirthDate = tbl.BirthDate,
FirstName = tbl.FirstName,
LastName = tbl.LastName,
Role = tbl.Role,
UserID = tbl.UserID,
UserName = tbl.Username,
Salt = tbl.Salt,
Password = tbl.Password,
Dicipline = GetDiciplinesByUserId(tbl.UserID).ToList(),
Subscriptions = GetSubscriptionsByUserId(tbl.UserID).ToList()
};
return uw;
}
public bool OpenMainDataSet()
{
//if (UserInformation.UType != UserType.utSupervisor)
//{
// strConnFix = " and cCmptId='" + UserInformation.UnitId + "'";
//}
bool bIsOK = false;
string strX = "";
string sErr = "";
grdList.AutoGenerateColumns = false;
grdList.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DBDataSet.Clear();
string sSql = "select * from " + strTbNameMain + " where 1=1 and cCSId='" + _CSId.Trim() + "'";
DBDataSet = DBFuns.GetDataBySql(AppInformation.SvrSocket, false, sSql, strTbNameMain, 0, 0, "", out sErr);
#region
//DBCommInfo.DBSQLCommandInfo cmdInfo = new DBSQLCommandInfo();//执行命令的对象
////cmdInfo.SqlText = "select * from " + strTbNameMain + " where 1=1 " + sCondition + strConnFix; //SQL语句 或 存储过程名 若有参数，另外在参数集里增加
//cmdInfo.SqlText = "select * from " + strTbNameMain + " where 1=1 and cCSId='"+ _CSId.Trim() +"'"; //SQL语句 或 存储过程名 若有参数，另外在参数集里增加
////if (UserInformation.UType != UserType.utSupervisor)
////{
//// cmdInfo.SqlText = cmdInfo.SqlText + " where "+strKeyFld+"='"+ UserInformation.UnitId +"'"; //仅显示当前用户的单位
////}
//cmdInfo.SqlType = SqlCommandType.sctSql; //SQL命令类型 SqlCommandType.sctSql SQL 语句 SqlCommandType.sctProcedure 表存储过程
//cmdInfo.PageIndex = 0; //需要分页时的页号
//cmdInfo.PageSize = 0; //需要分页时的每页记录条数
//cmdInfo.FromSysType = "dotnet"; //采用处理结果数据的方式：php 表按照<tr><td></td></tr> xml 否则 直接采用ado 的记录集方式
//cmdInfo.DataTableName = strTbNameMain; //指定结果数据记录集表名
//SunEast.SeDBClient sdcX = new SeDBClient(); //获取服务器数据的类型对象
////sdcX.DBSTServer = DBSocketServerType.dbsstNormal; //自动根据配置文件读
////DataSet dsX = null;
////DataTable tbX= null ;
//DBDataSet = sdcX.GetDataSet(cmdInfo, out sErr); //通过获取服务器数据对象的GetDataSet方法获取数据
#endregion
bIsOK = DBDataSet != null;
//if (bIsOK)
//{
// DBDataSet.Clear();
// tbX = new DataTable(strTbNameMain);
// tbX = dsX.Tables["data"].Copy();
// DBDataSet.Tables.Add(tbX);
//}
if (!bIsOK)
{
MessageBox.Show(sErr);
}
else
{
try
{
ClearUIValues(pnlEdit);
bIsMainOpened = false;
this.bdsMain.DataSource = DBDataSet.Tables[strTbNameMain];
bIsMainOpened = true;
BindDataSetToCtrls();
grdList.DataSource = bdsMain;
bIsOK = true;
optMain = OperateType.optNone;
}
catch (Exception e)
{
MessageBox.Show(e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
bIsOK = false;
}
}
return(bIsOK);
}
public bool OpenMainDataSet(string sCon)
{
bool bIsOK = false;
string strX = "";
bMainlstIsOpened = false;
grdList.AutoGenerateColumns = false;
grdList.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
DBDataSet.Clear();
DBCommInfo.DBSQLCommandInfo cmdInfo = new DBSQLCommandInfo(); //执行命令的对象
cmdInfo.SqlText = "select * from " + strTbNameMain + sCon; //SQL语句 或 存储过程名 若有参数，另外在参数集里增加
if (UserInformation.UType == UserType.utSupervisor)
{
cmdInfo.SqlText = "select * from " + strTbNameMain; //仅显示当前用户的单位
}
cmdInfo.SqlType = SqlCommandType.sctSql; //SQL命令类型 SqlCommandType.sctSql SQL 语句 SqlCommandType.sctProcedure 表存储过程
cmdInfo.PageIndex = 0; //需要分页时的页号
cmdInfo.PageSize = 0; //需要分页时的每页记录条数
cmdInfo.FromSysType = "dotnet"; //采用处理结果数据的方式：php 表按照<tr><td></td></tr> xml 否则 直接采用ado 的记录集方式
cmdInfo.DataTableName = strTbNameMain; //指定结果数据记录集表名
SunEast.SeDBClient sdcX = new SeDBClient(); //获取服务器数据的类型对象
//sdcX.DBSTServer = DBSocketServerType.dbsstNormal; //自动根据配置文件读
string sErr = "";
//DataSet dsX = null;
//DataTable tbX= null ;
DBDataSet = sdcX.GetDataSet(cmdInfo, out sErr); //通过获取服务器数据对象的GetDataSet方法获取数据
bIsOK = DBDataSet != null;
//if (bIsOK)
//{
// DBDataSet.Clear();
// tbX = new DataTable(strTbNameMain);
// tbX = dsX.Tables["data"].Copy();
// DBDataSet.Tables.Add(tbX);
//}
if (!bIsOK)
{
MessageBox.Show(sErr);
}
else
{
try
{
DataSetUnBind(pnlEdit);
this.bdsMain.DataSource = DBDataSet.Tables[strTbNameMain];
if (bdsMain != null && bdsMain.Count > 0)
{
BindDataSetToCtrls();
}
bIsOK = true;
optMain = OperateType.optNone;
}
catch (Exception e)
{
MessageBox.Show(e.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
bIsOK = false;
}
}
bMainlstIsOpened = true;
return(bIsOK);
}
public virtual int Update(DBDataSet dataSet) {
return this.Adapter.Update(dataSet, "Productos");
}
public bool Read(string _strfilename, int _iid)
{
this.ID = _iid;
this.DBPath = _strfilename;
if (DSDatabase != null) DSDatabase.Dispose();
DSDatabase = new DBDataSet();
if (dbHandler.bFillDataSet(DSDatabase, this.DBPath))
{
return Loader();
}
else return false;
}
public bool Read(string _strfilename)
{
DataTable dtrobot = new DataTable();
if (dbHandler.bFillDataTable(dtrobot, DBHandler.RobotQuery, _strfilename, true))
{
int irobotid = 0;
if (dtrobot.Rows.Count > 1)
{
DialogResult dr = MyMessageBox.Show("Selected database contains data for more than one robot.\r\nPlease choose which robot you want to use:", "Choose Robot", MyMessageBox.MyButtons.ChooseCancel, MyMessageBox.MyIcon.Question, MyMessageBox.RobotChooser.RobotChooser, dtrobot);
if (dr != DialogResult.Cancel) irobotid = -(Convert.ToInt32(dr));
}
else irobotid = Convert.ToInt32(dtrobot.Rows[0]["RobotID"]);
if (irobotid != 0)
{
if (DSDatabase != null) DSDatabase.Dispose();
this.ID = irobotid;
this.DBPath = _strfilename;
DSDatabase = new DBDataSet();
if (dbHandler.bFillDataSet(DSDatabase, this.DBPath))
{
return Loader();
}
else return false;
}
else return false;
}
else return false;
}
private void ReadDB(string _strfilename)
{
DataTable dtrobot = new DataTable();
if (dbHandler.bFillDataTable(dtrobot, DBHandler.RobotQuery, _strfilename, true))
{
int irobotid = 0;
if (dtrobot.Rows.Count > 1)
{
DialogResult dr = MyMessageBox.Show("Selected database contains data for more than one robot.\r\nPlease choose which robot you want to use:", "Choose Robot", MyMessageBox.MyButtons.ChooseCancel, MyMessageBox.MyIcon.Question, MyMessageBox.RobotChooser.RobotChooser, dtrobot);
if (dr != DialogResult.Cancel) irobotid = -(Convert.ToInt32(dr));
}
else irobotid = Convert.ToInt32(dtrobot.Rows[0]["RobotID"]);
if (irobotid != 0)
{
if (this.bDataSetFilled) CloseDB();
this.iRobotID = irobotid;
this.strDBPath = _strfilename;
DSDatabase = new DBDataSet();
DSDatabase.Disposed += new EventHandler(DSDatabase_Disposed);
if (this.bDataSetFilled = dbHandler.bFillDataSet(DSDatabase, this.strDBPath))
{
SetStatusText("DB succesfully loaded!");
if (robotSerialPort.IsOpen) connectionButton_Click(null, null);
refreshPortsButton_Click(null, null);
refreshBaudRatesButton_Click(null, null);
Reading();
}
}
}
}
