// // GET: /Nuoi trong man ngot no/ public ActionResult Index(ViewModelSearchNT_NUOC_NGOT Searchmodel) { ApplicationUser curUser = this.getCurrentUser(); //Load danh mục: this.LoadDanhMuc(Searchmodel); var models = _context.NT_NUOC_NGOT.Where(o => ((string.IsNullOrEmpty(Searchmodel.TThanhPho) && (string.IsNullOrEmpty(curUser.MA_TINHTP) || curUser.MA_TINHTP.StartsWith("Z"))) || (string.IsNullOrEmpty(Searchmodel.TThanhPho) && o.MA_TINHTP == curUser.MA_TINHTP) || o.MA_TINHTP == Searchmodel.TThanhPho) && (Searchmodel.Thang == null || o.THANG == Searchmodel.Thang) && (Searchmodel.Nam == null || o.NAM == Searchmodel.Nam) && (Searchmodel.LoaiBaoCao == null || o.LOAI_BAO_CAO == Searchmodel.LoaiBaoCao) && (Searchmodel.TuNgay == null || (o.NGAY_BAO_CAO_TU >= Searchmodel.TuNgay)) && (Searchmodel.DenNgay == null || (o.NGAY_BAO_CAO_DEN <= Searchmodel.DenNgay)) && (Searchmodel.DoiTuongNuoi == null || o.DSNT_NuocNgotDetail.Any(d => d.ID_DOITUONG_NUOI_NGOT == Searchmodel.DoiTuongNuoi)) && (Searchmodel.HinhThucNuoi == null || o.DSNT_NuocNgotDetail.Any(d => d.ID_HINHTHUC_NUOI == Searchmodel.HinhThucNuoi)) ) ; // string sqlsanLuongs = ((ObjectQuery)sanLuongs).ToTraceString(); ViewBag.TotalRow = models.Count().ToString(); models = models.OrderByDescending(m => m.ID); //Phân trang ở đây: var pageIndex = Searchmodel.Page ?? 1; Searchmodel.SearchResults = models.ToPagedList(pageIndex, FDB.Common.Constants.PageSize); return(View(Searchmodel)); }
//Nếu dùng Jquery Validate thì hàm này có thể bỏ //private String GenderHTML(List<int> lstInt, FormCollection _form, ref int MaxID) //{ // String strHTML = ""; // int _maxID = 0; // if (lstInt != null && lstInt.Count > 0) // { // List<DM_NHOMDOITUONG_NUOI> lstDMNhomDoiTuongNuoi = _context.DM_NHOMDOITUONG_NUOI.ToList(); // List<DM_DOITUONG_NUOI> lstDMDoiTuongNuoi = _context.DM_DOITUONG_NUOI.ToList(); // List<DM_DOITUONG_NUOI> lstDMDoiTuongNuoiSelected = new List<DM_DOITUONG_NUOI>(); // int ID_NhomDoiTuongSelected = 1; // for (int i = 0; i < lstInt.Count; i++) // { // strHTML += "<tr><td><select class=\"selectNhomNghe\" name=\"ddlID_NUOITRONG_NHOMDOITUONG_" + lstInt[i].ToString() + "\" id=\"ddlID_NUOITRONG_NHOMDOITUONG_" + lstInt[i].ToString() + "\">"; // lstDMNhomDoiTuongNuoi.ForEach(d => // { // if (d.ID.ToString() == _form["ddlID_NUOITRONG_NHOMDOITUONG_" + lstInt[i].ToString()]) // { // ID_NhomDoiTuongSelected = d.ID; // strHTML += "<option value=\"" + d.ID.ToString() + "\" selected=\"selected\">" + d.TEN_NHOM + "</option>"; // } // else // strHTML += "<option value=\"" + d.ID.ToString() + "\" >" + d.TEN_NHOM + "</option>"; // } // ); // strHTML += "</td>"; // lstDMDoiTuongNuoiSelected = lstDMDoiTuongNuoi.Where(o => o.DM_NHOMDOITUONG_NUOIID == ID_NhomDoiTuongSelected).ToList(); // strHTML += "<td><select class=\"form-control\" name=\"ddlID_NUOITRONG_DOITUONG_" + lstInt[i].ToString() + "\" id=\"ddlID_NUOITRONG_DOITUONG_" + lstInt[i].ToString() + "\"><option value></option>"; // lstDMDoiTuongNuoiSelected.ForEach(d => // { // if (d.ID.ToString() == _form["ddlID_NUOITRONG_DOITUONG_" + lstInt[i].ToString()]) // strHTML += "<option value=\"" + d.ID.ToString() + "\" selected=\"selected\">" + d.TEN_DOI_TUONG + "</option>"; // else // strHTML += "<option value=\"" + d.ID.ToString() + "\" >" + d.TEN_DOI_TUONG + "</option>"; // } // ); // strHTML += "</select>"; // strHTML += "</td>"; // strHTML += "<td><input type=\"text\" value=\"" + _form["txtDIEN_TICH_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtDIEN_TICH_" + lstInt[i].ToString() + "\"/></td>"; // strHTML += "<td><input type=\"text\" value=\"" + _form["txtSAN_LUONG_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtSAN_LUONG_" + lstInt[i].ToString() + "\"/></td>"; // strHTML += "<td><input type=\"text\" value=\"" + _form["txtNANG_SUAT_TU_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtNANG_SUAT_TU_" + lstInt[i].ToString() + "\"/></td>"; // strHTML += "<td><input type=\"text\" value=\"" + _form["txtNANG_SUAT_DEN_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtNANG_SUAT_DEN_" + lstInt[i].ToString() + "\"/></td>"; // strHTML += "<td><input type=\"text\" value=\"" + _form["txtDIEN_TICH_GAP_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtDIEN_TICH_GAP_" + lstInt[i].ToString() + "\"/></td>"; // strHTML += "<td><input type=\"text\" value=\"" + _form["txtDIEN_TICH_NUOI_CDK_" + lstInt[i].ToString()] + "\" class=\"form-control\" name=\"txtDIEN_TICH_NUOI_CDK_" + lstInt[i].ToString() + "\"/></td>"; // strHTML += "<td><select class=\"form-control\" name=\"ddlID_MOHINH_NUOI_" + lstInt[i].ToString() + "\">"; // CategoryCommon.DM_MOHINH_NUOIs.ForEach(d => // { // if (d.ID.ToString() == _form["ddlID_MOHINH_NUOI_" + lstInt[i].ToString()]) // strHTML += "<option value=\"" + d.ID.ToString() + "\" selected=\"selected\">" + d.TEN + "</option>"; // else // strHTML += "<option value=\"" + d.ID.ToString() + "\" >" + d.TEN + "</option>"; // } // ); // strHTML += "</select>"; // strHTML += "</td>"; // strHTML += "<td><label class=\"BtnPlus\" style=\"cursor:pointer\"><img src=\"/fonts/button-add-icon.png\" title=\"Thêm mới\" /></label>"; // strHTML += "<label class=\"BtnMinus\" id=\"lblDetail_\"" + (i + 1).ToString() + " style=\"cursor:pointer\"><img src=\"/fonts/DELETE.GIF\" title=\"Xóa\" /></label></td>"; // strHTML += "</tr>"; // if (lstInt[i] > _maxID) // _maxID = lstInt[i]; // } // } // MaxID = _maxID; // return strHTML; //} public void LoadDanhMuc(ViewModelSearchNT_NUOC_NGOT Searchmodel) { //Load danh mục: ApplicationUser curUser = this.getCurrentUser(); var tinh = _context.DTINHTP.Where(u => (curUser.MA_TINHTP == null || curUser.MA_TINHTP.StartsWith("Z")) || u.MA_TINHTP == curUser.MA_TINHTP) .Except(_context.DTINHTP.Where(d => d.MA_TINHTP.StartsWith("Z"))); ViewBag.DMTThanhPho = new SelectList(tinh, "MA_TINHTP", "TEN_TINHTP", Searchmodel.TThanhPho); // ViewBag.DMQhuyen = new SelectList(_context.DQUANHUYEN, "MA_QUANHUYEN", "TEN_QUANHUYEN", Searchmodel.Qhuyen); ViewBag.DMMoHinhNuoi = new SelectList(_context.DM_HINHTHUC_NUOI, "ID", "TEN_HINH_THUC", Searchmodel.HinhThucNuoi); var doituongNgot = _context.DM_DOITUONG_NUOI_NGOT.Where(d => d.LOAI_DOI_TUONG == Searchmodel.HinhThucNuoi); ViewBag.DMDoiTuongNuoi = new SelectList(doituongNgot, "ID", "TEN_DOI_TUONG", Searchmodel.DoiTuongNuoi); ViewBag.DEFAULT_VALUE_DDL = CategoryCommon.DEFAULT_VALUE_DDL; }