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;
}
}
