Created
December 9, 2016 09:18
-
-
Save ertugrulozcan/34aa1c7ecf4f0069dfceacac31794a5d to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System; | |
| using System.Data; | |
| using System.Data.SqlClient; | |
| using System.Data.OleDb; | |
| using System.Configuration; | |
| namespace stok_takip | |
| { | |
| partial class stoga_giris | |
| { | |
| /// <summary> | |
| /// Required designer variable. | |
| /// </summary> | |
| private System.ComponentModel.IContainer components = null; | |
| protected override void OnLoad(EventArgs e) | |
| { | |
| base.OnLoad(e); | |
| this.ReadCompanyListFromDatabase(ConfigurationManager.ConnectionStrings["stok_takip.Properties.Settings.stokConnectionString"].ConnectionString); | |
| } | |
| private void ReadCompanyListFromDatabase(string connectionString) | |
| { | |
| DataSet dataset = new DataSet(); | |
| using (OleDbConnection connection = new OleDbConnection(connectionString)) | |
| { | |
| OleDbDataAdapter adapter = new OleDbDataAdapter(); | |
| adapter.SelectCommand = new OleDbCommand("select * from urunler", connection); | |
| adapter.Fill(dataset); | |
| } | |
| } | |
| private void LoadCompanyListBox(DataSet dataset) | |
| { | |
| DataTable dtable = dataset.Tables["authenticate"]; | |
| this.listBox1.Items.Clear(); | |
| for (int i = 0; i < dtable.Rows.Count; i++) | |
| { | |
| DataRow drow = dtable.Rows[i]; | |
| this.listBox1.Items.Add(drow["name"].ToString()); | |
| } | |
| } | |
| /// <summary> | |
| /// Clean up any resources being used. | |
| /// </summary> | |
| /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param> | |
| protected override void Dispose(bool disposing) | |
| { | |
| if (disposing && (components != null)) | |
| { | |
| components.Dispose(); | |
| } | |
| base.Dispose(disposing); | |
| } | |
| #region Windows Form Designer generated code | |
| /// <summary> | |
| /// Required method for Designer support - do not modify | |
| /// the contents of this method with the code editor. | |
| /// </summary> | |
| private void InitializeComponent() | |
| { | |
| this.groupBox1 = new System.Windows.Forms.GroupBox(); | |
| this.listeye_ekle = new System.Windows.Forms.Button(); | |
| this.fiyati_tb = new System.Windows.Forms.TextBox(); | |
| this.comboBox1 = new System.Windows.Forms.ComboBox(); | |
| this.label12 = new System.Windows.Forms.Label(); | |
| this.label9 = new System.Windows.Forms.Label(); | |
| this.label11 = new System.Windows.Forms.Label(); | |
| this.label8 = new System.Windows.Forms.Label(); | |
| this.label10 = new System.Windows.Forms.Label(); | |
| this.label7 = new System.Windows.Forms.Label(); | |
| this.label6 = new System.Windows.Forms.Label(); | |
| this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker(); | |
| this.miktari_tb = new System.Windows.Forms.TextBox(); | |
| this.label5 = new System.Windows.Forms.Label(); | |
| this.mevcut_tb = new System.Windows.Forms.TextBox(); | |
| this.kdv_tb = new System.Windows.Forms.TextBox(); | |
| this.birimi_tb = new System.Windows.Forms.TextBox(); | |
| this.kodu_tb = new System.Windows.Forms.TextBox(); | |
| this.urun_bul_tb = new System.Windows.Forms.TextBox(); | |
| this.label4 = new System.Windows.Forms.Label(); | |
| this.label3 = new System.Windows.Forms.Label(); | |
| this.listBox2 = new System.Windows.Forms.ListBox(); | |
| this.firma_bul_tb = new System.Windows.Forms.TextBox(); | |
| this.label2 = new System.Windows.Forms.Label(); | |
| this.listBox1 = new System.Windows.Forms.ListBox(); | |
| this.label1 = new System.Windows.Forms.Label(); | |
| this.groupBox2 = new System.Windows.Forms.GroupBox(); | |
| this.dataGridView1 = new System.Windows.Forms.DataGridView(); | |
| this.groupBox1.SuspendLayout(); | |
| this.groupBox2.SuspendLayout(); | |
| ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); | |
| this.SuspendLayout(); | |
| // | |
| // groupBox1 | |
| // | |
| this.groupBox1.Controls.Add(this.listeye_ekle); | |
| this.groupBox1.Controls.Add(this.fiyati_tb); | |
| this.groupBox1.Controls.Add(this.comboBox1); | |
| this.groupBox1.Controls.Add(this.label12); | |
| this.groupBox1.Controls.Add(this.label9); | |
| this.groupBox1.Controls.Add(this.label11); | |
| this.groupBox1.Controls.Add(this.label8); | |
| this.groupBox1.Controls.Add(this.label10); | |
| this.groupBox1.Controls.Add(this.label7); | |
| this.groupBox1.Controls.Add(this.label6); | |
| this.groupBox1.Controls.Add(this.dateTimePicker1); | |
| this.groupBox1.Controls.Add(this.miktari_tb); | |
| this.groupBox1.Controls.Add(this.label5); | |
| this.groupBox1.Controls.Add(this.mevcut_tb); | |
| this.groupBox1.Controls.Add(this.kdv_tb); | |
| this.groupBox1.Controls.Add(this.birimi_tb); | |
| this.groupBox1.Controls.Add(this.kodu_tb); | |
| this.groupBox1.Controls.Add(this.urun_bul_tb); | |
| this.groupBox1.Controls.Add(this.label4); | |
| this.groupBox1.Controls.Add(this.label3); | |
| this.groupBox1.Controls.Add(this.listBox2); | |
| this.groupBox1.Controls.Add(this.firma_bul_tb); | |
| this.groupBox1.Controls.Add(this.label2); | |
| this.groupBox1.Controls.Add(this.listBox1); | |
| this.groupBox1.Controls.Add(this.label1); | |
| this.groupBox1.Location = new System.Drawing.Point(13, 13); | |
| this.groupBox1.Name = "groupBox1"; | |
| this.groupBox1.Size = new System.Drawing.Size(791, 197); | |
| this.groupBox1.TabIndex = 0; | |
| this.groupBox1.TabStop = false; | |
| this.groupBox1.Text = "Giriş Yapılacak Ürünün Seçimi"; | |
| // | |
| // listeye_ekle | |
| // | |
| this.listeye_ekle.Location = new System.Drawing.Point(657, 139); | |
| this.listeye_ekle.Name = "listeye_ekle"; | |
| this.listeye_ekle.Size = new System.Drawing.Size(124, 41); | |
| this.listeye_ekle.TabIndex = 20; | |
| this.listeye_ekle.Text = "Listeye Ekle"; | |
| this.listeye_ekle.UseVisualStyleBackColor = true; | |
| // | |
| // fiyati_tb | |
| // | |
| this.fiyati_tb.Location = new System.Drawing.Point(660, 97); | |
| this.fiyati_tb.Name = "fiyati_tb"; | |
| this.fiyati_tb.Size = new System.Drawing.Size(100, 22); | |
| this.fiyati_tb.TabIndex = 19; | |
| // | |
| // comboBox1 | |
| // | |
| this.comboBox1.FormattingEnabled = true; | |
| this.comboBox1.Location = new System.Drawing.Point(454, 156); | |
| this.comboBox1.Name = "comboBox1"; | |
| this.comboBox1.Size = new System.Drawing.Size(121, 24); | |
| this.comboBox1.TabIndex = 17; | |
| // | |
| // label12 | |
| // | |
| this.label12.AutoSize = true; | |
| this.label12.Location = new System.Drawing.Point(605, 100); | |
| this.label12.Name = "label12"; | |
| this.label12.Size = new System.Drawing.Size(49, 17); | |
| this.label12.TabIndex = 3; | |
| this.label12.Text = "Fiyatı :"; | |
| // | |
| // label9 | |
| // | |
| this.label9.AutoSize = true; | |
| this.label9.Location = new System.Drawing.Point(358, 156); | |
| this.label9.Name = "label9"; | |
| this.label9.Size = new System.Drawing.Size(90, 17); | |
| this.label9.TabIndex = 12; | |
| this.label9.Text = "Giriş Yapan :"; | |
| // | |
| // label11 | |
| // | |
| this.label11.AutoSize = true; | |
| this.label11.Location = new System.Drawing.Point(597, 71); | |
| this.label11.Name = "label11"; | |
| this.label11.Size = new System.Drawing.Size(57, 17); | |
| this.label11.TabIndex = 2; | |
| this.label11.Text = "Miktarı :"; | |
| // | |
| // label8 | |
| // | |
| this.label8.AutoSize = true; | |
| this.label8.Location = new System.Drawing.Point(387, 130); | |
| this.label8.Name = "label8"; | |
| this.label8.Size = new System.Drawing.Size(61, 17); | |
| this.label8.TabIndex = 11; | |
| this.label8.Text = "Mevcut :"; | |
| // | |
| // label10 | |
| // | |
| this.label10.AutoSize = true; | |
| this.label10.Location = new System.Drawing.Point(602, 41); | |
| this.label10.Name = "label10"; | |
| this.label10.Size = new System.Drawing.Size(52, 17); | |
| this.label10.TabIndex = 1; | |
| this.label10.Text = "Tarihi :"; | |
| // | |
| // label7 | |
| // | |
| this.label7.AutoSize = true; | |
| this.label7.Location = new System.Drawing.Point(404, 101); | |
| this.label7.Name = "label7"; | |
| this.label7.Size = new System.Drawing.Size(44, 17); | |
| this.label7.TabIndex = 10; | |
| this.label7.Text = "KDV :"; | |
| // | |
| // label6 | |
| // | |
| this.label6.AutoSize = true; | |
| this.label6.Location = new System.Drawing.Point(398, 72); | |
| this.label6.Name = "label6"; | |
| this.label6.Size = new System.Drawing.Size(50, 17); | |
| this.label6.TabIndex = 9; | |
| this.label6.Text = "Birimi :"; | |
| // | |
| // dateTimePicker1 | |
| // | |
| this.dateTimePicker1.Format = System.Windows.Forms.DateTimePickerFormat.Short; | |
| this.dateTimePicker1.Location = new System.Drawing.Point(660, 40); | |
| this.dateTimePicker1.Name = "dateTimePicker1"; | |
| this.dateTimePicker1.Size = new System.Drawing.Size(121, 22); | |
| this.dateTimePicker1.TabIndex = 4; | |
| // | |
| // miktari_tb | |
| // | |
| this.miktari_tb.Location = new System.Drawing.Point(660, 68); | |
| this.miktari_tb.Name = "miktari_tb"; | |
| this.miktari_tb.Size = new System.Drawing.Size(100, 22); | |
| this.miktari_tb.TabIndex = 18; | |
| // | |
| // label5 | |
| // | |
| this.label5.AutoSize = true; | |
| this.label5.Location = new System.Drawing.Point(399, 43); | |
| this.label5.Name = "label5"; | |
| this.label5.Size = new System.Drawing.Size(49, 17); | |
| this.label5.TabIndex = 8; | |
| this.label5.Text = "Kodu :"; | |
| // | |
| // mevcut_tb | |
| // | |
| this.mevcut_tb.Location = new System.Drawing.Point(454, 127); | |
| this.mevcut_tb.Name = "mevcut_tb"; | |
| this.mevcut_tb.Size = new System.Drawing.Size(100, 22); | |
| this.mevcut_tb.TabIndex = 16; | |
| // | |
| // kdv_tb | |
| // | |
| this.kdv_tb.Location = new System.Drawing.Point(454, 98); | |
| this.kdv_tb.Name = "kdv_tb"; | |
| this.kdv_tb.Size = new System.Drawing.Size(100, 22); | |
| this.kdv_tb.TabIndex = 15; | |
| // | |
| // birimi_tb | |
| // | |
| this.birimi_tb.Location = new System.Drawing.Point(454, 69); | |
| this.birimi_tb.Name = "birimi_tb"; | |
| this.birimi_tb.Size = new System.Drawing.Size(100, 22); | |
| this.birimi_tb.TabIndex = 14; | |
| // | |
| // kodu_tb | |
| // | |
| this.kodu_tb.Location = new System.Drawing.Point(454, 40); | |
| this.kodu_tb.Name = "kodu_tb"; | |
| this.kodu_tb.Size = new System.Drawing.Size(100, 22); | |
| this.kodu_tb.TabIndex = 13; | |
| // | |
| // urun_bul_tb | |
| // | |
| this.urun_bul_tb.Location = new System.Drawing.Point(181, 167); | |
| this.urun_bul_tb.Name = "urun_bul_tb"; | |
| this.urun_bul_tb.Size = new System.Drawing.Size(169, 22); | |
| this.urun_bul_tb.TabIndex = 7; | |
| // | |
| // label4 | |
| // | |
| this.label4.AutoSize = true; | |
| this.label4.Location = new System.Drawing.Point(178, 147); | |
| this.label4.Name = "label4"; | |
| this.label4.Size = new System.Drawing.Size(63, 17); | |
| this.label4.TabIndex = 6; | |
| this.label4.Text = "Ürün Bul"; | |
| // | |
| // label3 | |
| // | |
| this.label3.AutoSize = true; | |
| this.label3.Location = new System.Drawing.Point(179, 23); | |
| this.label3.Name = "label3"; | |
| this.label3.Size = new System.Drawing.Size(55, 17); | |
| this.label3.TabIndex = 5; | |
| this.label3.Text = "Ürünler"; | |
| // | |
| // listBox2 | |
| // | |
| this.listBox2.FormattingEnabled = true; | |
| this.listBox2.ItemHeight = 16; | |
| this.listBox2.Location = new System.Drawing.Point(182, 43); | |
| this.listBox2.Name = "listBox2"; | |
| this.listBox2.Size = new System.Drawing.Size(169, 100); | |
| this.listBox2.TabIndex = 4; | |
| // | |
| // firma_bul_tb | |
| // | |
| this.firma_bul_tb.Location = new System.Drawing.Point(6, 167); | |
| this.firma_bul_tb.Name = "firma_bul_tb"; | |
| this.firma_bul_tb.Size = new System.Drawing.Size(169, 22); | |
| this.firma_bul_tb.TabIndex = 3; | |
| // | |
| // label2 | |
| // | |
| this.label2.AutoSize = true; | |
| this.label2.Location = new System.Drawing.Point(6, 146); | |
| this.label2.Name = "label2"; | |
| this.label2.Size = new System.Drawing.Size(67, 17); | |
| this.label2.TabIndex = 2; | |
| this.label2.Text = "Firma Bul"; | |
| // | |
| // listBox1 | |
| // | |
| this.listBox1.FormattingEnabled = true; | |
| this.listBox1.ItemHeight = 16; | |
| this.listBox1.Location = new System.Drawing.Point(7, 43); | |
| this.listBox1.Name = "listBox1"; | |
| this.listBox1.Size = new System.Drawing.Size(169, 100); | |
| this.listBox1.TabIndex = 1; | |
| // | |
| // label1 | |
| // | |
| this.label1.AutoSize = true; | |
| this.label1.Location = new System.Drawing.Point(7, 22); | |
| this.label1.Name = "label1"; | |
| this.label1.Size = new System.Drawing.Size(59, 17); | |
| this.label1.TabIndex = 0; | |
| this.label1.Text = "Firmalar"; | |
| // | |
| // groupBox2 | |
| // | |
| this.groupBox2.Controls.Add(this.dataGridView1); | |
| this.groupBox2.Location = new System.Drawing.Point(13, 217); | |
| this.groupBox2.Name = "groupBox2"; | |
| this.groupBox2.Size = new System.Drawing.Size(791, 197); | |
| this.groupBox2.TabIndex = 1; | |
| this.groupBox2.TabStop = false; | |
| this.groupBox2.Text = "Girişi Yapılacak Ürün Listesi"; | |
| // | |
| // dataGridView1 | |
| // | |
| this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; | |
| this.dataGridView1.Location = new System.Drawing.Point(7, 22); | |
| this.dataGridView1.Name = "dataGridView1"; | |
| this.dataGridView1.RowTemplate.Height = 24; | |
| this.dataGridView1.Size = new System.Drawing.Size(774, 169); | |
| this.dataGridView1.TabIndex = 0; | |
| // | |
| // stoga_giris | |
| // | |
| this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 16F); | |
| this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; | |
| this.ClientSize = new System.Drawing.Size(816, 425); | |
| this.Controls.Add(this.groupBox2); | |
| this.Controls.Add(this.groupBox1); | |
| this.Name = "stoga_giris"; | |
| this.Text = "stoga_giris"; | |
| this.groupBox1.ResumeLayout(false); | |
| this.groupBox1.PerformLayout(); | |
| this.groupBox2.ResumeLayout(false); | |
| ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); | |
| this.ResumeLayout(false); | |
| } | |
| #endregion | |
| private System.Windows.Forms.GroupBox groupBox1; | |
| private System.Windows.Forms.ComboBox comboBox1; | |
| private System.Windows.Forms.Label label9; | |
| private System.Windows.Forms.Label label8; | |
| private System.Windows.Forms.Label label7; | |
| private System.Windows.Forms.Label label6; | |
| private System.Windows.Forms.Label label5; | |
| private System.Windows.Forms.TextBox mevcut_tb; | |
| private System.Windows.Forms.TextBox kdv_tb; | |
| private System.Windows.Forms.TextBox birimi_tb; | |
| private System.Windows.Forms.TextBox kodu_tb; | |
| private System.Windows.Forms.TextBox urun_bul_tb; | |
| private System.Windows.Forms.Label label4; | |
| private System.Windows.Forms.Label label3; | |
| private System.Windows.Forms.ListBox listBox2; | |
| private System.Windows.Forms.TextBox firma_bul_tb; | |
| private System.Windows.Forms.Label label2; | |
| private System.Windows.Forms.ListBox listBox1; | |
| private System.Windows.Forms.Label label1; | |
| private System.Windows.Forms.Button listeye_ekle; | |
| private System.Windows.Forms.TextBox fiyati_tb; | |
| private System.Windows.Forms.Label label12; | |
| private System.Windows.Forms.Label label11; | |
| private System.Windows.Forms.Label label10; | |
| private System.Windows.Forms.DateTimePicker dateTimePicker1; | |
| private System.Windows.Forms.TextBox miktari_tb; | |
| private System.Windows.Forms.GroupBox groupBox2; | |
| private System.Windows.Forms.DataGridView dataGridView1; | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment