private void frmTtkcbngtr_Load(object sender, System.EventArgs e)
{
user = d.user; stime = "'" + d.f_ngay + "'";
s_thetrongtinh = d.thetrongtinh(i_nhom);
s_thetunguyen = d.thetunguyen(i_nhom);
if (s_thetunguyen != "")
{
s_tunguyen = s_thetunguyen.Replace(",", "','");
}
string vitri = d.thetunguyen_vitri_ora(i_nhom);
if (vitri != "")
{
v1 = int.Parse(vitri.Substring(0, 1)); v2 = int.Parse(vitri.Substring(2, 1));
}
dtnhom = d.get_data("select * from " + user + ".v_nhombhyt order by stt").Tables[0];
madoituong.DisplayMember = "DOITUONG";
madoituong.ValueMember = "MADOITUONG";
madoituong.DataSource = d.get_data("select * from " + user + ".doituong where sothe<>0 order by madoituong").Tables[0];
sql = "select * from " + user + ".d_dmkho where hide=0 and nhom=" + i_nhom;
if (s_makho != "")
{
sql += " and id in (" + s_makho.Substring(0, s_makho.Length - 1) + ")";
}
sql += " order by stt";
dtkho = d.get_data(sql).Tables[0];
makho.DataSource = dtkho;
makho.DisplayMember = "TEN";
makho.ValueMember = "ID";
taotable();
loaidt.SelectedIndex = 0;
}
private void frmInphieuxuat_Load(object sender, System.EventArgs e)
{
user = d.user; stime = "'" + d.f_ngay + "'";
loai.Enabled = d.bChonloaiphieu_xuat(i_nhom);
phieu.Enabled = loai.Enabled;
imp.Visible = m.Mabv_so == 701424;
ds.ReadXml("..\\..\\..\\xml\\d_xuatkho.xml");
ds.Tables[0].Columns.Add("manhom", typeof(decimal)).DefaultValue = 0;
ds.Tables[0].Columns.Add("tennhom");
//dsxml.ReadXml("..\\..\\..\\xml\\d_xuatkho.xml");
dsxml = ds.Copy();
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
dtloai = d.get_data("select * from " + user + ".d_dmphieu where id<5 order by stt").Tables[0];
loai.DataSource = dtloai;
loai.DisplayMember = "TEN";
loai.ValueMember = "ID";
phieu.DisplayMember = "TEN";
phieu.ValueMember = "ID";
makho.DisplayMember = "TEN";
makho.ValueMember = "ID";
nhom.DisplayMember = "TEN";
nhom.ValueMember = "ID";
load_nhom();
load_makp();
load_makho();
load_dmnhom();
dmnhom.DisplayMember = "TEN";
dmnhom.ValueMember = "ID";
}
private void frmTT_pttt_thuoc_Load(object sender, System.EventArgs e)
{
user = m.user;
dtdt = m.get_data("select * from " + user + ".d_doituong order by madoituong").Tables[0];
if (d.bQuanlynguon(i_nhom))
{
dtnguon = d.get_data("select * from " + user + ".d_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0];
}
else
{
dtnguon = d.get_data("select * from " + user + ".d_dmnguon where nhom=0 or nhom=" + i_nhom + " order by stt").Tables[0];
}
dsdm.ReadXml("..//..//..//xml//d_dmbd.xml");
dsdm.Tables[0].Columns.Add("Chon", typeof(bool));
load_grid();
AddGridTableStyle();
this.disabledBackBrush = new SolidBrush(Color.FromArgb(255, 255, 192));
this.disabledTextBrush = new SolidBrush(Color.FromArgb(255, 0, 0));
this.alertBackBrush = new SolidBrush(SystemColors.HotTrack);
this.alertFont = new Font(this.dataGrid1.Font.Name, this.dataGrid1.Font.Size, FontStyle.Bold);
this.alertTextBrush = new SolidBrush(Color.White);
this.currentRowFont = new Font(this.dataGrid1.Font.Name, this.dataGrid1.Font.Size, FontStyle.Regular);
this.currentRowBackBrush = new SolidBrush(Color.FromArgb(0, 255, 255));
ds.ReadXml("..//..//..//xml//m_pttt_thuoc.xml");
AddGridTableStyle1();
load_chitiet();
}
private void frmPttt_thuoc_Load(object sender, System.EventArgs e)
{
// DataTable dt=d.get_data("select id from d_duyet where nhom="+i_nhom+" and to_char(ngay,'dd/mm/yyyy')='"+ngay+"'"+" and loai="+loai+" and phieu="+phieu+" and makhoa="+makp).Tables[0];
// if (dt.Rows.Count!=0) l_duyet=long.Parse(dt.Rows[0][0].ToString());
// else l_duyet=0;
dtdt = m.get_data("select * from d_doituong order by madoituong").Tables[0];
if (d.bQuanlynguon(i_nhom))
{
dtnguon = d.get_data("select * from d_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0];
}
else
{
dtnguon = d.get_data("select * from d_dmnguon where nhom=0 or nhom=" + i_nhom + " order by stt").Tables[0];
}
dsdm.ReadXml("..\\..\\..\\xml\\d_tutructh.xml");
dsdm.Tables[0].Columns.Add("Chon", typeof(bool));
load_grid();
AddGridTableStyle();
this.disabledBackBrush = new SolidBrush(Color.FromArgb(255, 255, 192));
this.disabledTextBrush = new SolidBrush(Color.FromArgb(255, 0, 0));
this.alertBackBrush = new SolidBrush(SystemColors.HotTrack);
this.alertFont = new Font(this.dataGrid1.Font.Name, this.dataGrid1.Font.Size, FontStyle.Bold);
this.alertTextBrush = new SolidBrush(Color.White);
this.currentRowFont = new Font(this.dataGrid1.Font.Name, this.dataGrid1.Font.Size, FontStyle.Regular);
this.currentRowBackBrush = new SolidBrush(Color.FromArgb(0, 255, 255));
ds.ReadXml("..\\..\\..\\xml\\m_pttt_thuoc.xml");
AddGridTableStyle1();
load_chitiet();
}
private void frmTreoduyet_Load(object sender, System.EventArgs e)
{
user = d.user;
format_soluong = d.format_soluong(i_nhom);
if (bTutrucchung)
{
label3.Text = "Tủ trực :";
}
load_ngay_duyet();
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
makp.DataSource = dtkp;
makp.SelectedValue = i_makp.ToString();
if (makp.Items.Count > 0)
{
kp.Text = dtkp.Rows[makp.SelectedIndex]["ma"].ToString();
}
string sql = "select * from " + user + ".d_loaiphieu ";
if (bThua)
{
sql += " where id=0";
}
else
{
sql += " where nhom=" + i_nhom + " and loai=" + i_loai;
sql += " and id<>0 order by stt";
}
dtph = d.get_data(sql).Tables[0];
phieudutru.DisplayMember = "TEN";
phieudutru.ValueMember = "ID";
phieudutru.DataSource = dtph;
load_phieu();
}
private void frmYlenh_cd_Load(object sender, System.EventArgs e)
{
user = d.user; f_ngay = d.f_ngay;
dsmabd.ReadXml("..\\..\\..\\xml\\d_mabd.xml");
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
sql = "select * from " + user + ".d_duockp";
if (s_makp != "")
{
sql += " where makp='" + s_makp + "'";
}
else
{
sql += " where makp is not null";
}
sql += " and nhom like '%" + i_nhom.ToString() + ",%'";
sql += " order by stt";
dtmakp = d.get_data(sql).Tables[0];
makp.DataSource = dtmakp;
makp.SelectedIndex = 0;
if (i_makp >= 0)
{
makp.SelectedValue = i_makp;
}
else
{
makp.SelectedIndex = 0;
}
nhom.DisplayMember = "TEN";
nhom.ValueMember = "ID";
load_nhom();
load_makho();
Chech_phieu();
}
private void load_grid()
{
sql = "select c.ten as tennguon,b.ma,trim(b.ten)||' '||b.hamluong as tenbd,b.tenhc,b.dang,a.tondau,a.slnhap,a.slxuat,a.tondau+a.slnhap-a.slxuat as toncuoi, d.ten as tenkho ";
sql += " from " + xxx + ".d_tutructh a," + user + ".d_dmbd b," + user + ".d_dmnguon c," + user + ".d_dmkho d ";
sql += " where a.mabd=b.id and a.manguon=c.id and a.makho=d.id and a.makp=" + i_makp;
if (i_kho > 0)
{
sql += " and a.makho=" + i_kho + "";
}
sql += " order by d.ten, b.ten";
dt = d.get_data(sql).Tables[0];
dataGrid1.DataSource = dt;
}
private void f_load_dmnhomkho()
{
string asql = "select * from " + d.user + ".d_dmnhomkho where id>0 ";
DataSet ads = d.get_data(asql);
cmbNhomkhonguon.DataSource = ads.Tables[0].Copy();
cmbNhomkhonguon.DisplayMember = "TEN";
cmbNhomkhonguon.ValueMember = "ID";
cmbNhomkhoDich.DataSource = ads.Tables[0].Copy();
cmbNhomkhoDich.DisplayMember = "TEN";
cmbNhomkhoDich.ValueMember = "ID";
}
private void frmInphieuxuat_Load(object sender, System.EventArgs e)
{
user = m.user; stime = "'" + m.f_ngay + "'";
imp.Visible = m.Mabv_so == 701424;
ds.ReadXml("..//..//..//xml//d_xuatkho.xml");
dsxml.ReadXml("..//..//..//xml//d_xuatkho.xml");
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
dtloai = d.get_data("select * from " + user + ".d_dmphieu where id<5 order by stt").Tables[0];
loai.DataSource = dtloai;
loai.DisplayMember = "TEN";
loai.ValueMember = "ID";
phieu.DisplayMember = "TEN";
phieu.ValueMember = "ID";
makho.DisplayMember = "TEN";
makho.ValueMember = "ID";
nhom.DisplayMember = "TEN";
nhom.ValueMember = "ID";
load_nhom();
load_makp();
load_makho();
}
private void frmDiungthuoc_Load(object sender, System.EventArgs e)
{
if (bbadt)
{
this.Location = new System.Drawing.Point(188 - 38, 120);//151
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
this.Size = new Size(829 + 40, 610);
}
//try
//{
// sql = "alter table " + user + ".qn_benhnhan add column tieudoan varchar(50) ";
// m.execute_data(sql);
//}
//catch
//{
//}
user = m.user;
//LoaiDonVi
cb_quandoan.DisplayMember = "TEN";
cb_quandoan.ValueMember = "id";
//khuyen 12/02/2014 cb_quandoan.DataSource = d.get_data("select * from " + user + ".qn_dmloaidv order by id").Tables[0];
cb_quandoan.DataSource = d.get_data("select * from " + user + ".qn_dmdonvi_cap1 order by id").Tables[0];//khuyen 12/02/2014 thay table qn_dmloaidv=qn_dmdonvi_cap1
//Donvi
cb_sudoan.DisplayMember = "TEN";
cb_sudoan.ValueMember = "id";
//khuyen 12/02/14 cmbDonVi.DataSource = d.get_data("select * from " + user + ".qn_dmdonvi order by id").Tables[0];
cb_sudoan.DataSource = d.get_data("select * from " + user + ".qn_dmdonvi_cap2 order by id").Tables[0];//12/02/14 thay table qn_dmdonvi=qn_dmdonvi_cap2
//khuyen 12/02/2014 them 2 table qn_dmdonvi_cap3,qn_dmdonvi_cap4 vao phan quan ly thong tin bo doi
//Donvi trung doan
cmbTrung_Doan.DisplayMember = "TEN";
cmbTrung_Doan.ValueMember = "id";
cmbTrung_Doan.DataSource = d.get_data("select * from " + user + ".qn_dmdonvi_cap3 order by id").Tables[0];
//Donvi tieu doan
cmbTieu_doan.DisplayMember = "TEN";
cmbTieu_doan.ValueMember = "id";
cmbTieu_doan.DataSource = d.get_data("select * from " + user + ".qn_dmdonvi_cap4 order by id").Tables[0];
//end
//CapBac
cmbCapBac.DisplayMember = "TEN";
cmbCapBac.ValueMember = "id";
cmbCapBac.DataSource = d.get_data("select * from " + user + ".qn_dmcapbac order by id").Tables[0];
//ChucVu
cmbChucVu.DisplayMember = "TEN";
cmbChucVu.ValueMember = "id";
cmbChucVu.DataSource = d.get_data("select * from " + user + ".qn_dmchucvu order by id").Tables[0];
load_grid();
AddGridTableStyle();
lan.Read_dtgrid_to_Xml(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
lan.Change_dtgrid_HeaderText_to_English(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
ref_text();
if (bxemlai == false)
{
butMoi_Click(null, null);
}
// cb_quandoan_SelectedIndexChanged(null, null);
}
private void frmDiungthuoc_Load(object sender, System.EventArgs e)
{
list.DisplayMember = "MA";
list.ValueMember = "TEN";
list.DataSource = d.get_data("select a.ma,a.ten from d_dmhoatchat a,d_dmnhomkho b where a.nhom=b.id and b.loai=1 order by a.ten").Tables[0];
mucdo.DisplayMember = "TEN";
mucdo.ValueMember = "ID";
mucdo.DataSource = d.get_data("select * from mucdodiung order by stt").Tables[0];
load_grid();
AddGridTableStyle();
lan.Read_dtgrid_to_Xml(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
lan.Change_dtgrid_HeaderText_to_English(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
ref_text();
}
private void frmSotienNgay_Load(object sender, System.EventArgs e)
{
user = m.user;
ds.ReadXml("..//..//..//xml//sotienngay.xml");
makp.DataSource = d.get_data("select * from " + user + ".btdkp_bv order by loai,makp").Tables[0];
makp.DisplayMember = "TENKP";
makp.ValueMember = "MAKP";
ketqua.DataSource = d.get_data("select * from " + user + ".ketqua order by ma").Tables[0];
ketqua.DisplayMember = "TEN";
ketqua.ValueMember = "MA";
dataGrid1.DataSource = ds.Tables[0];
AddGridTableStyle();
lan.Read_dtgrid_to_Xml(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
lan.Change_dtgrid_HeaderText_to_English(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
}
private void load_grid()
{
if (dt == null || dt.Rows.Count == 0)
{
dt = d.get_data("select * from " + user + mmyy + ".d_chandoan where id=" + l_id + " and loai=" + i_loai).Tables[0];
}
dataGrid1.DataSource = dt;
}
//binh
private string get_dirreport(int s_id)
{
string s_dir = "";
string sql = "select * from " + d.user + ".d_thongso where id=" + s_id + " and nhom=" + i_nhom;
try
{
System.Data.DataTable dt = d.get_data(sql).Tables[0];
foreach (DataRow r in dt.Rows)
{
s_dir = r["ten"].ToString().Trim();
}
dt.Dispose();
}
catch {}
return((s_dir == "")?"report":s_dir);
}
public DataTable get_db_tuongtac(string s_generic1)
{
string suser = d.user;
//sql = "select * from " + suser + ".d_group where lower(generic1)='" + s_generic1.Trim() + "'";
sql = "select lower(generic1) as generic1, lower(generic2) as generic2, g1, g2, effect, a.severity, action1, action2, action3, action4, action5 ";
sql += ", b.effect_eng, effect_vn, c1.action_eng as action_eng1, c1.action_vn as action_vn1, c2.action_eng as action_eng2, c2.action_vn as action_vn2, c3.action_eng as action_eng3, c3.action_vn as action_vn3, c4.action_eng as action_eng4, c4.action_vn as action_vn4, c5.action_eng as action_eng5, c5.action_vn as action_vn5 ";
sql += ", d.vietnam as severity_v, d.severity_e, a.kt_ ";
sql += " from " + suser_tt + ".d_drug_interaction_full a, " + suser_tt + ".d_effect b, " + suser_tt + ".d_action c1," + suser_tt + ".d_action c2," + suser_tt + ".d_action c3, " + suser_tt + ".d_action c4, " + suser_tt + ".d_action c5 ";
sql += " , " + suser_tt + ".d_severity d";
sql += " where a.effect=b.code(+) and a.action1=c1.code(+) and a.action2=c2.code(+) and a.action3=c3.code(+) and a.action4=c4.code(+) and a.action5=c5.code (+) ";
sql += " and a.severity = d.code(+)";
sql += " and lower(a.generic1)='" + s_generic1.Trim().ToLower() + "'";
return(d.get_data(sql).Tables[0]);
}
private void rptXuat_khoa_Load(object sender, System.EventArgs e)
{
user = d.user; stime = "'" + d.f_ngay + "'";
i_dongia = d.d_dongia_le(i_nhom);
format_soluong = d.format_soluong(i_nhom);
sql = "select a.*, b.stt as sttnhom, b.ten as tennhom from " + user + ".d_dmbd a, " + user + ".d_dmnhom b";
sql += " where a.manhom=b.id and a.nhom=" + i_nhom + " order by a.id";
dt = d.get_data(sql).Tables[0];
manguon.DisplayMember = "TEN";
manguon.ValueMember = "ID";
if (d.bQuanlynguon(i_nhom))
{
manguon.DataSource = d.get_data("select * from " + user + ".d_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0];
}
else
{
manguon.DataSource = d.get_data("select * from " + user + ".d_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0];
}
sql = "select * from " + user + ".d_dmkho where hide=0 and nhom=" + i_nhom;
if (s_kho != "")
{
sql += " and id in (" + s_kho.Substring(0, s_kho.Length - 1) + ")";
}
sql += " order by stt";
dtdmkho = d.get_data(sql).Tables[0];
makho.DataSource = dtdmkho;
makho.DisplayMember = "TEN";
makho.ValueMember = "ID";
}
private void f_Loadchinhanh()
{
string asql = "select * from medibv.dmchinhanh where id>0 ";
if (i_ChiNhanhHienTai > 0)
{
asql += " and id<>" + i_ChiNhanhHienTai;
}
dscn = d.get_data(asql);
cmbChinhanh.DataSource = dscn.Tables[0];
cmbChinhanh.DisplayMember = "TEN";
cmbChinhanh.ValueMember = "ID";
}
private void frmDiungthuoc_Load(object sender, System.EventArgs e)
{
if (bbadt)
{
this.Location = new System.Drawing.Point(188 - 38, 120);//151
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
this.Size = new Size(829 + 40, 610);
}
user = m.user;
list.DisplayMember = "MA";
list.ValueMember = "TEN";
list.DataSource = d.get_data("select a.ma,a.ten from " + user + ".d_dmhoatchat a," + user + ".d_dmnhomkho b where a.nhom=b.id and b.loai=1 and a.ten<>'' order by a.ten").Tables[0];
mucdo.DisplayMember = "TEN";
mucdo.ValueMember = "ID";
mucdo.DataSource = d.get_data("select * from " + user + ".mucdodiung order by stt").Tables[0];
load_grid();
AddGridTableStyle();
lan.Read_dtgrid_to_Xml(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
lan.Change_dtgrid_HeaderText_to_English(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
ref_text();
}
private void frmPttt_thuoc_Load(object sender, System.EventArgs e)
{
user = d.user;
dtdt = m.get_data("select * from " + user + ".d_doituong order by madoituong").Tables[0];
if (d.bQuanlynguon(i_nhom))
{
dtnguon = d.get_data("select * from " + user + ".d_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0];
}
else
{
dtnguon = d.get_data("select * from " + user + ".d_dmnguon where nhom=0 or nhom=" + i_nhom + " order by stt").Tables[0];
}
dsdm.ReadXml("..//..//..//xml//d_tutructh.xml");
dsdm.Tables[0].Columns.Add("Chon", typeof(bool));
if (mapt != "")
{
foreach (DataRow r in m.get_data("select mavp from " + user + ".dmpttt where mapt='" + mapt + "'").Tables[0].Rows)
{
l_mavp = decimal.Parse(r["mavp"].ToString());
}
}
load_grid();
AddGridTableStyle();
f_soluong = d.format_soluong(i_nhom);
this.disabledBackBrush = new SolidBrush(Color.FromArgb(255, 255, 192));
this.disabledTextBrush = new SolidBrush(Color.FromArgb(255, 0, 0));
this.alertBackBrush = new SolidBrush(SystemColors.HotTrack);
this.alertFont = new Font(this.dataGrid1.Font.Name, this.dataGrid1.Font.Size, FontStyle.Bold);
this.alertTextBrush = new SolidBrush(Color.White);
this.currentRowFont = new Font(this.dataGrid1.Font.Name, this.dataGrid1.Font.Size, FontStyle.Regular);
this.currentRowBackBrush = new SolidBrush(Color.FromArgb(0, 255, 255));
ds.ReadXml("..//..//..//xml//m_pttt_thuoc.xml");
AddGridTableStyle1();
load_chitiet();
}
private void load_d_dm()
{
string sql = "select * from d_duockp order by stt";
tenkp.DisplayMember = "TEN";
tenkp.ValueMember = "ID";
tenkp.DataSource = d.get_data(sql).Tables[0];
//
//dtdmbd=d.get_data("select a.ma,trim(a.ten)||' '||a.hamluong ten,trim(b.ten)||'/'||c.ten hang,a.dang,a.tenhc,a.id,a.giaban,b.ten tenhang,c.ten tennuoc from d_dmbd a,d_dmhang b,d_dmnuoc c where a.mahang=b.id and a.manuoc=c.id and a.nhom="+i_nhom+" order by a.ten").Tables[0];
dtdmbd = d.get_data("select a.ma,trim(a.ten)||' '||a.hamluong ten,trim(b.ten)||'/'||c.ten hang,a.dang,a.tenhc,a.id,a.giaban,b.ten tenhang,c.ten tennuoc, d.ma stk from d_dmbd a,d_dmhang b,d_dmnuoc c,d_dmnhomkt d where a.mahang=b.id and a.manuoc=c.id and a.sotk=d.id(+) and a.nhom=" + i_nhom + " order by a.ten").Tables[0].Copy();
//
no.Tag = "";
co.Tag = "";
}
private void button2_Click(object sender, EventArgs e)
{
if (thumuc.Text == "")
{
button1_Click(null, null);
return;
}
if (!System.IO.File.Exists(thumuc.Text))
{
MessageBox.Show("Không tìm thấy File !");
return;
}
string sql = "";
sql = " create table " + s_user + ".d_group (id numeric(7), generic1 varchar(255),generic2 varchar(255), group1 varchar(255), group2 varchar(255), severity numeric(3), mechanism text,actions text, s_effect text, mec_detail text)";
d.execute_data(sql);
//
dthc = d.get_data("select * from " + s_user + ".d_group ").Tables[0];
sql = "select * from group1 order by generic1";
string s_name = "", s_generic = "", s_group = "", s_exp = "", s_id = "0", s_severity = "0";
string s_ploai = "";
int i_loai = 0, i_stt = 0, i_id = 0, i_nhom = 1;//Khoa duoc
long l_id = 0;
ds = m.get_data_acc(sql, thumuc.Text);
int jjj = 0;
foreach (DataRow r in ds.Tables[0].Rows)
{
s_exp = "generic1='" + r["generic1"].ToString().Trim().Replace("'", "") + "' and generic2='" + r["generic2"].ToString().Trim().Replace("'", "") + "'";
DataRow dr = d.getrowbyid(dthc, s_exp);
if (dr == null)
{
s_group = r["group1"].ToString().Trim().Replace("'", "");
s_generic = r["generic1"].ToString().Trim().Replace("'", "");
s_id = (r["id"].ToString().Trim() == "") ? "0" : r["id"].ToString().Trim();
s_severity = (r["severity"].ToString().Trim() == "") ? "0" : r["severity"].ToString().Trim();
sql = "insert into " + s_user + ".d_group (id, generic1, generic2, group1, group2, severity, mechanism, actions, s_effect, mec_detail) ";
sql += " values(" + s_id + ",'" + s_generic + "','" + r["generic2"].ToString().Trim().Replace("'", "") + "','" + s_group + "','" + r["group2"].ToString().Trim().Replace("'", "") + "'," + s_severity + ",'" + r["mechanism"].ToString().Trim().Replace("'", "") + "','" + r["actions"].ToString().Trim().Replace("'", "") + "','" + r["s_effect"].ToString().Trim().Replace("'", "") + "','" + r["mec_detail"].ToString().Trim().Replace("'", "") + "')";
d.execute_data(sql);
}
jjj += 1;
label1.Text = "Record " + jjj.ToString();
this.Refresh();
}
thumuc.Text = "";
}
private void rptBcngay_Load(object sender, System.EventArgs e)
{
user = d.user; stime = "'" + d.f_ngay + "'";
dtnhom = d.get_data("select * from " + user + ".d_dmnhom where nhom=" + i_nhom + " order by stt").Tables[0];
manhom.DataSource = dtnhom;
manhom.DisplayMember = "TEN";
manhom.ValueMember = "ID";
sql = "select * from " + user + ".d_duockp where makp is not null and nhom like '%" + i_nhom.ToString() + ",%'";
if (s_makp != "")
{
string s = s_makp.Replace(",", "','");
sql += " and makp in ('" + s.Substring(0, s.Length - 3) + "')";
}
sql += " order by stt";
dtmakp = d.get_data(sql).Tables[0];
makp.DataSource = dtmakp;
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
dt = d.get_data("select * from " + user + ".d_dmbd where nhom=" + i_nhom + " order by id").Tables[0];
dsngay.ReadXml("..//..//..//xml//d_tsngay.xml");
dieutri.SelectedIndex = 0;
}
private void load_makp()
{
if (nhom.SelectedIndex != -1)
{
sql = "select * from " + user + ".d_duockp where nhom like '%" + int.Parse(nhom.SelectedValue.ToString()) + ",%'";
if (s_makp != "")
{
string s = s_makp.Replace(",", "','");
sql += " and makp in ('" + s.Substring(0, s.Length - 3) + "')";
}
else if (i_benhnhan == 1)
{
sql += " and makp is not null";
}
sql += " order by stt";
dtmakp = d.get_data(sql).Tables[0];
makp.DataSource = dtmakp;
if (makp.Items.Count > 0)
{
kp.Text = dtmakp.Rows[makp.SelectedIndex]["ma"].ToString();
}
if (i_loai == 2)
{
load_matutruc();
}
}
}
private void butIn_Click(object sender, System.EventArgs e)
{
string sql1 = "", sql2 = "";
int loai;
ds.Clear();
ds.ReadXml("..\\..\\..\\xml\\thnx.xml");
foreach (DataColumn c in ds.Tables[0].Columns)
{
c.DefaultValue = 0;
}
if (loaibenh.SelectedIndex < 0)
{
loai = -1;
sql = "select to_char(ngay,'dd/mm/yyyy') ngay,count(*) ts,sum(decode(a.phai,0,1,0)) nu,sum(decode(a.mann,'07',1,0)) cb,sum(decode(a.mann,'04',1,0)) cn,";
sql += "sum(decode(a.mann,'01',1,0)) te,sum(decode(a.mann,'04',0,'01',0,'07',0,1)) nd,sum(decode(b.makp,'02',1,0)) a,";
sql += "sum(decode(b.makp,'03',1,0)) b,sum(decode(b.makp,'04',1,0)) c,sum(decode(b.makp,'05',1,0)) d,sum(decode(b.makp,'06',1,0)) e,";
sql += "sum(decode(b.makp,'07',1,0)) x1,sum(decode(b.makp,'08',1,0)) x2,sum(decode(b.makp,'09',1,0)) x3,sum(decode(b.makp,'10',1,0)) hc,sum(decode(b.makp,'20',1,0)) vl";
sql += " from btdbn a,nhapkhoa b where a.mabn=b.mabn and to_date(b.ngay,'dd/mm/yy') between to_date('" + tu.Text + "','dd/mm/yy') and to_date('" + den.Text + "','dd/mm/yy') ";
sql += "group by to_char(ngay,'dd/mm/yyyy') order by substr(ngay,7)||substr(ngay,4,2)||substr(ngay,1,2)";
sql1 = "select to_char(ngay,'dd/mm/yyyy') ngay,count(*) ts,sum(decode(a.phai,0,1,0)) nu,sum(decode(a.mann,'07',1,0)) cb,sum(decode(a.mann,'04',1,0)) cn,";
sql1 += "sum(decode(a.mann,'01',1,0)) te,sum(decode(a.mann,'04',0,'01',0,'07',0,1)) nd,sum(decode(c.makp,'02',1,0)) a,";
sql1 += "sum(decode(c.makp,'03',1,0)) b,sum(decode(c.makp,'04',1,0)) c,sum(decode(c.makp,'05',1,0)) d,sum(decode(c.makp,'06',1,0)) e,";
sql1 += "sum(decode(c.makp,'07',1,0)) x1,sum(decode(c.makp,'08',1,0)) x2,sum(decode(c.makp,'09',1,0)) x3,sum(decode(c.makp,'10',1,0)) hc,sum(decode(c.makp,'20',1,0)) vl";
sql1 += " from btdbn a,xuatkhoa b,nhapkhoa c,benhandt d where a.mabn=c.mabn and c.maql=d.maql and b.id=c.id and to_date(b.ngay,'dd/mm/yy') between to_date('" + tu.Text + "','dd/mm/yy') and to_date('" + den.Text + "','dd/mm/yy') ";
sql1 += "group by to_char(ngay,'dd/mm/yyyy') order by substr(ngay,7)||substr(ngay,4,2)||substr(ngay,1,2)";
sql2 = "select count(*) ts,sum(decode(a.phai,0,1,0)) nu,sum(decode(a.mann,'07',1,0)) cb,sum(decode(a.mann,'04',1,0)) cn,";
sql2 += "sum(decode(a.mann,'01',1,0)) te,sum(decode(a.mann,'04',0,'01',0,'07',0,1)) nd,sum(decode(c.makp,'02',1,0)) a,";
sql2 += "sum(decode(c.makp,'03',1,0)) b,sum(decode(c.makp,'04',1,0)) c,sum(decode(c.makp,'05',1,0)) d,sum(decode(c.makp,'06',1,0)) e,";
sql2 += "sum(decode(c.makp,'07',1,0)) x1,sum(decode(c.makp,'08',1,0)) x2,sum(decode(c.makp,'09',1,0)) x3,sum(decode(c.makp,'10',1,0)) hc,sum(decode(c.makp,'20',1,0)) vl";
sql2 += " from nhapkhoa c,btdbn a,xuatkhoa b where c.id=b.id(+) and a.mabn=c.mabn ";
sql2 += " and to_date(c.ngay,'dd/mm/yy')<to_date('" + tu.Text + "','dd/mm/yy') and (b.ngay is null or to_date(b.ngay,'dd/mm/yy')>to_date('" + tu.Text + "','dd/mm/yy'))";
}
else
{
loai = int.Parse(loaibenh.SelectedValue.ToString());
sql = "select to_char(b.ngay,'dd/mm/yyyy') ngay,count(*) ts,sum(decode(a.phai,0,1,0)) nu,sum(decode(a.mann,'07',1,0)) cb,sum(decode(a.mann,'04',1,0)) cn,";
sql += "sum(decode(a.mann,'01',1,0)) te,sum(decode(a.mann,'04',0,'01',0,'07',0,1)) nd,sum(decode(b.makp,'02',1,0)) a,";
sql += "sum(decode(b.makp,'03',1,0)) b,sum(decode(b.makp,'04',1,0)) c,sum(decode(b.makp,'05',1,0)) d,sum(decode(b.makp,'06',1,0)) e,";
sql += "sum(decode(b.makp,'07',1,0)) x1,sum(decode(b.makp,'08',1,0)) x2,sum(decode(b.makp,'09',1,0)) x3,sum(decode(b.makp,'10',1,0)) hc,sum(decode(b.makp,'20',1,0)) vl";
sql += " from btdbn a,nhapkhoa b,benhandt c where a.mabn=b.mabn and b.maql=c.maql and to_date(b.ngay,'dd/mm/yy') between to_date('" + tu.Text + "','dd/mm/yy') and to_date('" + den.Text + "','dd/mm/yy') and loaiba=" + loai;
sql += " group by to_char(b.ngay,'dd/mm/yyyy') order by substr(ngay,7)||substr(ngay,4,2)||substr(ngay,1,2)";
sql1 = "select to_char(b.ngay,'dd/mm/yyyy') ngay,count(*) ts,sum(decode(a.phai,0,1,0)) nu,sum(decode(a.mann,'07',1,0)) cb,sum(decode(a.mann,'04',1,0)) cn,";
sql1 += "sum(decode(a.mann,'01',1,0)) te,sum(decode(a.mann,'04',0,'01',0,'07',0,1)) nd,sum(decode(c.makp,'02',1,0)) a,";
sql1 += "sum(decode(c.makp,'03',1,0)) b,sum(decode(c.makp,'04',1,0)) c,sum(decode(c.makp,'05',1,0)) d,sum(decode(c.makp,'06',1,0)) e,";
sql1 += "sum(decode(c.makp,'07',1,0)) x1,sum(decode(c.makp,'08',1,0)) x2,sum(decode(c.makp,'09',1,0)) x3,sum(decode(c.makp,'10',1,0)) hc,sum(decode(c.makp,'20',1,0)) vl";
sql1 += " from btdbn a,xuatkhoa b,nhapkhoa c,benhandt d where a.mabn=c.mabn and c.maql=d.maql and to_date(b.ngay,'dd/mm/yy') between to_date('" + tu.Text + "','dd/mm/yy') and to_date('" + den.Text + "','dd/mm/yy') and b.id=c.id and loaiba=" + loai;
sql1 += " group by to_char(b.ngay,'dd/mm/yyyy') order by substr(ngay,7)||substr(ngay,4,2)||substr(ngay,1,2)";
sql2 = "select count(*) ts,sum(decode(a.phai,0,1,0)) nu,sum(decode(a.mann,'07',1,0)) cb,sum(decode(a.mann,'04',1,0)) cn,";
sql2 += "sum(decode(a.mann,'01',1,0)) te,sum(decode(a.mann,'04',0,'01',0,'07',0,1)) nd,sum(decode(c.makp,'02',1,0)) a,";
sql2 += "sum(decode(c.makp,'03',1,0)) b,sum(decode(c.makp,'04',1,0)) c,sum(decode(c.makp,'05',1,0)) d,sum(decode(c.makp,'06',1,0)) e,";
sql2 += "sum(decode(c.makp,'07',1,0)) x1,sum(decode(c.makp,'08',1,0)) x2,sum(decode(c.makp,'09',1,0)) x3,sum(decode(c.makp,'10',1,0)) hc,sum(decode(c.makp,'20',1,0)) vl";
sql2 += " from nhapkhoa c,btdbn a,xuatkhoa b,benhandt d where c.id=b.id(+) and a.mabn=c.mabn and c.maql=d.maql and loaiba=" + loai;
sql2 += " and to_date(c.ngay,'dd/mm/yy')<to_date('" + tu.Text + "','dd/mm/yy') and (b.ngay is null or to_date(b.ngay,'dd/mm/yy')>to_date('" + tu.Text + "','dd/mm/yy'))";
}
System.Data.DataTable dtdk = new System.Data.DataTable(); //dau ky
dtdk = m.get_data(sql2).Tables[0];
dt = m.get_data(sql1).Tables[0];
DataRow r1, r2, rdk;
foreach (DataRow r in m.get_data(sql).Tables[0].Rows)
{
r1 = ds.Tables[0].NewRow();
r1[0] = r["ngay"].ToString();
r1[1] = Decimal.Parse(r["ts"].ToString());
r1[2] = Decimal.Parse(r["nu"].ToString());
r1[3] = Decimal.Parse(r["cb"].ToString());
r1[4] = Decimal.Parse(r["cn"].ToString());
r1[5] = Decimal.Parse(r["nd"].ToString());
r1[6] = Decimal.Parse(r["te"].ToString());
r1[7] = Decimal.Parse(r["a"].ToString());
r1[8] = Decimal.Parse(r["b"].ToString());
r1[9] = Decimal.Parse(r["c"].ToString());
r1[10] = Decimal.Parse(r["d"].ToString());
r1[11] = Decimal.Parse(r["e"].ToString());
r1[12] = Decimal.Parse(r["x1"].ToString());
r1[13] = Decimal.Parse(r["x2"].ToString());
r1[14] = Decimal.Parse(r["x3"].ToString());
r1[15] = Decimal.Parse(r["hc"].ToString());
r1[16] = Decimal.Parse(r["vl"].ToString());
r2 = m.getrowbyid(dt, "ngay='" + r["ngay"].ToString() + "'");
if (r2 != null)
{
r1[17] = Decimal.Parse(r2["ts"].ToString());
r1[18] = Decimal.Parse(r2["nu"].ToString());
r1[19] = Decimal.Parse(r2["cb"].ToString());
r1[20] = Decimal.Parse(r2["cn"].ToString());
r1[21] = Decimal.Parse(r2["nd"].ToString());
r1[22] = Decimal.Parse(r2["te"].ToString());
r1[23] = Decimal.Parse(r2["a"].ToString());
r1[24] = Decimal.Parse(r2["b"].ToString());
r1[25] = Decimal.Parse(r2["c"].ToString());
r1[26] = Decimal.Parse(r2["d"].ToString());
r1[27] = Decimal.Parse(r2["e"].ToString());
r1[28] = Decimal.Parse(r2["x1"].ToString());
r1[29] = Decimal.Parse(r2["x2"].ToString());
r1[30] = Decimal.Parse(r2["x3"].ToString());
r1[31] = Decimal.Parse(r2["hc"].ToString());
r1[32] = Decimal.Parse(r2["vl"].ToString());
}
//dau ky + nhap - xuat
rdk = dtdk.Rows[0];
//rdk["nl"]=Decimal.Parse(rdk["ts"].ToString())+Decimal.Parse(r1["v_ts"].ToString())-Decimal.Parse(r1["r_ts"].ToString())-(Decimal.Parse(rdk["te"].ToString())+Decimal.Parse(r1["v_te"].ToString())-Decimal.Parse(r1["r_te"].ToString()));
rdk["nu"] = Decimal.Parse(rdk["nu"].ToString()) + Decimal.Parse(r1["v_nu"].ToString()) - Decimal.Parse(r1["r_nu"].ToString());
rdk["cb"] = Decimal.Parse(rdk["cb"].ToString()) + Decimal.Parse(r1["v_cb"].ToString()) - Decimal.Parse(r1["r_cb"].ToString());
rdk["cn"] = Decimal.Parse(rdk["cn"].ToString()) + Decimal.Parse(r1["v_cn"].ToString()) - Decimal.Parse(r1["r_cn"].ToString());
rdk["nd"] = Decimal.Parse(rdk["nd"].ToString()) + Decimal.Parse(r1["v_nd"].ToString()) - Decimal.Parse(r1["r_nd"].ToString());
rdk["te"] = Decimal.Parse(rdk["te"].ToString()) + Decimal.Parse(r1["v_te"].ToString()) - Decimal.Parse(r1["r_te"].ToString());
rdk["a"] = Decimal.Parse(rdk["a"].ToString()) + Decimal.Parse(r1["v_a"].ToString()) - Decimal.Parse(r1["r_a"].ToString());
rdk["b"] = Decimal.Parse(rdk["b"].ToString()) + Decimal.Parse(r1["v_b"].ToString()) - Decimal.Parse(r1["r_b"].ToString());
rdk["c"] = Decimal.Parse(rdk["c"].ToString()) + Decimal.Parse(r1["v_c"].ToString()) - Decimal.Parse(r1["r_c"].ToString());
rdk["d"] = Decimal.Parse(rdk["d"].ToString()) + Decimal.Parse(r1["v_d"].ToString()) - Decimal.Parse(r1["r_d"].ToString());
rdk["e"] = Decimal.Parse(rdk["e"].ToString()) + Decimal.Parse(r1["v_e"].ToString()) - Decimal.Parse(r1["r_e"].ToString());
rdk["x1"] = Decimal.Parse(rdk["x1"].ToString()) + Decimal.Parse(r1["v_1"].ToString()) - Decimal.Parse(r1["r_1"].ToString());
rdk["x2"] = Decimal.Parse(rdk["x2"].ToString()) + Decimal.Parse(r1["v_2"].ToString()) - Decimal.Parse(r1["r_2"].ToString());
rdk["x3"] = Decimal.Parse(rdk["x3"].ToString()) + Decimal.Parse(r1["v_3"].ToString()) - Decimal.Parse(r1["r_3"].ToString());
rdk["hc"] = Decimal.Parse(rdk["hc"].ToString()) + Decimal.Parse(r1["v_hc"].ToString()) - Decimal.Parse(r1["r_hc"].ToString());
rdk["vl"] = Decimal.Parse(rdk["vl"].ToString()) + Decimal.Parse(r1["v_vl"].ToString()) - Decimal.Parse(r1["r_vl"].ToString());
rdk["ts"] = Decimal.Parse(rdk["ts"].ToString()) + Decimal.Parse(r1["v_ts"].ToString()) - Decimal.Parse(r1["r_ts"].ToString());
r1[33] = Decimal.Parse(rdk["ts"].ToString()) - Decimal.Parse(rdk["te"].ToString());
r1[34] = rdk["nu"];
r1[35] = rdk["cb"];
r1[36] = rdk["cn"];
r1[37] = rdk["nd"];
r1[38] = rdk["te"];
r1[39] = rdk["a"];
r1[40] = rdk["b"];
r1[41] = rdk["c"];
r1[42] = rdk["d"];
r1[43] = rdk["e"];
r1[44] = rdk["x1"];
r1[45] = rdk["x2"];
r1[46] = rdk["x3"];
r1[47] = rdk["hc"];
r1[48] = rdk["vl"];
r1[49] = rdk["ts"];
ds.Tables[0].Rows.Add(r1);
}
try
{
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Không có số liệu !");
return;
}
else
{
string title = "Từ ngày " + tu.Text + " Đến ngày " + den.Text;
if (tu.Text == den.Text)
{
title = "Ngày " + tu.Text;
}
// ds.WriteXml("rthnx.xml");
exp_excel(false);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void load_makp()
{
if (nhom.SelectedIndex != -1)
{
sql = "select a.* from " + user + ".d_duockp a left join " + user + ".btdkp_bv b on a.makp=b.makp where a.nhom like '%" + int.Parse(nhom.SelectedValue.ToString()) + ",%'";
if (s_makp != "")
{
string s = s_makp.Replace(",", "','");
if (s.Length > 3)
{
s = s.Substring(0, s.Length - 3);
}
sql += " and a.makp in ('" + s + "')";
}
else if (i_benhnhan == 1)
{
sql += " and a.makp is not null";
}
if (i_khudt != 0)
{
sql += " and (a.khu=0 or a.khu=" + i_khudt + ")"; //binh 210411
}
if (i_idchinhanh > 0)
{
sql += " and a.chinhanh=" + i_idchinhanh;
}
sql += " order by a.stt";
dtmakp = d.get_data(sql).Tables[0];
makp.DataSource = dtmakp;
if (makp.Items.Count > 0)
{
kp.Text = dtmakp.Rows[makp.SelectedIndex]["ma"].ToString();
}
if (i_loai == 2)
{
load_matutruc();
}
}
}
private void load_phieu()
{
if (bThua)
{
sql = "select * from " + user + ".d_loaiphieu where id=0";
}
else
{
string s_phieu = "";
string tenfile = (i_loai == 2) ? "d_bucstt" : "d_xuatsdct";
sql = "select distinct a.phieu from " + xxx + ".d_xuatsdll a," + xxx + "." + tenfile + " b where a.id=b.id and a.nhom=" + i_nhom + " and a.loai=" + i_loai + " and to_char(a.ngay,'dd/mm/yyyy')='" + s_ngay + "'";
if (makp.SelectedIndex != -1)
{
if (bIntheocstt)
{
sql += " and a.makp=" + int.Parse(makp.SelectedValue.ToString());
}
else
{
sql += " and a.makhoa=" + int.Parse(makp.SelectedValue.ToString());
}
}
if (s_makho != "")
{
sql += " and b.makho in (" + s_makho.Substring(0, s_makho.Length - 1) + ")";
}
foreach (DataRow r in d.get_data(sql).Tables[0].Rows)
{
s_phieu += r["phieu"].ToString() + ",";
}
sql = "select * from " + user + ".d_loaiphieu where nhom=" + i_nhom;
sql += " and loai=" + i_loai;
if (s_phieu != "")
{
sql += " and id in (" + s_phieu.Substring(0, s_phieu.Length - 1) + ")";
}
sql += " order by stt";
}
dtphieu = d.get_data(sql).Tables[0];
phieu.DataSource = dtphieu;
}
private void rptChiphidon_Load(object sender, System.EventArgs e)
{
user = d.user; stime = "'" + d.f_ngay + "'";
i_songay = d.Ngay_toa_bhyt(i_nhom);
psothe.Enabled = d.sothe_doituong(i_madoituong);
s_thetrongtinh = d.thetrongtinh(i_nhom);
s_thetrongtinh_vitri = d.thetrongtinh_vitri(i_nhom);
bCongkham = d.bcongkham_bhyt(i_nhom);
bSotien = d.bSotien_bhyt(i_nhom);
manguon.DisplayMember = "TEN";
manguon.ValueMember = "ID";
if (d.bQuanlynguon(i_nhom))
{
manguon.DataSource = d.get_data("select * from " + user + ".d_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0];
}
else
{
manguon.DataSource = d.get_data("select * from " + user + ".d_dmnguon where id=0 or nhom=" + i_nhom + " order by stt").Tables[0];
}
dt = d.get_data("select * from " + user + ".d_dmbd where nhom=" + i_nhom + " order by id").Tables[0];
sql = "select * from " + user + ".d_dmkho where hide=0 and nhom=" + i_nhom;
if (s_makho != "")
{
sql += " and id in (" + s_makho.Substring(0, s_makho.Length - 1) + ")";
}
sql += " order by stt";
dtdmkho = d.get_data(sql).Tables[0];
kho.DataSource = dtdmkho;
kho.DisplayMember = "TEN";
kho.ValueMember = "ID";
sql = "select * from " + user + ".doituong";
if (i_madoituong == 1)
{
sql += " where madoituong=1";
}
else
{
sql += " where madoituong<>1";
}
sql += " order by madoituong";
madoituong.DisplayMember = "DOITUONG";
madoituong.ValueMember = "MADOITUONG";
madoituong.DataSource = d.get_data(sql).Tables[0];
dc = new DataColumn();
dc.ColumnName = "id";
dc.DataType = Type.GetType("System.Decimal");
dtnhomvp.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "stt";
dc.DataType = Type.GetType("System.Decimal");
dtnhomvp.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "ten";
dc.DataType = Type.GetType("System.String");
dtnhomvp.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "tc";
dc.DataType = Type.GetType("System.Decimal");
dtnhomvp.Columns.Add(dc);
}
private void frmPhieulinh_ng_Load(object sender, System.EventArgs e)
{
user = d.user; stime = "'" + d.f_ngay + "'";
i_dongiale = d.d_dongia_le(i_nhom); bChuky = m.bChuky; bLinh_losx = d.bPhieulinh_dongia_losx_date(i_nhom);
sql = "select * from " + user + ".d_duockp ";
sql += " where nhom like '%" + i_nhom.ToString() + ",%'";
if (s_makp != "")
{
string s = s_makp.Replace(",", "','");
sql += " and makp in ('" + s.Substring(0, s.Length - 3) + "')";
}
sql += " order by stt";
dtkp = d.get_data(sql).Tables[0];
makp.DataSource = dtkp;
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
dstt.ReadXml("..//..//..//xml//d_sttphieulinh.xml");
sql = "select * from " + user + ".d_dmloaint where nhom=" + i_nhom;
if (s_loaint != "")
{
sql += " and id in (" + s_loaint.Substring(0, s_loaint.Length - 1) + ")";
}
sql += " order by stt";
dtloai = d.get_data(sql).Tables[0];
loai.DataSource = dtloai;
loai.DisplayMember = "TEN";
loai.ValueMember = "ID";
sql = "select a.id,a.ma,trim(a.ten)||' '||a.hamluong as ten,a.dang,a.tenhc,c.ten as tennhom,c.stt as manhom,c.stt,d.ten as tenhang from " + user + ".d_dmbd a," + user + ".d_dmnhom b," + user + ".d_nhomin c," + user + ".d_dmhang d";
sql += " where a.manhom=b.id ";
if (d.bNhomin_mabd(i_nhom))
{
sql += " and a.nhomin=c.id ";
}
else
{
sql += " and b.nhomin=c.id ";
}
sql += " and a.mahang=d.id and a.nhom=" + i_nhom;
dt = d.get_data(sql).Tables[0];
s_makho = d.get_dmkho(7).Trim();
s_makho = (s_makho == "") ? "" : s_makho.Substring(0, s_makho.Length - 1);
sql = "select * from " + user + ".d_dmkho where hide=0 and nhom=" + i_nhom;
if (s_makho != "")
{
sql += " and id in (" + s_makho + ")";
}
sql += " order by stt";
dtdmkho = d.get_data(sql).Tables[0];
kho.DataSource = dtdmkho;
kho.DisplayMember = "TEN";
kho.ValueMember = "ID";
ds.ReadXml("..//..//..//xml//d_inphieu.xml");
dsxml.ReadXml("..//..//..//xml//d_inphieu.xml");
if (bChuky)
{
dtbs = d.get_data("select * from " + user + ".dmbs where nhom=" + LibMedi.AccessData.truongkhoa).Tables[0];
DataColumn dc = new DataColumn("image_duoc", typeof(byte[]));
dsxml.Tables[0].Columns.Add(dc);
dc = new DataColumn("image_dieutri", typeof(byte[]));
dsxml.Tables[0].Columns.Add(dc);
}
dtkho = d.get_data("select * from " + user + ".d_dmkho where hide=0 and nhom=" + i_nhom).Tables[0];
dsmabn.ReadXml("..//..//..//xml//d_mabn.xml");
dsmabn.Tables[0].Columns.Add("Chon", typeof(bool));
dataGrid1.DataSource = dsmabn.Tables[0];
AddGridTableStyle();
lan.Read_dtgrid_to_Xml(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
lan.Change_dtgrid_HeaderText_to_English(dataGrid1, this.Name.ToString() + "_" + dataGrid1.Name.ToString());
this.disabledBackBrush = new SolidBrush(Color.FromArgb(255, 255, 192));
this.disabledTextBrush = new SolidBrush(Color.FromArgb(255, 0, 0));
this.alertBackBrush = new SolidBrush(SystemColors.HotTrack);
this.alertFont = new Font(this.dataGrid1.Font.Name, this.dataGrid1.Font.Size, FontStyle.Bold);
this.alertTextBrush = new SolidBrush(Color.White);
this.currentRowFont = new Font(this.dataGrid1.Font.Name, this.dataGrid1.Font.Size, FontStyle.Regular);
this.currentRowBackBrush = new SolidBrush(Color.FromArgb(0, 255, 255));
}
private void frmKhoacstt_Load(object sender, System.EventArgs e)
{
s_makho = ""; user = d.user; stime = "'" + d.f_ngay + "'";
foreach (DataRow r in d.get_data("select kho from " + user + ".d_dmphieu where id=2").Tables[0].Rows)
{
s_makho = r["kho"].ToString();
}
makho.DisplayMember = "TEN";
makho.ValueMember = "ID";
string sql = "select * from " + user + ".d_dmkho where hide=0 and loai=" + i_loai;
if (i_loai == 1)
{
sql += " and nhom=" + i_nhom;
if (s_makho != "")
{
sql += " and id in (" + s_makho.Substring(0, s_makho.Length - 1) + ")";
}
}
else
{
sql += " and nhom<>" + i_nhom;
if (s_nhomkho != "")
{
sql += " and nhom in (" + s_nhomkho.Substring(0, s_nhomkho.Length - 1) + ")";
}
}
sql += " order by stt";
dtdmkho = d.get_data(sql).Tables[0];
makho.DataSource = dtdmkho;
if (makho.Items.Count > 0)
{
makho.SelectedIndex = 0;
}
makp.DisplayMember = "TEN";
makp.ValueMember = "ID";
sql = "select * from " + user + ".d_duockp where nhom like '%" + i_nhom.ToString() + ",%'";
if (s_makp != "")
{
string s = s_makp.Replace(",", "','");
sql += " and makp in ('" + s.Substring(0, s.Length - 3) + "')";
}
sql += " order by stt";
dtkp = d.get_data(sql).Tables[0];
makp.DataSource = dtkp;
if (makp.Items.Count > 0)
{
makp.SelectedIndex = 0;
}
ds.ReadXml("..//..//..//xml//d_khoacstt.xml");
dsxml.ReadXml("..//..//..//xml//d_khoacstt.xml");
format_soluong = d.format_soluong(i_nhom);
sql = "select a.*, b.stt as sttnhom, b.ten as tennhom,c.ten as tenhang,d.ten as nuocsx from " + user + ".d_dmbd a, " + user + ".d_dmnhom b," + user + ".d_dmhang c," + user + ".d_dmnuoc d";
sql += " where a.manhom=b.id and a.mahang=c.id and a.manuoc=d.id and a.nhom=" + i_nhom + " order by a.id";
dt = d.get_data(sql).Tables[0];
manguon.DisplayMember = "TEN";
manguon.ValueMember = "ID";
if (d.bQuanlynguon(i_nhom))
{
manguon.DataSource = d.get_data("select * from " + user + ".d_dmnguon where nhom=" + i_nhom + " order by stt").Tables[0];
}
else
{
manguon.DataSource = d.get_data("select * from " + user + ".d_dmnguon where nhom=0 or nhom=" + i_nhom + " order by stt").Tables[0];
}
}
private void butChon_Click(object sender, System.EventArgs e)
{
if (makp.SelectedIndex == -1)
{
makp.Focus(); return;
}
if (phieu.SelectedIndex == -1)
{
phieu.Focus(); return;
}
s_phieu = "";
if (phieudutru.CheckedItems.Count > 0)
{
for (int i = 0; i < phieudutru.Items.Count; i++)
{
if (phieudutru.GetItemChecked(i))
{
s_phieu += dtph.Rows[i]["id"].ToString().Trim() + ",";
}
}
}
s_tu = tu.Text; s_den = den.Text; i_phieu = int.Parse(phieu.SelectedValue.ToString()); i_makp = int.Parse(makp.SelectedValue.ToString());
s_tenkp = makp.Text;
if (d.get_duyet(s_mmyy, i_makp, i_nhom, i_loai, i_phieu, s_ngay, s_makho))
{
MessageBox.Show(lan.Change_language_MessageText("Ngày") + " " + s_ngay + "\n" + lan.Change_language_MessageText("Khoa") + " " + makp.Text + "\n" + lan.Change_language_MessageText("Phiếu") + " " + phieu.Text + "\n" + lan.Change_language_MessageText("Đã duyệt !"), d.Msg);
return;
}
bool bChieu_sang = m.bChieu_sang;
if (bChieu_sang)
{
DataRow r1, r2;
r2 = d.getrowbyid(dtphieu, "id=" + int.Parse(phieu.SelectedValue.ToString()));
if (r2 != null)
{
if (r2["buoi"].ToString() == "0")
{
r1 = d.getrowbyid(dtkp, "id=" + int.Parse(makp.SelectedValue.ToString()));
if (r1 != null)
{
if (d.get_ttngay(s_ngay, r1["makp"].ToString()))
{
MessageBox.Show(lan.Change_language_MessageText("Ngày") + " " + s_ngay + " " + lan.Change_language_MessageText("viện phí đã in danh sách thu tiền") + "\n" + lan.Change_language_MessageText("Yêu cầu chọn phiếu buổi chiều !"), d.Msg);
return;
}
}
}
}
}
if (chkChuyen.Checked)
{
string sql = "select id from " + xxx + ".d_duyet ";
sql += " where done=0 and nhom=" + i_nhom + " and loai=" + i_loai;
sql += " and makhoa=" + i_makp;
sql += " and ngay between to_date('" + s_tu + "','" + f_ngay + "') and to_date('" + s_den + "','" + f_ngay + "')";
if (s_phieu != "")
{
sql += " and phieu in (" + s_phieu.Substring(0, s_phieu.Length - 1) + ")";
}
foreach (DataRow r in d.get_data(sql).Tables[0].Rows)
{
d.execute_data("update " + xxx + ".d_duyet set done=1 where id=" + decimal.Parse(r["id"].ToString()));
}
}
DataTable dttam = new DataTable();
dttam = d.get_data("select computer from " + user + ".d_danglaysolieu where makp=" + i_makp +
" and phieu=" + i_phieu + " and to_char(ngay,'dd/mm/yyyy')='" + s_ngay + "' and computer<>'" + System.Environment.MachineName + "'").Tables[0];
if (dttam.Rows.Count > 0)
{
MessageBox.Show(lan.Change_language_MessageText("Phiếu này đang lấy số liệu duyệt tại máy ") + dttam.Rows[0][0].ToString() + lan.Change_language_MessageText(".\n Vui lòng chọn phiếu khác."));
return;
}
d.upd_danglaysolieu(i_makp, i_phieu, s_ngay, i_userid);
d.close(); this.Close();
}