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