public void Fill_Disponible(MetroFramework.Controls.MetroComboBox combo) { combo.Items.Clear(); combo.ResetText(); combo.Items.Add("disponible"); combo.Items.Add("non disponible"); combo.SelectedItem = "disponible"; }
public void comholder(MetroFramework.Controls.MetroComboBox box, string text) { if (box.Text != text) { box.Items.Clear(); box.Items.Insert(0, text); box.SelectedIndex = 0; } }
public void gradelvcomrefresh(MetroFramework.Controls.MetroComboBox com, string _SY) { bool check1; using (SqlConnection conn = new SqlConnection("server=Library\\SQLEXPRESS;database=Library;User ID=sa;Password=bsusclibrary;Integrated Security=false;")) { using (SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM information_schema.tables WHERE table_name ='" + "SY" + _SY + "Grade_Section'", conn)) { conn.Open(); int count = (int)cmd.ExecuteScalar(); if (count > 0) { check1 = true; } else { check1 = false; } } } if (check1) { bool check; using (SqlConnection conn = new SqlConnection("server=Library\\SQLEXPRESS;database=Library;User ID=sa;Password=bsusclibrary;Integrated Security=false;")) { using (SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM [" + "SY" + _SY + "Grade_Section]", conn)) { conn.Open(); SqlDataReader read = cmd.ExecuteReader(); check = read.HasRows; } } if (check) { using (SqlConnection conn = new SqlConnection("server=Library\\SQLEXPRESS;database=Library;User ID=sa;Password=bsusclibrary;Integrated Security=false;")) { using (SqlCommand cmd = new SqlCommand("SELECT DISTINCT Grade_Level FROM [" + "SY" + _SY + "Grade_Section]", conn)) { int ctr = 0; conn.Open(); SqlDataReader read = cmd.ExecuteReader(); com.Items.Clear(); while (read.Read()) { com.Items.Insert(ctr, read[0].ToString()); ctr++; } } } } } }
private void ValidarBox(int c, MetroFramework.Controls.MetroComboBox b, MetroFramework.Controls.MetroTile t, MetroFramework.Controls.MetroLabel l) { if (b.SelectedIndex != -1) { EntradasVal[c] = true; val.CambiarColor(t, l, 'g'); } else { EntradasVal[c] = false; val.CambiarColor(t, l, 'b'); } ValidarEntradas(); }
public void Fill_NomClient(MetroFramework.Controls.MetroComboBox combo) { combo.Items.Clear(); combo.ResetText(); cmd = new SqlCommand("SELECT nom FROM infoClients", conn); adapt = new SqlDataAdapter(cmd); ds = new DataSet(); adapt.Fill(ds); combo.Items.Add(""); foreach (DataRow x in ds.Tables[0].Rows) { combo.Items.Add(x[0].ToString()); } }
public void PopulateComboboxTamaños(ref MetroFramework.Controls.MetroComboBox combo, ref List <int> idTamañosCombobox) { List <EntitiePezTamaño> tamaños = ControllerPeces.Instance.GetTamaños(); idTamañosCombobox = new List <int>(); combo.Items.Clear(); for (int i = 0; i < tamaños.Count; i++) { combo.Items.Add(tamaños[i].GetDescripcion()); idTamañosCombobox.Add(tamaños[i].GetIdTamaño()); } combo.SelectedIndex = 0; }
private void catchTheControls() { buttonOk = (MetroFramework.Controls.MetroTile)requestWindow.Controls.Find("mTileOk", true).First(); textBoxName = (MetroFramework.Controls.MetroTextBox)requestWindow.Controls.Find("mTxtBxReqName", true).First(); textBoxArea = (MetroFramework.Controls.MetroTextBox)requestWindow.Controls.Find("mTxtBxReqArea", true).First();; textBoxAmount = (MetroFramework.Controls.MetroTextBox)requestWindow.Controls.Find("mTxtBxAmount", true).First();; textBoxStartDate = (MetroFramework.Controls.MetroTextBox)requestWindow.Controls.Find("mTxtBxStartDate", true).First();; textBoxEndDate = (MetroFramework.Controls.MetroTextBox)requestWindow.Controls.Find("mTxtBxEndDate", true).First();; comboBoxProducts = (MetroFramework.Controls.MetroComboBox)requestWindow.Controls.Find("mCbBxProducts", true).First();; comboBoxStrippings = (MetroFramework.Controls.MetroComboBox)requestWindow.Controls.Find("mCbBxStrippings", true).First();; textBoxPlacing = (MetroFramework.Controls.MetroTextBox)requestWindow.Controls.Find("mTxtBxPlaceCode", true).First(); textBoxSubcontr = (MetroFramework.Controls.MetroTextBox)requestWindow.Controls.Find("mTxtBxBeszall", true).First(); labelPlacing = (MetroFramework.Controls.MetroLabel)requestWindow.Controls.Find("mLabelPlacing", true).First(); infoLabel = (MetroFramework.Controls.MetroLabel)requestWindow.Controls.Find("mLblInfoTitle", true).First(); labelOfProduct = (MetroFramework.Controls.MetroLabel)requestWindow.Controls.Find("mLabelOfProductCmb", true).First(); }
public void Fill_Plat(MetroFramework.Controls.MetroComboBox combo) { combo.Items.Clear(); combo.ResetText(); cmd = new SqlCommand("SELECT nom_plat FROM Plat where disponible = 'True'", conn); adapt = new SqlDataAdapter(cmd); cmd.ExecuteNonQuery(); ds = new DataSet(); adapt.Fill(ds); combo.Items.Add(""); ds.Tables[0].DefaultView.Sort = "nom_plat ASC"; foreach (DataRow x in ds.Tables[0].Rows) { combo.Items.Add(x[0].ToString()); } }
public void Fill_Table_3(MetroFramework.Controls.MetroComboBox combo) { combo.Items.Clear(); combo.ResetText(); cmd = new SqlCommand("SELECT id_table FROM Tablee where nom_serveur = '-' or nom_serveur = '" + Authentification.user_info[1] + "'", conn); adapt = new SqlDataAdapter(cmd); cmd.ExecuteNonQuery(); ds = new DataSet(); adapt.Fill(ds); combo.Items.Add(""); foreach (DataRow x in ds.Tables[0].Rows) { combo.Items.Add(x[0].ToString()); } }
public void Fill_Categorie(MetroFramework.Controls.MetroComboBox combo) { combo.Items.Clear(); combo.ResetText(); cmd = new SqlCommand("SELECT nom_categorie FROM Categorie", conn); adapt = new SqlDataAdapter(cmd); cmd.ExecuteNonQuery(); ds = new DataSet(); adapt.Fill(ds); combo.Items.Add(""); foreach (DataRow x in ds.Tables[0].Rows) { combo.Items.Add(x[0].ToString()); } }
private void evento_edad(object sender, EventArgs e) { MetroFramework.Controls.MetroComboBox combobox = sender as MetroFramework.Controls.MetroComboBox; if (combobox.Text.Equals("Personalizado")) { txt_edad_especifica.Visible = true; txt_edad_especifica.Text = ""; txt_edad_especifica.Select(); } else { txt_edad_especifica.Visible = false; txt_edad_especifica.Text = ""; cbox_sexo.Select(); } }
public string ExtraercoutaId(MetroFramework.Controls.MetroComboBox pcuotas, MetroFramework.Controls.MetroTextBox plegajo) { con = generarConexion(); con.Open(); metCobros ObjMetCobros = new metCobros(); ObjMetCobros.ExtraerFechaVenc(pcuotas); string nlegajo = plegajo.Text; string FechaVencEncontrada = ExtraerFechaVenc(pcuotas); DateTime fecha = Convert.ToDateTime(FechaVencEncontrada); string consulta = "SELECT c.CUO_ID CUOTA_ID " + "FROM T_CUOTA_FINAL c " + "WHERE c.CUO_FECHA_VENC = '" + FechaVencEncontrada + "' " + "AND c.CUO_PER_LEGAJO = '" + nlegajo + "' " + "AND c.CUO_ESTADO = 'ADEUDADA' "; cmd = new SqlCommand(consulta, con); dta = new SqlDataAdapter(cmd); dt = new DataTable(); dta.Fill(dt); string extraer = ""; if (dt != null) { foreach (DataRow dr in dt.Rows) { if (dr["CUOTA_ID"] != DBNull.Value) { extraer = Convert.ToString(dr["CUOTA_ID"]); } } } con.Close(); return(extraer); }
private void catchTheControls() { txtbName = (MetroFramework.Controls.MetroTextBox)productWindow.Controls.Find("mTxtBxName", true).First(); cmbbSubcontr = (MetroFramework.Controls.MetroComboBox)productWindow.Controls.Find("mCmbBxSubcontr", true).First(); txtbQuantUn = (MetroFramework.Controls.MetroTextBox)productWindow.Controls.Find("mTxtBxQuantUnit", true).First(); txtbDescr = (MetroFramework.Controls.MetroTextBox)productWindow.Controls.Find("mTxtBxDescr", true).First(); txtbSaftySh = (MetroFramework.Controls.MetroTextBox)productWindow.Controls.Find("mTxtBxSheet", true).First(); txtbDanger = (MetroFramework.Controls.MetroTextBox)productWindow.Controls.Find("mTxtBxDanger", true).First(); txtbStripping = (MetroFramework.Controls.MetroTextBox)productWindow.Controls.Find("mTxtBxStripping", true).First(); txtbQuan = (MetroFramework.Controls.MetroTextBox)productWindow.Controls.Find("mTxtBxQuantity", true).First(); txtbPlace = (MetroFramework.Controls.MetroTextBox)productWindow.Controls.Find("mTxtBxPlaceing", true).First(); txtbBarcode = (MetroFramework.Controls.MetroTextBox)productWindow.Controls.Find("mTxtBxBarcode", true).First(); btnOk = (MetroFramework.Controls.MetroTile)productWindow.Controls.Find("mTileOk", true).First(); lblInfos = (MetroFramework.Controls.MetroLabel)productWindow.Controls.Find("mLabelInfos", true).First(); lblMain = (MetroFramework.Controls.MetroLabel)productWindow.Controls.Find("mLabelMainTitle", true).First(); }
public void PopulateComboboxCategorias(ref MetroFramework.Controls.MetroComboBox combo, ref List <int> idCategoriasCombobox) { List <EntitieGastoCategoria> categorias = GetCategorias(); idCategoriasCombobox = new List <int>(); combo.Items.Clear(); combo.Items.Add("-"); idCategoriasCombobox.Add(0); for (int i = 0; i < categorias.Count; i++) { combo.Items.Add(categorias[i].GetNombre()); idCategoriasCombobox.Add(categorias[i].GetIdCuenta()); } if (combo.Items.Count > 0) { combo.SelectedIndex = 0; } }
public void PopulateComboboxBase(ref MetroFramework.Controls.MetroComboBox combo, ref List <int> idBaseCombobox) { List <EntitieBase> bases = null; idBaseCombobox = new List <int>(); combo.Items.Clear(); combo.Items.Add("-"); idBaseCombobox.Add(0); for (int i = 0; i < bases.Count; i++) { combo.Items.Add(bases[i]); idBaseCombobox.Add(Convert.ToInt32(bases[i])); } if (combo.Items.Count > 0) { combo.SelectedIndex = 0; } }
public void PopulateComboboxEspecies(ref MetroFramework.Controls.MetroComboBox combo, ref List <int> idEspeciesCombobox) { List <EntitiePezEspecie> especies = GetEspecies(); idEspeciesCombobox = new List <int>(); combo.Items.Clear(); combo.Items.Add("-"); idEspeciesCombobox.Add(0); for (int i = 0; i < especies.Count; i++) { combo.Items.Add(especies[i].GetNombre()); idEspeciesCombobox.Add(especies[i].GetIdPezEspecie()); } if (combo.Items.Count > 0) { combo.SelectedIndex = 0; } }
private void catchTheControls() { buttonOk = (MetroFramework.Controls.MetroTile)parentOrdWin.Controls.Find("mTileOk", true).First(); labelInfoBar = parentOrdWin.Controls.Find("mLblInfoTitle", true).First(); textBoxStartDate = (MetroFramework.Controls.MetroTextBox)parentOrdWin.Controls.Find("mTxtBxOrderStart", true).First(); textBoxFinalDate = (MetroFramework.Controls.MetroTextBox)parentOrdWin.Controls.Find("mTxtBxOrderFinal", true).First(); textBoxUserOrder = (MetroFramework.Controls.MetroTextBox)parentOrdWin.Controls.Find("mTxtBxUserStart", true).First(); textBoxUserModif = (MetroFramework.Controls.MetroTextBox)parentOrdWin.Controls.Find("mTxtBxModifUser", true).First(); labelFinalDate = parentOrdWin.Controls.Find("mLblFinalDate", true).First(); labelModifierArea = parentOrdWin.Controls.Find("mLblModifierArea", true).First(); textBoxOrdAmount = (MetroFramework.Controls.MetroTextBox)parentOrdWin.Controls.Find("mTxtBxAmount", true).First(); textBoxOrdArrivAmount = (MetroFramework.Controls.MetroTextBox)parentOrdWin.Controls.Find("mTxtBxAmountArriv", true).First(); labelArrivedAmount = parentOrdWin.Controls.Find("mLblAmountArriv", true).First(); textBoxOrdPlace = (MetroFramework.Controls.MetroTextBox)parentOrdWin.Controls.Find("mTxtBxPlacing", true).First(); labelPlacing = parentOrdWin.Controls.Find("mLblPlacing", true).First(); textBoxSubcontr = (MetroFramework.Controls.MetroTextBox)parentOrdWin.Controls.Find("mTxtBxSubcontr", true).First(); textBoxProdcode = (MetroFramework.Controls.MetroTextBox)parentOrdWin.Controls.Find("mTxtBxProdCode", true).First(); labelProductInfo = parentOrdWin.Controls.Find("mLblProductInfo", true).First(); comboBoxOrdProd = (MetroFramework.Controls.MetroComboBox)parentOrdWin.Controls.Find("mCmbxProduct", true).First(); comboBoxOrdStrip = (MetroFramework.Controls.MetroComboBox)parentOrdWin.Controls.Find("mCmbxStripping", true).First(); checkBoxNewProd = (MetroFramework.Controls.MetroCheckBox)parentOrdWin.Controls.Find("mChckBoxNewProdAdj", true).First(); }
private void ComboBoxFromAndTo_UPDATE_ITEMS(MetroFramework.Controls.MetroComboBox ComboBox, string Selected) { ComboBox.Items.Clear(); switch (Selected) { case "Банковский счет": { for (int index = 0; index < Accounts.List_BankAccounts.Count; index++) { ComboBox.Items.Add(Accounts.List_BankAccounts[index].AccountName); } break; } case "Пластиковая карта": { for (int index = 0; index < Accounts.List_PlasticCards.Count; index++) { ComboBox.Items.Add(Accounts.List_PlasticCards[index].Name); } break; } case "Криптовалютный кошелек": { for (int index = 0; index < Accounts.List_CryptoWallets.Count; index++) { ComboBox.Items.Add(Accounts.List_CryptoWallets[index].Name); } break; } } }
public void LoadMedTech(MetroFramework.Controls.MetroComboBox combo_box) { using (MySqlConnection con = new MySqlConnection(connection.conString)) { string sql = @"SELECT mmg_lab.tblusers.*, mmg_lab.tblprofiles.*, CONCAT(mmg_lab.tblprofiles.first_name, ' ', mmg_lab.tblprofiles.last_name) AS full_name FROM mmg_lab.tblusers INNER JOIN mmg_lab.tblprofiles ON mmg_lab.tblusers.id = mmg_lab.tblprofiles.user_id WHERE mmg_lab.tblusers.user_level = 184 AND mmg_lab.tblusers.active = 1;"; using (MySqlCommand cmd = new MySqlCommand(sql, con)) { MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { combo_box.ValueMember = "user_id"; combo_box.DisplayMember = "full_name"; combo_box.DataSource = dt; } } } }
private void AddNewPanel() { var panel = new MetroFramework.Controls.MetroPanel() { Anchor = (AnchorStyles.Left | AnchorStyles.Bottom | AnchorStyles.Top), Size = GetSizePanel, Location = new System.Drawing.Point(curLocation.X, curLocation.Y), BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle }; panel.Controls.Clear(); var txtHash = new MetroFramework.Controls.MetroTextBox { Anchor = (AnchorStyles.Left | AnchorStyles.Top), Text = "Рассчитываемый хеш блока будет здесь", Enabled = false, ReadOnly = true, Size = new System.Drawing.Size() { Width = GetSizeTxtHash.Width, Height = GetSizeTxtHash.Height }, Location = new System.Drawing.Point(GetLocationTxtHash.X, GetLocationTxtHash.Y) }; panel.Controls.Add(txtHash); var txtContent = new MetroFramework.Controls.MetroTextBox { Anchor = (AnchorStyles.Left | AnchorStyles.Bottom | AnchorStyles.Top), Multiline = true, Size = new System.Drawing.Size() { Width = GetSizeTxtContent.Width, Height = GetSizeTxtContent.Height }, Location = new System.Drawing.Point(GetLocationTxtContent.X, GetLocationTxtContent.Y) }; txtContent.TextChanged += SaveText; panel.Controls.Add(txtContent); var users = _dataProvider.GetUsers().Where(x => x.UserId != sessionUser.UserId).ToList(); var cmbUser = new MetroFramework.Controls.MetroComboBox { Anchor = (AnchorStyles.Left | AnchorStyles.Bottom), Name = "cmbUser", Size = new System.Drawing.Size() { Width = GetSizeTxtUser.Width + GetSizeTxtDateTime.Width + 2, Height = GetSizeTxtDateTime.Height }, Location = new System.Drawing.Point(GetLocationTxtUser.X, GetLocationTxtUser.Y), DataSource = users, DisplayMember = "Login", ValueMember = "UserID" }; cmbUser.SelectedItem = null; cmbUser.SelectedIndexChanged += SaveUser; panel.Controls.Add(cmbUser); var txtMoney = new MetroFramework.Controls.MetroTextBox { Anchor = (AnchorStyles.Left | AnchorStyles.Bottom), WaterMark = "Сумма", Name = "txtMoney", Size = new System.Drawing.Size() { Width = GetSizeTxtMoney.Width, Height = GetSizeTxtMoney.Height }, Location = new System.Drawing.Point(GetLocationTxtMoney.X + GetSizeTxtDateTime.Width + 2, GetLocationTxtMoney.Y) }; txtMoney.TextChanged += SaveMoney; panel.Controls.Add(txtMoney); var button = new MetroFramework.Controls.MetroButton() { Anchor = (AnchorStyles.Left | AnchorStyles.Bottom), Name = "button", Text = "Создать новый блок", Size = new System.Drawing.Size() { Width = GetSizeTxtHash.Width, Height = GetSizeTxtHash.Height }, Location = new System.Drawing.Point(GetLocationTxtPrevHash.X, GetLocationTxtPrevHash.Y), }; button.Click += CreateNewBlock; panel.Controls.Add(button); curGrid.Controls.Add(panel); curLocation = new Point(panel.Location.X + panel.Width + OFFSET, panel.Location.Y); curPanel = panel; }
private void cmbMarks_SelectedIndexChanged(object sender, EventArgs e) { flowLayoutPanel1.Controls.Clear(); MetroFramework.Controls.MetroComboBox cmb = sender as MetroFramework.Controls.MetroComboBox; LoadProducts(lNameCategory.Text, cmb.Text); }
public string ModificarEstadoCuota(MetroFramework.Controls.MetroComboBox pcuotas, MetroFramework.Controls.MetroTextBox plegajo, MetroFramework.Controls.MetroTextBox pbarrabuscao) { con = generarConexion(); con.Open(); metCobros ObjMetCobros = new metCobros(); ObjMetCobros.ExtraerFechaVenc(pcuotas); string FechaVencEncontrada = ExtraerFechaVenc(pcuotas); Convert.ToDateTime(FechaVencEncontrada).ToString("yyyy-MM-dd"); string nlegajo = plegajo.Text; string consulta = "UPDATE T_CUOTA_FINAL " + "SET CUO_ESTADO = 'PAGADA' " + "WHERE CUO_FECHA_VENC = '" + FechaVencEncontrada + "' " + "AND CUO_PER_LEGAJO = '" + nlegajo + "'"; cmd = new SqlCommand(consulta, con); cmd.ExecuteNonQuery(); con.Close(); con = generarConexion(); con.Open(); metCobros ObjMetCobro = new metCobros(); ObjMetCobro.ExtraerDni(pbarrabuscao); string dniencontrado = ExtraerDni(pbarrabuscao); string consulta1 = "SELECT DISTINCT (p.PER_NOMBRE + ',' + p.PER_APELLIDO)NOMBRE_APELLIDO, " + "p.PER_DOCUMENTO, " + "p.PER_LEGAJO, " + "c.CUO_FECHA_VENC, " + "CONCAT( CONCAT ('$', c.CUO_IMPORTE) , ' ' , c.CUO_FECHA_VENC, ' ', '(' , c.CUO_ESTADO , ')')INFO_CUOTA " + "FROM T_PERSONAS p , T_CUOTA_FINAL c " + "WHERE p.PER_LEGAJO = c.CUO_PER_LEGAJO " + "AND p.PER_DOCUMENTO = '" + dniencontrado + "' " + "AND c.CUO_ESTADO = 'ADEUDADA' "; cmd = new SqlCommand(consulta1, con); dta = new SqlDataAdapter(cmd); dt = new DataTable("INFO_CUOTA"); dta.Fill(dt); pcuotas.DataSource = dt; pcuotas.DisplayMember = "INFO_CUOTA"; pcuotas.SelectedItem = null; //pcuotas.SelectedIndex = 0; //if (pcuotas.SelectedIndex == -1) //{ // MessageBox.Show("El alumno ingresado no tiene registros de cuotas pendientes de cobro"); //} //pcuotas.SelectedIndex = -1; con.Close(); return(MessageBox.Show("Se registro el cobro. La cuota se encuentra PAGADA").ToString()); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.metroTile5 = new MetroFramework.Controls.MetroTile(); this.metroTile2 = new MetroFramework.Controls.MetroTile(); this.metroTile1 = new MetroFramework.Controls.MetroTile(); this.addmember = new MetroFramework.Controls.MetroTile(); this.metroLabel2 = new MetroFramework.Controls.MetroLabel(); this.metroLabel1 = new MetroFramework.Controls.MetroLabel(); this.metroTextBox1 = new MetroFramework.Controls.MetroTextBox(); this.metroLabel7 = new MetroFramework.Controls.MetroLabel(); this.metroLabel6 = new MetroFramework.Controls.MetroLabel(); this.metroLabel5 = new MetroFramework.Controls.MetroLabel(); this.metroLabel4 = new MetroFramework.Controls.MetroLabel(); this.metroLabel3 = new MetroFramework.Controls.MetroLabel(); this.metroTextBox2 = new MetroFramework.Controls.MetroTextBox(); this.dataGridView1 = new System.Windows.Forms.DataGridView(); this.metroTile6 = new MetroFramework.Controls.MetroTile(); this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker(); this.metroComboBox1 = new MetroFramework.Controls.MetroComboBox(); this.metroComboBox2 = new MetroFramework.Controls.MetroComboBox(); this.addmember.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); this.SuspendLayout(); // // metroTile5 // this.metroTile5.BackColor = System.Drawing.Color.Turquoise; this.metroTile5.CustomBackground = true; this.metroTile5.CustomForeColor = true; this.metroTile5.ForeColor = System.Drawing.SystemColors.ActiveCaptionText; this.metroTile5.Location = new System.Drawing.Point(303, 76); this.metroTile5.Name = "metroTile5"; this.metroTile5.Size = new System.Drawing.Size(110, 57); this.metroTile5.TabIndex = 11; this.metroTile5.Text = "Refresh"; this.metroTile5.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; this.metroTile5.TileImageAlign = System.Drawing.ContentAlignment.MiddleCenter; this.metroTile5.TileTextFontWeight = MetroFramework.MetroTileTextWeight.Bold; // // metroTile2 // this.metroTile2.BackColor = System.Drawing.Color.RosyBrown; this.metroTile2.CustomBackground = true; this.metroTile2.CustomForeColor = true; this.metroTile2.ForeColor = System.Drawing.SystemColors.ActiveCaptionText; this.metroTile2.Location = new System.Drawing.Point(153, 76); this.metroTile2.Name = "metroTile2"; this.metroTile2.Size = new System.Drawing.Size(129, 57); this.metroTile2.TabIndex = 10; this.metroTile2.Text = "Update Member"; this.metroTile2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; this.metroTile2.TileImageAlign = System.Drawing.ContentAlignment.TopCenter; this.metroTile2.TileTextFontWeight = MetroFramework.MetroTileTextWeight.Bold; // // metroTile1 // this.metroTile1.BackColor = System.Drawing.Color.Gold; this.metroTile1.CustomBackground = true; this.metroTile1.CustomForeColor = true; this.metroTile1.ForeColor = System.Drawing.SystemColors.ActiveCaptionText; this.metroTile1.Location = new System.Drawing.Point(441, 76); this.metroTile1.Name = "metroTile1"; this.metroTile1.Size = new System.Drawing.Size(124, 57); this.metroTile1.TabIndex = 9; this.metroTile1.Text = "Search Member"; this.metroTile1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; this.metroTile1.TileImageAlign = System.Drawing.ContentAlignment.BottomLeft; this.metroTile1.TileTextFontWeight = MetroFramework.MetroTileTextWeight.Bold; // // addmember // this.addmember.BackColor = System.Drawing.Color.Red; this.addmember.Controls.Add(this.metroLabel2); this.addmember.Controls.Add(this.metroLabel1); this.addmember.CustomBackground = true; this.addmember.CustomForeColor = true; this.addmember.ForeColor = System.Drawing.SystemColors.ActiveCaptionText; this.addmember.Location = new System.Drawing.Point(23, 76); this.addmember.Name = "addmember"; this.addmember.Size = new System.Drawing.Size(110, 57); this.addmember.TabIndex = 8; this.addmember.Text = "Add Member"; this.addmember.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; this.addmember.TileImageAlign = System.Drawing.ContentAlignment.BottomLeft; this.addmember.TileTextFontWeight = MetroFramework.MetroTileTextWeight.Bold; this.addmember.UseMnemonic = false; // // metroLabel2 // this.metroLabel2.AutoSize = true; this.metroLabel2.Location = new System.Drawing.Point(10, 10); this.metroLabel2.Name = "metroLabel2"; this.metroLabel2.Size = new System.Drawing.Size(0, 0); this.metroLabel2.TabIndex = 1; // // metroLabel1 // this.metroLabel1.AutoSize = true; this.metroLabel1.Location = new System.Drawing.Point(1, 4); this.metroLabel1.Name = "metroLabel1"; this.metroLabel1.Size = new System.Drawing.Size(0, 0); this.metroLabel1.TabIndex = 0; // // metroTextBox1 // this.metroTextBox1.CustomBackground = true; this.metroTextBox1.CustomForeColor = true; this.metroTextBox1.FontSize = MetroFramework.MetroTextBoxSize.Medium; this.metroTextBox1.ForeColor = System.Drawing.SystemColors.ControlLightLight; this.metroTextBox1.Location = new System.Drawing.Point(585, 107); this.metroTextBox1.Name = "metroTextBox1"; this.metroTextBox1.Size = new System.Drawing.Size(226, 26); this.metroTextBox1.TabIndex = 12; this.metroTextBox1.Text = "Attendance ID"; // // metroLabel7 // this.metroLabel7.AutoSize = true; this.metroLabel7.BackColor = System.Drawing.Color.Black; this.metroLabel7.CustomBackground = true; this.metroLabel7.CustomForeColor = true; this.metroLabel7.ForeColor = System.Drawing.SystemColors.ControlLightLight; this.metroLabel7.Location = new System.Drawing.Point(23, 318); this.metroLabel7.Name = "metroLabel7"; this.metroLabel7.Size = new System.Drawing.Size(91, 19); this.metroLabel7.TabIndex = 20; this.metroLabel7.Text = "Employer NIC"; // // metroLabel6 // this.metroLabel6.AutoSize = true; this.metroLabel6.BackColor = System.Drawing.Color.Black; this.metroLabel6.CustomBackground = true; this.metroLabel6.CustomForeColor = true; this.metroLabel6.ForeColor = System.Drawing.SystemColors.ControlLightLight; this.metroLabel6.Location = new System.Drawing.Point(23, 280); this.metroLabel6.Name = "metroLabel6"; this.metroLabel6.Size = new System.Drawing.Size(104, 19); this.metroLabel6.TabIndex = 19; this.metroLabel6.Text = "Empoloyer Type"; // // metroLabel5 // this.metroLabel5.AutoSize = true; this.metroLabel5.BackColor = System.Drawing.Color.Black; this.metroLabel5.CustomBackground = true; this.metroLabel5.CustomForeColor = true; this.metroLabel5.ForeColor = System.Drawing.SystemColors.ControlLightLight; this.metroLabel5.Location = new System.Drawing.Point(23, 244); this.metroLabel5.Name = "metroLabel5"; this.metroLabel5.Size = new System.Drawing.Size(106, 19); this.metroLabel5.TabIndex = 18; this.metroLabel5.Text = "Attendance Date"; // // metroLabel4 // this.metroLabel4.AutoSize = true; this.metroLabel4.BackColor = System.Drawing.Color.Black; this.metroLabel4.CustomBackground = true; this.metroLabel4.CustomForeColor = true; this.metroLabel4.ForeColor = System.Drawing.SystemColors.ControlLightLight; this.metroLabel4.Location = new System.Drawing.Point(23, 207); this.metroLabel4.Name = "metroLabel4"; this.metroLabel4.Size = new System.Drawing.Size(91, 19); this.metroLabel4.TabIndex = 17; this.metroLabel4.Text = "Attendance ID"; // // metroLabel3 // this.metroLabel3.AutoSize = true; this.metroLabel3.BackColor = System.Drawing.Color.Black; this.metroLabel3.CustomBackground = true; this.metroLabel3.CustomForeColor = true; this.metroLabel3.FontSize = MetroFramework.MetroLabelSize.Tall; this.metroLabel3.ForeColor = System.Drawing.SystemColors.ControlLightLight; this.metroLabel3.Location = new System.Drawing.Point(23, 169); this.metroLabel3.Name = "metroLabel3"; this.metroLabel3.Size = new System.Drawing.Size(189, 25); this.metroLabel3.TabIndex = 16; this.metroLabel3.Text = "Add Attendance Details"; // // metroTextBox2 // this.metroTextBox2.CustomBackground = true; this.metroTextBox2.CustomForeColor = true; this.metroTextBox2.Location = new System.Drawing.Point(216, 203); this.metroTextBox2.Name = "metroTextBox2"; this.metroTextBox2.Size = new System.Drawing.Size(135, 23); this.metroTextBox2.TabIndex = 22; // // dataGridView1 // this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dataGridView1.Location = new System.Drawing.Point(441, 160); this.dataGridView1.Name = "dataGridView1"; this.dataGridView1.Size = new System.Drawing.Size(517, 265); this.dataGridView1.TabIndex = 27; // // metroTile6 // this.metroTile6.BackColor = System.Drawing.Color.DarkViolet; this.metroTile6.CustomBackground = true; this.metroTile6.CustomForeColor = true; this.metroTile6.ForeColor = System.Drawing.SystemColors.ActiveCaptionText; this.metroTile6.Location = new System.Drawing.Point(848, 460); this.metroTile6.Name = "metroTile6"; this.metroTile6.Size = new System.Drawing.Size(110, 57); this.metroTile6.TabIndex = 28; this.metroTile6.Text = "Exit"; this.metroTile6.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; this.metroTile6.TileTextFontWeight = MetroFramework.MetroTileTextWeight.Bold; this.metroTile6.Click += new System.EventHandler(this.metroTile6_Click); // // dateTimePicker1 // this.dateTimePicker1.Location = new System.Drawing.Point(216, 232); this.dateTimePicker1.Name = "dateTimePicker1"; this.dateTimePicker1.Size = new System.Drawing.Size(135, 20); this.dateTimePicker1.TabIndex = 31; // // metroComboBox1 // this.metroComboBox1.FormattingEnabled = true; this.metroComboBox1.ItemHeight = 23; this.metroComboBox1.Items.AddRange(new object[] { "Instrouctor", "Manager", "Member"}); this.metroComboBox1.Location = new System.Drawing.Point(216, 270); this.metroComboBox1.Name = "metroComboBox1"; this.metroComboBox1.Size = new System.Drawing.Size(135, 29); this.metroComboBox1.TabIndex = 32; // // metroComboBox2 // this.metroComboBox2.FormattingEnabled = true; this.metroComboBox2.ItemHeight = 23; this.metroComboBox2.Items.AddRange(new object[] { "Male", "female"}); this.metroComboBox2.Location = new System.Drawing.Point(216, 308); this.metroComboBox2.Name = "metroComboBox2"; this.metroComboBox2.Size = new System.Drawing.Size(135, 29); this.metroComboBox2.TabIndex = 33; // // Form3attendance // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(981, 591); this.Controls.Add(this.metroComboBox2); this.Controls.Add(this.metroComboBox1); this.Controls.Add(this.dateTimePicker1); this.Controls.Add(this.metroTile6); this.Controls.Add(this.dataGridView1); this.Controls.Add(this.metroTextBox2); this.Controls.Add(this.metroLabel7); this.Controls.Add(this.metroLabel6); this.Controls.Add(this.metroLabel5); this.Controls.Add(this.metroLabel4); this.Controls.Add(this.metroLabel3); this.Controls.Add(this.metroTextBox1); this.Controls.Add(this.metroTile5); this.Controls.Add(this.metroTile2); this.Controls.Add(this.metroTile1); this.Controls.Add(this.addmember); this.MaximizeBox = false; this.Name = "Form3attendance"; this.Resizable = false; this.Text = "Attendance"; this.Theme = MetroFramework.MetroThemeStyle.Dark; this.addmember.ResumeLayout(false); this.addmember.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
public String InsetarDatosCobrosenformBuscar(MetroFramework.Controls.MetroTextBox pbarrabuscao, MetroFramework.Controls.MetroTextBox pnomyapell, MetroFramework.Controls.MetroTextBox pdni, MetroFramework.Controls.MetroTextBox plegajo, MetroFramework.Controls.MetroComboBox pcuotas, MetroFramework.Controls.MetroTextBox pimporte, /*MetroFramework.Controls.MetroDateTime pfechacobro,*/ MetroFramework.Controls.MetroComboBox pformapago) { con = generarConexion(); con.Open(); metCobros ObjmetCobro = new metCobros(); ObjmetCobro.ExtraerDni(pbarrabuscao); string dniencontrado = ExtraerDni(pbarrabuscao); string consulta = "SELECT co.COB_ID, " + "p.PER_NOMBRE + ',' + p.PER_APELLIDO NOMBRE_APELLIDO, " + "p.PER_DOCUMENTO, " + "p.PER_LEGAJO, " + "c.CUO_FECHA_VENC, " + "CONCAT(CONCAT('$', c.CUO_IMPORTE), ' ', convert(nvarchar(20), c.CUO_FECHA_VENC, 103), ' ', '(', c.CUO_ESTADO, ')') INFO_CUOTA " + "FROM T_PERSONAS p, T_CUOTA_FINAL c, T_COBRO co " + "WHERE p.PER_LEGAJO = c.CUO_PER_LEGAJO " + "AND co.COB_CUO_ID = c.CUO_ID " + "AND p.PER_DOCUMENTO = '" + dniencontrado + "' and c.CUO_ESTADO = 'PAGADA' "; cmd = new SqlCommand(consulta, con); dr = cmd.ExecuteReader(); if (dr.Read() == true) { pnomyapell.Text = dr["NOMBRE_APELLIDO"].ToString(); pdni.Text = dr["PER_DOCUMENTO"].ToString(); plegajo.Text = dr["PER_LEGAJO"].ToString(); } else { MessageBox.Show("El alumno ingresado no tiene registros de cuotas abonadas"); } con.Close(); con = generarConexion(); con.Open(); cmd = new SqlCommand(consulta, con); dta = new SqlDataAdapter(cmd); dt = new DataTable("INFO_CUOTA"); dta.Fill(dt); pcuotas.DataSource = dt; pcuotas.DisplayMember = "INFO_CUOTA"; pcuotas.ValueMember = "COB_ID"; pcuotas.SelectedItem = null; con.Close(); return(dniencontrado); }
private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(DBSetting)); this.btnSave = new MetroFramework.Controls.MetroButton(); this.txtHost = new MetroFramework.Controls.MetroTextBox(); this.metroLabel1 = new MetroFramework.Controls.MetroLabel(); this.btnApply = new MetroFramework.Controls.MetroButton(); this.btnCancel = new MetroFramework.Controls.MetroButton(); this.lbUser = new MetroFramework.Controls.MetroLabel(); this.txtUsername = new MetroFramework.Controls.MetroTextBox(); this.lbPass = new MetroFramework.Controls.MetroLabel(); this.txtPassword = new MetroFramework.Controls.MetroTextBox(); this.metroLabel4 = new MetroFramework.Controls.MetroLabel(); this.cbAuthentication = new MetroFramework.Controls.MetroComboBox(); this.SuspendLayout(); // // btnSave // this.btnSave.Location = new System.Drawing.Point(234, 391); this.btnSave.Name = "btnSave"; this.btnSave.Size = new System.Drawing.Size(95, 29); this.btnSave.Style = MetroFramework.MetroColorStyle.Lime; this.btnSave.TabIndex = 0; this.btnSave.Text = "Save"; this.btnSave.UseCustomBackColor = true; this.btnSave.UseCustomForeColor = true; this.btnSave.UseSelectable = true; this.btnSave.UseStyleColors = true; this.btnSave.Click += new System.EventHandler(this.btnSave_Click); // // txtHost // // // // this.txtHost.CustomButton.Image = null; this.txtHost.CustomButton.Location = new System.Drawing.Point(253, 1); this.txtHost.CustomButton.Name = ""; this.txtHost.CustomButton.Size = new System.Drawing.Size(27, 27); this.txtHost.CustomButton.Style = MetroFramework.MetroColorStyle.Blue; this.txtHost.CustomButton.TabIndex = 1; this.txtHost.CustomButton.Theme = MetroFramework.MetroThemeStyle.Light; this.txtHost.CustomButton.UseSelectable = true; this.txtHost.CustomButton.Visible = false; this.txtHost.FontSize = MetroFramework.MetroTextBoxSize.Medium; this.txtHost.Lines = new string[0]; this.txtHost.Location = new System.Drawing.Point(159, 122); this.txtHost.MaxLength = 32767; this.txtHost.Multiline = true; this.txtHost.Name = "txtHost"; this.txtHost.PasswordChar = '\0'; this.txtHost.ScrollBars = System.Windows.Forms.ScrollBars.None; this.txtHost.SelectedText = ""; this.txtHost.SelectionLength = 0; this.txtHost.SelectionStart = 0; this.txtHost.ShortcutsEnabled = true; this.txtHost.Size = new System.Drawing.Size(281, 29); this.txtHost.Style = MetroFramework.MetroColorStyle.Lime; this.txtHost.TabIndex = 1; this.txtHost.UseCustomBackColor = true; this.txtHost.UseCustomForeColor = true; this.txtHost.UseSelectable = true; this.txtHost.UseStyleColors = true; this.txtHost.WaterMarkColor = System.Drawing.Color.FromArgb(((int)(((byte)(109)))), ((int)(((byte)(109)))), ((int)(((byte)(109))))); this.txtHost.WaterMarkFont = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Pixel); // // metroLabel1 // this.metroLabel1.AutoSize = true; this.metroLabel1.FontSize = MetroFramework.MetroLabelSize.Tall; this.metroLabel1.Location = new System.Drawing.Point(39, 126); this.metroLabel1.Name = "metroLabel1"; this.metroLabel1.Size = new System.Drawing.Size(108, 25); this.metroLabel1.Style = MetroFramework.MetroColorStyle.Lime; this.metroLabel1.TabIndex = 2; this.metroLabel1.Text = "Hostname : "; this.metroLabel1.UseCustomBackColor = true; this.metroLabel1.UseCustomForeColor = true; this.metroLabel1.UseStyleColors = true; // // btnApply // this.btnApply.Location = new System.Drawing.Point(352, 391); this.btnApply.Name = "btnApply"; this.btnApply.Size = new System.Drawing.Size(88, 29); this.btnApply.Style = MetroFramework.MetroColorStyle.Lime; this.btnApply.TabIndex = 3; this.btnApply.Text = "Apply"; this.btnApply.UseCustomBackColor = true; this.btnApply.UseCustomForeColor = true; this.btnApply.UseSelectable = true; this.btnApply.UseStyleColors = true; this.btnApply.Click += new System.EventHandler(this.btnApply_Click); // // btnCancel // this.btnCancel.Location = new System.Drawing.Point(56, 391); this.btnCancel.Name = "btnCancel"; this.btnCancel.Size = new System.Drawing.Size(91, 29); this.btnCancel.Style = MetroFramework.MetroColorStyle.Lime; this.btnCancel.TabIndex = 4; this.btnCancel.Text = "Cancel"; this.btnCancel.UseCustomBackColor = true; this.btnCancel.UseCustomForeColor = true; this.btnCancel.UseSelectable = true; this.btnCancel.UseStyleColors = true; this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click); // // lbUser // this.lbUser.AutoSize = true; this.lbUser.FontSize = MetroFramework.MetroLabelSize.Tall; this.lbUser.Location = new System.Drawing.Point(86, 242); this.lbUser.Name = "lbUser"; this.lbUser.Size = new System.Drawing.Size(106, 25); this.lbUser.Style = MetroFramework.MetroColorStyle.Lime; this.lbUser.TabIndex = 6; this.lbUser.Text = "Username : "******""; this.txtUsername.CustomButton.Size = new System.Drawing.Size(27, 27); this.txtUsername.CustomButton.Style = MetroFramework.MetroColorStyle.Blue; this.txtUsername.CustomButton.TabIndex = 1; this.txtUsername.CustomButton.Theme = MetroFramework.MetroThemeStyle.Light; this.txtUsername.CustomButton.UseSelectable = true; this.txtUsername.CustomButton.Visible = false; this.txtUsername.FontSize = MetroFramework.MetroTextBoxSize.Medium; this.txtUsername.Lines = new string[0]; this.txtUsername.Location = new System.Drawing.Point(192, 242); this.txtUsername.MaxLength = 32767; this.txtUsername.Multiline = true; this.txtUsername.Name = "txtUsername"; this.txtUsername.PasswordChar = '\0'; this.txtUsername.ScrollBars = System.Windows.Forms.ScrollBars.None; this.txtUsername.SelectedText = ""; this.txtUsername.SelectionLength = 0; this.txtUsername.SelectionStart = 0; this.txtUsername.ShortcutsEnabled = true; this.txtUsername.Size = new System.Drawing.Size(248, 29); this.txtUsername.Style = MetroFramework.MetroColorStyle.Lime; this.txtUsername.TabIndex = 5; this.txtUsername.UseCustomBackColor = true; this.txtUsername.UseCustomForeColor = true; this.txtUsername.UseSelectable = true; this.txtUsername.UseStyleColors = true; this.txtUsername.WaterMarkColor = System.Drawing.Color.FromArgb(((int)(((byte)(109)))), ((int)(((byte)(109)))), ((int)(((byte)(109))))); this.txtUsername.WaterMarkFont = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Pixel); // // lbPass // this.lbPass.AutoSize = true; this.lbPass.FontSize = MetroFramework.MetroLabelSize.Tall; this.lbPass.Location = new System.Drawing.Point(86, 298); this.lbPass.Name = "lbPass"; this.lbPass.Size = new System.Drawing.Size(104, 25); this.lbPass.Style = MetroFramework.MetroColorStyle.Lime; this.lbPass.TabIndex = 8; this.lbPass.Text = "Password : "******""; this.txtPassword.CustomButton.Size = new System.Drawing.Size(27, 27); this.txtPassword.CustomButton.Style = MetroFramework.MetroColorStyle.Blue; this.txtPassword.CustomButton.TabIndex = 1; this.txtPassword.CustomButton.Theme = MetroFramework.MetroThemeStyle.Light; this.txtPassword.CustomButton.UseSelectable = true; this.txtPassword.CustomButton.Visible = false; this.txtPassword.FontSize = MetroFramework.MetroTextBoxSize.Medium; this.txtPassword.Lines = new string[0]; this.txtPassword.Location = new System.Drawing.Point(192, 294); this.txtPassword.MaxLength = 32767; this.txtPassword.Multiline = true; this.txtPassword.Name = "txtPassword"; this.txtPassword.PasswordChar = '*'; this.txtPassword.ScrollBars = System.Windows.Forms.ScrollBars.None; this.txtPassword.SelectedText = ""; this.txtPassword.SelectionLength = 0; this.txtPassword.SelectionStart = 0; this.txtPassword.ShortcutsEnabled = true; this.txtPassword.Size = new System.Drawing.Size(248, 29); this.txtPassword.Style = MetroFramework.MetroColorStyle.Lime; this.txtPassword.TabIndex = 7; this.txtPassword.UseCustomBackColor = true; this.txtPassword.UseCustomForeColor = true; this.txtPassword.UseSelectable = true; this.txtPassword.UseStyleColors = true; this.txtPassword.WaterMarkColor = System.Drawing.Color.FromArgb(((int)(((byte)(109)))), ((int)(((byte)(109)))), ((int)(((byte)(109))))); this.txtPassword.WaterMarkFont = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Pixel); // // metroLabel4 // this.metroLabel4.AutoSize = true; this.metroLabel4.FontSize = MetroFramework.MetroLabelSize.Tall; this.metroLabel4.Location = new System.Drawing.Point(5, 185); this.metroLabel4.Name = "metroLabel4"; this.metroLabel4.Size = new System.Drawing.Size(142, 25); this.metroLabel4.Style = MetroFramework.MetroColorStyle.Lime; this.metroLabel4.TabIndex = 9; this.metroLabel4.Text = "Authentication : "; this.metroLabel4.UseCustomBackColor = true; this.metroLabel4.UseCustomForeColor = true; this.metroLabel4.UseStyleColors = true; // // cbAuthentication // this.cbAuthentication.FormattingEnabled = true; this.cbAuthentication.ItemHeight = 24; this.cbAuthentication.Items.AddRange(new object[] { "Windows Authentication", "SQL Server Authentication" }); this.cbAuthentication.Location = new System.Drawing.Point(159, 180); this.cbAuthentication.Name = "cbAuthentication"; this.cbAuthentication.Size = new System.Drawing.Size(281, 30); this.cbAuthentication.Style = MetroFramework.MetroColorStyle.Lime; this.cbAuthentication.TabIndex = 10; this.cbAuthentication.UseCustomBackColor = true; this.cbAuthentication.UseCustomForeColor = true; this.cbAuthentication.UseSelectable = true; this.cbAuthentication.SelectedIndexChanged += new System.EventHandler(this.cbAuthentication_SelectedIndexChanged); // // DBSetting // this.ClientSize = new System.Drawing.Size(504, 452); this.Controls.Add(this.cbAuthentication); this.Controls.Add(this.metroLabel4); this.Controls.Add(this.lbPass); this.Controls.Add(this.txtPassword); this.Controls.Add(this.lbUser); this.Controls.Add(this.txtUsername); this.Controls.Add(this.btnCancel); this.Controls.Add(this.btnApply); this.Controls.Add(this.metroLabel1); this.Controls.Add(this.txtHost); this.Controls.Add(this.btnSave); this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon"))); this.Movable = false; this.Name = "DBSetting"; this.Text = "Setting up a Database"; this.ResumeLayout(false); this.PerformLayout(); }
public void setcmblang(String a, MetroFramework.Controls.MetroComboBox comboBox) { }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(agrergarcasa)); this.metroLabel1 = new MetroFramework.Controls.MetroLabel(); this.metroLink1 = new MetroFramework.Controls.MetroLink(); this.metroComboBox1 = new MetroFramework.Controls.MetroComboBox(); this.metroButton1 = new MetroFramework.Controls.MetroButton(); this.metroStyleManager1 = new MetroFramework.Components.MetroStyleManager(this.components); this.bunifuImageButton1 = new Bunifu.Framework.UI.BunifuImageButton(); ((System.ComponentModel.ISupportInitialize)(this.metroStyleManager1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.bunifuImageButton1)).BeginInit(); this.SuspendLayout(); // // metroLabel1 // this.metroLabel1.AutoSize = true; this.metroLabel1.Location = new System.Drawing.Point(37, 69); this.metroLabel1.Name = "metroLabel1"; this.metroLabel1.Size = new System.Drawing.Size(115, 19); this.metroLabel1.TabIndex = 0; this.metroLabel1.Text = "Seleccione Lugar: "; // // metroLink1 // this.metroLink1.Location = new System.Drawing.Point(113, 113); this.metroLink1.Name = "metroLink1"; this.metroLink1.Size = new System.Drawing.Size(224, 23); this.metroLink1.TabIndex = 2; this.metroLink1.Text = "¿La casa no esta? Registrala AQUI!!"; this.metroLink1.UseSelectable = true; this.metroLink1.Click += new System.EventHandler(this.metroLink1_Click); // // metroComboBox1 // this.metroComboBox1.FormattingEnabled = true; this.metroComboBox1.ItemHeight = 23; this.metroComboBox1.Location = new System.Drawing.Point(158, 69); this.metroComboBox1.Name = "metroComboBox1"; this.metroComboBox1.Size = new System.Drawing.Size(121, 29); this.metroComboBox1.TabIndex = 3; this.metroComboBox1.UseSelectable = true; // // metroButton1 // this.metroButton1.Location = new System.Drawing.Point(177, 153); this.metroButton1.Name = "metroButton1"; this.metroButton1.Size = new System.Drawing.Size(75, 23); this.metroButton1.TabIndex = 4; this.metroButton1.Text = "Agregar"; this.metroButton1.UseSelectable = true; this.metroButton1.Click += new System.EventHandler(this.metroButton1_Click); // // metroStyleManager1 // this.metroStyleManager1.Owner = this; this.metroStyleManager1.Style = MetroFramework.MetroColorStyle.Orange; this.metroStyleManager1.Theme = MetroFramework.MetroThemeStyle.Dark; // // bunifuImageButton1 // this.bunifuImageButton1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(17)))), ((int)(((byte)(17)))), ((int)(((byte)(17))))); this.bunifuImageButton1.Cursor = System.Windows.Forms.Cursors.Hand; this.bunifuImageButton1.Image = ((System.Drawing.Image)(resources.GetObject("bunifuImageButton1.Image"))); this.bunifuImageButton1.ImageActive = null; this.bunifuImageButton1.Location = new System.Drawing.Point(361, 28); this.bunifuImageButton1.Name = "bunifuImageButton1"; this.bunifuImageButton1.Size = new System.Drawing.Size(46, 33); this.bunifuImageButton1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.Zoom; this.bunifuImageButton1.TabIndex = 41; this.bunifuImageButton1.TabStop = false; this.bunifuImageButton1.Zoom = 10; this.bunifuImageButton1.Click += new System.EventHandler(this.bunifuImageButton1_Click); // // agrergarcasa // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(414, 199); this.Controls.Add(this.bunifuImageButton1); this.Controls.Add(this.metroButton1); this.Controls.Add(this.metroComboBox1); this.Controls.Add(this.metroLink1); this.Controls.Add(this.metroLabel1); this.Name = "agrergarcasa"; this.Text = "agrergar casa"; this.Theme = MetroFramework.MetroThemeStyle.Dark; this.Load += new System.EventHandler(this.agrergarcasa_Load); ((System.ComponentModel.ISupportInitialize)(this.metroStyleManager1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.bunifuImageButton1)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FrmRental)); this.GrbDetail = new System.Windows.Forms.GroupBox(); this.DtpRentalDate = new MetroFramework.Controls.MetroDateTime(); this.TxtBookNames = new MetroFramework.Controls.MetroTextBox(); this.metroLabel8 = new MetroFramework.Controls.MetroLabel(); this.metroLabel3 = new MetroFramework.Controls.MetroLabel(); this.BtnSave = new MetroFramework.Controls.MetroButton(); this.BtnNew = new MetroFramework.Controls.MetroButton(); this.TxtMemberName = new MetroFramework.Controls.MetroTextBox(); this.TxtIdx = new MetroFramework.Controls.MetroTextBox(); this.metroLabel2 = new MetroFramework.Controls.MetroLabel(); this.metroLabel1 = new MetroFramework.Controls.MetroLabel(); this.DgvData = new System.Windows.Forms.DataGridView(); this.BtnSearchMember = new System.Windows.Forms.Button(); this.BtnSearchBook = new System.Windows.Forms.Button(); this.metroLabel4 = new MetroFramework.Controls.MetroLabel(); this.metroLabel5 = new MetroFramework.Controls.MetroLabel(); this.CboRentalState = new MetroFramework.Controls.MetroComboBox(); this.TxtReturnDate = new MetroFramework.Controls.MetroTextBox(); this.GrbDetail.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.DgvData)).BeginInit(); this.SuspendLayout(); // // GrbDetail // this.GrbDetail.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Right))); this.GrbDetail.Controls.Add(this.TxtReturnDate); this.GrbDetail.Controls.Add(this.CboRentalState); this.GrbDetail.Controls.Add(this.metroLabel5); this.GrbDetail.Controls.Add(this.metroLabel4); this.GrbDetail.Controls.Add(this.BtnSearchBook); this.GrbDetail.Controls.Add(this.BtnSearchMember); this.GrbDetail.Controls.Add(this.DtpRentalDate); this.GrbDetail.Controls.Add(this.TxtBookNames); this.GrbDetail.Controls.Add(this.metroLabel8); this.GrbDetail.Controls.Add(this.metroLabel3); this.GrbDetail.Controls.Add(this.BtnSave); this.GrbDetail.Controls.Add(this.BtnNew); this.GrbDetail.Controls.Add(this.TxtMemberName); this.GrbDetail.Controls.Add(this.TxtIdx); this.GrbDetail.Controls.Add(this.metroLabel2); this.GrbDetail.Controls.Add(this.metroLabel1); this.GrbDetail.Location = new System.Drawing.Point(368, 63); this.GrbDetail.Name = "GrbDetail"; this.GrbDetail.Size = new System.Drawing.Size(321, 472); this.GrbDetail.TabIndex = 0; this.GrbDetail.TabStop = false; this.GrbDetail.Text = "상세"; // // DtpRentalDate // this.DtpRentalDate.CustomFormat = "yyyy-MM-dd"; this.DtpRentalDate.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.DtpRentalDate.Location = new System.Drawing.Point(99, 118); this.DtpRentalDate.MinimumSize = new System.Drawing.Size(0, 29); this.DtpRentalDate.Name = "DtpRentalDate"; this.DtpRentalDate.Size = new System.Drawing.Size(180, 29); this.DtpRentalDate.TabIndex = 7; // // TxtBookNames // // // // this.TxtBookNames.CustomButton.Image = null; this.TxtBookNames.CustomButton.Location = new System.Drawing.Point(128, 1); this.TxtBookNames.CustomButton.Name = ""; this.TxtBookNames.CustomButton.Size = new System.Drawing.Size(21, 21); this.TxtBookNames.CustomButton.Style = MetroFramework.MetroColorStyle.Blue; this.TxtBookNames.CustomButton.TabIndex = 1; this.TxtBookNames.CustomButton.Theme = MetroFramework.MetroThemeStyle.Light; this.TxtBookNames.CustomButton.UseSelectable = true; this.TxtBookNames.CustomButton.Visible = false; this.TxtBookNames.Lines = new string[0]; this.TxtBookNames.Location = new System.Drawing.Point(99, 89); this.TxtBookNames.MaxLength = 32767; this.TxtBookNames.Name = "TxtBookNames"; this.TxtBookNames.PasswordChar = '\0'; this.TxtBookNames.PromptText = "도서명"; this.TxtBookNames.ScrollBars = System.Windows.Forms.ScrollBars.None; this.TxtBookNames.SelectedText = ""; this.TxtBookNames.SelectionLength = 0; this.TxtBookNames.SelectionStart = 0; this.TxtBookNames.ShortcutsEnabled = true; this.TxtBookNames.Size = new System.Drawing.Size(150, 23); this.TxtBookNames.TabIndex = 5; this.TxtBookNames.UseSelectable = true; this.TxtBookNames.WaterMark = "도서명"; this.TxtBookNames.WaterMarkColor = System.Drawing.Color.FromArgb(((int)(((byte)(109)))), ((int)(((byte)(109)))), ((int)(((byte)(109))))); this.TxtBookNames.WaterMarkFont = new System.Drawing.Font("맑은 고딕", 9F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0))); // // metroLabel8 // this.metroLabel8.AutoSize = true; this.metroLabel8.Location = new System.Drawing.Point(37, 124); this.metroLabel8.Name = "metroLabel8"; this.metroLabel8.Size = new System.Drawing.Size(62, 19); this.metroLabel8.TabIndex = 9; this.metroLabel8.Text = "대여일 : "; // // metroLabel3 // this.metroLabel3.AutoSize = true; this.metroLabel3.Location = new System.Drawing.Point(37, 90); this.metroLabel3.Name = "metroLabel3"; this.metroLabel3.Size = new System.Drawing.Size(62, 19); this.metroLabel3.TabIndex = 8; this.metroLabel3.Text = "도서명 : "; // // BtnSave // this.BtnSave.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.BtnSave.Location = new System.Drawing.Point(177, 401); this.BtnSave.Name = "BtnSave"; this.BtnSave.Size = new System.Drawing.Size(115, 52); this.BtnSave.TabIndex = 12; this.BtnSave.Text = "저장"; this.BtnSave.UseSelectable = true; this.BtnSave.Click += new System.EventHandler(this.BtnSave_Click); // // BtnNew // this.BtnNew.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.BtnNew.Location = new System.Drawing.Point(37, 401); this.BtnNew.Name = "BtnNew"; this.BtnNew.Size = new System.Drawing.Size(104, 52); this.BtnNew.TabIndex = 11; this.BtnNew.Text = "신규"; this.BtnNew.UseSelectable = true; this.BtnNew.Click += new System.EventHandler(this.BtnNew_Click); // // TxtMemberName // // // // this.TxtMemberName.CustomButton.Image = null; this.TxtMemberName.CustomButton.Location = new System.Drawing.Point(128, 1); this.TxtMemberName.CustomButton.Name = ""; this.TxtMemberName.CustomButton.Size = new System.Drawing.Size(21, 21); this.TxtMemberName.CustomButton.Style = MetroFramework.MetroColorStyle.Blue; this.TxtMemberName.CustomButton.TabIndex = 1; this.TxtMemberName.CustomButton.Theme = MetroFramework.MetroThemeStyle.Light; this.TxtMemberName.CustomButton.UseSelectable = true; this.TxtMemberName.CustomButton.Visible = false; this.TxtMemberName.Lines = new string[0]; this.TxtMemberName.Location = new System.Drawing.Point(99, 60); this.TxtMemberName.MaxLength = 32767; this.TxtMemberName.Name = "TxtMemberName"; this.TxtMemberName.PasswordChar = '\0'; this.TxtMemberName.PromptText = "대여회원"; this.TxtMemberName.ScrollBars = System.Windows.Forms.ScrollBars.None; this.TxtMemberName.SelectedText = ""; this.TxtMemberName.SelectionLength = 0; this.TxtMemberName.SelectionStart = 0; this.TxtMemberName.ShortcutsEnabled = true; this.TxtMemberName.Size = new System.Drawing.Size(150, 23); this.TxtMemberName.TabIndex = 3; this.TxtMemberName.UseSelectable = true; this.TxtMemberName.WaterMark = "대여회원"; this.TxtMemberName.WaterMarkColor = System.Drawing.Color.FromArgb(((int)(((byte)(109)))), ((int)(((byte)(109)))), ((int)(((byte)(109))))); this.TxtMemberName.WaterMarkFont = new System.Drawing.Font("맑은 고딕", 9F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0))); // // TxtIdx // // // // this.TxtIdx.CustomButton.Image = null; this.TxtIdx.CustomButton.Location = new System.Drawing.Point(158, 1); this.TxtIdx.CustomButton.Name = ""; this.TxtIdx.CustomButton.Size = new System.Drawing.Size(21, 21); this.TxtIdx.CustomButton.Style = MetroFramework.MetroColorStyle.Blue; this.TxtIdx.CustomButton.TabIndex = 1; this.TxtIdx.CustomButton.Theme = MetroFramework.MetroThemeStyle.Light; this.TxtIdx.CustomButton.UseSelectable = true; this.TxtIdx.CustomButton.Visible = false; this.TxtIdx.Lines = new string[0]; this.TxtIdx.Location = new System.Drawing.Point(99, 31); this.TxtIdx.MaxLength = 32767; this.TxtIdx.Name = "TxtIdx"; this.TxtIdx.PasswordChar = '\0'; this.TxtIdx.PromptText = "순번"; this.TxtIdx.ReadOnly = true; this.TxtIdx.ScrollBars = System.Windows.Forms.ScrollBars.None; this.TxtIdx.SelectedText = ""; this.TxtIdx.SelectionLength = 0; this.TxtIdx.SelectionStart = 0; this.TxtIdx.ShortcutsEnabled = true; this.TxtIdx.Size = new System.Drawing.Size(180, 23); this.TxtIdx.TabIndex = 2; this.TxtIdx.UseSelectable = true; this.TxtIdx.WaterMark = "순번"; this.TxtIdx.WaterMarkColor = System.Drawing.Color.FromArgb(((int)(((byte)(109)))), ((int)(((byte)(109)))), ((int)(((byte)(109))))); this.TxtIdx.WaterMarkFont = new System.Drawing.Font("맑은 고딕", 9F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0))); // // metroLabel2 // this.metroLabel2.AutoSize = true; this.metroLabel2.Location = new System.Drawing.Point(23, 61); this.metroLabel2.Name = "metroLabel2"; this.metroLabel2.Size = new System.Drawing.Size(76, 19); this.metroLabel2.TabIndex = 1; this.metroLabel2.Text = "대여회원 : "; // // metroLabel1 // this.metroLabel1.AutoSize = true; this.metroLabel1.Location = new System.Drawing.Point(51, 33); this.metroLabel1.Name = "metroLabel1"; this.metroLabel1.Size = new System.Drawing.Size(48, 19); this.metroLabel1.TabIndex = 0; this.metroLabel1.Text = "순번 : "; // // DgvData // this.DgvData.AllowUserToAddRows = false; this.DgvData.AllowUserToDeleteRows = false; this.DgvData.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.DgvData.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.DgvData.Location = new System.Drawing.Point(23, 63); this.DgvData.Name = "DgvData"; this.DgvData.ReadOnly = true; this.DgvData.RowTemplate.Height = 23; this.DgvData.Size = new System.Drawing.Size(329, 472); this.DgvData.TabIndex = 1; this.DgvData.CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.DgvData_CellClick); // // BtnSearchMember // this.BtnSearchMember.FlatAppearance.BorderSize = 0; this.BtnSearchMember.Image = ((System.Drawing.Image)(resources.GetObject("BtnSearchMember.Image"))); this.BtnSearchMember.Location = new System.Drawing.Point(255, 60); this.BtnSearchMember.Name = "BtnSearchMember"; this.BtnSearchMember.Size = new System.Drawing.Size(24, 23); this.BtnSearchMember.TabIndex = 4; this.BtnSearchMember.UseVisualStyleBackColor = true; this.BtnSearchMember.Click += new System.EventHandler(this.BtnSearchMember_Click); // // BtnSearchBook // this.BtnSearchBook.FlatAppearance.BorderSize = 0; this.BtnSearchBook.Image = ((System.Drawing.Image)(resources.GetObject("BtnSearchBook.Image"))); this.BtnSearchBook.Location = new System.Drawing.Point(255, 89); this.BtnSearchBook.Name = "BtnSearchBook"; this.BtnSearchBook.Size = new System.Drawing.Size(24, 23); this.BtnSearchBook.TabIndex = 6; this.BtnSearchBook.UseVisualStyleBackColor = true; this.BtnSearchBook.Click += new System.EventHandler(this.BtnSearchBook_Click); // // metroLabel4 // this.metroLabel4.AutoSize = true; this.metroLabel4.Location = new System.Drawing.Point(37, 157); this.metroLabel4.Name = "metroLabel4"; this.metroLabel4.Size = new System.Drawing.Size(62, 19); this.metroLabel4.TabIndex = 16; this.metroLabel4.Text = "반납일 : "; // // metroLabel5 // this.metroLabel5.AutoSize = true; this.metroLabel5.Location = new System.Drawing.Point(23, 191); this.metroLabel5.Name = "metroLabel5"; this.metroLabel5.Size = new System.Drawing.Size(76, 19); this.metroLabel5.TabIndex = 16; this.metroLabel5.Text = "대여상태 : "; // // CboRentalState // this.CboRentalState.FormattingEnabled = true; this.CboRentalState.ItemHeight = 23; this.CboRentalState.Location = new System.Drawing.Point(99, 188); this.CboRentalState.Name = "CboRentalState"; this.CboRentalState.Size = new System.Drawing.Size(87, 29); this.CboRentalState.TabIndex = 9; this.CboRentalState.UseSelectable = true; // // TxtReturnDate // // // // this.TxtReturnDate.CustomButton.Image = null; this.TxtReturnDate.CustomButton.Location = new System.Drawing.Point(158, 1); this.TxtReturnDate.CustomButton.Name = ""; this.TxtReturnDate.CustomButton.Size = new System.Drawing.Size(21, 21); this.TxtReturnDate.CustomButton.Style = MetroFramework.MetroColorStyle.Blue; this.TxtReturnDate.CustomButton.TabIndex = 1; this.TxtReturnDate.CustomButton.Theme = MetroFramework.MetroThemeStyle.Light; this.TxtReturnDate.CustomButton.UseSelectable = true; this.TxtReturnDate.CustomButton.Visible = false; this.TxtReturnDate.Lines = new string[0]; this.TxtReturnDate.Location = new System.Drawing.Point(99, 156); this.TxtReturnDate.MaxLength = 32767; this.TxtReturnDate.Name = "TxtReturnDate"; this.TxtReturnDate.PasswordChar = '\0'; this.TxtReturnDate.ReadOnly = true; this.TxtReturnDate.ScrollBars = System.Windows.Forms.ScrollBars.None; this.TxtReturnDate.SelectedText = ""; this.TxtReturnDate.SelectionLength = 0; this.TxtReturnDate.SelectionStart = 0; this.TxtReturnDate.ShortcutsEnabled = true; this.TxtReturnDate.Size = new System.Drawing.Size(180, 23); this.TxtReturnDate.TabIndex = 17; this.TxtReturnDate.UseSelectable = true; this.TxtReturnDate.WaterMarkColor = System.Drawing.Color.FromArgb(((int)(((byte)(109)))), ((int)(((byte)(109)))), ((int)(((byte)(109))))); this.TxtReturnDate.WaterMarkFont = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Pixel); // // FrmRental // this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(709, 554); this.Controls.Add(this.DgvData); this.Controls.Add(this.GrbDetail); this.Name = "FrmRental"; this.Text = "도서 대여 관리"; this.Load += new System.EventHandler(this.FrmDivCode_Load); this.Resize += new System.EventHandler(this.FrmDivCode_Resize); this.GrbDetail.ResumeLayout(false); this.GrbDetail.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.DgvData)).EndInit(); this.ResumeLayout(false); }