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 frmReport_Load(object sender, System.EventArgs e)
{
this.Report.Size = new System.Drawing.Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
this.Size = new System.Drawing.Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
string dir = System.IO.Directory.GetCurrentDirectory();
//
bAdminHethong = d.bAdmin(d_userid);
i_nhom = get_nhomkho();
if (!bAdminHethong && d.bUserthuong_CamxuatExcel_E11(i_nhom))
{
butExcel.Enabled = false;
Report.ShowExportButton = false;
}
//
ExportPath = "";
int j = 0;
for (int i = 0; i < dir.Length; i++)
{
if (dir.Substring(i, 1) == "\\")
{
j++;
}
if (j == 2)
{
break;
}
ExportPath += dir.Substring(i, 1);
}
ExportPath += "\\pdf\\";
if (!System.IO.Directory.Exists(ExportPath))
{
System.IO.Directory.CreateDirectory(ExportPath);
}
s_dirreport = get_dirreport(56); //doc thu muc report cua tung benh vien
i_soluong_le = d.d_soluong_le(i_nhom);
i_dongia_le = d.d_dongia_le(i_nhom);
i_thanhtien_le = d.d_thanhtien_le(i_nhom);
//
if (b_bienlai)
{
Bienlai();
}
else if (ReportFile.ToString().ToLower() == "d_phieunhap.rpt")
{
Phieunhap();
}
else if (bDs)
{
Reportds();
}
else if (msg != "")
{
treem();
}
else
{
PreviewReport();
}
}
private void taotable()
{
if (!kiemtra())
{
return;
}
i_dongia = d.d_dongia_le(int.Parse(nhom.SelectedValue.ToString()));
ds.Clear();
s_loai = ""; s_phieu = "";
for (int i = 0; i < loai.Items.Count; i++)
{
if (loai.GetItemChecked(i))
{
s_loai += dtloai.Rows[i]["id"].ToString().Trim() + ",";
}
}
for (int i = 0; i < phieu.Items.Count; i++)
{
if (phieu.GetItemChecked(i))
{
s_phieu += dtphieu.Rows[i]["id"].ToString().Trim() + ",";
}
}
dtdmbd = d.get_data("select * from " + user + ".d_dmbd where nhom=" + int.Parse(nhom.SelectedValue.ToString())).Tables[0];
string cont = " and a.makp=" + int.Parse(makp.SelectedValue.ToString()) + " and a.nhom=" + int.Parse(nhom.SelectedValue.ToString());
cont += " and a.ngay between to_date('" + tu.Text + "'," + stime + ") and to_date('" + den.Text + "'," + stime + ")";
if (s_loai != "")
{
cont += " and a.loai in (" + s_loai.Substring(0, s_loai.Length - 1) + ")";
}
if (s_phieu != "")
{
cont += " and a.phieu in (" + s_phieu.Substring(0, s_phieu.Length - 1) + ")";
}
if (imp.Visible)
{
if (imp.Checked)
{
cont += " and c.manhom in (31,55)";
}
else
{
cont += " and c.manhom not in (31,55)";
}
}
s_makho = ""; s_tenkho = "";
for (int i = 0; i < makho.Items.Count; i++)
{
if (makho.GetItemChecked(i))
{
s_makho += dtkho.Rows[i]["id"].ToString().Trim() + ",";
s_tenkho += dtkho.Rows[i]["ten"].ToString().Trim() + ";";
}
}
if (s_makho == "")
{
for (int i = 0; i < makho.Items.Count; i++)
{
s_makho += dtkho.Rows[i]["id"].ToString().Trim() + ",";
s_tenkho += dtkho.Rows[i]["ten"].ToString().Trim() + ";";
}
}
//
s_manhom = ""; s_tennhom = "";
for (int i = 0; i < dmnhom.Items.Count; i++)
{
if (dmnhom.GetItemChecked(i))
{
s_manhom += dtdmnhom.Rows[i]["id"].ToString().Trim() + ",";
s_tennhom += dtdmnhom.Rows[i]["ten"].ToString().Trim() + ";";
}
}
if (s_manhom == "")
{
for (int i = 0; i < dmnhom.Items.Count; i++)
{
s_manhom += dtdmnhom.Rows[i]["id"].ToString().Trim() + ",";
s_tennhom += dtdmnhom.Rows[i]["ten"].ToString().Trim() + ";";
}
}
//
if (s_makho != "")
{
cont += " and b.makho in (" + s_makho.Substring(0, s_makho.Length - 1) + ")";
}
if (s_manhom.Trim().Trim(',') != "")
{
cont += " and c.manhom in(" + s_manhom.Trim().Trim(',') + ")";
}
DateTime dt1 = d.StringToDate(tu.Text).AddDays(-d.iNgaykiemke);
DateTime dt2 = d.StringToDate(den.Text).AddDays(d.iNgaykiemke);
int y1 = dt1.Year, m1 = dt1.Month;
int y2 = dt2.Year, m2 = dt2.Month;
int itu, iden;
string mmyy = "";
for (int i = y1; i <= y2; i++)
{
itu = (i == y1)?m1:1;
iden = (i == y2)?m2:12;
for (int j = itu; j <= iden; j++)
{
mmyy = j.ToString().PadLeft(2, '0') + i.ToString().Substring(2, 2);
if (d.bMmyy(mmyy))
{
get_xuat(mmyy, cont);
get_hoantra(mmyy, cont);
}
}
}
sort();
}