public Product RecordProduct(String productId) { try { DataTable dt; dt = new DataTable(); dt = this.db.execQuery("Sp_ProductSelById", new object[] { productId }); Model.Product prod = new Model.Product(); if (dt.Rows.Count > 0) { prod.product_id = dt.Rows[0]["product_id"].ToString(); prod.uom_code = dt.Rows[0]["uom_code"].ToString(); prod.product_name = dt.Rows[0]["product_name"].ToString(); //System.Console.Write(dt.Rows[0]["qtt_stock"].ToString()); prod.qty_stock = Convert.ToInt32(dt.Rows[0]["qty_stock"].ToString()); prod.product_price = Convert.ToInt32(dt.Rows[0]["product_price"].ToString()); } return prod; } catch (Exception ex) { throw ex; } }
public IEnumerable<Model.Product> GetProductsByCategoryID(string categoryID) { string sql = ""; string connectionString = DBHelper.ConnectionString; SqlParameter pID = new SqlParameter("@id", SqlDbType.VarChar, 10); pID.Value = categoryID; List<Petshop.Model.Product> list = new List<Model.Product>(); using (SqlDataReader reader=DBUtility.SqlHelper.ExecuteReader(connectionString,CommandType.Text,sql,pID)) { while (reader.Read()) { Model.Product product = new Model.Product() { //为相应属性赋值 }; list.Add(product); } reader.Close(); } return list; }
private void ShowPnl(PnlToShow pnlToshow, Model.Product product = null) { if (pnlToshow == PnlToShow.pnlProduct) { //this.pnlProperty.Width = 0; pnlProperty.Hide(); pnlProduct.Show(); } if (pnlToshow == PnlToShow.pnlProperty) { pnlProperty.Width = pnlProduct.Width; pnlProperty.Location = new Point(pnlProduct.Location.X, pnlProperty.Location.Y); pnlProduct.Hide(); frmSelectProperty = new frmSelecteProperties(product, m_Company); frmSelectProperty.SaveSelectedProperty = SaveSelectedProperty; frmSelectProperty.HideThis = HideProperty; //frmSelectProperty.m_Product = product; pnlProperty.Controls.Clear(); pnlProperty.Controls.Add(frmSelectProperty); pnlProperty.Show(); } }
private void btn_Product_EditValueChanged(object sender, EventArgs e) { Model.Product p = this.btn_Product.EditValue as Model.Product; if (p != null) { if (!string.IsNullOrEmpty(p.BasedUnitGroupId)) { BL.ProductUnitManager manager = new Book.BL.ProductUnitManager(); Model.UnitGroup ug = new BL.UnitGroupManager().Get(p.BasedUnitGroupId); IList <Model.ProductUnit> unitList = manager.Select(ug); this.cobUnit.Properties.Items.Clear(); foreach (Model.ProductUnit item in unitList) { this.cobUnit.Properties.Items.Add(item.CnName); } } } else { this.cobUnit.Properties.Items.Clear(); } }
private void gridView3_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } IList <Model.InvoiceCGDetail> details = this.bindingSource1.DataSource as IList <Model.InvoiceCGDetail>; if (details == null || details.Count < 1) { return; } Model.Product detail = details[e.ListSourceRowIndex].Product; Model.InvoiceCODetail codetail = details[e.ListSourceRowIndex].InvoiceCODetail; switch (e.Column.Name) { case "colProductId": if (detail == null) { return; } e.DisplayText = detail.Id; break; case "gridColumn18": if (codetail != null) { e.DisplayText = codetail.NoArrivalQuantity.Value.ToString("0.####"); } break; case "gridColumn17": if (codetail != null) { e.DisplayText = codetail.OrderQuantity.Value.ToString(); } break; } }
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } Model.Product p = null; if (this.action != "view") { IList <Model.InvoicePODetail> invoicePODetails = this.bindingSourcePODetail.DataSource as IList <Model.InvoicePODetail>; if (invoicePODetails == null || invoicePODetails.Count <= 0) { return; } p = invoicePODetails[e.ListSourceRowIndex].Product; } else { IList <Model.InvoicePIDetail> invoicePIDetails = this.bindingSourcePODetail.DataSource as IList <Model.InvoicePIDetail>; if (invoicePIDetails == null || invoicePIDetails.Count <= 0) { return; } p = invoicePIDetails[e.ListSourceRowIndex].Product; } switch (e.Column.Name) { case "gridColumn5": e.DisplayText = p.ProductSpecification; break; case "gridColumn10": e.DisplayText = p.CustomerProductName; break; } }
public async Task <IActionResult> Update(int id, Model.Product productData) { var product = _context.Products.Where(a => a.Id == id).FirstOrDefault(); if (product == null) { return(NotFound()); } else { product.Name = productData.Name; product.Description = productData.Description; product.Price = productData.Price; product.Rating = productData.Rating; product.Stock_Available = productData.Stock_Available; product.Url = productData.Url; await _context.SaveChanges(); return(Ok(product.Id)); } }
private void gridViewIn_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column == this.colProductId) { Model.InvoiceCFDetail detailIn = this.gridViewIn.GetRow(e.RowHandle) as Model.InvoiceCFDetail; if (detailIn != null) { Model.Product p = productManager.Get(e.Value.ToString()); detailIn.InvoiceCFDetailId = Guid.NewGuid().ToString(); detailIn.InvoiceCFDetailKind = "I"; detailIn.InvoiceCFDetailNote = ""; detailIn.InvoiceCFDetailPrice = 0; detailIn.InvoiceCFDetailQuantity = 0; detailIn.InvoiceCFDetailZongji = 0; detailIn.Product = p; detailIn.ProductId = p.ProductId; //detailIn.InvoiceProductUnit = detailIn.Product.ProductBaseUnit; this.bindingSourceIn.Position = this.bindingSourceIn.IndexOf(detailIn); } this.gridControlIn.RefreshDataSource(); } }
public void Insert(IList <Model.Stock> list) { foreach (Model.Stock item in list) { Model.Stock stock = this.GetStockByProductIdAndDepotPositionId(item.ProductId, item.DepotPositionId); if (stock != null) { if (stock.IsNotUpdate != null) { if (!stock.IsNotUpdate.Value) { stock.StockQuantity0 = item.StockQuantity0; } else { stock.StockQuantity0 = item.StockQuantity0; stock.StockQuantity1 = item.StockQuantity0; } } else { stock.StockQuantity0 = item.StockQuantity0; stock.StockQuantity1 = item.StockQuantity0; } this.Update(stock); Model.Product pro = productAccessor.Get(item.ProductId); // pro.StocksQuantity = this.GetTheCountByProduct(item.Product); productManager.UpdateProduct_Stock(pro); } else { this.Insert(item); Model.Product pro = productAccessor.Get(item.ProductId); // pro.StocksQuantity = this.GetTheCountByProduct(item.Product); productManager.UpdateProduct_Stock(pro); } } }
private void gridView1_ShowingEditor(object sender, CancelEventArgs e) { if (this.gridView1.FocusedColumn.Name == this.gridColumn1.Name) { if (this.gridView1.FocusedColumn.ColumnEdit is DevExpress.XtraEditors.Repository.RepositoryItemComboBox) { Model.Product p = (this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as Model.CustomerPackageDetail).Product; this.repositoryItemComboBox1.Items.Clear(); if (!string.IsNullOrEmpty(p.BasedUnitGroupId)) { IList <Model.ProductUnit> units = productUnitManager.Select(p.BasedUnitGroup); foreach (Model.ProductUnit ut in units) { this.repositoryItemComboBox1.Items.Add(ut.CnName); } } } } }
public bool Save(Model.Product product) { if (!product.HasChanges) { return(true); } if (!product.IsValid) { return(false); } if (product.IsNew) { //Insert } else { //Update } return(true); }
private void gridView1_ShowingEditor(object sender, CancelEventArgs e) { if (this.gridView1.FocusedColumn.Name == "gridColumn1") { if (this.gridView1.FocusedColumn.ColumnEdit is DevExpress.XtraEditors.Repository.RepositoryItemComboBox) { Model.Product p = (this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as Model.InvoiceCTDetail).Product; this.repositoryItemComboBox1.Items.Clear(); if (!string.IsNullOrEmpty(p.BasedUnitGroupId)) { BL.ProductUnitManager unitManager = new Book.BL.ProductUnitManager(); IList <Model.ProductUnit> unitList = unitManager.Select(p.BasedUnitGroupId); foreach (Model.ProductUnit item in unitList) { this.repositoryItemComboBox1.Items.Add(item.CnName); } } } } }
private void gridView1_ShowingEditor(object sender, CancelEventArgs e) { if (this.gridView1.FocusedColumn.Name == "gridColumnProductUnitName") { if (this.gridView1.FocusedColumn.ColumnEdit is DevExpress.XtraEditors.Repository.RepositoryItemComboBox) { Model.Product p = (this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as Model.StockEditorDetal).Product; if (p == null) { return; } if (!string.IsNullOrEmpty(p.BasedUnitGroupId)) { IList <Model.ProductUnit> units = this._productUnitManager.Select(p.BasedUnitGroupId); foreach (Model.ProductUnit ut in units) { this.repositoryItemComboBox1.Items.Add(ut.CnName); } } } } }
/// <summary> /// 选择货品 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonEditProduct_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { Invoices.ChooseProductForm f = new Book.UI.Invoices.ChooseProductForm(); if (f.ShowDialog(this) == DialogResult.OK) { Model.Product product = f.SelectedItem as Model.Product; if (product != null) { this.buttonEditProduct.Text = product.Id; this.textEditProductName.Text = string.IsNullOrEmpty(product.CustomerProductName) ? product.ProductName : product.ProductName + "{" + product.CustomerProductName + "}"; if (!string.IsNullOrEmpty(product.CustomerProductName)) { this.textEditCustomerPro.Text = product.CustomerProductName; } if (product.IsCustomerProduct == true && !string.IsNullOrEmpty(product.CustomerProductName)) { this._bomParentPartInfo = bomParentPartInfo.Get(this.productManager.Get(product.CustomerBeforeProductId)); // this.textEditCustomProduct.Text = product.CustomerProductName; this.newChooseContorlCustomer.EditValue = product.Customer; } else { this._bomParentPartInfo = bomParentPartInfo.Get(product); // this.textEditCustomProduct.Text = ""; this.newChooseContorlCustomer.EditValue = null; } this._manprocedure.Bom = this._bomParentPartInfo; if (this._bomParentPartInfo != null) { this.textEditBOMID.EditValue = this._bomParentPartInfo.Id; // this.textEditBOMType.EditValue = this._bomParentPartInfo.MaterialType; } } } f.Dispose(); GC.Collect(); }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column == this.gridColumn1 || e.Column == this.gridColumn2) { Model.StockCheckDetail detail = this.gridView1.GetRow(e.RowHandle) as Model.StockCheckDetail; if (detail != null) { Model.Product p = productManager.Get(e.Value.ToString()); detail.StockCheckDetailId = Guid.NewGuid().ToString(); detail.StockCheckId = _stockCheck.StockCheckId; detail.StockCheck = _stockCheck; detail.Directions = ""; detail.StockCheckQuantity = null; detail.Product = p; detail.Directions = p.ProductDescription; detail.ProductId = p.ProductId; detail.ProductUnitName = p.DepotUnit == null ? null : p.DepotUnit.CnName; this.bindingSourceStockCheckDetail.Position = this.bindingSourceStockCheckDetail.IndexOf(detail); } this.gridControl1.RefreshDataSource(); } }
void updateItems() { if (Program.theDatabase.currentSale.productIDs == null) { return; } foreach (StringTexture t in items) { t.Dispose(); } items.Clear(); for (int i = 0; i < Program.theDatabase.currentSale.productIDs.Length; i++) { Model.Product p = Program.theDatabase.getProduct(Program.theDatabase.currentSale.productIDs[i]); string s = p.cost.ToString("c"); s = s + " - " + p.name; items.Add(GLMethods.generateString(s, 16, System.Drawing.Color.White)); } foreach (Button b in cancelButtons) { b.Dispose(); } cancelButtons.Clear(); for (int i = 0; i < Program.theDatabase.currentSale.productIDs.Length; i++) { Model.Product p = Program.theDatabase.getProduct(Program.theDatabase.currentSale.productIDs[i]); cancelButtons.Add(new Button("x", 16, System.Drawing.Color.Red, System.Drawing.Color.Red, 0, 0)); cancelButtons[i].onClick2 += cancelClicked; } cancelButtons.Add(new Button("X", 16, System.Drawing.Color.Red, System.Drawing.Color.Red, 0, 0)); cancelButtons[cancelButtons.Count - 1].onClick2 += cancelClicked; Program.theDatabase.saveToDisk(); }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { Model.InvoiceHZDetail detail = this.gridView1.GetRow(e.RowHandle) as Model.InvoiceHZDetail; if (e.Column == this.colProductId) { if (detail != null) { Model.Product p = productManager.Get(e.Value.ToString()); detail.InvoiceHZDetailId = Guid.NewGuid().ToString(); detail.InvoiceHZDetailMoney = 0; detail.InvoiceHZDetailNote = ""; detail.InvoiceHZDetailPrice = 0; detail.InvoiceHZDetailQuantity = 0; detail.Product = p; detail.ProductId = p.ProductId; //detail.InvoiceCGDetailPrice = detail.Product.ProductCurrentCGPrice == null ? 0 : detail.Product.ProductCurrentCGPrice.Value; //detail.InvoiceProductUnit = detail.Product.ProductBaseUnit; //detail.InvoiceCGDetailMoney0 = Convert.ToDecimal(detail.InvoiceCGDetailQuantity.Value) * detail.InvoiceCGDetailPrice; //detail.InvoiceCGDetailMoney1 = detail.InvoiceCGDetailMoney0; this.bindingSourceInvoiceHZDetail.Position = this.bindingSourceInvoiceHZDetail.IndexOf(detail); } this.gridControl1.RefreshDataSource(); } if (e.Column == this.DepotPositionId) { if (detail != null) { Model.DepotPosition position = new BL.DepotPositionManager().Get(e.Value.ToString()); detail.DepotPosition = position; if (position != null) { detail.DepotPositionId = position.DepotPositionId; } } this.gridControl1.RefreshDataSource(); } }
public IList <Model.ProduceMaterialdetails> SelectByProductIdAndHeadId(Model.Product pId0, Model.Product pId1, string produceMaterialId) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT * "); sb.Append(" ,(SELECT ProductName FROM Product WHERE Product.ProductId = ProduceMaterialdetails.ProductId) AS ProductName"); sb.Append(" ,(SELECT CustomerProductName FROM Product WHERE Product.ProductId = ProduceMaterialdetails.ProductId) AS CustomerProductName"); sb.Append(" FROM ProduceMaterialdetails WHERE ProduceMaterialID='" + produceMaterialId + "'"); if (pId0 != null && pId1 != null) { sb.Append(" AND ProductId IN (SELECT ProductId FROM Product WHERE Id BETWEEN '" + pId0.Id + "' AND '" + pId1.Id + "')"); } return(this.DataReaderBind <Model.ProduceMaterialdetails>(sb.ToString(), null, CommandType.Text)); #region 注释 //Hashtable ht = new Hashtable(); //ht.Add("produceMaterialId", produceMaterialId); //ht.Add("pId0", pId0 == null ? null : pId0.ProductName); //ht.Add("pId1", pId1 == null ? null : pId1.ProductName); //return sqlmapper.QueryForList<Model.ProduceMaterialdetails>("ProduceMaterialdetails.selectByproductIdAndHeadIdRange", ht); #endregion }
private void gridView2_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } IList <Model.ProduceMaterialdetails> list = this.bindingSourceProduceMaterialDetails.DataSource as IList <Model.ProduceMaterialdetails>; if (list == null || list.Count == 0) { return; } Model.Product product = list[e.ListSourceRowIndex].Product; switch (e.Column.Name) { case "gridColumnProductId": if (product != null) { e.DisplayText = product.Id; } break; } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { Model.ProduceOtherExitDetail detail = this.gridView1.GetRow(e.RowHandle) as Model.ProduceOtherExitDetail; if (e.Column == this.ColProductId) { if (detail != null) { Model.Product p = productManager.Get(e.Value.ToString()); detail.ProduceOtherExitDetailId = Guid.NewGuid().ToString(); detail.ProduceQuantity = 0; detail.ProduceAllUserQuantity = 0; detail.CriterionUserQuantity = 0; detail.Product = p; detail.ProductId = p.ProductId; detail.ProductStock = p.StocksQuantity; detail.ProductSpecification = p.ProductSpecification; this.bindingSourceDetails.Position = this.bindingSourceDetails.IndexOf(detail); } this.gridControl1.RefreshDataSource(); } }
private void Validate(Model.Product product) { if (product.ProductCategory == null) { throw new Helper.RequireValueException(Model.Product.PRO_ProductCategoryId); } if (string.IsNullOrEmpty(product.Id)) { throw new Helper.RequireValueException(Model.Product.PRO_Id); } if (string.IsNullOrEmpty(product.ProductName)) { throw new Helper.RequireValueException(Model.Product.PRO_ProductName); } if (product.BasedUnitGroup == null) { throw new Helper.RequireValueException(Model.Product.PRO_BasedUnitGroupId); } if (product.DepotUnit == null) { throw new Helper.RequireValueException(Model.Product.PRO_DepotUnitId); } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column == this.gridColumn3 || e.Column == this.gridColumnProductId || e.Column == this.gridColumnProductName) { Model.DepotInDetail detail = this.gridView1.GetRow(e.RowHandle) as Model.DepotInDetail; if (detail != null) { Model.Product p = this._productManager.Get(e.Value.ToString()); //detail.DepotInDetailId = Guid.NewGuid().ToString(); detail.DepotPositionId = null; detail.DepotInQuantity = 1; detail.DepotInPrice = null; detail.DepotInTotal = null; detail.Product = p; detail.ProductId = p == null ? "" : p.ProductId; detail.ProductUnit = p == null ? "" : p.DepotUnit.CnName; detail.DepotInId = this._depotIn.DepotInId; detail.Description = p == null ? "" : p.ProductDescription; this.bindingSourceDetail.Position = this.bindingSourceDetail.IndexOf(detail); } this.gridControl1.RefreshDataSource(); } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { Model.InvoicePODetail detail = this.gridView1.GetRow(e.RowHandle) as Model.InvoicePODetail; if (e.Column == this.colProductId) { if (detail != null) { Model.Product p = productManager.Get(e.Value.ToString()); detail.InvoicePODetailId = Guid.NewGuid().ToString(); detail.InvoicePIDetailNote = ""; detail.InvoicePIDetailQuantity = 0; detail.InvoicePODetailNote = ""; detail.InvoicePODetailJCQuantity = 0; detail.InvoicePODetailWHQuantity = 0; detail.InvoicePODetailYHQuantity = 0; detail.Product = p; detail.ProductId = p.ProductId; detail.InvoiceProductUnit = detail.Product.ProduceUnit.CnName;; this.bindingSource1.Position = this.bindingSource1.IndexOf(detail); } this.gridControl1.RefreshDataSource(); } if (e.Column == this.gridColumn1) { if (detail != null) { Model.DepotPosition position = new BL.DepotPositionManager().Get(e.Value.ToString()); detail.DepotPosition = position; if (position != null) { detail.DepotPositionId = position.DepotPositionId; } } this.gridControl1.RefreshDataSource(); } }
private void gridView2_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } IList <Model.ProduceMaterialExitDetail> list = this.bindingSourceProduceMaterialDetails.DataSource as IList <Model.ProduceMaterialExitDetail>; if (list == null || list.Count == 0) { return; } //Model.Depot depot = list[e.ListSourceRowIndex].Depot; //string depotPosition = list[e.ListSourceRowIndex].DepotPosition; Model.Product product = list[e.ListSourceRowIndex].Product; //string productUnit = list[e.ListSourceRowIndex].ProductUnit; switch (e.Column.Name) { //case "gridColumnDepotId": // if (depot != null) // e.DisplayText = string.IsNullOrEmpty(depot.DepotId) ? "" : depot.ToString(); // break; case "gridColumnProductId": if (product != null) { e.DisplayText = string.IsNullOrEmpty(product.ProductId) ? "" : product.ToString(); } break; case "gridColumnProductName": if (product != null) { e.DisplayText = string.IsNullOrEmpty(product.ProductId) ? "" : product.Id; } break; } }
public void Delete(Model.ProduceOtherMaterial produceOtherMaterial) { try { BL.V.BeginTransaction(); //foreach (var item in ProduceOtherMaterialDetailAccessor.Select(produceOtherMaterial)) //{ // stockAccessor.Increment(new BL.DepotPositionManager().Get(item.DepotPositionId), item.Product, item.OtherMaterialQuantity); // Model.ProduceOtherCompactMaterial CompactDetail = produceOtherCompactMaterialAccessor.Get(item.ProduceOtherCompactMaterialId); // if (CompactDetail != null) // { // CompactDetail.AlreadyOutQuantity = CompactDetail.AlreadyOutQuantity == null ? 0 : CompactDetail.AlreadyOutQuantity - item.OtherMaterialQuantity; // produceOtherCompactMaterialAccessor.Update(CompactDetail); // } //} Model.ProduceOtherMaterial produceMaterialOld = this.GetDetails(produceOtherMaterial.ProduceOtherMaterialId); foreach (Model.ProduceOtherMaterialDetail detail in produceMaterialOld.Details) { // produceMaterialdetails.Distributioned = (produceMaterialdetails.Distributioned == null ? 0 : produceMaterialdetails.Distributioned) + produceMaterialdetails.Materialprocessum; Model.Product product = productManager.Get(detail.Product.ProductId); product.OtherMaterialDistributioned = (product.OtherMaterialDistributioned == null ? 0 : product.OtherMaterialDistributioned) - (detail.OtherMaterialQuantity == null ? 0 : detail.OtherMaterialQuantity) + (detail.OtherMaterialALLUserQuantity == null ? 0 : detail.OtherMaterialALLUserQuantity); productManager.update(product); } this.Delete(produceOtherMaterial.ProduceOtherMaterialId); BL.V.CommitTransaction(); } catch { BL.V.RollbackTransaction(); throw; } }
private void gridView2_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } IList <Model.ProduceOtherCompactMaterial> details = this.bindingSourceMaterial.DataSource as IList <Model.ProduceOtherCompactMaterial>; if (details == null || details.Count < 1) { return; } Model.Product detail = details[e.ListSourceRowIndex].Product; switch (e.Column.Name) { case "gridColumnStock1": if (detail == null) { return; } e.DisplayText = detail.StocksQuantity.HasValue ? detail.StocksQuantity.ToString() : "0"; break; } }
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column == this.colProductId) { Model.InvoiceJRDetail detail = this.gridView1.GetRow(e.RowHandle) as Model.InvoiceJRDetail; if (detail != null) { Model.Product p = productManager.Get(e.Value.ToString()); detail.InvoiceJRDetailId = Guid.NewGuid().ToString(); detail.InvoiceHCDetailNote = ""; detail.InvoiceHCDetailQuantity = 0; detail.InvoiceJRDetailNote = ""; detail.InvoiceJRDetailQuantity = 0; detail.InvoiceWeiHuaiChuQuantity = 0; detail.InvoiceYiHuaiChuQuantity = 0; detail.Product = p; detail.ProductId = p.ProductId; detail.InvoiceProductUnit = p.ProduceUnit.CnName; //detail.InvoiceProductUnit = detail.Product.ProductBaseUnit; this.bindingSource1.Position = this.bindingSource1.IndexOf(detail); } this.gridControl1.RefreshDataSource(); } }
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } IList <Model.Stock> stockDetail = this.bindingSourceStock.DataSource as IList <Model.Stock>; if (stockDetail == null || stockDetail.Count < 1) { return; } Model.Product product = stockDetail[e.ListSourceRowIndex].Product; if (product == null) { return; } switch (e.Column.Name) { case "gridColumnProductUnit": e.DisplayText = product.DepotUnit == null ? string.Empty : product.DepotUnit.CnName; break; case "gridColumnProductSpecification": e.DisplayText = product.ProductSpecification; break; case "gridColumnProductId": e.DisplayText = product.Id; break; case "gridColumn": e.DisplayText = product.ProductDescription; break; } }
private void gridView2_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } IList <Model.ProduceMaterialExitDetail> details = this.bindingSourceproduceMaterialExitDetail.DataSource as IList <Model.ProduceMaterialExitDetail>; if (details == null || details.Count < 1) { return; } Model.Product p = details[e.ListSourceRowIndex].Product; switch (e.Column.Name) { case "gridColumnproductId": e.DisplayText = p.Id; break; case "gridColumnStock": e.DisplayText = p.StocksQuantity.ToString(); break; } }
public void ConvertToBusinessObject(out OnlineShoppingCart.Model.Product productBO) { productBO = new Model.Product { ID = this.Id, ProductCode = this.ProductCode, ProductName = this.ProductName, ProductDescription = this.ProductDescription, CategoryID = this.CategoryId, Brand = this.Brand, Model = this.Model, UnitPrice = this.UnitPrice, SKU = this.SKU, CurrentStock = this.CurrentStock, IsActive = this.IsActive, CreatedOn = this.CreatedOn, UpdatedOn = this.UpdatedOn.GetValueOrDefault(), CreatedByUserID = this.CreatedByUserId, UpdatedByUserID = this.UpdatedByUserId.GetValueOrDefault() //public byte[] ImageThumbNail = //byte[] ImageIndex = //List<byte[]> ImageOthers = }; }
//删除图片 public string DelPic(HttpContext context) { try { DataSet ds = new DataSet(); long ID = Convert.ToInt64(context.Request["lbID"]); ds = new BLL.Product().GetDataSetByProc(ID); string path = System.Web.HttpContext.Current.Server.MapPath("../ProductPic/" + ds.Tables[0].Rows[0]["Image"].ToString() + ""); if (System.IO.File.Exists(path)) { string delFile = System.Web.HttpContext.Current.Server.MapPath("../ProductPic/" + ds.Tables[0].Rows[0]["Image"].ToString() + ""); System.IO.File.Delete(delFile); } Model.Product model = new Model.Product(); model.ID = ID; model.Image = ""; ds = new BLL.Product().UpdateImageByProc(model); if (ds.Tables[0].Rows[0][0].ToString() == "") { return("success"); } else { return("fail"); } } catch (Exception ex) { throw ex; } }
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } detailsDisplay = this.bindingSource1.DataSource as IList <Model.InvoiceXTDetail>; if (detailsDisplay == null || detailsDisplay.Count < 1) { return; } //Model.CustomerProducts detail = details[e.ListSourceRowIndex].PrimaryKey; detailDisplay = detailsDisplay[e.ListSourceRowIndex].Product; //Model.InvoiceXODetail xodetail = invoicexoDetailManager.Get(detailsDisplay[e.ListSourceRowIndex].InvoiceXODetailId); if (detailDisplay == null) { return; } switch (e.Column.Name) { case "colProductId": e.DisplayText = detailDisplay.Id; break; case "gridColumCusProName": e.DisplayText = detailDisplay.CustomerProductName; break; case "gridColumnCuxXOId": if (detailsDisplay[e.ListSourceRowIndex].InvoiceXODetail != null) { e.DisplayText = detailsDisplay[e.ListSourceRowIndex].InvoiceXODetail.Invoice.CustomerInvoiceXOId; } break; } }
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e) { if (e.ListSourceRowIndex < 0) { return; } IList <Model.InvoiceCJDetail> details = this.bindingSource1.DataSource as IList <Model.InvoiceCJDetail>; if (details == null || details.Count < 1) { return; } Model.Product detail = details[e.ListSourceRowIndex].Product; switch (e.Column.Name) { case "colProductId": if (detail == null) { return; } e.DisplayText = string.IsNullOrEmpty(detail.Id) ? "" : detail.Id; break; } }
private static void LoadMySQLEntries() { using (ProductsDBContext sqlContext = new ProductsDBContext()) { ProductsDBModel mySQLContext = new ProductsDBModel(@"Server=localhost;Database=products_db;Uid=Rami;Pwd=killer91;"); foreach (var measure in mySQLContext.Measures) { ProductsDB.Model.Measure newMeasure = new Model.Measure() { MeasureId = measure.Measure_ID, MeasureName = measure.Measure_Name }; sqlContext.Measures.Add(newMeasure); } sqlContext.SaveChanges(); foreach (var vendor in mySQLContext.Vendors) { ProductsDB.Model.Vendor newVendor = new Model.Vendor() { VendorId = vendor.Vendor_ID, VendorName = vendor.Vendor_Name }; sqlContext.Vendors.Add(newVendor); } sqlContext.SaveChanges(); foreach (var prod in mySQLContext.Products) { ProductsDB.Model.Vendor vendor = sqlContext.Vendors.Where (v => v.VendorId == prod.Vendors_Vendor_ID).First(); ProductsDB.Model.Measure measure = sqlContext.Measures.Where (m => m.MeasureId == prod.Measures_Measure_ID).First(); ProductsDB.Model.Product newProd = new Model.Product() { ProductId = prod.Products_ID, ProductName = prod.Product_Name, VendorId = prod.Vendors_Vendor_ID, Vendor = vendor, MeasureId = prod.Measures_Measure_ID, Measure = measure, BasePrice = prod.BasePrice, }; sqlContext.Products.Add(newProd); } sqlContext.SaveChanges(); } }
public ActionResult post_product(HttpPostedFileBase fileData) { HttpFileCollectionBase files = Request.Files; fileData = files["file"]; string title, bewrite, select_option_type, file_img, price, number, date, pointOfDeparture = ""; select_option_type = Library_public.Tool.GetSafeSqlandHtml(Request["select_option_type"]); title = Library_public.Tool.GetSafeSqlandHtml(Request["title"]); bewrite = Library_public.Tool.GetSafeSqlandHtml(Request["content"]); file_img = Library_public.Tool.GetSafeSqlandHtml(Request["file_img"]); price = Library_public.Tool.GetSafeSqlandHtml(Request["price"]); number = Library_public.Tool.GetSafeSqlandHtml(Request["number"]); date = Library_public.Tool.GetSafeSqlandHtml(Request["date"]); pointOfDeparture = Library_public.Tool.GetSafeSqlandHtml(Request["pointOfDeparture"]); // 文件上传后的保存路径 string filePath = Server.MapPath("~/Upload/"); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } if (fileData == null) { return Redirect("Product"); } string fileName = Path.GetFileName(fileData.FileName);// 原始文件名称 string fileExtension = Path.GetExtension(fileName); // 文件扩展名 string saveName = Guid.NewGuid().ToString() + fileExtension; // 保存文件名称 fileData.SaveAs(filePath + saveName); Model.Product product = new Model.Product { JK_Product_DateTime = DateTime.Now, JK_Product_Imgsrc = saveName, JK_Product_parameten_1 = title, JK_Product_Bewrite = bewrite, }; BLL.Product.Add(product); if (BLL.Product.Add(product) >= 1) { return Content("添加成功!"); } return Redirect("Product"); }