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