private void frmKisiListesi_Load(object sender, EventArgs e) { SqlClass sqlCon = new SqlClass(); String bag; // MySqlConnectionStringBuilder build = new MySqlConnectionStringBuilder(); DataSet dSet = new DataSet(); //build.Server = "localhost"; //build.UserID = "root"; //build.Password = "******"; //build.Database = "case_follow"; //build.Port = 3306; // DataGridView stock_list = new DataGridView(); stock_list.Name = "stock_list"; //SqlClass sqlCon = new SqlClass(); SqlClass connect = new SqlClass(); connect.ConnectSql(); String sql2 = "SELECT ID, NAME, SURNAME FROM customer_list "; //if (DataGridList.Name == "dtgridSalesList") // sql = sql + " ORDER BY SALE_CODE"; DataTable dtable2 = new DataTable(); MySqlDataAdapter adapter2 = new MySqlDataAdapter(); MySqlCommand command2 = new MySqlCommand(); bag = build.ToString(); baglanti = new MySqlConnection(bag); command2.CommandText = sql2; command2.Connection = baglanti; adapter2.SelectCommand = command2; baglanti.Open(); adapter2.Fill(dtable2); adapter2.Fill(dSet); stock_list.DataSource = dtable2; dtgrdList.DataSource = dtable2; baglanti.Close(); // sqlCon.ListData(dtgrdStockList, DateTime.Now, DateTime.Now); dtgrdList.Columns[0].HeaderText = "ID"; dtgrdList.Columns[1].HeaderText = "Adı"; dtgrdList.Columns[2].HeaderText = "Soyadı"; dtgrdList.Columns[0].Visible = false; }
private void dtgrdStockList_CellEnter(object sender, DataGridViewCellEventArgs e) { String lvSL_CODE; try { lvSL_CODE = dtgrdStockList.CurrentRow.Cells["CODE"].Value.ToString(); } catch { lvSL_CODE = "0"; } SqlClass sqlCon = new SqlClass(); String bag; DataSet dSet = new DataSet(); SqlClass connect = new SqlClass(); connect.ConnectSql(); String sql2 = "SELECT SLC.KISI_ADI, SLC.ODEMETIPI, SLC.* FROM stock_list_case SLC WHERE SLC.CODE = " + "'" + lvSL_CODE + "'"; DataTable dtable2 = new DataTable(); MySqlDataAdapter adapter2 = new MySqlDataAdapter(); MySqlCommand command2 = new MySqlCommand(); bag = build.ToString(); baglanti = new MySqlConnection(bag); command2.CommandText = sql2; command2.Connection = baglanti; adapter2.SelectCommand = command2; baglanti.Open(); adapter2.Fill(dtable2); adapter2.Fill(dSet); dtgrdDetail.DataSource = dtable2; baglanti.Close(); // sqlCon.ListData(dtgrdStockList, DateTime.Now, DateTime.Now); dtgrdDetail.Columns[0].HeaderText = "Kişi/Firma Adı"; dtgrdDetail.Columns[1].HeaderText = "Ödeme Tipi"; dtgrdDetail.Columns[2].HeaderText = "detayId"; dtgrdDetail.Columns[3].HeaderText = "CL_ID"; dtgrdDetail.Columns[4].HeaderText = "TL"; dtgrdDetail.Columns[4].DefaultCellStyle.Format = "N"; dtgrdDetail.Columns[5].HeaderText = "Dolar"; dtgrdDetail.Columns[5].DefaultCellStyle.Format = "N"; dtgrdDetail.Columns[6].HeaderText = "Euro"; dtgrdDetail.Columns[6].DefaultCellStyle.Format = "N"; dtgrdDetail.Columns[7].HeaderText = "Ödeme Tipi"; dtgrdDetail.Columns[8].HeaderText = "Kaç Adet?"; dtgrdDetail.Columns[9].HeaderText = "Kişi/Firma Adı"; dtgrdDetail.Columns[10].HeaderText = "Stok Kodu"; dtgrdDetail.Columns[11].HeaderText = "Tarih"; dtgrdDetail.Columns[12].HeaderText = "SL_ID"; dtgrdDetail.Columns[1].Visible = false; dtgrdDetail.Columns[2].Visible = false; dtgrdDetail.Columns[3].Visible = false; dtgrdDetail.Columns[10].Visible = false; dtgrdDetail.Columns[9].Visible = false; dtgrdDetail.Columns[12].Visible = false; dtgrdDetail.AllowUserToAddRows = false; }
private void frmCusumerCase_Load(object sender, EventArgs e) { string yr3, m3, d3; string yr, m, d, yr2, m2, d2; yr = dateTimePicker1.Value.Year.ToString(); m = dateTimePicker1.Value.Month.ToString(); d = dateTimePicker1.Value.Day.ToString(); yr2 = dateTimePicker2.Value.Year.ToString(); m2 = dateTimePicker2.Value.Month.ToString(); d2 = dateTimePicker2.Value.Day.ToString(); yr3 = DateTime.Now.Year.ToString(); m3 = DateTime.Now.Month.ToString(); d3 = DateTime.Now.Day.ToString(); int d4 = Convert.ToInt32(d3) + 1; SqlClass sqlCon = new SqlClass(); //sqlCon.ListData(customer_list, DateTime.Now, DateTime.Now); sqlCon.ConnectSql(); String sql = "SELECT CL.*, CL.ID AS CL_ID FROM customer_list CL Where CL.DATE BETWEEN '" + yr + "-" + m + "-" + d + "' AND " + "'" + yr2 + "-" + m2 + "-" + d2 + "'"; //" SELECT CL.*, CC.*,cl.DATE FROM customer_case cc INNER JOIN customer_list cl ON cl.ID = cc.CL_ID"; //if (DataGridList.Name == "dtgridSalesList") // sql = sql + " ORDER BY SALE_CODE"; DataTable dt = new DataTable(); adapter = new MySqlDataAdapter();//MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand(); command.CommandText = sql; command.Connection = baglanti; adapter.SelectCommand = command; //baglanti.Open(); adapter.Fill(dt); customer_list.DataSource = dt; baglanti.Close(); customer_list.Columns[0].HeaderText = "ID"; customer_list.Columns[1].HeaderText = "Adı"; customer_list.Columns[2].HeaderText = "Soyadı"; customer_list.Columns[3].HeaderText = "Adres"; customer_list.Columns[4].HeaderText = "Telefon Numarası"; customer_list.Columns[5].HeaderText = "Firma Adı"; customer_list.Columns[6].HeaderText = "Kayıt Tarihi"; customer_list.Columns[7].HeaderText = "IDW"; customer_list.Columns[0].Visible = false; customer_list.Columns[7].Visible = false; customer_list.AllowUserToAddRows = false; // SqlClass sqlCon = new SqlClass(); //sqlCon.ListData(customer_list, DateTime.Now, DateTime.Now); //sqlCon.ConnectSql(); String sqlTotal2 = "SELECT CC.ODEMETIPI,SUM(CC.TL) AS TL, SUM(CC.EURO) AS EURO, SUM(CC.DOLAR) AS DOLAR FROM customer_case cc WHERE DATE BETWEEN '" + yr3 + "-" + m3 + "-" + d3 + "' AND " + "'" + yr3 + "-" + m3 + "-" + d4 + "'" + " GROUP BY CC.ODEMETIPI"; //if (DataGridList.Name == "dtgridSalesList") // sql = sql + " ORDER BY SALE_CODE"; DataTable dtTotal2 = new DataTable(); MySqlDataAdapter adapterTotal2 = new MySqlDataAdapter(); MySqlCommand commandTotal2 = new MySqlCommand(); commandTotal2.CommandText = sqlTotal2; commandTotal2.Connection = baglanti; adapterTotal2.SelectCommand = commandTotal2; //baglanti.Open(); adapterTotal2.Fill(dtTotal2); grdCase_Total.DataSource = dtTotal2; baglanti.Close(); grdCase_Total.Columns[0].HeaderText = "Ödeme Tipi"; grdCase_Total.Columns[1].HeaderText = "TL"; grdCase_Total.Columns[1].DefaultCellStyle.Format = "N"; grdCase_Total.Columns[2].HeaderText = "€"; grdCase_Total.Columns[2].DefaultCellStyle.Format = "N"; grdCase_Total.Columns[3].HeaderText = "$"; grdCase_Total.Columns[3].DefaultCellStyle.Format = "N"; // customer_list.Columns[0].Visible = false; String id; int lvD = 0; int lvT = 0; int lvE = 0; }
private void btnQueryStock_Click_1(object sender, EventArgs e) { string yr, m, d, yr2, m2, d2; yr = dateTimePicker1.Value.Year.ToString(); m = dateTimePicker1.Value.Month.ToString(); d = dateTimePicker1.Value.Day.ToString(); yr2 = dateTimePicker2.Value.Year.ToString(); m2 = dateTimePicker2.Value.Month.ToString(); d2 = dateTimePicker2.Value.Day.ToString(); SqlClass sqlCon = new SqlClass(); sqlCon.ConnectSql(); String sql = "SELECT cl.*,cl.ID AS CL_ID FROM customer_list CL Where CL.DATE BETWEEN '" + yr + "-" + m + "-" + d + "' AND " + "'" + yr2 + "-" + m2 + "-" + d2 + "'"; DataTable dt = new DataTable(); adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand(); command.CommandText = sql; command.Connection = baglanti; adapter.SelectCommand = command; //baglanti.Open(); adapter.Fill(dt); customer_list.DataSource = dt; baglanti.Close(); customer_list.Columns[0].HeaderText = "ID"; customer_list.Columns[1].HeaderText = "Adı"; customer_list.Columns[2].HeaderText = "Soyadı"; customer_list.Columns[3].HeaderText = "Firma Adı"; customer_list.Columns[4].HeaderText = "Telefon Numarası"; customer_list.Columns[5].HeaderText = "Adres"; customer_list.Columns[6].HeaderText = "Kayıt Tarihi"; customer_list.Columns[7].HeaderText = "IDW"; customer_list.Columns[0].Visible = false; customer_list.Columns[7].Visible = false; customer_list.AllowUserToAddRows = false; String lvCL_ID; //dataSet = null; try { lvCL_ID = customer_list.CurrentRow.Cells["ID"].Value.ToString(); } catch { lvCL_ID = "0"; } String sqlTotal3 = "SELECT * FROM customer_case CC where CC.CL_ID = " + "'" + lvCL_ID + "'"; DataTable dtTotal3 = new DataTable(); dataSet = new DataSet(); adapter = new MySqlDataAdapter(); MySqlCommand commandTotal3 = new MySqlCommand(); commandTotal3.CommandText = sqlTotal3; commandTotal3.Connection = baglanti; adapter.SelectCommand = commandTotal3; if (baglanti.State == ConnectionState.Closed) { baglanti.Open(); } adapter.Fill(dtTotal3); adapter.Fill(dataSet, "customer_case"); grdCusCasDetail.DataSource = dataSet.Tables[0];//dtTotal3; baglanti.Close(); grdCusCasDetail.Columns[0].HeaderText = "CL_ID"; grdCusCasDetail.Columns[1].HeaderText = "TL"; grdCusCasDetail.Columns[1].DefaultCellStyle.Format = "N"; grdCusCasDetail.Columns[2].HeaderText = "€"; grdCusCasDetail.Columns[2].DefaultCellStyle.Format = "N"; grdCusCasDetail.Columns[3].HeaderText = "$"; grdCusCasDetail.Columns[3].DefaultCellStyle.Format = "N"; grdCusCasDetail.Columns[4].HeaderText = "Ödeme Tipi"; grdCusCasDetail.Columns[5].HeaderText = "ID"; grdCusCasDetail.Columns[0].Visible = false; grdCusCasDetail.Columns[5].Visible = false; }