private void LoadItemSuppliers(int itemId) { mItemSuppliersTbl.Clear(); DataTable dtSuppliers = ItemSupplierDAL.GetAllItemSuppliersByItemId(itemId); foreach (DataRow row in dtSuppliers.Rows) { int supplierId = StringUtil.GetSafeInt(row["SupplierId"]); SupplierType supplier = SupplierDAL.GetSupplierById(supplierId); if (supplier == null) { continue; } DataRow rowLoc = mItemSuppliersTbl.NewRow(); rowLoc["SupplierId"] = supplierId; rowLoc["SupplierName"] = supplier.SupplierName; rowLoc["URL"] = StringUtil.GetSafeString(row["SouringURL"]); rowLoc["Price"] = StringUtil.GetSafeDouble(row["Price"]); rowLoc["ShippingFee"] = StringUtil.GetSafeDouble(row["ShippingFee"]); rowLoc["Comment"] = StringUtil.GetSafeString(row["Comment"]); mItemSuppliersTbl.Rows.Add(rowLoc); } this.dgvItemSuppliers.DataSource = mItemSuppliersTbl; }
private void ToolStripMenuItemDelSupplier_Click(object sender, EventArgs e) { if (MessageBox.Show("你确认刪除该供应商么?\r\n删除前,必须删除所有该供应商的采购单。", "确认发货?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No) { return; } // Check if any sourcing notes related to this supplier, if so, disallow delete. // [ZHI_TODO] int rowIdx = this.pagedDgvSupplier.DgvData.CurrentRow.Index; int supplierId = StringUtil.GetSafeInt(this.pagedDgvSupplier.DgvData.Rows[rowIdx].Cells[0].Value.ToString()); SupplierType supplier = SupplierDAL.GetSupplierById(supplierId); if (supplier == null) { return; } SupplierDAL.DeleteOneSupplier(supplierId); MessageBox.Show(String.Format("删除供应商成功!", supplier.SupplierName), "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information); this.pagedDgvSupplier.LoadData(); }
private void LoadExistingSourcingNote() { if (mSourcingNote == null) { return; } SupplierType supplier = SupplierDAL.GetSupplierById(mSourcingNote.SupplierId); if (supplier == null) { return; } mSupplier = supplier; this.textBoxSupplier.Text = supplier.SupplierName; this.textBoxExtraFee.Text = mSourcingNote.ExtraFee.ToString(); this.textBoxShippingFee.Text = mSourcingNote.ShippingFee.ToString(); this.textBoxTotalFee.Text = mSourcingNote.TotalFee.ToString(); this.textBoxComment.Text = mSourcingNote.Comment; this.dateTimePickerDate.Value = mSourcingNote.SourcingDate; String skuListStr = mSourcingNote.ItemSkuList; String numListStr = mSourcingNote.ItemNumList; String priceListStr = mSourcingNote.ItemPriceList; String [] skuArr = skuListStr.Split(new char[] { ',' }); String [] numArr = numListStr.Split(new char[] { ',' }); String[] priceArr = priceListStr.Split(new char[] { ',' }); if (skuArr.Length != numArr.Length || skuArr.Length != priceArr.Length) { return; } for (int ii = 0; ii < skuArr.Length; ++ii) { String sku = skuArr[ii]; InventoryItemType item = ItemDAL.GetItemBySKU(sku); if (item == null) { continue; } DataRow dr = mItemsTable.NewRow(); dr["ItemSKU"] = sku; dr["ItemName"] = item.ItemName; dr["ItemPrice"] = StringUtil.GetSafeDouble(priceArr[ii]); dr["ItemCount"] = StringUtil.GetSafeInt(numArr[ii]); mItemsTable.Rows.Add(dr); } this.dgvItems.DataSource = mItemsTable; }
void DgvData_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { foreach (DataGridViewRow row in pagedDgvSourcingNote.DgvData.Rows) { int supplierId = StringUtil.GetSafeInt(row.Cells[1].Value); SupplierType supplier = SupplierDAL.GetSupplierById(supplierId); if (supplier == null) { continue; } row.Cells[2].Value = supplier.SupplierName; } }
private void ShowSupplierData() { SupplierType supplier = SupplierDAL.GetSupplierById(mSupplierId); if (supplier == null) { MessageBox.Show("无供应商信息", "抱歉", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } this.textBoxSupplierName.Text = supplier.SupplierName; this.textBoxSupplierTel.Text = supplier.SupplierTel; this.textBoxSupplierLink1.Text = supplier.SupplierLink1; this.textBoxSupplierLink2.Text = supplier.SupplierLink2; this.textBoxSupplierLink3.Text = supplier.SupplierLink3; this.textBoxSupplierComment.Text = supplier.Comment; }
private void ToolStripMenuItemEditSupplier_Click(object sender, EventArgs e) { int rowIdx = this.pagedDgvSupplier.DgvData.CurrentRow.Index; int supplierId = StringUtil.GetSafeInt(this.pagedDgvSupplier.DgvData.Rows[rowIdx].Cells[0].Value.ToString()); SupplierType supplier = SupplierDAL.GetSupplierById(supplierId); if (supplier == null) { return; } FrmEditSupplier frmEditSupplier = new FrmEditSupplier(supplierId); frmEditSupplier.ShowDialog(); this.pagedDgvSupplier.LoadData(); }
private void btnFinishSelecting_Click(object sender, EventArgs e) { DataGridViewRow row = this.pagedDgvSupplier.DgvData.CurrentRow; if (row == null) { MessageBox.Show("未选中任何供应商", "抱歉", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int supplierId = StringUtil.GetSafeInt(row.Cells[0].Value); mSelectedSupplier = SupplierDAL.GetSupplierById(supplierId); if (mSelectedSupplier == null) { MessageBox.Show("未选中任何供应商", "抱歉", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } this.Close(); }