private void btnOk_Click(object sender, RoutedEventArgs e) { string tungay = dtpTuNgay.SelectedDate.Value.ToString("dd/MM/yyyy"); string denngay = dtpDenNgay.SelectedDate.Value.ToString("dd/MM/yyyy"); ClsOracle clsora = new ClsOracle(); DataTable dt = new DataTable(); clsora.ClsConnect(); string tk = str.Left(cboTk.SelectedValue.ToString().Trim(), 10); //MessageBox.Show(tk); string sql = "select to_char(a.ngaygd,'dd/MM/yyyy') as NGGD,c.AC_DESC as TENTK,a.*,b.* from hsbt a, DMPOS b,DMTKGL c where a.ngaybc >= " + "to_date(" + "'" + tungay + "'" + "," + "'dd/mm/yyyy" + "')" + " and a.ngaybc <= " + "to_date(" + "'" + denngay + "'" + "," + "'dd/mm/yyyy" + "') and a.MAPGD= " + "'" + str.Left(cboPos.SelectedValue.ToString().Trim(), 6) + "'" + " and a.TK= " + "'" + tk + "'" + " and a.MAPGD=b.PO_MA and a.TK=c.BANK_AC order by a.NGAYGD "; //MessageBox.Show(sql); dt = clsora.LoadDataText(sql); //dataGrid1.ItemsSource = dt.DefaultView; if (dt.Rows.Count > 0) { rpt_Pstk rpt = new rpt_Pstk(); RPUtility.ShowRp(rpt, dt, this, srv.DbSourceSerVer(), srv.DbNameSerVer(), srv.DbUserSerVer(), srv.DbPassSerVer()); } else { MessageBox.Show("Không có bản ghi nào ", "Thông báo"); } }
private void BtnOKOra_OnClick(object sender, RoutedEventArgs e) { ClsOracle cls = new ClsOracle(); cls.ClsConnect(); int thamso = 2; string[] bien = new string[thamso]; object[] giatri = new object[thamso]; bien[0] = "P_MAPGD"; giatri[0] = CboPos.SelectedValue; bien[1] = "P_NGAYBC"; //if (dtpNgay.SelectedDate != null) giatri[1] = dtpNgay.SelectedDate.Value.ToString("dd/MM/yyyy"); giatri[1] = dtpNgay.SelectedDate.Value; MessageBox.Show("POS : " + giatri[0] + " , Ngay : " + giatri[1]); var dt = cls.LoadDataProcPara("uspQB_SaoKe", bien, giatri, thamso); dgvData.ItemsSource = dt.DefaultView; cls.DongKetNoi(); }
static void Main(string[] args) { ClsMySQL cnMySql = new ClsMySQL(); ClsConexion cnSql = new ClsConexion(); ClsOracle cnOracle = new ClsOracle(); int opcion; Console.WriteLine("Ingrese una opcion:\n1.Conectar con SQL server\n2.Conectar con MySql\n3.Conectar con Oracle"); opcion = int.Parse(Console.ReadLine()); switch (opcion) { case 1: int selecion; Console.WriteLine("Ingrese opcion:\n1. Conectar a SQL Server\n2.Insertar datos\n3. Insertar doc.txt"); selecion = int.Parse(Console.ReadLine()); switch (selecion) { case 1: cnSql.abrirConexion(); cnSql.cerrarConexionBD(); break; case 2: string datos = cnSql.insertar_datos(); cnSql.EjecutaSQLDirecto(datos); break; case 3: string ob_txt = cnSql.Insert_Registro_txt(); cnSql.EjecutaSQLDirecto(ob_txt); break; default: Console.WriteLine("Opcion invalida"); break; } break; case 2: int selecion2; Console.WriteLine("Ingrese opcion:\n1. Conectar y comprobar conexion a MySQL\n2.Insertar datos\n3. Insertar doc.txt\n4.Hacer consulta"); selecion2 = int.Parse(Console.ReadLine()); switch (selecion2) { case 1: cnMySql.AbrirBD(); cnMySql.CerrarBD(); break; case 2: string dat = cnMySql.insertarBD(); cnMySql.CrudTable(dat); break; case 3: string dt_txt = cnMySql.Insert_Registro_txt(); cnMySql.CrudTable(dt_txt); break; case 4: string consult = "SELECT * FROM tb_alumnos where parcial1>6"; cnMySql.consulta_bd(consult); break; default: break; } break; case 3: int selecion3; Console.WriteLine("Ingrese opcion:\n1. Conectar a Oracle\n2.Insertar datos\n3. Insertar doc.txt"); selecion3 = int.Parse(Console.ReadLine()); switch (selecion3) { case 1: break; case 2: break; case 3: break; default: break; } break; default: break; } }