// Load all message templates. private void LoadAllMessageTemplates() { DataTable dtTemplates = MessageTemplateDAL.GetAllMessageTemplates(); foreach (DataRow dr in dtTemplates.Rows) { int templateId = StringUtil.GetSafeInt(dr["TemplateId"]); int templateCategoryId = StringUtil.GetSafeInt(dr["TemplateCategoryId"]); String templateName = StringUtil.GetSafeString(dr["TemplateName"]); String templateContent = StringUtil.GetSafeString(dr["TemplateContent"]); MessageTemplateType templateType = new MessageTemplateType(); templateType.TemplateId = templateId; templateType.TemplateName = templateName; templateType.TemplateCategoryId = templateCategoryId; templateType.TemplateContent = templateContent; TreeNode newNode = new TreeNode(); newNode.Tag = templateType; newNode.Text = templateName; newNode.Name = templateId.ToString(); // Find the category node. TreeNode[] categoryNodes = treeViewMessageTemplate.Nodes.Find(templateCategoryId.ToString(), false); if (categoryNodes.Length == 1) { categoryNodes[0].Nodes.Add(newNode); categoryNodes[0].ExpandAll(); } } }
private void buttonDelSupplier_Click(object sender, EventArgs e) { DataGridViewCell cell = this.dgvItemSuppliers.CurrentCell; if (cell == null) { return; } DataGridViewRow dgvRow = cell.OwningRow; int supplierId = StringUtil.GetSafeInt(dgvRow.Cells[SupplierIdIndex].Value); DataRow row = null; int rowCount = mItemSuppliersTbl.Rows.Count; for (int ii = 0; ii < rowCount; ++ii) { DataRow rowLoc = mItemSuppliersTbl.Rows[ii]; if (StringUtil.GetSafeInt(rowLoc["SupplierId"]) == supplierId) { row = rowLoc; } } if (row != null) { mItemSuppliersTbl.Rows.Remove(row); } buttonSaveItemSupplier_Click(sender, e); MessageBox.Show("删除供应商信息成功", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information); }
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 ToolStripMenuItemEditNote_Click(object sender, EventArgs e) { DataGridViewSelectedRowCollection rows = this.pagedDgvSourcingNote.DgvData.SelectedRows; if (rows == null || rows.Count != 1) { return; } DataGridViewRow row = rows[0]; if (row == null) { return; } int noteId = StringUtil.GetSafeInt(row.Cells[0].Value); SourcingNoteType note = SourcingNoteDAL.GetSourcingNoteById(noteId); if (note == null) { return; } FrmEditSourcingNote frm = new FrmEditSourcingNote(note); frm.StartPosition = FormStartPosition.CenterParent; frm.ShowDialog(); this.pagedDgvSourcingNote.LoadData(); }
public static InventoryItemType GetItemBySKU(string SKU) { DataTable dt = GetItemTableBySKU(SKU); if (dt.Rows.Count == 0) { return(null); } DataRow dr = dt.Rows[0]; InventoryItemType item = new InventoryItemType(); item.ItemId = StringUtil.GetSafeInt(dr["ItemId"]); item.CategoryId = Int32.Parse(dr["CategoryId"].ToString()); item.ItemName = dr["ItemName"].ToString(); item.ItemSKU = SKU; item.ItemImagePath = StringUtil.GetSafeString(dr["ItemImagePath"]); item.ItemStockShresholdNum = Int32.Parse(dr["ItemStockShresholdNum"].ToString()); item.ItemStockNum = Int32.Parse(dr["ItemStockNum"].ToString()); item.ItemSourcingInfo = dr["ItemSourcingInfo"].ToString(); item.ItemSourcingURL = StringUtil.GetSafeString(dr["ItemSourcingURL"]); item.ItemCost = Double.Parse(dr["ItemCost"].ToString()); item.ItemWeight = Double.Parse(dr["ItemWeight"].ToString()); item.ItemCustomName = dr["ItemCustomName"].ToString(); item.ItemCustomWeight = Double.Parse(dr["ItemCustomWeight"].ToString()); item.ItemCustomCost = Double.Parse(dr["ItemCustomCost"].ToString()); item.ItemAddDateTime = DateTime.Parse(dr["ItemAddDateTime"].ToString()); item.IsGroupItem = Boolean.Parse(dr["IsGroupItem"].ToString()); item.SubItemSKUs = dr["SubItemSKUs"].ToString(); item.ItemNote = StringUtil.GetSafeString(dr["ItemNote"]); return(item); }
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 LoadAllItems() { DataTable dtItems = ItemDAL.GetAllItems(); if (dtItems.Rows.Count == 0) { return; } foreach (DataRow dr in dtItems.Rows) { int itemId = StringUtil.GetSafeInt(dr["ItemId"]); int itemCatId = StringUtil.GetSafeInt(dr["CategoryId"]); string itemName = StringUtil.GetSafeString(dr["ItemName"]); string itemSKU = StringUtil.GetSafeString(dr["ItemSKU"]); ItemCompactInfo itemInfo = new ItemCompactInfo(itemId, itemCatId, itemName, itemSKU); TreeNode itemNode = new TreeNode(); itemNode.Text = string.Format("[{0}] {1}", itemSKU, itemName); itemNode.Tag = itemInfo; itemNode.Name = itemSKU; TreeNode[] nodes = this.treeViewCategories.Nodes.Find(itemCatId.ToString(), true); if (nodes.Length == 1) { nodes[0].Nodes.Add(itemNode); } } }
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; }
private void dgvItemSuppliers_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { DataGridViewRow row = this.dgvItemSuppliers.Rows[e.RowIndex]; if (StringUtil.GetSafeInt(row.Cells[SupplierIdIndex].Value) <= 0) { return; } this.buttonDelSupplier.Enabled = true; }
private void LoadAllCategories() { DataTable dtCategories = ItemCategoryDAL.GetAllCategories(); if (dtCategories.Rows.Count == 0) { return; } this.treeViewAllCategories.Nodes.Clear(); foreach (DataRow dr in dtCategories.Rows) { int catId = StringUtil.GetSafeInt(dr["CategoryId"]); int parentCatId = StringUtil.GetSafeInt(dr["ParentCategoryId"]); string catName = StringUtil.GetSafeString(dr["CategoryName"]); string catSkuPrefix = StringUtil.GetSafeString(dr["CategorySkuPrefix"]); ItemCategoryType catType = new ItemCategoryType(); catType.CategoryId = catId; catType.ParentCategoryId = parentCatId; catType.CategoryName = catName; catType.CategorySkuPrefix = catSkuPrefix; TreeNode newNode = new TreeNode(); newNode.Tag = catType; newNode.Text = catName; newNode.Name = catId.ToString(); if (parentCatId == -1) { this.treeViewAllCategories.Nodes.Add(newNode); } else { TreeNode[] parentNodes = this.treeViewAllCategories.Nodes.Find(parentCatId.ToString(), true); if (parentNodes.Length == 1) { parentNodes[0].Nodes.Add(newNode); } } int catSkuPrefixVal = -1; if (Int32.TryParse(catSkuPrefix, out catSkuPrefixVal) && catSkuPrefixVal > maxSkuPrefix) { maxSkuPrefix = catSkuPrefixVal; } } this.treeViewAllCategories.ExpandAll(); return; }
private static ItemStockInNoteType GetItemStockInNoteFromDataRow(DataRow dr) { ItemStockInNoteType note = new ItemStockInNoteType(); note.NoteId = StringUtil.GetSafeInt(dr["NoteId"]); note.ItemSKU = StringUtil.GetSafeString(dr["ItemSKU"]); note.ItemTitle = StringUtil.GetSafeString(dr["ItemTitle"]); note.SourcingNoteId = StringUtil.GetSafeString(dr["SourcingNoteId"]); note.StockInNum = StringUtil.GetSafeInt(dr["StockInNum"]); note.StockInDate = StringUtil.GetSafeDateTime(dr["StockInDate"]); note.Comment = StringUtil.GetSafeString(dr["Comment"]); return(note); }
private static DeliveryNoteType GetDeliveryNoteFromDataRow(DataRow dr) { DeliveryNoteType note = new DeliveryNoteType(); note.DeliveryNoteId = StringUtil.GetSafeInt(dr["DeliveryNoteId"]); note.DeliveryDate = StringUtil.GetSafeDateTime(dr["DeliveryDate"]); note.DeliveryOrderIds = StringUtil.GetSafeString(dr["DeliveryOrderIds"]); note.DeliveryUser = StringUtil.GetSafeString(dr["DeliveryUser"]); note.DeliveryFee = StringUtil.GetSafeDouble(dr["DeliveryFee"]); note.DeliveryExtraFee = StringUtil.GetSafeDouble(dr["DeliveryExtraFee"]); note.DeliveryComment = StringUtil.GetSafeString(dr["DeliveryComment"]); return(note); }
private static SupplierType GetSupplierFromDataRow(DataRow dr) { SupplierType supplier = new SupplierType(); supplier.SupplierID = StringUtil.GetSafeInt(dr["SupplierID"]); supplier.SupplierName = StringUtil.GetSafeString(dr["SupplierName"]); supplier.SupplierTel = StringUtil.GetSafeString(dr["SupplierTel"]); supplier.SupplierLink1 = StringUtil.GetSafeString(dr["SupplierLink1"]); supplier.SupplierLink2 = StringUtil.GetSafeString(dr["SupplierLink2"]); supplier.SupplierLink3 = StringUtil.GetSafeString(dr["SupplierLink3"]); supplier.Comment = StringUtil.GetSafeString(dr["Comment"]); return(supplier); }
// Returns null if no record corresponds to itemID; public static EbayActiveListingType GetOneActiveListing(String itemID) { if (itemID == null || itemID.Trim().Length == 0) { return(null); } String sql_getOneActiveListing = String.Format("select * from [ActiveListing] where ItemID='{0}'", itemID); DataTable dt = DataFactory.ExecuteSqlReturnTable(sql_getOneActiveListing); if (dt.Rows.Count == 0) { return(null); } DataRow dr = dt.Rows[0]; EbayActiveListingType activeListing = new EbayActiveListingType(); activeListing.ListId = StringUtil.GetSafeInt(dr["ListId"]); activeListing.SellerName = StringUtil.GetSafeString(dr["SellerName"]); activeListing.ItemID = itemID; activeListing.Title = StringUtil.GetSafeString(dr["Title"]); activeListing.ListingType = StringUtil.GetSafeString(dr["ListingType"]); activeListing.GalleryURL = StringUtil.GetSafeString(dr["GalleryURL"]); activeListing.QuantityBid = StringUtil.GetSafeInt(dr["QuantityBid"]); activeListing.MaxBid = StringUtil.GetSafeDouble(dr["MaxBid"]); activeListing.StartPrice = StringUtil.GetSafeDouble(dr["StartPrice"]); activeListing.BuyItNowPrice = StringUtil.GetSafeDouble(dr["BuyItNowPrice"]); activeListing.CurrencyID = StringUtil.GetSafeString(dr["CurrencyID"]); activeListing.StartTime = StringUtil.GetSafeDateTime(dr["StartTime"]); activeListing.EndTime = StringUtil.GetSafeDateTime(dr["EndTime"]); activeListing.ViewItemURL = StringUtil.GetSafeString(dr["ViewItemURL"]); activeListing.ListDuration = StringUtil.GetSafeInt(dr["ListDuration"]); activeListing.PrivateListing = StringUtil.GetSafeBool(dr["PrivateListing"]); activeListing.Quantity = StringUtil.GetSafeInt(dr["Quantity"]); activeListing.QuantityAvailable = StringUtil.GetSafeInt(dr["QuantityAvailable"]); activeListing.SellingStatus = StringUtil.GetSafeString(dr["SellingStatus"]); activeListing.SKU = StringUtil.GetSafeString(dr["SKU"]); activeListing.TimeLeft = StringUtil.GetSafeString(dr["TimeLeft"]); activeListing.WatchCount = StringUtil.GetSafeInt(dr["WatchCount"]); activeListing.BidCount = StringUtil.GetSafeInt(dr["BidCount"]); activeListing.BidderCount = StringUtil.GetSafeInt(dr["BidCount"]); activeListing.CurrentPrice = StringUtil.GetSafeDouble(dr["BidCount"]); activeListing.FVF = StringUtil.GetSafeDouble(dr["BidCount"]); activeListing.ImagePath = StringUtil.GetSafeString(dr["ImagePath"]); return(activeListing); }
// Delete a message template category, if there are any message templates under // this category, prompt user. private void ToolStripMenuItemDelCategory_Click(object sender, EventArgs e) { TreeNode node = treeViewMessageTemplate.SelectedNode; if (node == null) { return; } if (node.Tag == null) { return; } if (node.Tag.GetType() != typeof(MessageTemplateCategoryType)) { return; } MessageTemplateCategoryType categoryType = (MessageTemplateCategoryType)node.Tag; int categoryId = categoryType.CategoryId; DataTable dtMessageTemplates = MessageTemplateDAL.GetAllMessageTemplatesWithCategoryId(categoryId); if (dtMessageTemplates.Rows.Count > 0) { if (MessageBox.Show(string.Format("确认删除主题 {0}? 我们将删除所有隶属该主题的消息模板", categoryType.CategoryName), "请确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No) { return; } } // Either cases: // 1) The category has message templates and user confirmed to delete the category. // 2) The category has no message templates. // Delete all the relevant message templates first. foreach (DataRow dr in dtMessageTemplates.Rows) { int messageTemplateId = StringUtil.GetSafeInt(dr["TemplateId"]); MessageTemplateDAL.DeleteOneMessageTemplate(messageTemplateId); } MessageTemplateCategoryDAL.DeleteOneMessageTemplateCategory(categoryType.CategoryId); treeViewMessageTemplate.Nodes.Remove(node); }
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; } }
public static bool ModifyOneMessageTemplate(MessageTemplateType messageTemplate) { IDbCommand cmd = DataFactory.CreateCommand(null); cmd.CommandText = @"Update [MessageTemplate] set TemplateCategoryId=@TemplateCategoryId, TemplateName=@TemplateName, TemplateContent=@TemplateContent where TemplateId=@TemplateId"; DataFactory.AddCommandParam(cmd, "@TemplateCategoryId", DbType.Int32, messageTemplate.TemplateCategoryId); DataFactory.AddCommandParam(cmd, "@TemplateName", DbType.String, StringUtil.GetSafeString(messageTemplate.TemplateName)); DataFactory.AddCommandParam(cmd, "@TemplateContent", DbType.String, StringUtil.GetSafeString(messageTemplate.TemplateContent)); DataFactory.AddCommandParam(cmd, "@TemplateId", DbType.Int32, StringUtil.GetSafeInt(messageTemplate.TemplateId)); bool result = DataFactory.ExecuteCommandNonQuery(cmd); return(result); }
public static bool UpdateOneMessageTemplateCategory(MessageTemplateCategoryType cat) { IDbCommand cmd = DataFactory.CreateCommand(null); cmd.CommandText = @"Update [MessageTemplateCategory] set ParentCategoryId=@ParentCategoryId, CategoryName=@CategoryName, CategoryDescription=@CategoryDescription where CategoryId=@CategoryId"; DataFactory.AddCommandParam(cmd, "@ParentCategoryId", DbType.Int32, cat.ParentCategoryId); DataFactory.AddCommandParam(cmd, "@CategoryName", DbType.String, StringUtil.GetSafeString(cat.CategoryName)); DataFactory.AddCommandParam(cmd, "@CategoryDescription", DbType.String, StringUtil.GetSafeString(cat.CategoryDescription)); DataFactory.AddCommandParam(cmd, "@CategoryId", DbType.Int32, StringUtil.GetSafeInt(cat.CategoryId)); bool result = DataFactory.ExecuteCommandNonQuery(cmd); return(result); }
private static SourcingNoteType GetSourcingNoteFromDataRow(DataRow dr) { SourcingNoteType note = new SourcingNoteType(); note.SourcingId = StringUtil.GetSafeInt(dr["SourcingId"]); note.SupplierId = StringUtil.GetSafeInt(dr["SupplierId"]); note.ItemSkuList = StringUtil.GetSafeString(dr["ItemSkuList"]); note.ItemNumList = StringUtil.GetSafeString(dr["ItemNumList"]); note.ItemPriceList = StringUtil.GetSafeString(dr["ItemPriceList"]); note.ExtraFee = StringUtil.GetSafeDouble(dr["ExtraFee"]); note.ShippingFee = StringUtil.GetSafeDouble(dr["ShippingFee"]); note.TotalFee = StringUtil.GetSafeDouble(dr["TotalFee"]); note.Comment = StringUtil.GetSafeString(dr["Comment"]); note.SourcingDate = StringUtil.GetSafeDateTime(dr["SourcingDate"]); return(note); }
private void LoadAllMessageTemplates() { this.tvMessageTemplates.Nodes.Clear(); DataTable dtMessageCategories = MessageTemplateCategoryDAL.GetAllMessageTemplateCategories(); DataTable dtMessageTemplates = MessageTemplateDAL.GetAllMessageTemplates(); foreach (DataRow drCategory in dtMessageCategories.Rows) { int categoryId = StringUtil.GetSafeInt(drCategory["CategoryId"]); String categoryName = StringUtil.GetSafeString(drCategory["CategoryName"]); MessageTemplateCategoryType catType = new MessageTemplateCategoryType(); TreeNode catNode = new TreeNode(); catNode.Tag = catType; catNode.Text = categoryName; catNode.Name = categoryId.ToString(); this.tvMessageTemplates.Nodes.Add(catNode); } foreach (DataRow drMessageTemplate in dtMessageTemplates.Rows) { int templateId = StringUtil.GetSafeInt(drMessageTemplate["TemplateId"]); int categoryId = StringUtil.GetSafeInt(drMessageTemplate["TemplateCategoryId"]); String templateName = StringUtil.GetSafeString(drMessageTemplate["TemplateName"]); String templateContent = StringUtil.GetSafeString(drMessageTemplate["TemplateContent"]); MessageTemplateType templateType = new MessageTemplateType(); templateType.TemplateId = templateId; templateType.TemplateCategoryId = categoryId; templateType.TemplateName = templateName; templateType.TemplateContent = templateContent; TreeNode msgNode = new TreeNode(); msgNode.Tag = templateType; msgNode.Text = templateName; TreeNode[] catNodes = this.tvMessageTemplates.Nodes.Find(categoryId.ToString(), false); if (catNodes.Length > 0) { catNodes[0].Nodes.Add(msgNode); } } this.tvMessageTemplates.ExpandAll(); }
private void LoadAllCategories() { DataTable dtCategories = ItemCategoryDAL.GetAllCategories(); if (dtCategories.Rows.Count == 0) { return; } this.treeViewCategories.Nodes.Clear(); for (int itNum = 0; itNum < 2; ++itNum) { foreach (DataRow dr in dtCategories.Rows) { int catId = StringUtil.GetSafeInt(dr["CategoryId"]); int parentCatId = StringUtil.GetSafeInt(dr["ParentCategoryId"]); string catName = StringUtil.GetSafeString(dr["CategoryName"]); ItemCategoryType catType = new ItemCategoryType(); catType.CategoryId = catId; catType.ParentCategoryId = parentCatId; catType.CategoryName = catName; TreeNode newNode = new TreeNode(); newNode.Tag = catType; newNode.Text = catName; newNode.Name = catId.ToString(); if (parentCatId == -1 && itNum == 0) { this.treeViewCategories.Nodes.Add(newNode); } else if (parentCatId != -1 && itNum == 1) { TreeNode[] parentNodes = this.treeViewCategories.Nodes.Find(parentCatId.ToString(), true); if (parentNodes.Length == 1) { parentNodes[0].Nodes.Add(newNode); } } } } this.treeViewCategories.ExpandAll(); return; }
private void OnDgvDataBindCompleted() { for (int rowIdx = 0; rowIdx < this.pagedDgvItem.DgvData.Rows.Count; rowIdx++) { DataGridViewCell cell = this.pagedDgvItem.DgvData.Rows[rowIdx].Cells[2]; if (cell == null) { continue; } int stockNum = StringUtil.GetSafeInt(cell.Value); if (stockNum == 0) { this.pagedDgvItem.DgvData.Rows[rowIdx].DefaultCellStyle.BackColor = ColorTranslator.FromHtml("#D4D4D6"); } } }
private void buttonSaveItemSupplier_Click(object sender, EventArgs e) { List <ItemSupplierType> itemSupplierList = new List <ItemSupplierType>(); int itemId = GetSelectedItemId(); if (itemId <= 0) { return; } // Delete all suppliers for this item. ItemSupplierDAL.DeleteItemSuppliers(itemId); foreach (DataGridViewRow row in dgvItemSuppliers.Rows) { int supplierId = StringUtil.GetSafeInt(row.Cells[SupplierIdIndex].Value); String URL = StringUtil.GetSafeString(row.Cells[URLIndex].Value); Double price = StringUtil.GetSafeDouble(row.Cells[PriceIndex].Value); Double shippingFee = StringUtil.GetSafeDouble(row.Cells[ShippingFeeIndex].Value); String comment = StringUtil.GetSafeString(row.Cells[CommentIndex].Value); if (supplierId <= 0 || URL == "") { continue; } ItemSupplierType itemSupplier = new ItemSupplierType(); itemSupplier.ItemId = itemId; itemSupplier.SupplierId = supplierId; itemSupplier.SourcingURL = URL; itemSupplier.Price = price; itemSupplier.ShippingFee = shippingFee; itemSupplier.Comment = comment; itemSupplier.CreatedDate = DateTime.Now; itemSupplierList.Add(itemSupplier); } foreach (ItemSupplierType itemSupplier in itemSupplierList) { ItemSupplierDAL.AddOneItemSupplier(itemSupplier); } MessageBox.Show("保存供应商信息成功", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information); }
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(); }
public static MessageTemplateCategoryType GetMessageTemplateCategory(String categoryName) { String sql_getCategory = String.Format("select * from [MessageTemplateCategory] where CategoryName='{0}'", categoryName); DataTable dt = DataFactory.ExecuteSqlReturnTable(sql_getCategory); if (dt.Rows.Count == 0) { return(null); } DataRow dr = dt.Rows[0]; MessageTemplateCategoryType categoryType = new MessageTemplateCategoryType(); categoryType.CategoryId = StringUtil.GetSafeInt(dr["CategoryId"]); categoryType.ParentCategoryId = StringUtil.GetSafeInt(dr["ParentCategoryId"]); categoryType.CategoryName = StringUtil.GetSafeString(dr["CategoryName"]); return(categoryType); }
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(); }
public static MessageTemplateType GetMessageTemplate(int parentCategoryId, String templateName) { String sql_getTemplate = String.Format("select * from [MessageTemplate] where TemplateCategoryId={0} and TemplateName='{1}'", parentCategoryId, templateName); DataTable dt = DataFactory.ExecuteSqlReturnTable(sql_getTemplate); if (dt.Rows.Count == 0) { return(null); } DataRow dr = dt.Rows[0]; MessageTemplateType templateType = new MessageTemplateType(); templateType.TemplateCategoryId = StringUtil.GetSafeInt(dr["TemplateCategoryId"]); templateType.TemplateName = StringUtil.GetSafeString(dr["TemplateName"]); templateType.TemplateContent = StringUtil.GetSafeString(dr["TemplateContent"]); return(templateType); }
// Load all message template categories. private void LoadAllMessageTemplateCategories() { DataTable dtCategories = MessageTemplateCategoryDAL.GetAllMessageTemplateCategories(); this.treeViewMessageTemplate.Nodes.Clear(); foreach (DataRow dr in dtCategories.Rows) { int categoryId = StringUtil.GetSafeInt(dr["CategoryId"]); String categoryName = StringUtil.GetSafeString(dr["CategoryName"]); MessageTemplateCategoryType categoryType = new MessageTemplateCategoryType(); categoryType.CategoryId = categoryId; categoryType.CategoryName = categoryName; TreeNode newNode = new TreeNode(); newNode.Tag = categoryType; newNode.Text = categoryName; newNode.Name = categoryId.ToString(); this.treeViewMessageTemplate.Nodes.Add(newNode); } }
public static EbayMessageType GetOneMessage(String ebayMessageId) { String sql_getAllMessages = String.Format("select * from [Message] where EbayMessageId='{0}'", ebayMessageId); DataTable dt = DbAccess.ExecuteSqlReturnTable(sql_getAllMessages); if (dt.Rows.Count == 0) { return(null); } DataRow dr = dt.Rows[0]; EbayMessageType msg = new EbayMessageType(); msg.MessageId = StringUtil.GetSafeInt(dr["MessageId"]); msg.SellerName = StringUtil.GetSafeString(dr["SellerName"]); msg.EbayMessageId = StringUtil.GetSafeString(dr["EbayMessageId"]); msg.MessageType = StringUtil.GetSafeString(dr["MessageType"]); msg.QuestionType = StringUtil.GetSafeString(dr["QuestionType"]); msg.IsRead = StringUtil.GetSafeBool(dr["IsRead"]); msg.IsReplied = StringUtil.GetSafeBool(dr["IsReplied"]); msg.IsResponseEnabled = StringUtil.GetSafeBool(dr["IsResponseEnabled"]); msg.ResponseURL = StringUtil.GetSafeString(dr["ResponseURL"]); msg.UserResponseDate = StringUtil.GetSafeDateTime(dr["UserResponseDate"]); msg.ReceiveDate = StringUtil.GetSafeDateTime(dr["ReceiveDate"]); msg.Sender = StringUtil.GetSafeString(dr["Sender"]); msg.RecipientUserId = StringUtil.GetSafeString(dr["RecipientUserId"]); msg.Subject = StringUtil.GetSafeString(dr["Subject"]); msg.Content = StringUtil.GetSafeString(dr["MessageContent"]); msg.Text = StringUtil.GetSafeString(dr["MessageText"]); msg.ExternalMessageId = StringUtil.GetSafeString(dr["ExternalMessageId"]); msg.FolderId = StringUtil.GetSafeInt(dr["FolderId"]); msg.ItemID = StringUtil.GetSafeString(dr["ItemID"]); msg.ItemTitle = StringUtil.GetSafeString(dr["ItemTitle"]); // ZHI_TODO: return(msg); } // GetOneMessage
private void dataGridViewPostSale_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { if (e.ListChangedType == ListChangedType.ItemChanged) { return; } for (int rowIdx = 0; rowIdx < this.dataGridViewPostSale.Rows.Count; rowIdx++) { DataGridViewCell orderLineItemIdCell = this.dataGridViewPostSale.Rows[rowIdx].Cells[PostSaleDgv_OrderLineItemIdIdx]; if (orderLineItemIdCell.Value == null) { continue; } String orderLineItemId = orderLineItemIdCell.Value.ToString(); DataRow dr = getPostSaleOrderLocally(orderLineItemId); if (dr == null) { continue; } int transId = StringUtil.GetSafeInt(dr["TransactionId"]); String buyerId = StringUtil.GetSafeString(dr["BuyerId"]); String sellerName = StringUtil.GetSafeString(dr["SellerName"]); String itemId = StringUtil.GetSafeString(dr["ItemId"]); if (buyerId == "" || sellerName == "" || itemId == "") { continue; } TransactionMessageStatus messageStatus = (TransactionMessageStatus)StringUtil.GetSafeInt(dr["MessageStatus"]); if (messageStatus == TransactionMessageStatus.BuyerRepliedSellerNotReplied) { TransactionMessageStatus messageStatusComputed = EbayMessageDAL.GetTransactionMessageStatus(buyerId, sellerName, itemId); if (messageStatus != messageStatusComputed) { EbayTransactionDAL.UpdateTransactionMessageStatus(transId, messageStatusComputed); messageStatus = messageStatusComputed; } } Color rowBkColor = Color.White; if (messageStatus == TransactionMessageStatus.SellerInquired) { rowBkColor = ColorTranslator.FromHtml("#90EE90"); } else if (messageStatus == TransactionMessageStatus.BuyerRepliedSellerNotReplied) { rowBkColor = ColorTranslator.FromHtml("#FFFF00"); } else if (messageStatus == TransactionMessageStatus.BuyerRepliedSellerReplied) { rowBkColor = ColorTranslator.FromHtml("#DAA520"); } if (!StringUtil.GetSafeBool(dr["IsPaid"])) { rowBkColor = ColorTranslator.FromHtml("#808080"); } this.dataGridViewPostSale.Rows[rowIdx].DefaultCellStyle.BackColor = rowBkColor; } }