public IEnumerable <Item> GetByFilter(FilterClass filter) { //List<Item> items = Get().ToList(); //return items.FindAll(item => item.Quantity > filter.LowQuantity && item.Quantity < filter.HighQuantity); List <Item> items = new List <Item>(); string query = $"SELECT * FROM dbo.items WHERE Quantity > {filter.LowQuantity} AND Quantity < {filter.HighQuantity}"; using (SqlConnection conn = new SqlConnection(connectionstring)) { conn.Open(); using (SqlCommand com = new SqlCommand(getAll, conn)) { SqlDataReader sr = com.ExecuteReader(); while (sr.Read()) { Item item = ReadNextElement(sr); items.Add(item); } sr.Close(); } } return(items); }
private void 提成管理toolStripMenuItem2_Click(object sender, EventArgs e) { if (!FilterClass.tcgl()) { MessageBox.Show("无权操作!"); return; } }
//我的收藏 過濾 public ActionResult FavoriteFilter(FilterClass filter) { MemberService service = new MemberService(); filter.list = service.GetFavoritelist(Int32.Parse(Request.Cookies["upid"].Value)); List <FavoriteView> newlist = service.FavoritesFilter(filter); return(Json(newlist, JsonRequestBehavior.AllowGet)); }
public void FilterTest() { List <int> list = new List <int> { 5, 2, 8, 3, 7 }; List <int> filterList = FilterClass <int> .Filter(list, x => (x % 2) == 0); Assert.IsTrue(filterList[0] == 2 && filterList.Count == 2); }
public static string AddToCart(FilterClass fc) { if (HttpContext.Current.Session["uid"] == null) { var gioHang = GioHangBus.GetAll() .FirstOrDefault(m => m.DiaChiIp == Cart.IpAddress && m.MaSp == fc.ProductId); if (gioHang != null) { return(@"<div class='alert alert-warning'> <a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a> <b>Sản phẩm đã tồn tại trong giỏ hàng !</b> </div>" ); } if (GioHangBus.Insert(new DTO.GioHang { MaSp = fc.ProductId, DiaChiIp = Cart.IpAddress, SoLuong = 1 }) != null) { return(@"<div class='alert alert-success'> <a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a> <b>Sản phẩm đã được thêm !</b> </div>" ); } } else { var gioHang = GioHangBus.GetAll() .FirstOrDefault(m => m.MaKh == int.Parse(HttpContext.Current.Session["uid"].ToString()) && m.MaSp == fc.ProductId); if (gioHang != null) { return(@"<div class='alert alert-warning'> <a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a> <b>Sản phẩm đã tồn tại trong giỏ hàng !</b> </div>" ); } if (GioHangBus.Insert(new DTO.GioHang { MaSp = fc.ProductId, MaKh = int.Parse(HttpContext.Current.Session["uid"].ToString()), SoLuong = 1 }) != null) { return(@"<div class='alert alert-success'> <a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a> <b>Sản phẩm đã được thêm !</b> </div>" ); } } return("OK"); }
public void FilterTest1() { List <int> list = FilterClass.Filter( new List <int>() { 1 }, x => (x % 2 == 0)); Assert.IsTrue(list.Count == 0); }
void SearchCommandExecute(Object parameter) { MainWork mw = parameter as MainWork; string searchKeyWords = mw.txt_Keywords.Text.Trim(); ListCollectionView lcv = (ListCollectionView)CollectionViewSource.GetDefaultView(mw.lvCredentialInfo.ItemsSource); FilterClass filter = new FilterClass(); filter.keywords = searchKeyWords; lcv.Filter = new Predicate <object>(filter.Filterkeywords); }
public void AddFilter(FilterType fType) { #region Conditions to collection if (lstFilter.SelectedValue != null && ((FilterClass)lstFilter.SelectedValue).ConditionType == FilterType.Collection) { switch (fType) { case FilterType.Name: case FilterType.Host: case FilterType.Description: case FilterType.OperatingSystem: case FilterType.Folder: case FilterType.Protocol: case FilterType.Credential: case FilterType.Public: case FilterType.Port: case FilterType.ProtocolSetting: case FilterType.Connection: case FilterType.Collection: var newFilter = new FilterClass(fType); ((FilterClass)lstFilter.SelectedValue).SubConditions.Add(newFilter); break; } } #endregion #region Conditions to root else { switch (fType) { case FilterType.Name: case FilterType.Host: case FilterType.Description: case FilterType.OperatingSystem: case FilterType.Folder: case FilterType.Protocol: case FilterType.Credential: case FilterType.Public: case FilterType.Port: case FilterType.ProtocolSetting: case FilterType.Connection: case FilterType.Collection: var newFilter = new FilterClass(fType); FilterList.Add(newFilter); break; } } RaisePropertyChanged("FilterList"); lstFilter.SelectedIndex = lstFilter.Items.Count - 1; #endregion }
//显示管理员设置窗口 private void 管理员设置ToolStripMenuItem_Click(object sender, EventArgs e) { if (!FilterClass.glysz()) { MessageBox.Show("无权操作!"); return; } glyszForm glygl = glyszForm.Create(); glygl.Show(); glygl.Focus(); }
//显示连锁店管理窗口 private void 系统设置ToolStripMenuItem_Click(object sender, EventArgs e) { if (!FilterClass.lsdsz()) { MessageBox.Show("无权操作!"); return; } lsdglForm lsdgl = lsdglForm.Create(); lsdgl.Show(); lsdgl.Focus(); }
private void 其他ToolStripMenuItem_Click(object sender, EventArgs e) { if (!FilterClass.qtfw()) { MessageBox.Show("无权操作!"); return; } qtForm qt = qtForm.Create(); qt.Show(); qt.Focus(); }
private void 员工管理ToolStripMenuItem_Click(object sender, EventArgs e) { if (!FilterClass.yggl()) { MessageBox.Show("无权操作!"); return; } ygglForm yggl = ygglForm.Create(); yggl.Show(); yggl.Focus(); }
private void 分类服务ToolStripMenuItem_Click(object sender, EventArgs e) { if (!FilterClass.flgl()) { MessageBox.Show("无权操作!"); return; } hyflglfwForm hyflgl = hyflglfwForm.Create(); hyflgl.Show(); hyflgl.Focus(); }
private bool CheckDefaultLoadFilterAtt() { if (FilterClass == null) { return(false); } foreach (var att in FilterClass.GetCustomAttributes(typeof(OrmDefaultIsFilteredAttribute), true)) { return((att as OrmDefaultIsFilteredAttribute).DefaultIsFiltered); } return(false); }
private void 基本参数ToolStripMenuItem_Click(object sender, EventArgs e) { if (!FilterClass.jbcs()) { MessageBox.Show("无权操作!"); return; } jbcsForm jbcs = jbcsForm.Create(); jbcs.Show(); jbcs.Focus(); }
private void toolStripButton3_Click(object sender, EventArgs e) { if (!FilterClass.hygl()) { MessageBox.Show("无权操作!"); return; } hyglform huiyuan = hyglform.CreateForm(); huiyuan.MdiParent = this; huiyuan.Parent = panel3; huiyuan.WindowState = FormWindowState.Maximized; huiyuan.Show(); }
private void toolStripButton4_Click(object sender, EventArgs e) { if (!FilterClass.jcsj()) { MessageBox.Show("无权操作!"); return; } jcform jicun = jcform.CreateForm(); jicun.MdiParent = this; jicun.Parent = panel3; jicun.WindowState = FormWindowState.Maximized; jicun.Show(); }
private void toolStripButton8_Click(object sender, EventArgs e) { if (!FilterClass.tjbb()) { MessageBox.Show("无权操作!"); return; } tjfrom tongjibaobiao = tjfrom.CreateForm(); tongjibaobiao.MdiParent = this; tongjibaobiao.Parent = panel3; tongjibaobiao.WindowState = FormWindowState.Maximized; tongjibaobiao.Show(); }
private void toolStripButton7_Click(object sender, EventArgs e) { if (!FilterClass.dxgl()) { MessageBox.Show("无权操作!"); return; } dxform duanxinguanli = dxform.CreateForm(); duanxinguanli.MdiParent = this; duanxinguanli.Parent = panel3; duanxinguanli.WindowState = FormWindowState.Maximized; duanxinguanli.Show(); }
private void toolStripButton6_Click(object sender, EventArgs e) { if (!FilterClass.spgl()) { MessageBox.Show("无权操作!"); return; } spform shangpinguanli = spform.CreateForm(); shangpinguanli.MdiParent = this; shangpinguanli.Parent = panel3; shangpinguanli.WindowState = FormWindowState.Maximized; shangpinguanli.Show(); }
private void toolStripButton1_Click(object sender, EventArgs e) { if (!FilterClass.shgl()) { MessageBox.Show("无权操作!"); return; } shglform shouhuo = shglform.CreateForm(); shouhuo.MdiParent = this; shouhuo.Parent = panel3; shouhuo.WindowState = FormWindowState.Maximized; //shouhuo.FormBorderStyle = FormBorderStyle.FixedToolWindow; shouhuo.Show(); }
private void toolStripButton12_Click(object sender, EventArgs e) { if (!FilterClass.dmjs()) { MessageBox.Show("无权操作!"); return; } DMJSFrom yggl = DMJSFrom.CreateForm(); yggl.MdiParent = this; yggl.Parent = panel3; yggl.WindowState = FormWindowState.Maximized; yggl.Show(); yggl.Focus(); }
} //Constructor private void btnZoek_Click(object sender, EventArgs e) //All the Search functions { FilterClass FC = new FilterClass(); //All 3 if (tbName.Text != "" && tbWoord.Text != "" && cbCat.Text != "") { Filerlst = FC.GetAll(tbName.Text, tbWoord.Text, cbCat.Text); this.Close(); } //Just Name else if (tbName.Text != "" && tbWoord.Text == "" && cbCat.Text == "") { Filerlst = FC.GetName(tbName.Text); this.Close(); } //Just Word else if (tbName.Text == "" && tbWoord.Text != "" && cbCat.Text == "") { Filerlst = FC.GetWord(tbWoord.Text); this.Close(); } //Just Category else if (tbName.Text == "" && tbWoord.Text == "" && cbCat.Text != "") { Filerlst = FC.GetCategory(cbCat.Text); this.Close(); } //Name and Word else if (tbName.Text != "" && tbWoord.Text != "" && cbCat.Text == "") { Filerlst = FC.GetNameWord(tbName.Text, tbWoord.Text); this.Close(); } //Name and Category else if (tbName.Text != "" && tbWoord.Text == "" && cbCat.Text != "") { Filerlst = FC.GetNameCategory(tbName.Text, cbCat.Text); this.Close(); } //Word and Category else if (tbName.Text == "" && tbWoord.Text != "" && cbCat.Text != "") { Filerlst = FC.GetWordCategory(tbWoord.Text, cbCat.Text); this.Close(); } }
/// <summary> /// Checks if all Filter in a FilterClass are valid /// </summary> /// <param name="fC"></param> /// <returns></returns> private bool FilterValidation(FilterClass fC) { if (fC.IsValidValue == false) { return(false); } foreach (FilterClass subfC in fC.SubConditions) { if (FilterValidation(subfC) == false) { return(false); } } return(true); }
private async Task GetGalleryImagesAsync(string query) { var endpoint = new GalleryEndpoint(currentUser); IEnumerable <IGalleryItem> images = await endpoint.SearchGalleryAsync(query); if (this.images != null) { this.images.Clear(); } this.images = FilterClass <IGalleryItem> .convertList(null, images.ToList()); _adapter = new LvImgBinder(this, Resource.Layout.listview_model, this.images, currentUser); RunOnUiThread(() => { _lv.Adapter = _adapter; _lv.ItemClick += lv_ItemClick; }); }
public static string UpdateItemFromCart(FilterClass fc) { DTO.GioHang gh; gh = HttpContext.Current.Session["uid"] != null ? GioHangBus.GetAll().FirstOrDefault(m => m.MaSp == fc.UpdateId && m.MaKh == int.Parse(HttpContext.Current.Session["uid"].ToString())) : GioHangBus.GetAll().FirstOrDefault(m => m.MaSp == fc.UpdateId && m.DiaChiIp == Cart.IpAddress); if (gh != null) { gh.SoLuong = fc.Quantity; GioHangBus.Update(gh); } return(@"<div class='alert alert-danger'> <a href = '#' class='close' data-dismiss='alert' aria-label='close'>×</a> <b>Sản phẩm đã được sửa</b> </div>"); }
private async Task GetImagesAsync(int delay, string query) { await Task.Delay(delay); var endpoint = new AccountEndpoint(currentUser); IEnumerable <IImage> images = await endpoint.GetImagesAsync(); if (this.images != null) { this.images.Clear(); } this.images = FilterClass <IImage> .convertList(query, images.ToList()); _adapter = new LvImgBinder(this, Resource.Layout.listview_model, this.images, currentUser); RunOnUiThread(() => { _lv.Adapter = _adapter; _lv.ItemClick += lv_ItemClick; }); }
//窗体加载 private void glyszForm_Load(object sender, EventArgs e) { //string name = ""; groupBox2.Text = "管理员列表-有" + dataGridView1.RowCount + "条"; if (FilterClass.isadmin()) { List <string> str = dpbll.selectDPName(); foreach (var iteam in str) { comboBox1.Items.Add(iteam); } comboBox1.SelectedIndex = 0; } else { comboBox1.Text = FilterClass.DianPu1.UserName; comboBox1.Enabled = false; } databind(comboBox1.Text.Trim()); }
public static string GetProducts(FilterClass fc) { var sb = new StringBuilder(); _spList = Sp_BUS.GetAll(); if (!string.IsNullOrEmpty(fc.CatId.ToString())) { _spList = _spList.Where(sp => sp.MaLoaiSp == fc.CatId).ToList(); } if (!string.IsNullOrEmpty(fc.BrandId.ToString())) { _spList = _spList.Where(sp => sp.MaNcc == fc.BrandId).ToList(); } if (!string.IsNullOrEmpty(fc.SearchKey)) { _spList = _spList.Where(sp => sp.TenSp.Contains(fc.SearchKey)).ToList(); } var spListPaged = _spList.Skip(ProductOnPage * ((fc.PageId ?? 1) - 1)).Take(ProductOnPage).ToList(); foreach (var sp in spListPaged) { sb.Append($@" <div class='col-md-4'> <div class='panel panel-info'> <div class='panel-heading'>{sp.TenSp}</div> <div class='panel-body'> <img src='/product_images/{sp.HinhSp}' style='width:160px; height:250px;'/> </div> <div class='panel-heading'>{sp.DonGia} <button pid='{sp.MaSp}' style='float:right;' id='product' class='btn btn-danger btn-xs'>Thêm giở hàng</button> </div> </div> </div> "); } return(string.IsNullOrEmpty(sb.ToString()) ? "Không có sản phẩm" : sb.ToString()); }
public static string Login(FilterClass fc) { var email = fc.Email; string password; using (var md5Hash = MD5.Create()) { password = SecurityHelper.GetMd5Hash(md5Hash, fc.Password); } var kh = KhBus.GetAll().FirstOrDefault(m => m.Email == email && m.MatKhau == password); if (kh != null) { HttpContext.Current.Session["uid"] = kh.MaKh; HttpContext.Current.Session["name"] = kh.TenKh; return("Thành công"); } return("<span style='color:red;'>Đăng ký nếu chưa có tài khoản!</span>"); }
// сформировать строку фильтра для датавью private static string GenerateFilterString(FilterClass filter) { var filterStr = ""; if (!string.IsNullOrEmpty(filter.MaskName)) { filter.MaskName = Functions.ReplaceChars(filter.MaskName, "'[]", "?"); filterStr += string.Format(" and name like '%{0}%'", filter.MaskName); } if (!string.IsNullOrEmpty(filter.MaskCode)) { filter.MaskCode = Functions.ReplaceChars(filter.MaskCode, "'[]", "?"); filterStr += string.Format(" and code like '%{0}%'", filter.MaskCode); } if (!string.IsNullOrEmpty(filter.SizeCondition)) { var min = Math.Min(filter.SizeA, filter.SizeB); var max = Math.Max(filter.SizeA, filter.SizeB); filterStr += string.Format(" and size_a {0} {1} and size_b {0} {2}", filter.SizeCondition, min, max); } if (filter.Type != "quest") { if (filter.LevelMin >= 0) filterStr += string.Format(" and level >= {0}", filter.LevelMin); if (filter.LevelMax >= 0) filterStr += string.Format(" and level <= {0}", filter.LevelMax); } else { if (filter.LevelMin >= 0) filterStr += string.Format(" and levelEnd >= {0}", filter.LevelMin); if (filter.LevelMax >= 0) filterStr += string.Format(" and levelBegin <= {0}", filter.LevelMax); } if (filterStr != "") filterStr = filterStr.Substring(5); if (filter.SquadFilterList.Count > 0 || filter.QuestFilterList.Count > 0) { var add = ""; for (var k = 0; k < filter.SquadFilterList.Count; k++) { if (filter.SquadFilterList[k]) { switch (k) { case 0: // NPC add += " or level = 0"; break; case 1: // Basic squads add += " or basic > 0"; break; case 2: // Upgradable add += " or upgrade > 0"; break; case 3: // Rank squads add += " or rank > 0"; break; case 4: // Guild squads add += " or guild > 0"; break; } } } for (var k = 0; k < filter.QuestFilterList.Count; k++) { if (filter.QuestFilterList[k]) { switch (k) { case 0: // дейлики add += " or daily = 1"; break; } } } if (add != "") { add = add.Substring(4); filterStr += string.Format(" and ({0})", add); } } return filterStr; }
// Сброс значений фильтра private void btnFilterReset_Click(object sender, EventArgs e) { FilterClass filter; int page; if (GetCurrentFilter(out filter, out page)) { filter = new FilterClass(""); switch (page) { case 1: filter = new FilterClass("building"); if (filter.LevelMin <= 0) filter.LevelMin = 1; txtbxFilterBuildingName.Text = filter.MaskName; txtbxFilterBuildingCode.Text = filter.MaskCode; cmbbxFilterBuildingSizeMode.Text = filter.SizeCondition; numFilterBuildingSizeA.Value = numFilterBuildingSizeA.Minimum; numFilterBuildingSizeB.Value = numFilterBuildingSizeB.Minimum; numFilterBuildingLevelMin.Value = filter.LevelMin; numFilterBuildingLevelMax.Value = filter.LevelMax; break; case 2: filter = new FilterClass("squad"); txtbxFilterSquadName.Text = filter.MaskName; txtbxFilterSquadCode.Text = filter.MaskCode; numFilterSquadLevelMin.Value = filter.LevelMin; numFilterSquadLevelMax.Value = filter.LevelMax; break; case 3: filter = new FilterClass("quest"); txtbxFilterQuestName.Text = filter.MaskName; txtbxFilterQuestCode.Text = filter.MaskCode; numFilterQuestLevelMin.Value = filter.LevelMin; numFilterQuestLevelMax.Value = filter.LevelMax; break; } SetFilterApply(true, filter, page); } }
private void SetFilterApply(bool forceUpdate, FilterClass filter, int page) { DataView dataView = null; bool ret = filter != null || GetCurrentFilter(out filter, out page); if (ret && page > 0) { switch (page) { case 1: dataView = _dtBuildingsListView; break; case 2: dataView = _dtSquadsListView; break; case 3: dataView = _dtQuestsListView; break; } if (filter != null && dataView != null && filter.Enabled && (filter.AutoUpdate || forceUpdate)) dataView.RowFilter = GenerateFilterString(filter); } }
// получить класс текущего фильтра private bool GetCurrentFilter(out FilterClass filter, out int page) { filter = new FilterClass(""); page = tabsMain.SelectedIndex; if (page < 1 || page > tabsMain.TabCount - 1) return false; switch (page) { case 1: filter = _filterBuilding; break; case 2: filter = _filterSquad; break; case 3: filter = _filterQuest; break; } return true; }