/// <summary> /// Hàm thực hiện lệnh /// </summary> /// <param name="pMyAction">Action pMyAction</param> private void PerformAction(Action pMyAction) { try { //CreateDeviceList(); switch (pMyAction) { case Action.Insert: DevicesListBusiness.InsertDevice(CreateDeviceList()); break; case Action.Update: DevicesListBusiness.UpdateDevice(CreateDeviceList()); break; case Action.Delete: DevicesListBusiness.DeleteDevice(CreateDeviceList()); break; } } catch (Exception) { throw; } }
/// <summary> /// Hàm lấy toàn bộ devices từ database đổ vào datagridview /// </summary> private void LoadAllDevices() { try { // grdDevices.SelectionChanged -= grdDevices_SelectionChanged; _tblDeviceTable = DevicesListBusiness.GetAllDevicesList(); // grdDevices.DataSource = _tblDeviceTable.DefaultView; grdDevices.DataSource = _tblDeviceTable; //grdDevices.SelectionChanged += grdDevices_SelectionChanged; grdDevices_SelectionChanged(grdDevices, new EventArgs()); } catch (Exception ex) { throw ex; } }
/// <summary> /// Fills the tree node para. /// </summary> private void FillTreeNodePara() { DataTable dtDevice; DataTable dtTestType; try { //Lấy ra tên loại Test dựa vào TestTypeID đổ vào datatable dtTestType = DevicesListBusiness.GetTestType(GvTestTypeId); foreach (DataRow drTestType in dtTestType.Rows) { var nodeTestType = new Node(); //node level 1 nodeTestType.Text = drTestType[TTestTypeList.Columns.TestTypeName].ToString(); // gán TestTypeName vào node nodeTestType.Expand(); //Lấy những thiết bị theo drTestType[TTestTypeList.Columns.TestTypeId] dtDevice = DevicesListBusiness.GetDeviceNameAndIdListByTestTypeId( drTestType[TTestTypeList.Columns.TestTypeId].ToString()); //danh sách tên thiết bị foreach (DataRow dr in dtDevice.Rows) { var nodeDeviceName = new Node(); //node level 2 nodeDeviceName.Text = dr[DDeviceList.Columns.DeviceName].ToString(); nodeDeviceName.CheckBoxVisible = true; nodeDeviceName.Editable = false; //Lấy Data Control theo thiết bị DataTable dt1 = CodeToCtrlEquip.GetDataControlForDevice(dr[DDeviceList.Columns.DeviceId].ToString()); foreach (DataRow dr1 in dt1.Rows) { //Lọc dữ liệu DataRow[] arrDr = GvDtParaEntry.Select("Para_Name='" + dr1[DDataControl.Columns.DataName] + "'"); if (arrDr.GetLength(0) > 0) { dr1.Delete(); } } dt1.AcceptChanges(); foreach (DataRow dr1 in dt1.Rows) { var cMale = new Cell(); cMale.Name = "cMale"; var cFemale = new Cell(); cFemale.Name = "cFemale"; var cUnit = new Cell(); cUnit.Name = "cUnit"; var nodeDataControl = new Node(); nodeDataControl.Text = dr1[DDataControl.Columns.DataName].ToString(); nodeDataControl.TagString = drTestType[TTestTypeList.Columns.TestTypeId].ToString(); cMale.Text = dr1[DDataControl.Columns.NormalLevel].ToString(); cFemale.Text = dr1[DDataControl.Columns.NormalLevelW].ToString(); cUnit.Text = dr1[DDataControl.Columns.MeasureUnit].ToString(); nodeDataControl.Cells.Add(cMale); nodeDataControl.Cells.Add(cFemale); nodeDataControl.Cells.Add(cUnit); nodeDataControl.CheckBoxVisible = true; nodeDeviceName.Nodes.Add(nodeDataControl); //gắn node level 2 vào node level } nodeTestType.Nodes.Add(nodeDeviceName); //gắn node level 1 vào node level 0 } treePara.Nodes.Add(nodeTestType); //gắn node level 0 vào tree } } catch (Exception ex) { MessageBox.Show(ex.Message); } }