public frmCustomer() { koneksi = KoneksiDB.Koneksi.getKoneksi(); impCustomer = new ImpCustomer(); entCustomer = new EntCustomer(); InitializeComponent(); txtNama.Focus(); }
public static void import_Customer() { Entity entity = new EntCustomer(); entity.SourceTable = "[dbo].[tmp_dtb_customer]"; entity.DestTable = "[dbo].[dtb_customer_test]"; entity.SourceSelectSQL = "select * from {0}"; entity.DestSelectSQL = "select * from {0}"; // SQL用のパラメータの設定 entity.SetDBParameters("influx_source", DbType.String); entity.SetDBParameters("name01", DbType.String); entity.SetDBParameters("name02", DbType.String); entity.SetDBParameters("kana01", DbType.String); entity.SetDBParameters("kana02", DbType.String); entity.SetDBParameters("zipcode", DbType.String); entity.SetDBParameters("addr01", DbType.String); entity.SetDBParameters("addr02", DbType.String); entity.SetDBParameters("tel", DbType.String); entity.SetDBParameters("email", DbType.String); entity.SetDBParameters("note", DbType.String); entity.SetDBParameters("customer_id", DbType.Int32); entity.SetDBParameters("pref", DbType.Int16); entity.SetDBParameters("sex", DbType.Int16); entity.SetDBParameters("job", DbType.Int16); entity.SetDBParameters("birth", DbType.Int32); entity.SetDBParameters("mailmaga_flg", DbType.Int16); entity.SetDBParameters("first_buy_date", DbType.Int32); entity.SetDBParameters("last_buy_date", DbType.Int32); entity.SetDBParameters("point", DbType.Int32); entity.SetDBParameters("use_point", DbType.Int32); entity.SetDBParameters("coupon", DbType.Int32); entity.SetDBParameters("status", DbType.Int16); entity.SetDBParameters("create_date", DbType.Int32); entity.SetDBParameters("create_time", DbType.Int32); entity.SetDBParameters("create_user", DbType.Int32); entity.SetDBParameters("update_date", DbType.Int32); entity.SetDBParameters("update_time", DbType.Int32); entity.SetDBParameters("update_user", DbType.Int32); entity.SetDBParameters("buy_times", DbType.Int32); entity.SetDBParameters("common_no", DbType.Int32); entity.SetDBParameters("del_flg", DbType.Int16); entity.SetDBParameters("buy_total", DbType.Int16); // 処理用クラス BizWorker customer = new BizWorker(entity); // 処理の実行 customer.Worker(); }
public Boolean updateCustomer(EntCustomer ec, int id_customer) { status = false; try { koneksi.Open(); query = "UPDATE customer SET nama_customer ='" + ec.getNamaCustomer() + "', alamat ='" + ec.getAlamat() + "', email ='" + ec.getEmail() + "', no_hp ='" + ec.getHP() + "' WHERE id_customer=" + id_customer + ""; MySqlCommand command = koneksi.CreateCommand(); command.CommandText = query; command.ExecuteNonQuery(); status = true; koneksi.Close(); } catch (MySqlException me) { Console.WriteLine(me); } return(status); }
public Boolean insertCustomer(EntCustomer ec) { status = false; try { koneksi.Open(); query = "INSERT INTO customer (nama_customer,alamat,email,no_hp) VALUES ('" + ec.getNamaCustomer() + "' , '" + ec.getAlamat() + "', '" + ec.getEmail() + "', '" + ec.getHP() + "')"; MySqlCommand command = koneksi.CreateCommand(); command.CommandText = query; command.ExecuteNonQuery(); status = true; koneksi.Close(); } catch (MySqlException me) { Console.WriteLine(me); } return(status); }