/// <summary> /// Get the ResultsField associated with a PivotGridField /// </summary> /// <param name="Rf"></param> /// <param name="f0"></param> /// <returns></returns> internal ResultsField GetPivotGridFieldResultsField( PivotGridField pgf) { Query q = Rf.Query; string[] sa = pgf.UnboundFieldName.Split('.'); if (sa.Length < 2) { return(null); } QueryTable qt = q.GetTableByName(sa[0]); if (qt == null) { return(null); } QueryColumn qc = qt.GetQueryColumnByName(sa[1]); if (qc == null) { return(null); } ResultsField rfld = Rf.GetResultsField(qc); return(rfld); }
static void TraerPorCatego(VentaRepuestos E) { Validaciones V = new Validaciones(); ConsolaHelper H = new ConsolaHelper(); try { string _srtCodigoC; int _codigoC = 0; bool _flag1; do { _srtCodigoC = H.PedirCodigo("categoria"); _flag1 = V.ValidarCodigoRepuesto(_srtCodigoC, ref _codigoC); } while (!_flag1); if (E.TraerPorCategoria(_codigoC).Count == 0) { throw new ListaVaciaCategoriaException(); } else { foreach (Repuesto Rf in E.TraerPorCategoria(_codigoC)) { H.MostrarMensaje(Rf.ToString()); } } } catch (ListaVaciaCategoriaException e) { H.MostrarMensaje(e.Message); } }
/// <summary> /// Sets the cell san pham With SanPhamModel from outsite /// We need to save it to model of ChiTietHoaDon /// One HoaDon complete - create and pham /// </summary> /// <param name="value">The value.</param> public void SetCellSanPham(SanPhamModel value) { if (dataGridView != null) { if (dataGridView.Rows.Count > 0) { if (currentRowSelected != -1) { if (currentRowSelected < dataGridView.Rows.Count) { dataGridView.Rows[currentRowSelected].Selected = true; } else { currentRowSelected = 0; } } dataGridView.Rows[currentRowSelected].Cells[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value = (value == null) ? "-1" : value.MaGiayDep; if (value != null) { var m = dataGridView.Rows[currentRowSelected].Cells; for (int i = 0; i < currentListDataTable.Count; i++) { if (currentListDataTable.ElementAt(i).IDModel == m[Rf.Name <ChiTietHdnModel>(c => c.IDModel)].Value.ToString()) { currentListDataTable.ElementAt(i).SanPham = value.ToEntity(); } } } } } }
public static void Stop() { Trans?.Stop(); TileLifter?.Stop(); Ferry?.Stop(); Carrier?.Stop(); Rf?.Stop(); TrafficControl?.Stop(); }
/// <summary> /// Handles the Click event of the bntXoa control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> private void bntXoa_Click(object sender, EventArgs e) { List <DataGridViewRow> selectedRows = (from row in dataGridView.Rows.Cast <DataGridViewRow>() where Convert.ToBoolean(row.Cells["CB"].Value) select row).ToList(); if ( MessageBox.Show(string.Format("Bạn có chắc chắn xóa {0} đơn hàng này không?", selectedRows.Count), Resources.View_Confirm, MessageBoxButtons.YesNo) == DialogResult.Yes) { var s = (from row in dataGridView.Rows.Cast <DataGridViewRow>() where Convert.ToBoolean(row.Cells["CB"].Value) select row.Index).ToList(); if (s.Count == 0) { return; } for (int k = s.Count - 1; k >= 0; k--) { var i = s.ElementAt(k); var mx = dataGridView.Rows[i].Cells; for (int j = 0; j < currentListDataTable.Count; j++) { var m = currentListDataTable.ElementAt(j); if (m.IDModel == mx[Rf.Name <ChiTietHdbModel>(c => c.IDModel)].Value) { currentListDataTable.RemoveAt(j); break; } } dataSourceDataTable.Rows.RemoveAt(i); } //var dt = (DataTable) dataBindingSource.DataSource; //dataGridView.Rows.RemoveAt(); //dataGridView.Rows.Clear(); //controller.Delete(string.Join(",", s.ToArray())); //controller.ReviewGrid(); } if (dataSourceDataTable.Rows.Count == 0) { bntXoa.Enabled = false; bntLuaChon.Enabled = false; //bntLuu.Enabled = false; //bntTaoMoi.Enabled = true; } }
private static void CheckAndStart() { while (!PubMaster.IsReady) { Thread.Sleep(2000); } TileLifter?.Start(); Ferry?.Start(); Carrier?.Start(); Trans?.Start(); Rf?.Start(); TrafficControl?.Start(); }
internal void FindNames() { Tables = new Hashtable(); try { var mainTag = ReadStandardString(4); if (!mainTag.Equals("ttcf")) { throw new DocumentException(FileName + " is not a valid TTC file."); } Rf.SkipBytes(4); var dirCount = Rf.ReadInt(); names = new string[dirCount]; var dirPos = Rf.FilePointer; for (var dirIdx = 0; dirIdx < dirCount; ++dirIdx) { Tables.Clear(); Rf.Seek(dirPos); Rf.SkipBytes(dirIdx * 4); DirectoryOffset = Rf.ReadInt(); Rf.Seek(DirectoryOffset); if (Rf.ReadInt() != 0x00010000) { throw new DocumentException(FileName + " is not a valid TTF file."); } var numTables = Rf.ReadUnsignedShort(); Rf.SkipBytes(6); for (var k = 0; k < numTables; ++k) { var tag = ReadStandardString(4); Rf.SkipBytes(4); var tableLocation = new int[2]; tableLocation[0] = Rf.ReadInt(); tableLocation[1] = Rf.ReadInt(); Tables[tag] = tableLocation; } names[dirIdx] = BaseFont; } } finally { if (Rf != null) { Rf.Close(); } } }
/// <summary> /// Adds the new template. /// </summary> /// <param name="table">The table.</param> public void AddNewTemplate(DataTable table) { var m = table.NewRow(); var a = TemplateNew(); //todo: check now currentListDataTable.Add(a); m[Rf.Name <ChiTietHdnModel>(c => c.ID)] = a.ID; m[Rf.Name <ChiTietHdnModel>(c => c.DonGia)] = a.DonGia; m[Rf.Name <ChiTietHdnModel>(c => c.GiamGia)] = a.GiamGia; m[Rf.Name <ChiTietHdnModel>(c => c.SoLuong)] = a.SoLuong; m[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)] = a.MaGiayDep; m[Rf.Name <ChiTietHdnModel>(c => c.ThanhTien)] = a.ThanhTien; m[Rf.Name <ChiTietHdnModel>(c => c.IDModel)] = a.IDModel; table.Rows.Add(m); //table.AcceptChanges(); }
//Събиране и изваждане private void SiI() { instr.text = " "; int x = Random.Range(2000, 9999); int y = Random.Range(2000, 9999); int c = Random.Range(0, 2); int d = Random.Range(0, 2); int z = Random.Range(1, 4); if (c == 0) { int Rf; int R; do { y = Random.Range(900, 1000); R = x - y; Rf = Random.Range(R - 100, R + 100); }while (y > x && Rf <= 0); quest.text = x + "-" + y + "= ?"; tr.text = R.ToString(); fal.text = Rf.ToString(); } quest.text = x + "+" + y + "= ?"; int S = x + y; double Sf1 = S - Mathf.Pow(10, z);; double Sf2 = S + Mathf.Pow(10, z);; tr.text = S.ToString(); if (d == 0) { fal.text = Sf1.ToString(); } fal.text = Sf2.ToString(); }
/// <summary> /// Handles the Click event of the bntTaoMoi control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> private void bntTaoMoi_Click(object sender, EventArgs e) { bntLuu.Enabled = true; bntTaoMoi.Enabled = true; bntXoa.Enabled = true; bntLuaChon.Enabled = true; currentListDataTable = currentListDataTable ?? new List <ChiTietHdnModel> { TemplateNew() }; if (dataGridView.Rows.Count == 0) { dataSourceDataTable = currentListDataTable.ToDataTable(); dataSourceDataTable.AcceptChanges(); dataBindingSource.DataSource = dataSourceDataTable; dataGridView.DataSource = dataBindingSource; dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.ID)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SanPhamID)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SanPham)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.HoaDonNhapID)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.HoaDonNhap)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SoHDN)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.IDModel)].Display(false); if (dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)] != null) { dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].DisplayIndex = 1; } } else { AddNewTemplate((DataTable)dataBindingSource.DataSource); } }
//Събиране и изваждане private void SiI() { instr.text = " "; int x = Random.Range(10000, 99999); int y = Random.Range(10000, 99999); int c = Random.Range(0, 2); int d = Random.Range(0, 2); int z = Random.Range(1, 5); if (c == 0) { do { y = Random.Range(10000, 100000); }while (y > x); int R = x - y; int Rf; do { Rf = Random.Range(0, R + 100); }while (Rf == R); quest.text = x + "-" + y + "= ?"; tr.text = R.ToString(); fal.text = Rf.ToString(); } quest.text = x + "+" + y + "= ?"; int S = x + y; int Sf1 = S - 10 * z; int Sf2 = S + 10 * z; tr.text = S.ToString(); if (d == 0) { fal.text = Sf1.ToString(); } fal.text = Sf2.ToString(); }
public override bool Start() { string su = "", ipbstrResult, strSQL, ProductCode, IA_SetValue; bool dada; //string ExtraInfo = "Produkt ma przypisaną wartość atrybutu SET"; //ipbstrResult = null; //System.Data.DataSet ds; //ProductCode = "393260 SETX"; //IA_SetValue = null; this.FormFile = "set\\Set22IAProductSelect.xml"; Rf.PushScreen(); //this.Rf.ClearScreen(); //this.Rf.PopScreen(); //Rf.ReadBufferByLine=true; /*Rf. = true; * Rf.DisplayText("HELLO ", 5, 1); * Rf.ReadString(ref su);*/ /*RFControlText rFControlText = new RFControlText * { * Visible = true, * Status = "kod", * InputSize = 15, * Size = 15, * Message = "Skanuj kod produktu", * Required = true, * Reverse=false, * IgnorePrevious=false, * ControlType = Mantis.LVision.RFApi.enmControlType.ALFANUMERIC, * OriginalValue="test" * }; * //rFControlText.Value = ""; * Rf.ReadText(rFControlText, ref su);*/ Routines dbr = new Routines(); //Rf.DisplayMessage(ExtraInfo); Mantis.LVision.RFTools.frmGetValue frmVal = new Mantis.LVision.RFTools.frmGetValue { // frmVal.Application = this.Application; //frmVal.Parameters = this.Parameters; //frmVal.Rf = this.Rf; //frmVal.SessionID = this.SessionID; TitleMessage = "Zeskanuj ", Message = "kod produktu:", Size = 15, X = 1, Y = 1, Required = true, ControlType = Mantis.LVision.RFApi.enmControlType.ALFANUMERIC, Caption1_Visible = true, Parent = this.Parent }; frmVal.ClearScreen(); dada = frmVal.Show(); frmVal.PushScreen(); //frmVal.ShowForm(m_Form); if (frmVal.Value == null || frmVal.Value == "") { Rf.DisplayError("zeskanuj kod produktu!!"); } //strSQL = "select '1' id, 'TAK' rep UNION ALL select '2' id, 'NIE' rep"; //ds = dbr.SelectTable(strSQL, m_Form, null); //su = m_Form.Rf.DisplayCombo(1, 1, "Produkt: "+ProductCode+(char)13+"Typ SET: " + IA_SetValue.ToString(), "Zmiana? : ", ref ipbstrResult, ds.Tables[0], "id", "id", "rep", eEchoMode.ECHO_ON, null, true, false, "1", true); return(false); }
/// <summary> /// DGV_s the cell click. /// </summary> /// <param name="sender">The sender.</param> /// <param name="e">The <see cref="DataGridViewCellEventArgs" /> instance containing the event data.</param> private void dataGridView1_ChangedValue(Object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } int row = e.RowIndex; int col = e.ColumnIndex; currentRowSelected = row; // from 1 no 0 var m = dataGridView.Rows[currentRowSelected].Cells; if (col > 0) { if (dataGridView.Columns[col].Name == Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)) { var id = m[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value.ToString(); if (id != "-1" && id != "") { var RowIDs = (from rowx in dataGridView.Rows.Cast <DataGridViewRow>() where (rowx.Cells[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value.ToString() == id) select rowx).ToList(); if (RowIDs.Count() > 1) { MessageBox.Show("Mã sản phẩm đã tồn tại!"); m[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value = "-1"; return; } var noex = controller.CheckMaFromSanPham(id); if (noex == null) { if (MyDialogs.Question("Mã sản phẩm chưa tồn tại, bạn muốn khai báo không?") == false) { m[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value = "-1"; } else { controller.ShowSanPhamViewToCreate(id); } } else { // get back đơn giá nhập! dataGridView.Rows[currentRowSelected].Cells[Rf.Name <ChiTietHdnModel>(c => c.DonGia)].Value = noex.DonGiaNhap; } } } var a = m[Rf.Name <ChiTietHdnModel>(c => c.SoLuong)].Value.ToInt32(); var b = m[Rf.Name <ChiTietHdnModel>(c => c.DonGia)].Value.ToDecimal(); var d = m[Rf.Name <ChiTietHdnModel>(c => c.GiamGia)].Value.ToDecimal(); if (d > b) { m[Rf.Name <ChiTietHdnModel>(c => c.GiamGia)].Value = d; } var total = a * (b - d); m[Rf.Name <ChiTietHdnModel>(c => c.ThanhTien)].Value = total; } var sum = (from r in dataGridView.Rows.Cast <DataGridViewRow>() select r.Cells[Rf.Name <ChiTietHdnModel>(c => c.ThanhTien)].Value.ToDecimal()).Sum(c => c); txtTongTien.Text = sum.ToString(CultureInfo.InvariantCulture); if (currentListDataTable != null) { for (int i = 0; i < currentListDataTable.Count; i++) { if (currentListDataTable.ElementAt(i).IDModel == m[Rf.Name <ChiTietHdnModel>(c => c.IDModel)].Value.ToString()) { currentListDataTable.ElementAt(i).DonGia = m[Rf.Name <ChiTietHdnModel>(c => c.DonGia)].Value.ToDecimal(); currentListDataTable.ElementAt(i).GiamGia = m[Rf.Name <ChiTietHdnModel>(c => c.GiamGia)].Value.ToDecimal(); currentListDataTable.ElementAt(i).SoLuong = m[Rf.Name <ChiTietHdnModel>(c => c.SoLuong)].Value.ToInt32(); currentListDataTable.ElementAt(i).MaGiayDep = m[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value.ToString(); currentListDataTable.ElementAt(i).ThanhTien = m[Rf.Name <ChiTietHdnModel>(c => c.ThanhTien)].Value.ToDecimal(); } } currentHoaDonNhapModel.TongTien = txtTongTien.Text.ToDecimal(); currentHoaDonNhapModel.ChiTietHDNModel = currentListDataTable; } }
/// <summary> /// Posts the view. /// </summary> /// <param name="value">The value.</param> public void PostView(HoaDonNhapModel value) { currentHoaDonNhapModel = value; currentListDataTable = null; dataGridView.Columns.Clear(); var g = new DataGridViewCheckBoxColumn { Name = "CB", HeaderText = "", Width = 24, AutoSizeMode = DataGridViewAutoSizeColumnMode.None, ReadOnly = true }; dataGridView.Columns.Add(g); dataSourceDataTable = value.ChiTietHDNModel.ToDataTable(); dataSourceDataTable.AcceptChanges(); dataBindingSource.DataSource = dataSourceDataTable; dataGridView.DataSource = dataBindingSource; //dataGridView.DataSource = new BindingSource { DataSource = value.ChiTietHDNModel }; dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.ID)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SanPhamID)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SanPham)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.HoaDonNhapID)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.HoaDonNhap)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SoHDN)].Display(false); dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.IDModel)].Display(false); if (dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)] != null) { dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].DisplayIndex = 1; } if (value != null) { if (value.SoHDN != null) { txtMaHoaDon.Text = value.SoHDN; } if (value.MaNV != null) { txtMaNhanVien.Text = value.MaNV; } if (value.MaNCC != null) { txtMaNCC.Text = value.MaNCC; } if (value.NgayNhap != null) { txtNgayNhap.Text = value.NgayNhap.ToDateString(); } if (value.TongTien != null) { txtTongTien.Text = value.TongTien.ToString(); } } txtMaNhanVien.Text = AppMediator.MANHANVIEN; dataGridView.ClearSelection(); dataGridView.CurrentCell = null; if (isEditMode) { bntLuu.Enabled = false; bntTaoMoi.Enabled = true; bntXoa.Enabled = false; bntLuaChon.Enabled = false; txtMaHoaDon.Focus(); } else { bntLuu.Enabled = false; bntTaoMoi.Enabled = false; bntXoa.Enabled = false; } currentModel = null; }