private void frmCustomerView_Load(object sender, System.EventArgs e) { this.Text += " - " + sCompanyID; Signature.Data.MySQL oMySql = Global.oMySql; dt = oMySql.GetDataView("SELECT PrizeID, Description, Prize_Break, Levels from Prizes Where CompanyID='" + sCompanyID + "'", "Prize"); DataGridTableStyle TbStyle = new DataGridTableStyle(); TbStyle.MappingName = "Prize"; TbStyle.RowHeadersVisible = false; TbStyle.GridLineColor = System.Drawing.Color.Black; TbStyle.AllowSorting = false; TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue; DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn(); Col_01.HeaderText = "Prize ID"; Col_01.MappingName = "PrizeID"; Col_01.Width = 60; Col_01.NullText = ""; Col_01.ReadOnly = true; Col_01.Alignment = System.Windows.Forms.HorizontalAlignment.Center; DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn(); Col_02.HeaderText = "Description"; Col_02.MappingName = "Description"; Col_02.Width = 70; Col_02.NullText = ""; Col_02.ReadOnly = true; DataGridTextBoxColumn Col_03 = new DataGridTextBoxColumn(); Col_03.HeaderText = "PrizeBreak"; Col_03.MappingName = "PrizeBreak"; Col_03.Width = 70; Col_03.NullText = ""; Col_03.ReadOnly = true; DataGridTextBoxColumn Col_04 = new DataGridTextBoxColumn(); Col_03.HeaderText = "Levels"; Col_03.MappingName = "Leves"; Col_03.Width = 70; Col_03.NullText = ""; Col_03.ReadOnly = true; TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_01, Col_02, Col_03, Col_04 }); DataGrid.TableStyles.Add(TbStyle); DataGrid.DataSource = dt; //DataGrid.Focus(); this.txtSearch.Focus(); //oMySql.Close(); }
private void frmCustomerView_Load(object sender, System.EventArgs e) { this.Text += " - " + sCompanyID; Signature.Data.MySQL oMySql = Global.oMySql; dt = oMySql.GetDataView("SELECT CustomerID, Name, City, State from Customer Where CompanyID='" + sCompanyID + "'", "Customer"); this.txtSearch.Focus(); Grid.DataSource = dt; }
private void frmCustomerView_Load(object sender, System.EventArgs e) { this.Text += " - " + sCompanyID; Signature.Data.MySQL oMySql = Global.oMySql; dt = oMySql.GetDataView(String.Format("Select r.Reference, ReceiveID, r.Date, r.PurchaseID, v.Name from Receive r Left join Purchase p on r.PurchaseID=p.PurchaseID And r.CompanyID=p.CompanyID Left join Vendor v on p.VendorID=v.VendorID And p.CompanyID=v.CompanyID Where p.CompanyID='{0}' Order By r.Date DESC ", sCompanyID), "Tmp"); //dt = oMySql.GetDataView(String.Format("CALL get_pending_PO('{0})", sCompanyID), "Tmp"); this.txtSearch.Focus(); Grid.DataSource = dt; }
private void frmCustomerView_Load(object sender, System.EventArgs e) { this.Text += " - " + sCompanyID; Signature.Data.MySQL oMySql = Global.oMySql; dt = oMySql.GetDataView(String.Format("SELECT * FROM CardTemplate"), "CardTemplate"); this.txtSearch.Focus(); Grid.DataSource = dt; }
private void frmCustomerView_Load(object sender, System.EventArgs e) { this.Text += " - " + CompanyID; Signature.Data.MySQL oMySql = Global.oMySql; dt = oMySql.GetDataView(String.Format("Select distinct(os.CustomerID), c.Name from OrderScanned os Left Join Customer c on os.CompanyID=c.CompanyID And os.CustomerID=c.CustomerID Where os.CompanyID='" + this.CompanyID + "'", "OrderScanned"), "Customers"); this.txtSearch.Focus(); Grid.DataSource = dt; }
private void frmCustomerView_Load(object sender, System.EventArgs e) { contextMenu1 = new System.Windows.Forms.ContextMenu(); System.Windows.Forms.MenuItem menuItem1; menuItem1 = new System.Windows.Forms.MenuItem(); System.Windows.Forms.MenuItem menuItem2; menuItem2 = new System.Windows.Forms.MenuItem(); System.Windows.Forms.MenuItem menuItem3; menuItem3 = new System.Windows.Forms.MenuItem(); contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { menuItem1, menuItem2, menuItem3 }); menuItem1.Index = 0; menuItem1.Text = "View"; menuItem2.Index = 1; menuItem2.Text = "Modify"; menuItem3.Index = 2; menuItem3.Text = "Delete"; menuItem1.Click += new EventHandler(this.menuitem1_Click); //textBox1.ContextMenu = contextMenu1; //txtSearch.ContextMenu = contextMenu1; Grid.ContextMenu = contextMenu1; // Signature.Data.MySQL oMySql = Global.oMySql; if (this.All) { dt = oMySql.GetDataView("SELECT CompanyID, Name FROM Company Order By CompanyID", "Company"); } else { dt = oMySql.GetDataView("SELECT CompanyID, Name FROM Company where IsExternal='0' Order By CompanyID", "Company"); } this.txtSearch.Focus(); Grid.DataSource = dt; }
private void frmCustomerView_Load(object sender, System.EventArgs e) { contextMenu1 = new System.Windows.Forms.ContextMenu(); System.Windows.Forms.MenuItem menuItem1; menuItem1 = new System.Windows.Forms.MenuItem(); System.Windows.Forms.MenuItem menuItem2; menuItem2 = new System.Windows.Forms.MenuItem(); System.Windows.Forms.MenuItem menuItem3; menuItem3 = new System.Windows.Forms.MenuItem(); contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { menuItem1, menuItem2, menuItem3 }); menuItem1.Index = 0; menuItem1.Text = "View"; menuItem2.Index = 1; menuItem2.Text = "Modify"; menuItem3.Index = 2; menuItem3.Text = "Delete"; menuItem1.Click += new EventHandler(this.menuitem1_Click); //textBox1.ContextMenu = contextMenu1; //txtSearch.ContextMenu = contextMenu1; Grid.ContextMenu = contextMenu1; // this.Text += " - " + sCompanyID; Signature.Data.MySQL oMySql = Global.oMySql; dt = oMySql.GetDataView(String.Format("SELECT user, RepID FROM mailserver.virtual_users Where domain_id='{0}'", this.DomainID), "Domains"); this.txtSearch.Focus(); Grid.DataSource = dt; }
private void frmViewTeacher_Load(object sender, System.EventArgs e) { Signature.Data.MySQL oMySql = Global.oMySql; //dt = oMySql.GetDataView("SELECT ID, Teacher, Student, Scanned, Packed FROM Orders Where CompanyID='"+sCompanyID+ "' And CustomerID='"+sCustomerID+"' And (BoxesPacked!=0 And BoxesPacked!=BoxesScanned)","Tmp"); dt = oMySql.GetDataView(String.Format("SELECT o.ID, o.Teacher,o.Student,ol.Scanned, ol.Packed FROM Orders o Left Join OrderByLine ol On o.ID=ol.OrderID Where o.CompanyID='{0}' And CustomerID='{1}' And ol.PackID='{2}' And (ol.Packed<>'1' Or ol.Scanned <>'1') And o.Teacher NOT Like '%A INTERNET%'", Global.CurrrentCompany, this.sCustomerID, Global.CurrrentLine), "Tmp"); //cboTraineeFields.Items.Insert(0, "Teacher"); //cboTraineeFields.Items.Insert(1, "Students"); //cboTraineeFields.SelectedIndex = 0; // DataGridTableStyle TbStyle = new DataGridTableStyle(); TbStyle.MappingName = "Tmp"; TbStyle.RowHeadersVisible = false; TbStyle.GridLineColor = System.Drawing.Color.Black; TbStyle.AllowSorting = false; TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue; DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn(); Col_01.HeaderText = "Order ID"; Col_01.MappingName = "ID"; Col_01.Width = 50; Col_01.NullText = ""; Col_01.ReadOnly = true; DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn(); Col_02.HeaderText = "Teacher Name"; Col_02.MappingName = "Teacher"; Col_02.Width = 150; Col_02.NullText = ""; Col_02.ReadOnly = true; DataGridTextBoxColumn Col_03 = new DataGridTextBoxColumn(); Col_03.HeaderText = "Student Name"; Col_03.MappingName = "Student"; Col_03.Width = 150; Col_03.NullText = ""; Col_03.ReadOnly = true; DataGridTextBoxColumn Col_04 = new DataGridTextBoxColumn(); Col_04.HeaderText = "Packed"; Col_04.MappingName = "Packed"; Col_04.Width = 50; Col_04.NullText = ""; Col_04.ReadOnly = true; DataGridTextBoxColumn Col_05 = new DataGridTextBoxColumn(); Col_05.HeaderText = "Scanned"; Col_05.MappingName = "Scanned"; Col_05.Width = 50; Col_05.NullText = ""; Col_05.ReadOnly = true; TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_01, Col_02, Col_03, Col_04, Col_05 }); DataGrid.TableStyles.Add(TbStyle); DataGrid.DataSource = dt; DataGrid.Focus(); //oMySql.Close(); }