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;
}
