public void LoadEditContent()
{
ComboBoxUnitQty.ItemsSource = CatalogTable.SelectFromCatalogTable();
ComboBoxUnitQty.DisplayMemberPath = "CatalogValue";
ComboBoxUnitQty.SelectedValuePath = "CatalogId";
var product = ProductTable.SelectSingleProduct(Pid);
TxtTitle.Text = product.ProductName;
TxtPrice.Text = product.ProductUnitPrice.ToString();
TxtQty.Text = product.ProductCount.ToString();
TxtDescription.Text = string.Empty;
TxtDescription.AppendText(product.ProductDescription);
var ppl = product.ProductPopularSupport;
if (ppl)
{
YesToPpl.IsChecked = true;
}
else
{
NoToPpl.IsChecked = true;
}
if (product.Catalog != null)
{
ComboBoxUnitQty.SelectedValue = product.Catalog.CatalogId;
}
}
private void BtnAddCatalogItem_Click(object sender, RoutedEventArgs e)
{
var catalogItemsWindow = new UnitQtyItmesWindow();
catalogItemsWindow.ShowDialog();
_catalogItems = CatalogTable.SelectFromCatalogTable();
foreach (var panleItem in PanelProductRecord.Children)
{
var prevSelectedItem = -1;
var AddBoxItem = panleItem as AddBoxUC;
if (AddBoxItem.ComboBoxUnitQty.SelectedValue != null)
{
prevSelectedItem = int.Parse(AddBoxItem.ComboBoxUnitQty.SelectedValue.ToString());
}
AddBoxItem.ComboBoxUnitQty.ItemsSource = null;
AddBoxItem.ComboBoxUnitQty.ItemsSource = _catalogItems;
AddBoxItem.ComboBoxUnitQty.DisplayMemberPath = "CatalogValue";
AddBoxItem.ComboBoxUnitQty.SelectedValuePath = "CatalogId";
foreach (var item in _catalogItems)
{
if (item.CatalogId != prevSelectedItem)
{
continue;
}
AddBoxItem.ComboBoxUnitQty.SelectedValue = prevSelectedItem;
break;
}
}
}
private void ButtonRemove_Click(object sender, RoutedEventArgs e)
{
var fe = sender as FrameworkElement;
if (fe != null && CatalogTable.DeleteFromCatalogTabel(int.Parse(fe.Uid)))
{
LoadContent();
Changed = true;
}
else
{
Close();
}
}
private void ButtonAdd_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(_btnAddToCatalog.TxtMain.Text))
{
return;
}
if (CatalogTable.InsertIntoCatalogTable(_btnAddToCatalog.TxtMain.Text))
{
LoadContent();
Changed = true;
}
else
{
Close();
}
}
private void BtnAddCatalogItem_Click(object sender, RoutedEventArgs e)
{
var catalogItemsWindow = new UnitQtyItmesWindow();
catalogItemsWindow.ShowDialog();
var catalogItems = CatalogTable.SelectFromCatalogTable();
foreach (var panleItem in PanelProductRecord.Children)
{
var searchBoxItem = panleItem as SearchBoxUC;
searchBoxItem.ComboBoxUnitQty.ItemsSource = null;
searchBoxItem.ComboBoxUnitQty.ItemsSource = catalogItems;
searchBoxItem.ComboBoxUnitQty.DisplayMemberPath = "CatalogValue";
searchBoxItem.ComboBoxUnitQty.SelectedValuePath = "CatalogId";
}
}
private void TxtUserQty_LostFocus(object sender, RoutedEventArgs e)
{
var fe = sender as FrameworkElement;
foreach (var child in PanelProductRecord.Children)
{
var srchBoxItem = child as SearchBoxUC;
if (srchBoxItem != null && (!string.IsNullOrWhiteSpace(srchBoxItem.TxtUserQty.Text) && srchBoxItem.TxtUserQty.Uid == fe.Uid))
{
if (srchBoxItem.SearchBox.SelectedItem != null)
{
srchBoxItem.ComboBoxUnitQty.Visibility = Visibility.Hidden;
srchBoxItem.BtnAddCatalogItem.Visibility = Visibility.Hidden;
var produc = srchBoxItem.SearchBox.SelectedItem as Product;
var count = produc.ProductCount - double.Parse(srchBoxItem.TxtUserQty.Text);
if (count >= 0)
{
srchBoxItem.LblStatus.Content = "موجود";
srchBoxItem.LblStatus.Foreground = Brushes.Green;
}
else
{
srchBoxItem.LblStatus.Content = "نیاز به خرید";
srchBoxItem.LblStatus.Foreground = Brushes.Red;
}
return;
}
if (string.IsNullOrWhiteSpace(srchBoxItem.SearchBox.SearchText))
{
continue;
}
srchBoxItem.ComboBoxUnitQty.ItemsSource = null;
srchBoxItem.ComboBoxUnitQty.ItemsSource = CatalogTable.SelectFromCatalogTable();
srchBoxItem.ComboBoxUnitQty.DisplayMemberPath = "CatalogValue";
srchBoxItem.ComboBoxUnitQty.SelectedValuePath = "CatalogId";
srchBoxItem.ComboBoxUnitQty.Visibility = Visibility.Visible;
srchBoxItem.BtnAddCatalogItem.Visibility = Visibility.Visible;
srchBoxItem.BtnAddCatalogItem.Click += BtnAddCatalogItem_Click;
srchBoxItem.LblStatus.Content = "نیاز به خرید";
srchBoxItem.LblStatus.Foreground = Brushes.Red;
return;
}
}
}
public void LoadContent()
{
_catalogItems = CatalogTable.SelectFromCatalogTable();
PanelCatalogItem.Children.Clear();
_btnAddToCatalog.TxtMain.Text = "";
foreach (var item in _catalogItems)
{
var btnExistingItems = new CatalogItemUC
{
LabelMain = { Content = item.CatalogValue },
ButtonMain = { Uid = item.CatalogId.ToString() },
Margin = new Thickness(0, 0, 0, 10),
};
btnExistingItems.ButtonMain.Click += ButtonRemove_Click;
PanelCatalogItem.Children.Add(btnExistingItems);
}
_btnAddToCatalog.ButtonAdd.Click += ButtonAdd_Click;
PanelCatalogItem.Children.Add(_btnAddToCatalog);
}
private void RadButton_Click(object sender, RoutedEventArgs e)
{
var catalogItemsWindow = new UnitQtyItmesWindow {
Changed = false
};
catalogItemsWindow.ShowDialog();
if (catalogItemsWindow.Changed)
{
ComboBoxUnitQty.ItemsSource = CatalogTable.SelectFromCatalogTable();
ComboBoxUnitQty.DisplayMemberPath = "CatalogValue";
ComboBoxUnitQty.SelectedValuePath = "CatalogId";
ComboBoxUnitQty.SelectedIndex = ComboBoxUnitQty.Items.Count - 1;
}
else
{
var product = ProductTable.SelectSingleProduct(Pid);
if (product.Catalog == null)
{
return;
}
ComboBoxUnitQty.SelectedValue = product.Catalog.CatalogValue;
}
}
private void BtnAccept_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(TxtTitle.Text))
{
var windowRemove = new RemoveWindow
{
WindowTitle = "عنوان را پر کنید",
Caption = "عنوان نمیتواند خالی باشد.",
InformationIcon = true,
OneBtn = true,
Btn2 = "باشه"
};
windowRemove.ShowDialog();
return;
}
if (string.IsNullOrWhiteSpace(TxtQty.Text))
{
var windowRemove = new RemoveWindow
{
WindowTitle = "مقدار را پر کنید",
Caption = "مقدار نمیتواند خالی باشد.",
InformationIcon = true,
OneBtn = true,
Btn2 = "باشه"
};
windowRemove.ShowDialog();
return;
}
if (string.IsNullOrWhiteSpace(ComboBoxUnitQty.Text))
{
var windowRemove = new RemoveWindow
{
WindowTitle = "واحد مقدار را انتخاب کنید",
Caption = "واحد مقدار نمیتواند خالی باشد.",
InformationIcon = true,
OneBtn = true,
Btn2 = "باشه"
};
windowRemove.ShowDialog();
return;
}
if (string.IsNullOrWhiteSpace(TxtPrice.Text) || TxtPrice.IsEnabled == false)
{
TxtPrice.Text = "0";
}
TxtPrice.Text = TxtPrice.Text.Replace(" ", string.Empty);
TxtQty.Text = TxtQty.Text.Replace(" ", string.Empty);
if (ProductTable.UpdateProductTabel(new Product()
{
ProductId = Pid,
ProductName = TxtTitle.Text,
ProductUnitPrice = int.Parse(TxtPrice.Text.Trim()),
ProductCount = float.Parse(TxtQty.Text),
Catalog = CatalogTable.SelectFromCatalogTable().Single(c => c.CatalogId == int.Parse(ComboBoxUnitQty.SelectedValue.ToString())),
ProductPopularSupport = YesToPpl.IsChecked == true,
ProductDescription = TxtDescription.Text
}))
{
Close();
}
}
private void BtnInventoryRequest_Click(object sender, RoutedEventArgs e)
{
var needRequestDocument = false;
if (CheckForSameItem())
{
return;
}
foreach (var panelChild in PanelProductRecord.Children)
{
var searchItem = panelChild as SearchBoxUC;
if (searchItem.LblStatus.Content.ToString() == "نیاز به خرید")
{
needRequestDocument = true;
break;
}
}
if (!needRequestDocument)
{
var windowRemove = new RemoveWindow
{
WindowTitle = "اقلام لیست در انبار موجود است",
Caption = "کسری موجودی برای درخواست خرید نیست.",
InformationIcon = true,
OneBtn = true,
Btn2 = "باشه"
};
windowRemove.ShowDialog();
return;
}
foreach (var panelChild in PanelProductRecord.Children)
{
var searchItem = panelChild as SearchBoxUC;
if (searchItem.BtnNewRecord.Visibility == Visibility.Visible)
{
break;
}
if (string.IsNullOrWhiteSpace(searchItem.SearchBox.SearchText))
{
var windowRemove = new RemoveWindow
{
WindowTitle = "عنوان نمیتواند خالی باشد",
Caption = "مقادیر عنوان را وارد کنید.",
InformationIcon = true,
OneBtn = true,
Btn2 = "باشه"
};
windowRemove.ShowDialog();
return;
}
}
foreach (var panelChild in PanelProductRecord.Children)
{
var searchItem = panelChild as SearchBoxUC;
if (searchItem.BtnNewRecord.Visibility == Visibility.Visible)
{
break;
}
if (string.IsNullOrWhiteSpace(searchItem.TxtUserQty.Text))
{
var windowRemove = new RemoveWindow
{
WindowTitle = "مقدار نمیتواند خالی باشد",
Caption = "مقدار را وارد کنید.",
InformationIcon = true,
OneBtn = true,
Btn2 = "باشه"
};
windowRemove.ShowDialog();
return;
}
}
foreach (var panelChild in PanelProductRecord.Children)
{
var searchItem = panelChild as SearchBoxUC;
if (searchItem.BtnNewRecord.Visibility == Visibility.Visible)
{
break;
}
if (!string.IsNullOrWhiteSpace(searchItem.LblQtyWithUnit.Content.ToString()))
{
continue;
}
if (searchItem.ComboBoxUnitQty.SelectedValue == null)
{
var windowRemove = new RemoveWindow
{
WindowTitle = "مقدار نمیتواند خالی باشد",
Caption = "مقدار را وارد کنید.",
InformationIcon = true,
OneBtn = true,
Btn2 = "باشه"
};
windowRemove.ShowDialog();
return;
}
}
var windowWarning = new RemoveWindow
{
WindowTitle = "ایجاد درخواست خرید",
Caption = "با ایجاد درخواست خرید مقادیر به موجودی افزوده میشوند.\nادامه میدهید؟",
Btn1 = "ادامه",
Btn2 = "انصراف"
};
windowWarning.ShowDialog();
if (windowWarning.Accept)
{
int dataIndex = 0;
int gapItem = 0;
String[][] data = new string[PanelProductRecord.Children.Count][];
foreach (var panelChild in PanelProductRecord.Children)
{
var searchBoxItem = panelChild as SearchBoxUC;
if (searchBoxItem.LblStatus.Content.ToString() == "نیاز به خرید")
{
var qty = searchBoxItem.TxtUserQty.Text.Replace(" ", String.Empty);
var produc = searchBoxItem.SearchBox.SelectedItem as Product;
if (searchBoxItem.SearchBox.SelectedItem != null)
{
qty = " " + produc.Catalog.CatalogValue + ((produc.ProductCount - double.Parse(searchBoxItem.TxtUserQty.Text.Replace(" ", String.Empty))) * -1);
}
else
{
qty = " " + searchBoxItem.ComboBoxUnitQty.Text + qty;
}
data[dataIndex] = new[] { "", searchBoxItem.SearchBox.SearchText, qty, (dataIndex + 1).ToString() };
dataIndex++;
if (searchBoxItem.SearchBox.SelectedItem != null)
{
ProductTable.UpdateProductTabel(new Product()
{
ProductId = produc.ProductId,
ProductName = produc.ProductName,
ProductUnitPrice = produc.ProductUnitPrice,
ProductCount = double.Parse(searchBoxItem.TxtUserQty.Text.Replace(" ", String.Empty)),
ProductPopularSupport = produc.ProductPopularSupport,
ProductDescription = produc.ProductDescription
});
}
else
{
ProductTable.InsertIntoProductTable(new Product()
{
ProductName = searchBoxItem.SearchBox.SearchText,
ProductCount = double.Parse(searchBoxItem.TxtUserQty.Text.Replace(" ", string.Empty)),
Catalog = CatalogTable.SelectFromCatalogTable().Single(c => c.CatalogId == int.Parse(searchBoxItem.ComboBoxUnitQty.SelectedValue.ToString())),
ProductUnitPrice = 0,
ProductData = persianDate,
ProductPopularSupport = false,
ProductDescription = ""
});
}
}
else
{
gapItem++;
}
}
PrintDocuments.RequestDocument(data, gapItem);
ConfirmInventory();
}
}
private void BtnInventoryDocument_Click(object sender, RoutedEventArgs e)
{
bool emptyList = true;
if (CheckForSameItem())
{
return;
}
foreach (var panelChild in PanelProductRecord.Children)
{
var searchItem = panelChild as SearchBoxUC;
if (!string.IsNullOrWhiteSpace(searchItem.LblStatus.Content.ToString()))
{
if (searchItem.LblStatus.Content.ToString() == "نیاز به خرید")
{
var windowRemove = new RemoveWindow
{
WindowTitle = "موجودی انبار را تکمیل کنید",
Caption = $"موجودی \"{searchItem.SearchBox.SearchText}\" کافی نیست.",
InformationIcon = true,
OneBtn = true,
Btn2 = "باشه"
};
windowRemove.ShowDialog();
return;
}
}
}
foreach (var panelChild in PanelProductRecord.Children)
{
var product = panelChild as SearchBoxUC;
if (!string.IsNullOrWhiteSpace(product.LblStatus.Content.ToString()))
{
emptyList = false;
break;
}
}
if (emptyList)
{
var windowRemove = new RemoveWindow
{
WindowTitle = "لیست خالی است",
Caption = "لیست خالی است.\nبرای افزودن به لیست روی جدید کلیک کنید.",
InformationIcon = true,
OneBtn = true,
Btn2 = "باشه"
};
windowRemove.ShowDialog();
return;
}
var windowWarning = new RemoveWindow
{
WindowTitle = "ایجاد حواله",
Caption = "با ایجاد حواله مقادیر از موجودی کم میشوند.\nادامه میدهید؟",
Btn1 = "ادامه",
Btn2 = "انصراف"
};
windowWarning.ShowDialog();
if (windowWarning.Accept)
{
int dataIndex = 0;
int gapItem = 0;
String[][] data = new string[PanelProductRecord.Children.Count][];
foreach (var panelChild in PanelProductRecord.Children)
{
var searchBoxItem = panelChild as SearchBoxUC;
var produc = new Product();
if (!string.IsNullOrWhiteSpace(searchBoxItem.LblStatus.Content.ToString()))
{
if (searchBoxItem.SearchBox.SelectedItem == null)
{
produc = ProductTable.SelectSingleProduct(searchBoxItem.SearchBox.SearchText);
searchBoxItem.LblId = produc.ProductId;
}
else
{
produc = ProductTable.SelectSingleProduct((searchBoxItem.SearchBox.SelectedItem as Product).ProductId);
}
if (string.IsNullOrWhiteSpace(searchBoxItem.LblTotalPrice.Content.ToString()))
{
searchBoxItem.LblTotalPrice.Content = "0";
}
searchBoxItem.LblQty = searchBoxItem.TxtUserQty.Text.Replace(" ", String.Empty);
var totalPrice = (Double.Parse(searchBoxItem.LblQty.ToString()) *
int.Parse(searchBoxItem.LblTotalPrice.Content.ToString()));
data[dataIndex] = new[]
{
$"{totalPrice:#,0}", $"{searchBoxItem.LblTotalPrice.Content:#,0}",
" " + produc.Catalog.CatalogValue + searchBoxItem.TxtUserQty.Text,
searchBoxItem.SearchBox.SearchText, searchBoxItem.LblId.ToString()
};
dataIndex++;
var newQty = (produc.ProductCount -
double.Parse(searchBoxItem.TxtUserQty.Text.Replace(" ", String.Empty)));
if (newQty == 0)
{
ProductTable.DeleteFromProductTable(produc.ProductId);
}
else
{
ProductTable.UpdateProductTabel(new Product()
{
ProductId = produc.ProductId,
ProductName = produc.ProductName,
ProductUnitPrice = produc.ProductUnitPrice,
ProductCount = newQty,
Catalog = CatalogTable.SelectFromCatalogTable().SingleOrDefault(c => c.CatalogId == produc.Catalog.CatalogId),
ProductPopularSupport = produc.ProductPopularSupport,
ProductDescription = produc.ProductDescription
});
}
}
else
{
gapItem++;
}
}
PrintDocuments.AssignmentDocument(data, gapItem, 1);
PanelProductRecord.Children.Clear();
Window_Loaded(null, null);
}
}
/// <summary>
/// 下载目录
/// </summary>
public void DownLoadCatalogUrl()
{
HtmlAgilityPack.HtmlDocument doc = new HtmlAgilityPack.HtmlDocument();
ArrayList arrayList = null;
string pageUrl = mainUrl;
for (int i = 1; i < TotalPage + 1; i++)
{
try
{
if (i == 1)
{
pageUrl = mainUrl;
}
else
{
pageUrl = mainUrl + $"home/{i}";
}
arrayList = hh.GetHtmlData(pageUrl, cookie);
doc.LoadHtml(arrayList[1].ToString());
HtmlNodeCollection aNodes = doc.DocumentNode.SelectNodes("//div[@class='main']/div[@class='pic']/ul/li/span[@class='title']/a");
if (aNodes != null)
{
ArrayList arrList = null;
HtmlAgilityPack.HtmlDocument hdc = null;
string catalogUrl = string.Empty, title = string.Empty;
foreach (var aNode in aNodes)
{
try
{
catalogUrl = aNode.GetAttributeValue("href", "");
title = aNode.InnerText;
if (!string.IsNullOrEmpty(catalogUrl))
{
CatalogTable catalogInfo = new CatalogTable();
catalogInfo.WebSiteUrl = mainUrl;
catalogInfo.CatalogUrl = catalogUrl;
catalogInfo.Describe = title;
arrList = hh.GetHtmlData(catalogUrl, cookie);
hdc = new HtmlAgilityPack.HtmlDocument();
hdc.LoadHtml(arrList[1].ToString());
HtmlNodeCollection pages = hdc.DocumentNode.SelectNodes("//div[@id='page']/a");
int total = int.Parse(pages[pages.Count - 2].InnerText);
catalogInfo.TotalImages = total;
catalogInfo.IsDownLoad = false;
ise.CatalogTables.Add(catalogInfo);
ise.SaveChanges();
}
}
catch (Exception ex)
{
myUtils.WriteLog("保存目录连接出错 " + catalogUrl);
}
}
}
}
catch (Exception e)
{
myUtils.WriteLog("查询目录节点出错 " + e);
}
}
}
