public static EntityCollection SearchThongTinHoSo(SearchInput input)
{
EntityCollection entityCollection = new EntityCollection(new ThongTinHoSoEntityFactory());
using (DataAccessAdapterBase dataAccessAdapterBase = new DataAccessAdapter(ManageBase.ConnectionString))
{
RelationPredicateBucket relationPredicateBucket = new RelationPredicateBucket();
relationPredicateBucket.PredicateExpression.Add(ThongTinHoSoFields.XaId == GlobalVariable.XaId);
relationPredicateBucket.PredicateExpression.Add(ThongTinHoSoFields.HoSoMoiNhat == true);
bool flag = !string.IsNullOrEmpty(input.SoThua);
if (flag)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(ThongTinHoSoFields.SoThuTuThua, null, FullTextSearchOperator.Contains, input.SoThua));
}
bool flag2 = !string.IsNullOrEmpty(input.SoTo);
if (flag2)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(ThongTinHoSoFields.SoHieuToBanDo, null, FullTextSearchOperator.Contains, input.SoTo));
}
bool flag3 = !string.IsNullOrEmpty(input.SoBienNhan);
if (flag3)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(ThongTinHoSoFields.SoBienNhan, null, FullTextSearchOperator.Contains, ManageBase.GetStringFullTextSearch(input.SoBienNhan, false)));
}
bool flag4 = !string.IsNullOrEmpty(input.SoBanVe);
if (flag4)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(ThongTinHoSoFields.SoBanVe, null, FullTextSearchOperator.Contains, ManageBase.GetStringFullTextSearch(input.SoBanVe, false)));
}
bool flag5 = !string.IsNullOrEmpty(input.SoSerial);
if (flag5)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(ThongTinHoSoFields.SoHieuGiayChungNhan, null, FullTextSearchOperator.Contains, ManageBase.GetStringFullTextSearch(input.SoSerial, false)));
}
bool laNguoiNopHoSo = input.LaNguoiNopHoSo;
if (laNguoiNopHoSo)
{
bool flag6 = !string.IsNullOrEmpty(input.HoTen);
if (flag6)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(ThongTinHoSoFields.NguoiNopHoSo, null, FullTextSearchOperator.Contains, ManageBase.GetStringFullTextSearch(input.HoTen, false)));
}
bool flag7 = !string.IsNullOrEmpty(input.SoGiayTo);
if (flag7)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(ThongTinHoSoFields.SoGiayToNguoiNop, null, FullTextSearchOperator.Contains, ManageBase.GetStringFullTextSearch(input.SoGiayTo, false)));
}
}
else
{
bool flag8 = !string.IsNullOrEmpty(input.HoTen);
if (flag8)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(ThongTinHoSoFields.HoTen, null, FullTextSearchOperator.Contains, ManageBase.GetStringFullTextSearch(input.HoTen, false)));
}
bool flag9 = !string.IsNullOrEmpty(input.SoGiayTo);
if (flag9)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(ThongTinHoSoFields.SoGiayTo, null, FullTextSearchOperator.Contains, ManageBase.GetStringFullTextSearch(input.SoGiayTo, false)));
}
}
dataAccessAdapterBase.FetchEntityCollection(entityCollection, relationPredicateBucket);
}
return(entityCollection);
}
public static DataTable SearchNguoiDungRDT(string tenDangNhap, string hoTen)
{
DataTable dataTable = new DataTable();
EntityCollection entityCollection = new EntityCollection(new NguoiDungEntityFactory());
using (DataAccessAdapterBase dataAccessAdapterBase = new DataAccessAdapter(ManageBase.ConnectionString))
{
RelationPredicateBucket relationPredicateBucket = new RelationPredicateBucket();
bool flag = !string.IsNullOrEmpty(tenDangNhap);
if (flag)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(NguoiDungFields.TenDangNhap, null, FullTextSearchOperator.Contains, ManageBase.GetStringFullTextSearch(tenDangNhap, false)));
}
bool flag2 = !string.IsNullOrEmpty(hoTen);
if (flag2)
{
relationPredicateBucket.PredicateExpression.Add(new FieldFullTextSearchPredicate(NguoiDungFields.HoTenNguoiDung, null, FullTextSearchOperator.Contains, ManageBase.GetStringFullTextSearch(hoTen, false)));
}
dataAccessAdapterBase.FetchTypedList(entityCollection.EntityFactoryToUse.CreateFields(), dataTable, relationPredicateBucket);
}
return(dataTable);
}
