public List <ViewALLCB> TimKiemDangVien(string username, string password, TimKiem tk)
{
try
{
authen a = new authen();
bool bAuthen = a.fAuthen(username, password);
if (bAuthen)
{
var ab =
(from k in db.ViewALLCBs
where (tk.HoTen != "" ? k.HoTenKhaiSinh.Contains(tk.HoTen) : true) &&
(tk.MaCB != "" ? k.MaCoSoDangQLDangVien.Contains(tk.MaCB) : true) &&
(tk.GioiTinh != "" ? k.GioiTinh == tk.GioiTinh : true) &&
(tk.ChuyenMonNghiepVu != "" ? k.ChuyenNganh == tk.ChuyenMonNghiepVu : true)
select k).Where(x => x.KhongLaDangVien != 1).ToList();
return(ab);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
private dynamic DocDanhSach(string tuKhoa = "", int?trangHienTai = 1)
{
var currenPage = (trangHienTai == null || trangHienTai < 1) ? 1 : trangHienTai.Value;
int soDongTrenTrang = PageNumber.Default;
int viTriBatDau = (currenPage - 1) * soDongTrenTrang;
int tongSoDong = 0;
var input = new TimKiem
{
TuKhoa = tuKhoa.Trim().ToLower(),
ViTriBatDau = viTriBatDau,
ViTriKetThuc = viTriBatDau + soDongTrenTrang
};
var output = XuLyAPI.ApiJsonPost(APIUrl.ThongBaoKhan.DocDanhSachPhanTrang, input) as CommonOutput;
if (output == null)
{
throw new Exception(ConstantValues.Message.LoiServer);
}
if (output.KetQua != 1)
{
throw new Exception(output.ThongBao);
}
var duLieuOutput = JsonConvert.DeserializeObject <Models.ThongBaoKhanModel.Output.DocDanhSach>(output.DuLieu.ToString());
var kq = new Models.ThongBaoKhanModel.Output.DocDanhSach();
kq.TrangHienTai = currenPage;
tongSoDong = duLieuOutput.TongSoDong;
kq.TongSoTrang = (tongSoDong % soDongTrenTrang > 0) ? tongSoDong / soDongTrenTrang + 1 : tongSoDong / soDongTrenTrang;
kq.TongSoDong = tongSoDong;
kq.DanhSach = duLieuOutput.DanhSach;
return(kq);
}
public List <ViewALLCB> TimKiemCanBo(string username, string password, TimKiem tk)
{
try
{
authen a = new authen();
bool bAuthen = a.fAuthen(username, password);
if (bAuthen)
{
return((from k in db.ViewALLCBs
where (tk.HoTen != "" ? k.HoTenKhaiSinh.Contains(tk.HoTen) : true) &&
(tk.MaCB != "" ? k.SoHieuCB.Contains(tk.MaCB) : true) &&
(tk.GioiTinh != "" ? k.GioiTinh == tk.GioiTinh : true) &&
(tk.TrinhDoHocVan != "" ? k.TrinhDoHocVan == tk.TrinhDoHocVan : true) &&
(tk.NgheNghiep != "" ? k.NgheNghiepKhiTuyenDung == tk.NgheNghiep : true) &&
(tk.ThanhPhanGiaDinh != "" ? k.ThanhPhanGiaDinh == tk.ThanhPhanGiaDinh : true) &&
(tk.DanToc != "" ? k.DanToc == tk.DanToc : true) &&
(tk.TonGiao != "" ? k.TonGiao == tk.TonGiao : true)
select k).ToList());
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
private void buttonTimKiem_Click(object sender, EventArgs e)
{
this.Hide();
TimKiem formTK = new TimKiem();
formTK.FormClosed += FormTK_FormClosed;
formTK.Show();
}
private void Detail_FormClosed(object sender, FormClosedEventArgs e)
{
BIENTOANCUC.dt = null;
BIENTOANCUC.imagepath = null;
TimKiem tk = new TimKiem();
this.Close();
tk.Show();
}
public List <Prod_CCTC_GetAllSale_Result> GetAllSale(TimKiem timkiem)
{
using (var db = new ERP_DATABASEEntities())
{
var query = db.Database.SqlQuery <Prod_CCTC_GetAllSale_Result>("Prod_CCTC_GetAllSale @macongty, @phongsale, @phongmarketing", new SqlParameter("macongty", timkiem.macongty), new SqlParameter("phongsale", timkiem.phongsale), new SqlParameter("phongmarketing", timkiem.phongmarketing));
var result = query.ToList();
return(result);
}
}
private void Load_TimKiem(string text)
{
try
{
TimKiem tk = new TimKiem();
DataTable dt = tk.TKCoBan(text);
dgvListTaiLieu.DataSource = dt;
dgvListTaiLieu.Refresh();
}
catch (Exception)
{
throw;
}
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
try
{
TimKiem tk = new TimKiem();
DataTable dt = tk.TKNangCao(txtTimKiem.Text, cbTimTheo.SelectedValue.ToString(), Convert.ToInt32(cbLoaiTimTheo.SelectedValue));
dgvListTaiLieu.DataSource = dt;
dgvListTaiLieu.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//dataGridView1.DataSource = ds.Tables[0];
//cm = BindingContext[this.ds.Tables[0]] as CurrencyManager;
//label5.Text = cm.Count.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string tukhoa = Request.QueryString["KeyKhoa"];
if (!string.IsNullOrEmpty(tukhoa))
{
TimKiem tk = new TimKiem();
DataTable dtb = tk.TimKiemBaiViet(tukhoa);
this.Title = "Tìm kiếm: Keyword= " + tukhoa;
if (dtb.Rows.Count > 0)
{
pnSearch.GroupingText = "Tìm thấy <u>" + dtb.Rows.Count + "</u> kết quả với từ khóa ''<b>" + tukhoa + "</b>''";
//Download source code tại Sharecode.vn
dtlSearch.DataSource = dtb;
dtlSearch.DataBind();
}
}
}
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
TimKiem frm = new TimKiem();
frm.Show();
}
private void simpleButton1_Click(object sender, EventArgs e)
{
TimKiem tk = new TimKiem();
tk.Show();
}
