private void load_event() { try { using (DAL.Accessdata acc = new DAL.Accessdata()) { foreach (DataRow row in acc.getEvent().Rows) { ListViewItem item = new ListViewItem(); if (row["code"].ToString() == "0") { item.ImageIndex = 0; item.Text = "Lỗi"; } item.SubItems.Add(row["ngay"].ToString()); item.SubItems.Add(row["thoigian"].ToString()); item.SubItems.Add(row["event"].ToString()); item.SubItems.Add(row["schema_"].ToString()); item.SubItems.Add(row["tablename"].ToString()); item.SubItems.Add(row["ten"].ToString()); item.SubItems.Add(row["srvSend"].ToString()); item.SubItems.Add(row["srvReceive"].ToString()); item.SubItems.Add(row["computer"].ToString()); listView2.Items.Add(item); } } } catch { } }
private void load_combobox() { DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(decimal)); dt.Columns.Add("name", typeof(string)); // string exp = ""; DataRow dr; DAL.Accessdata m = new DAL.Accessdata(); // list = DAL.Manager.listClient(); for (int i = 0; i < list.Count; i++) { DAL.Client client = list[i]; exp = "id=" + client.ID.ToString(); dr = m.getrowbyid(dt, exp); if (dr == null) { dr = dt.NewRow(); dr["id"] = client.ID; dr["name"] = client.DatabaseName + " [" + client.Host + "]"; dt.Rows.Add(dr); } } dt.AcceptChanges(); // // cmbMayTram.DataSource = dt; cmbMayTram.DisplayMember = "name"; cmbMayTram.ValueMember = "id"; // }
private void frmThucong_Load(object sender, EventArgs e) { dgrChinhanh.AutoGenerateColumns = false; using (DAL.Accessdata acc = new DAL.Accessdata()) { dtChinhanh = acc.get_data("select false as chon,false as server,a.* from medibv.dmchinhanh a").Tables[0]; dgrChinhanh.DataSource = dtChinhanh; } }
public void Dongbo_khamsuckhoe(long m_iddoanksk) { this.Cursor = Cursors.WaitCursor; lblstatuss.Text = "Running ..."; load_listview(); string schema = "", table = "", dieukien = ""; DataRow[] dtr = dsxml_ksk.Tables[0].Select("lastday=2", "stt"); using (DAL.Accessdata acc = new DAL.Accessdata()) { DateTime tn = DateTime.Now.AddDays(-(double)i_khoang_cach_ngay); DateTime dn = DateTime.Now.AddDays((double)i_khoang_cach_ngay); int y1 = tn.Year, y2 = dn.Year; int m1 = tn.Month, m2 = dn.Month; int itu = 0, iden = 0; for (int j = y1; j <= y2; j++) { itu = (j == y1) ? m1 : 1; iden = (j == y2) ? m2 : 12; for (int i = itu; i <= iden; i++) { string mmyy = i.ToString().PadLeft(2, '0') + j.ToString().Substring(2, 2); for (int ii = 0; ii < list.Count; ii++) { for (int jj = 0; jj < dtr.Length; jj++) { schema = dtr[jj]["schema_name"].ToString(); schema = schema.Replace("xxx", mmyy); table = dtr[jj]["table_name"].ToString(); dieukien = dtr[jj]["dieukien"].ToString(); dieukien = dieukien.Replace("xxx", mmyy); if (m_iddoanksk == 0) { dieukien = ""; //binh 08032012 } //Kiểm tra xem schema có tồn tại không? if (acc.bShemaValid(schema)) { Application.DoEvents(); statusServer.Text = list[ii].Host + "-" + list[ii].DatabaseName; lblstatuss.Text = schema + "." + table; acc.update_chungtu(list[ii], schema, table, txtText, Trangthai, proStatus, dieukien); statusServer.Text = ""; lblstatuss.Text = ""; } } } } } this.Cursor = Cursors.Default; lblstatuss.Text = "Finished "; } }
private void conXoa_Click(object sender, EventArgs e) { DAL.Accessdata dal = new DAL.Accessdata(); if (listView1.SelectedItems.Count > 0) { foreach (ListViewItem item in listView1.SelectedItems) { DAL.Client _client = list.Find ( delegate(DAL.Client d_client) { return(d_client.Host == item.Text); } ); if (MessageBox.Show("Bạn muốn xóa máy trạm :" + _client.Host, "Server", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { if (dal.XoaClient(_client)) { //dal.XoaClient(_client); DateTime tn = DateTime.Now.AddDays(-(double)i_khoang_cach_ngay); DateTime dn = DateTime.Now.AddDays((double)i_khoang_cach_ngay); for (int j = tn.Year; j <= dn.Year; j++) { for (int i = tn.Month; i <= dn.Month; i++) { string mmyy = i.ToString().PadLeft(2, '0') + j.ToString().Substring(2, 2); foreach (DataRow row in dsxml.Tables[0].Rows) { dal.dropFunction(row["schema_name"].ToString().Replace("xxx", mmyy) + ".syn_" + row["table_name"].ToString() + "_from_" + _client.ServerName.ToLower()); } } } //foreach (System.Data.DataRow row in dsxml.Tables[0].Rows) //{ // schema = row["schema_name"].ToString(); // schema = schema.Replace("xxx", mmyy); // table = row["table_name"].ToString(); // for (int i = 0; i < list.Count; i++) // { // dal.dropFunction(schema + ".syn_" + table + "_from_" + _client.ServerName.ToUpper()); // } //} } } } load_listview(); } }
private void cmbMayTram_SelectedIndexChanged(object sender, EventArgs e) { if (this.ActiveControl == cmbMayTram || sender == null) { if (cmbMayTram.SelectedIndex < 0) { return; } int i_IDMaytram = int.Parse(cmbMayTram.SelectedValue.ToString()); if (macc == null) { macc = new DAL.Accessdata(); } DAL.Client c_client = macc.TimClient(i_IDMaytram); clientUI1.Client = c_client; txtPath.Text = c_client.ImagePath; txtPathBN.Text = c_client.ImagePath_BN; txtPath_chungtu.Text = c_client.ImagePath_Chungtu; } }
private void btnLuu_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; try { using (DAL.Accessdata acc = new DAL.Accessdata()) { acc.upd_thongso(1, t1.Value.ToString()); acc.upd_thongso(2, t2.Value.ToString()); acc.upd_thongso(3, (t3.Checked ? "1" : "0")); acc.upd_thongso(4, t4.Text.PadLeft(2, '0')); acc.upd_thongso(5, t5.Text.PadLeft(2, '0')); acc.upd_thongso(6, t6.Value.ToString()); acc.upd_thongso(7, t7.Text.ToString()); acc.upd_thongso(8, t8.Text.ToString()); acc.upd_thongso(9, (t9.Checked ? "1" : "0")); acc.upd_thongso(10, t10.Value.ToString()); acc.upd_thongso(11, (t11.Checked ? "1" : "0")); acc.upd_thongso(12, (t12.Checked ? "1" : "0")); acc.upd_thongso(17, (t17.Checked ? "1" : "0"));//dong bo Hinh BN acc.upd_thongso(13, t13.Text.ToString()); acc.upd_thongso(14, t14.Text.ToString()); acc.upd_thongso(18, (t18.Checked ? "1" : "0"));//dong bo Hinh CDHA acc.upd_thongso(15, t15.Text.ToString()); acc.upd_thongso(16, t16.Text.ToString()); acc.upd_thongso(19, (t19.Checked ? "1" : "0"));//dong bo Hinh chung tu acc.upd_thongso(20, t20.Text.ToString()); acc.upd_thongso(21, t21.Text.ToString()); acc.upd_thongso(22, (t22.Checked ? "1" : "0"));//dong bo Hinh chung tu } } catch { } Cursor = Cursors.Default; MessageBox.Show("Đã cập nhật xong."); }
public frmDmemail(DAL.Accessdata _m, int _userid) { InitializeComponent(); m = _m; i_userid = _userid; }
public frmCauHinhMail() { InitializeComponent(); m = new DAL.Accessdata(); }
private void btnLuu_Click(object sender, EventArgs e) { //Xóa dblink DAL.Client f_client = clientUI1.Client; // if (macc == null) { macc = new DAL.Accessdata(); } if (bNew) { bool bFound = macc.TimClient_TheoSTT(f_client.STT); if (bFound) { MessageBox.Show("STT Máy này đã tồn tại, chọn lại STT máy"); return; } } // f_client.XoaDBLink(); // Nếu tạo thành công dblink thì lưu xuống database link if (!f_client.TaoDBLink()) { UI.Thongbao.Message("MC001"); return; } //Lưu thông tin máy trạm lên server trung tâm. f_client.ImagePath = @txtPath.Text; f_client.ImagePath_BN = @txtPathBN.Text; f_client.ImagePath_Chungtu = txtPath_chungtu.Text; if (!DAL.Manager.LuuClient(f_client)) { UI.Thongbao.Message("MC002"); return; } // // // tạo các function liên quan đến máy trạm //string schema = "", table = "", field = "", key = ""; //DAL.Accessdata acc = new DAL.Accessdata(); //foreach (System.Data.DataRow row in dsxml.Tables[0].Rows) //{ // schema = row["schema"].ToString(); // schema = schema.Replace("xxx", mmyy); // table = row["tablename"].ToString(); // field = row["field"].ToString(); // key = row["key"].ToString(); // acc.CreateFunction(m_server, f_client, schema, table, field, key); //} //try //{ // using (DAL.Accessdata acc = new DAL.Accessdata()) // { // DateTime tn = DateTime.Now.AddDays(-(double)i_khoang_cach_ngay); // DateTime dn = DateTime.Now.AddDays((double)i_khoang_cach_ngay); // for (int j = tn.Year; j <= dn.Year; j++) // { // for (int i = tn.Month; i <= dn.Month; i++) // { // string mmyy = i.ToString().PadLeft(2, '0') + j.ToString().Substring(2, 2); // foreach (DataRow row in dsxml.Tables[0].Rows) // { // acc.CreateFunction(f_client, row["schema_name"].ToString().Replace("xxx", mmyy), row["table_name"].ToString()); // } // } // } // } //} //catch { } //this.Close(); MessageBox.Show("Lưu thành công."); clientUI1.emptyText(); // load_combobox(); // Empty_text(); ena_obj(false); butMoi.Focus(); }
private void xóaTấtCảToolStripMenuItem_Click(object sender, EventArgs e) { DAL.Accessdata acc = new DAL.Accessdata(); acc.delEventlog(); load_event(); }
/// <summary> /// Load thong tin da duoc khai bao /// </summary> private void loadthongso() { try { using (DAL.Accessdata acc = new DAL.Accessdata()) { int i_IDChiNhanh = acc.i_ChiNhanhHienTai; bool bTrungtam = acc.ChiNhanhTrungTam; if (bTrungtam) { t9.Enabled = t7.Enabled = t8.Enabled = true; } else { t9.Enabled = t7.Enabled = t8.Enabled = false; t9.Checked = false; } // ds = acc.get_data("select * from " + acc.User + ".syn_thongso"); foreach (DataRow row in ds.Tables[0].Rows) { switch (row["id"].ToString()) { case "1": // thời gian đồng bộ liên tục t1.Value = decimal.Parse(row["giatri"].ToString()); break; case "2": // số máy sử dụng tối đa t2.Value = decimal.Parse(row["giatri"].ToString()); break; case "3": // khởi động cùng windown t3.Checked = row["giatri"].ToString() == "1"; break; case "4": // giờ đồng bộ cuối ngay t4.Text = row["giatri"].ToString(); break; case "5": // phút đồng bộ cuối ngày. t5.Text = row["giatri"].ToString(); break; case "6": // khoảng cách ngày đồng bộ. t6.Value = decimal.Parse(row["giatri"].ToString()); break; case "7": // Gio gui mail tu dong t7.Text = row["giatri"].ToString(); break; case "8": // Phut gui mail tu dong t8.Text = row["giatri"].ToString(); break; case "9": // Co gui mail tu dong khong t9.Checked = row["giatri"].ToString() == "1"; break; case "10": try { t10.Value = decimal.Parse(row["giatri"].ToString()); } catch { t10.Value = 10; } break; case "11": // Co gui mail tu dong khong t11.Checked = row["giatri"].ToString() == "1"; break; case "12": // Co gui mail tu dong khong t12.Checked = row["giatri"].ToString() == "1"; break; case "17": // dong bo hinh BN t17.Checked = row["giatri"].ToString() == "1"; break; case "13": // Gio dong bo hinh BN t13.Text = row["giatri"].ToString(); break; case "14": // Phut dong bo hinh BN t14.Text = row["giatri"].ToString(); break; case "18": // dong bo hinh cdha t18.Checked = row["giatri"].ToString() == "1"; break; case "15": // Gio dong bo hinh cdha t15.Text = row["giatri"].ToString(); break; case "16": // Phut dong bo hinh cdha t16.Text = row["giatri"].ToString(); break; case "19": // dong bo hinh cdha t19.Checked = row["giatri"].ToString() == "1"; break; case "20": // Gio dong bo hinh cdha t20.Text = row["giatri"].ToString(); break; case "21": // Phut dong bo hinh cdha t21.Text = row["giatri"].ToString(); break; case "22": // dong bo hinh cdha t22.Checked = row["giatri"].ToString() == "1"; break; default: break; } } } } catch (Exception er) { MessageBox.Show(er.Message, "Synchronize"); } }
private void butOK_Click(object sender, EventArgs e) { using (DAL.Accessdata acc = new DAL.Accessdata()) { foreach (DataRow r in dtChinhanh.Select("chon=True")) { DAL.Client client = new DAL.Client(r["ip"].ToString(), r["port"].ToString(), r["database_local"].ToString(), "medisoft", "links1920", r["database_local"].ToString()); client.ID = int.Parse(r["id"].ToString()); lblstatuss.Text = "btdbn"; acc.update(client, "medibv", "btdbn", txtText, lblstatuss, proStatus, "to_number(to_char(ngayud,'yymmdd'))", txtTungay.Text, txtDenngay.Text, txtMabn.Text); //acc.update(client, "medibv", "btdbn", txtText, lblstatuss, proStatus); statusServer.Text = ""; lblstatuss.Text = ""; DateTime tn = txtTungay.Value; DateTime dn = txtDenngay.Value; for (int j = tn.Year; j <= dn.Year; j++) { for (int i = tn.Month; i <= dn.Month; i++) { string mmyy = i.ToString().PadLeft(2, '0') + j.ToString().Substring(2, 2); string schema = acc.User + mmyy; if (acc.bShemaValid(schema)) { lblstatuss.Text = schema + ".lienhe"; Application.DoEvents(); acc.update(client, schema, "lienhe", txtText, lblstatuss, proStatus, "maql", txtTungay.Text, txtDenngay.Text, txtMabn.Text); lblstatuss.Text = schema + ".tiepdon"; Application.DoEvents(); acc.update(client, schema, "tiepdon", txtText, lblstatuss, proStatus, "maql", txtTungay.Text, txtDenngay.Text, txtMabn.Text); lblstatuss.Text = schema + ".bhyt"; //Application.DoEvents(); //acc.update(client, schema, "bhyt", txtText, lblstatuss, proStatus, "maql", txtTungay.Text, txtDenngay.Text, txtMabn.Text); //lblstatuss.Text = schema + ".lydokham"; Application.DoEvents(); acc.update(client, schema, "lydokham", txtText, lblstatuss, proStatus, "maql", txtTungay.Text, txtDenngay.Text, txtMabn.Text); lblstatuss.Text = schema + ".trieuchung"; Application.DoEvents(); acc.update(client, schema, "trieuchung", txtText, lblstatuss, proStatus, "maql", txtTungay.Text, txtDenngay.Text, txtMabn.Text); lblstatuss.Text = schema + ".v_chidinh"; Application.DoEvents(); acc.update(client, schema, "v_chidinh", txtText, lblstatuss, proStatus, "maql", txtTungay.Text, txtDenngay.Text, txtMabn.Text); //lblstatuss.Text = schema + ".xn_phieu"; //Application.DoEvents(); //acc.update(client, schema, "xn_phieu", txtText, lblstatuss, proStatus, "id", txtTungay.Text, txtDenngay.Text); //lblstatuss.Text = schema + ".xn_ketqua"; //Application.DoEvents(); //acc.update(client, schema, "xn_ketqua", txtText, lblstatuss, proStatus, "id", txtTungay.Text, txtDenngay.Text); //lblstatuss.Text = ""; } } } } foreach (DataRow r in dtChinhanh.Select("server=True")) { DAL.Client client = new DAL.Client(r["ip"].ToString(), r["port"].ToString(), r["database_local"].ToString(), "medisoft", "links1920", r["database_local"].ToString()); client.ID = int.Parse(r["id"].ToString()); lblstatuss.Text = "btdbn"; //acc.update(client, "medibv", "btdbn", txtText, lblstatuss, proStatus, "to_number(to_char(ngayud,'yymmdd'))", txtTungay.Text, txtDenngay.Text); //acc.update(client, "medibv", "btdbn", txtText, lblstatuss, proStatus); statusServer.Text = ""; lblstatuss.Text = ""; string s_id = "", tmp = ""; DateTime tn = txtTungay.Value; DateTime dn = txtDenngay.Value; for (int j = tn.Year; j <= dn.Year; j++) { for (int i = tn.Month; i <= dn.Month; i++) { string mmyy = i.ToString().PadLeft(2, '0') + j.ToString().Substring(2, 2); string schema = acc.User + mmyy; if (acc.bShemaValid(schema)) { lblstatuss.Text = schema + ".xn_phieu"; Application.DoEvents(); acc.update(client, schema, "xn_phieu", txtText, lblstatuss, proStatus, "id", txtTungay.Text, txtDenngay.Text, ref s_id, ""); if (s_id.Trim(',') == "") { return; } lblstatuss.Text = schema + ".xn_ketqua"; Application.DoEvents(); acc.update(client, schema, "xn_ketqua", txtText, lblstatuss, proStatus, "id", txtTungay.Text, txtDenngay.Text, ref tmp, s_id); lblstatuss.Text = ""; } } } } lblstatuss.Text = "Finish."; this.Cursor = Cursors.Default; } }