private void OpenProductsSelectedDialogForm(DataGridViewCellEventArgs e)
{
DataGridViewRow row = grvProductList.Rows[e.RowIndex];
int productId = int.Parse(row.Cells[Constant.ProductSearch.ProductGridColumnName.PRODUCT_ID].Value.ToString());
JSManagementDataSet.ProductDataTable prod = productTableAdapter.GetDataByProductId(productId);
ProductsSelectedDialogForm proSelectedDialogForm = new ProductsSelectedDialogForm();
Label lbProductCode = proSelectedDialogForm.Controls.Find(Constant.ProductsSelectedDialog.PRODUCT_CODE_LABEL_CONTROL_NAME, true)[0] as Label;
Label lbProductType = proSelectedDialogForm.Controls.Find(Constant.ProductsSelectedDialog.PRODUCT_TYPE_LABEL_CONTROL_NAME, true)[0] as Label;
Label lbProductBrand = proSelectedDialogForm.Controls.Find(Constant.ProductsSelectedDialog.PRODUCT_BRAND_LABEL_CONTROL_NAME, true)[0] as Label;
Label lbProdId = proSelectedDialogForm.Controls.Find(Constant.ProductsSelectedDialog.PROD_ID_LABEL_CONTROL_NAME, true)[0] as Label;
lbProductCode.Text = prod[0].ProductCode;
lbProductType.Text = prod[0].ProductType;
lbProductBrand.Text = prod[0].Brand;
lbProdId.Text = prod[0].ProdId.ToString();
proSelectedDialogForm.isWorkingOnOutputOrder = true;
proSelectedDialogForm.OutputTypeCode = this.OutputTypeCode;
proSelectedDialogForm.StartPosition = FormStartPosition.CenterScreen;
proSelectedDialogForm.ShowDialog();
this.Close();
}
private void ProductsSelectedDialogForm_Load(object sender, EventArgs e)
{
productTableAdapter = new JSManagementDataSetTableAdapters.ProductTableAdapter();
productTableAdapter.Connection = CommonHelper.GetSQLConnection();
int prodId = int.Parse(lbProdId.Text);
JSManagementDataSet.ProductDataTable productData = productTableAdapter.GetProductByProdId(prodId);
((ListBox)this.checkedListBoxSize).DataSource = productData;
((ListBox)this.checkedListBoxSize).DisplayMember = "Size";
((ListBox)this.checkedListBoxSize).ValueMember = "ProductId";
//checkedListBoxSize.Items.Clear();
//for (int i = 0; i < productData.Rows.Count; i++)
//{
// checkedListBoxSize.Items.Add(productData[i].Size);
//}
productTableAdapter.Dispose();
}
private void BindData(DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1 || e.RowIndex == grvProductList.RowCount - 1 || e.RowIndex == 0)
{
return;
}
btDelete.Visible = true;
btAddNew.Visible = true;
DataGridViewRow row = grvProductList.Rows[e.RowIndex];
int productId = int.Parse(row.Cells[Constant.ProductSearch.ProductGridColumnName.PRODUCT_ID].Value.ToString());
int prodId = int.Parse(row.Cells[Constant.ProductSearch.ProductGridColumnName.ProdId].Value.ToString());
if (cboxStoreFind.SelectedValue != null)
{
storeId = int.Parse(cboxStoreFind.SelectedValue.ToString());
}
JSManagementDataSet.ProductDataTable productDataTable = productTableAdapter.GetProductById(productId, storeId);
JSManagementDataSet.ProdDataTable prodDataTable = prodTableAdapter.GetDataById(prodId);
string productCode = prodDataTable[0].ProductCode;
string brand = prodDataTable[0].Brand;
string productType = prodDataTable[0].ProductType;
decimal productCost = productDataTable[0].ProductCost;
decimal price = productDataTable[0].Price;
decimal price2 = productDataTable[0].Price2;
decimal price3 = productDataTable[0].Price3;
decimal price4 = productDataTable[0].Price4;
string size = productDataTable[0].Size;
string imageUrls = productDataTable[0].ImageUrls;
lbProductHeader.Text = string.Format("Sửa mã hàng {0} Hiệu:{1} Size:{2}", productCode, brand, size);
txtProductCode.Text = productCode;
cbBoxProductType.Text = productType;
cbBoxBrand.Text = brand;
lbProductId.Text = productId.ToString();
lbProdId.Text = productDataTable[0].ProdId.ToString();
txtPrice.Text = price.ToString("#,###");
txtPrice2.Text = price2 == 0? "0": price2.ToString("#,###");
txtPrice3.Text = price3 == 0 ? "0" : price3.ToString("#,###");
txtPrice4.Text = price4 == 0 ? "0" : price4.ToString("#,###");
cbBoxSize.Text = size;
txtInputPrice.Text = productCost == 0 ? "0" : productCost.ToString("#,###");
txtNote.Text = prodDataTable[0].Note == null ? string.Empty: prodDataTable[0].Note;
grvProductInOutDetail.DataSource = getProductInOutDetailTableAdapter.GetProductInOutDetailByProductId(productId, storeId);
FormatProductInOutDetailGridview();
panelPicture.Controls.Clear();
if (imageUrls != null)
{
string[] imglinks = imageUrls.Split(',');
if (!imageUrls.Contains(","))
{
imglinks.SetValue(imageUrls, 0);
}
int p = -80;
foreach (var link in imglinks)
{
if (link.Equals(imglinks[0]))
{
p += 80;
WebRequest req = WebRequest.Create(link);
WebResponse res = req.GetResponse();
Stream imgStream = res.GetResponseStream();
Image img1 = Image.FromStream(imgStream);
imgStream.Close();
PictureBox pic = new PictureBox();
pic.Click += pic_Click;
pic.Height = 80;
pic.Width = 80;
pic.Image = img1;
pic.SizeMode = PictureBoxSizeMode.StretchImage;
pic.Location = new Point(p, 0);
panelPicture.Controls.Add(pic);
}
}
}
}
private void btOK_Click(object sender, EventArgs e)
{
productTableAdapter = new JSManagementDataSetTableAdapters.ProductTableAdapter();
productTableAdapter.Connection = CommonHelper.GetSQLConnection();
FormCollection fc = Application.OpenForms;
Form productInputForm = new Form();
Form purchaseReceiptOrderForm = new Form();
foreach (Form f in fc)
{
if (f.Name == "productInputForm")
{
productInputForm = f;
}
if (f.Name == "ProductSearchForm")
{
Application.OpenForms["ProductSearchForm"].Close();
}
if (f.Name == "PurchaseReceiptOrderForm")
{
purchaseReceiptOrderForm = f;
}
}
if (isWorkingOnOutputOrder)
{
DataGridView grvProducts = purchaseReceiptOrderForm.Controls.Find("grvProducts", true)[0] as DataGridView;
int currentIndex = grvProducts.CurrentCell.RowIndex;
for (int i = 0; i < checkedListBoxSize.CheckedItems.Count; i++)
{
DataRowView castedItem = checkedListBoxSize.CheckedItems[i] as DataRowView;
DataGridViewRow row;
object productId = castedItem["ProductId"];
JSManagementDataSet.ProductDataTable prodData = productTableAdapter.GetDataByProductId(int.Parse(productId.ToString()));
if (i != 0)
{
row = (DataGridViewRow)grvProducts.Rows[0].Clone();
grvProducts.NotifyCurrentCellDirty(true);
grvProducts.Rows.Insert(currentIndex + i, row);
}
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.PRODUCT_CODE].Value = prodData[0].ProductCode;
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.PRODUCT_TYPE].Value = prodData[0].ProductType;
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.PRODUCT_TYPE].ReadOnly = true;
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.BRAND].Value = prodData[0].Brand;
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.BRAND].ReadOnly = true;
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.SIZE].Value = prodData[0].Size;
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.SIZE].ReadOnly = true;
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.QUANTITY].Value = Setting.GetIntergerSetting("ProductOutputQuantity") == 0 ? 1 : Setting.GetIntergerSetting("ProductInputQuantity");
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.PRICE].Value = prodData[0].Price;
if (this.OutputTypeCode == Constant.OutputType.XTH)
{
if (LoginInfor.IsAdmin || Setting.GetBoolSetting(Constant.Setting.ALLOW_USER_VIEW_ALL_COST))
{
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.SOLD_PRICE].Value = prodData[0].ProductCost;
}
else
{
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.SOLD_PRICE].Value = 0;
}
}
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.PRODUCT_ID].Value = productId;
grvProducts.Rows[currentIndex + i].Cells[Constant.ProductOutputColumnName.PRODUCT_ID].ReadOnly = true;
}
}
if (isWorkingOnInputOrder)
{
DataGridView grvProducts = productInputForm.Controls.Find("grvProducts", true)[0] as DataGridView;
int currentIndex = grvProducts.CurrentCell.RowIndex;
for (int i = 0; i < checkedListBoxSize.CheckedItems.Count; i++)
{
DataRowView castedItem = checkedListBoxSize.CheckedItems[i] as DataRowView;
decimal cost = 0;
int quantity = 1;
if (i == 0)
{
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.PRODUCT_CODE].Value = lbProductCode.Text;
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.PRODUCT_TYPE].Value = lbProductType.Text;
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.PRODUCT_TYPE].ReadOnly = true;
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.BRAND].Value = lbBrand.Text;
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.BRAND].ReadOnly = true;
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.SIZE].Value = castedItem["Size"];
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.SIZE].ReadOnly = true;
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.QUANTITY].Value = Setting.GetIntergerSetting("ProductInputQuantity") == 0 ? 1 : Setting.GetIntergerSetting("ProductInputQuantity");
quantity = (int)grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.QUANTITY].Value;
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.PRODUCT_ID].Value = castedItem["ProductId"];
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.PRODUCT_ID].ReadOnly = true;
if (Setting.GetBoolSetting(Constant.Setting.ALLOW_USER_VIEW_ALL_COST) || LoginInfor.IsAdmin)
{
cost = productTableAdapter.GetDataByProductId(int.Parse(castedItem["ProductId"].ToString()))[0].ProductCost;
}
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.COST].Value = cost;
grvProducts.Rows[currentIndex].Cells[Constant.ProductInputColumnName.AMOUNT].Value = quantity * cost;
}
else
{
DataGridViewRow row = (DataGridViewRow)grvProducts.Rows[0].Clone();
grvProducts.NotifyCurrentCellDirty(true);
grvProducts.Rows.Insert(currentIndex + i, row);
row.Cells[Constant.ProductInputColumnName.PRODUCT_CODE].Value = lbProductCode.Text;
row.Cells[Constant.ProductInputColumnName.PRODUCT_TYPE].Value = lbProductType.Text;
row.Cells[Constant.ProductInputColumnName.PRODUCT_TYPE].ReadOnly = true;
row.Cells[Constant.ProductInputColumnName.BRAND].Value = lbBrand.Text;
row.Cells[Constant.ProductInputColumnName.BRAND].ReadOnly = true;
row.Cells[Constant.ProductInputColumnName.SIZE].Value = castedItem["Size"];
row.Cells[Constant.ProductInputColumnName.SIZE].ReadOnly = true;
row.Cells[Constant.ProductInputColumnName.QUANTITY].Value = Setting.GetIntergerSetting("ProductInputQuantity") == 0 ? 1 : Setting.GetIntergerSetting("ProductInputQuantity");
row.Cells[Constant.ProductInputColumnName.PRODUCT_ID].Value = castedItem["ProductId"];
row.Cells[Constant.ProductInputColumnName.PRODUCT_ID].ReadOnly = true;
if (Setting.GetBoolSetting(Constant.Setting.ALLOW_USER_VIEW_ALL_COST) || LoginInfor.IsAdmin)
{
cost = productTableAdapter.GetDataByProductId(int.Parse(castedItem["ProductId"].ToString()))[0].ProductCost;
}
row.Cells[Constant.ProductInputColumnName.COST].Value = cost;
row.Cells[Constant.ProductInputColumnName.AMOUNT].Value = quantity * cost;
}
}
}
this.Close();
}
