public void pLoad() { string sql = " SELECT tn.SoHoSo,DienThoai,DanhBo,lt.TenLoai,NgayNhan, GhiChu,CreateBy,ChuyenHS,DonViChuyen,NgayChuyen,NgayXuLy,KetQuaXuLy,NhanVienXuLy,TenKH,(SoNha + ' ' + TenDuong ) as DiaChi "; sql += " FROM TiepNhan tn, LoaiTiepNhan lt "; sql += " WHERE tn.LoaiHs=lt.ID "; sql += " AND CONVERT(DATE,NgayNhan,103) BETWEEN CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateTuNgay.Value.Date) + "',103) AND CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateDenNgay.Value.Date) + "',103) "; sql += " AND DonViChuyen='" + phong + "'"; if (ckChuaChuyen.Checked) { sql += " AND (ChuyenHS is NULL OR ChuyenHS='False')"; } else if (ckChuaXuLy.Checked) { sql += " AND (ChuyenHS is not null AND NgayXuLy is null) "; } else if (ckHoanTat.Checked) { sql += " AND NgayXuLy IS NOT NULL "; } sql += " ORDER BY NgayNhan DESC"; dataGrid.DataSource = CCallCenter.getDataTable(sql); }
public static DataTable getListTiepNhan(string danhbo) { string sql = " SELECT tn.SoHoSo,DienThoai,DanhBo,lt.TenLoai,NgayNhan, GhiChu,CreateBy,ChuyenHS,DonViChuyen,NgayChuyen,NgayXuLy,KetQuaXuLy,NhanVienXuLy,TenKH,(SoNha + ' ' + TenDuong ) as DiaChi "; sql += " FROM TiepNhan tn, LoaiTiepNhan lt "; sql += " WHERE tn.LoaiHs=lt.ID "; sql += " AND DanhBo='" + danhbo + "' ORDER BY NgayNhan DESC "; return(CCallCenter.getDataTable(sql)); }
public void alrt() { string sql2 = " SELECT tn.SoHoSo,DienThoai,DanhBo,lt.TenLoai,NgayNhan, GhiChu,CreateBy "; sql2 += " FROM TiepNhan tn, LoaiTiepNhan lt "; sql2 += " WHERE tn.LoaiHs=lt.ID "; //sql2 += " AND CONVERT(DATE,NgayNhan,103) BETWEEN CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateTuNgay.Value.Date) + "',103) AND CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateDenNgay.Value.Date) + "',103) "; sql2 += " AND DonViChuyen='TCTB' AND Mess='True' "; DataTable tb = CCallCenter.getDataTable(sql2); if (tb.Rows.Count > 0) { Mess of = new Mess(tb); timer1.Stop(); if (of.ShowDialog() == System.Windows.Forms.DialogResult.OK) { timer1.Start(); } } }
public void alrt() { string sql = " SELECT tn.SoHoSo,DienThoai,DanhBo,lt.TenLoai,NgayNhan, GhiChu,CreateBy,ChuyenHS,DonViChuyen,NgayChuyen,NgayXuLy,KetQuaXuLy,NhanVienXuLy,TenKH,(SoNha + ' ' + TenDuong ) as DiaChi "; sql += " FROM TiepNhan tn, LoaiTiepNhan lt "; sql += " WHERE tn.LoaiHs=lt.ID "; sql += " AND DATEDIFF(DD,NgayNhan,GETDATE())>3 "; sql += " AND NgayXuLy IS NULL "; sql += " ORDER BY NgayNhan DESC"; DataTable tb = CCallCenter.getDataTable(sql); if (tb.Rows.Count > 0) { MessChuaXL of = new MessChuaXL(tb); timer1.Stop(); of.ShowDialog(); //if (of.ShowDialog() == System.Windows.Forms.DialogResult.OK ) // timer1.Start(); } }
public void pLoad() { string sql = " SELECT tn.SoHoSo,DienThoai,DanhBo,lt.TenLoai,NgayNhan, GhiChu,CreateBy,ChuyenHS,DonViChuyen,NgayChuyen,NgayXuLy,KetQuaXuLy,NhanVienXuLy,TenKH,(SoNha + ' ' + TenDuong ) as DiaChi "; sql += " FROM TiepNhan tn, LoaiTiepNhan lt "; sql += " WHERE tn.LoaiHs=lt.ID "; sql += " AND CONVERT(DATE,NgayNhan,103) BETWEEN CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateTuNgay.Value.Date) + "',103) AND CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateDenNgay.Value.Date) + "',103) "; if (cbLoai.SelectedIndex == 0) { sql += " AND LoaiTN='KH'"; } else { sql += " AND LoaiTN='GM'"; } if (ckChuaChuyen.Checked) { sql += " AND (ChuyenHS is NULL OR ChuyenHS='False')"; } else if (ckChuaXuLy.Checked) { sql += " AND (ChuyenHS is not null AND NgayXuLy is null) "; } else if (ckHoanTat.Checked) { sql += " AND NgayXuLy IS NOT NULL "; } sql += " ORDER BY NgayNhan DESC"; dataGrid.DataSource = CCallCenter.getDataTable(sql); // format(); cbPhongBan.DataSource = CCallCenter.getDataTable("SELECT * FROM PhongBan "); cbPhongBan.DisplayMember = "TenPhong"; cbPhongBan.ValueMember = "MaPhong"; }