/// <summary> /// Popula o DataTable com a table de model /// </summary> private void PopulaDataTableListaModel(DataTable dt) { DataRow linha; rItem regraItem = new rItem(); mItem modelItem = new mItem(); try { foreach (mItemKit model in this._listaModelItemKit) { modelItem = regraItem.BuscaUnicoRegistro(Convert.ToInt32(model.Id_item)); linha = dt.NewRow(); linha["id_item"] = model.Id_item; linha["Codigo"] = modelItem.Id_item_real; linha["Item"] = modelItem.Nom; linha["qtd"] = model.Qtd_item; dt.Rows.Add(linha); } } catch (Exception ex) { throw ex; } finally { linha = null; regraItem = null; modelItem = null; } }
public mItem BuscaUnicoRegistro(int idItem) { DataTable dtRetorno = null; SqlParameter param = null; mItem modelItem = new mItem(); try { param = new SqlParameter("@id_item", idItem); dtRetorno = base.BuscaDados("sp_select_item", param); modelItem.Deserialize(dtRetorno); return(modelItem); } catch (Exception ex) { throw ex; } finally { param = null; if (dtRetorno != null) { dtRetorno.Dispose(); dtRetorno = null; } modelItem = null; } }
/// <summary> /// Completa a lista de model Item peca com o id do item que foi gravado no Banco de dados /// </summary> /// <param name="modelItem">model do item onde esta o id</param> private void CompletaListaModelItemPeca(mItem modelItem) { foreach (mItemPeca model in this._modelItemPeca) { model.Id_item = modelItem.Id_item; } }
/// <summary> /// Pega os dados da tela e popula o model de Item /// </summary> /// <returns>model item populado</returns> private mItem PegaDadosTelaItem() { mItem model = new mItem(); rItem regra = new rItem(); try { model.Dat_alt = DateTime.Now; model.Flg_ativo = true; model.Id_item = regra.BuscaIdMaximo(); model.Id_item_real = this.txtCodigoItem.Text; model.Nom = this.txtNmItem.Text; return(model); } catch (Exception ex) { throw ex; } finally { model = null; regra = null; } }
private void ValidaDados(mItem model) { if (this.ExisteItemReal(model.Id_item_real) == true) { throw new Exceptions.Item.CodigoRealItemExistenteException(); } else if (this.ExisteItemNome(model.Nom) == true) { throw new Exceptions.Item.NomeItemExistenteException(); } }
public ActionResult DeleteItem(string ItemCode) { mItem item = new mItem(); item = (from u in db.mItems.ToList() where u.ItemCode == ItemCode select u).FirstOrDefault(); item.Is_Deleted = true; item.Update_Date = DateTime.Now; item.Update_User = user.UserID; db.Entry(item).State = EntityState.Modified; db.SaveChanges(); return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet)); }
private void SelectTagsForMonitor() { mItem selectedTag = (mItem)dgrid_Tags.SelectedItem; mTag tag = new mTag(selectedTag.Name, selectedTag.Path); var contain = Model.opcSubscribedTags.Any(t => t.Name == tag.Name); if (!contain) { mTag newTag = (mTag)dgrid_Subscribed.SelectedItem as mTag; var mt = Model.opcSubscribedTags.FirstOrDefault(t => t.NameInDb == newTag.NameInDb); mt.Name = tag.Name; mt.Path = tag.Path; } }
public ActionResult EditItem(mItem itemdata) { try { mItem item = new mItem(); item = (from u in db.mItems.ToList() where u.ItemCode == itemdata.ItemCode select u).FirstOrDefault(); item.ItemName = itemdata.ItemName; item.Description = itemdata.Description; item.CusSupCode = itemdata.CusSupCode; item.CargoClass = itemdata.CargoClass; item.BaseMeasurement = itemdata.BaseMeasurement; item.Update_User = "******"; item.Update_Date = DateTime.Now; mItem checker = (from c in db.mItems where c.ItemName == item.ItemName && c.Description == item.Description && c.CusSupCode == item.CusSupCode && c.CargoClass == item.CargoClass && c.BaseMeasurement == item.BaseMeasurement && c.SiteCode == item.SiteCode select c).FirstOrDefault(); if (checker == null) { db.Entry(item).State = EntityState.Modified; db.SaveChanges(); } else { return(Json(new { result = "failed" }, JsonRequestBehavior.AllowGet)); } } catch (Exception err) { } return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateItem(mItem item) { item.SiteCode = System.Web.HttpContext.Current.Session["user"].ToString(); string gencode = string.Empty; string lastgencode = (from u in db.mItems.ToList() orderby u.ItemCode descending select u.ItemCode).FirstOrDefault(); if (lastgencode == null) { gencode = "ITM0001"; } else { gencode = lastgencode.Substring(3); int upId = Convert.ToInt32(gencode.TrimStart(new char[] { '0' })) + 1; gencode = string.Format("ITM{0}", upId.ToString().PadLeft(4, '0')); } item.ItemCode = gencode; item.Is_Deleted = false; item.Create_Date = DateTime.Now; item.Create_User = user.UserID; item.Update_Date = DateTime.Now; item.Update_User = user.UserID; mItem checker = (from c in db.mItems where c.ItemName == item.ItemName && c.Description == item.Description && c.CusSupCode == item.CusSupCode && c.CargoClass == item.CargoClass && c.BaseMeasurement == item.BaseMeasurement && c.SiteCode == item.SiteCode && c.Is_Deleted == false select c).FirstOrDefault(); if (checker == null) { try { db.mItems.Add(item); db.SaveChanges(); mItemPrice itemprice = new mItemPrice(); itemprice.ItemCode = gencode; itemprice.Is_Deleted = false; itemprice.Create_Date = DateTime.Now; itemprice.Create_User = user.UserID; itemprice.Update_Date = DateTime.Now; itemprice.Update_User = user.UserID; db.mItemPrices.Add(itemprice); db.SaveChanges(); } catch (Exception err) { } } else { return(Json(new { result = "failed" }, JsonRequestBehavior.AllowGet)); } return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet)); }
public ActionResult SetInbound(INinboundSet InboundItem, STstockInventoryDetail stockdetails, ItemUnitModel itemunit) { InboundItem.Is_Deleted = false; InboundItem.Create_Date = DateTime.Now; InboundItem.Create_User = user.UserID; InboundItem.Update_Date = DateTime.Now; InboundItem.Update_User = user.UserID; string DateID = DateTime.Now.ToString("yyyyMMdd"); string gencode = string.Empty; string lastgencode = (from u in db.INinboundSets.ToList() orderby u.InboundNoResult descending select u.InboundNoResult).FirstOrDefault(); if (lastgencode == null) { gencode = DateID + "INR0000001"; } else { gencode = lastgencode.Substring(11); int upId = Convert.ToInt32(gencode.TrimStart(new char[] { '0' })) + 1; gencode = DateID + string.Format("INR{0}", upId.ToString().PadLeft(7, '0')); } InboundItem.InboundNoResult = gencode; try { db.INinboundSets.Add(InboundItem); db.SaveChanges(); string gencodes = string.Empty; string lastgencodes = (from u in db.STstockInventoryDetails.ToList() orderby u.StockDetailCode descending select u.StockDetailCode).FirstOrDefault(); if (lastgencodes == null) { gencodes = DateID + "STD0000001"; } else { gencodes = lastgencodes.Substring(11); int upId = Convert.ToInt32(gencodes.TrimStart(new char[] { '0' })) + 1; gencodes = DateID + string.Format("STD{0}", upId.ToString().PadLeft(7, '0')); } INinboundPlan inboundplan = (from c in db.INinboundPlans where c.InboundPlanCode == InboundItem.InboundPlanCode select c).FirstOrDefault(); mItem itemcurrent_main = (from c in db.mItems where c.ItemCode == InboundItem.ItemCode select c).FirstOrDefault(); INinboundItem inboundplanitem = (from c in db.INinboundItems where c.InboundPlanCode == InboundItem.InboundPlanCode && c.ItemCode == itemcurrent_main.ItemCode select c).FirstOrDefault(); stockdetails.StockCode = (from c in db.STstockInventories where c.InboundPlanCode == InboundItem.InboundPlanCode select c.StockCode).FirstOrDefault(); stockdetails.InboundPlanNo = inboundplan.InboundPlanCode; stockdetails.InboundNoResult = gencode; //Inbound result Gen code stockdetails.StockDetailCode = gencodes; //Stock Details Code stockdetails.ItemCode = inboundplanitem.ItemCode; stockdetails.ExpiredDate = inboundplanitem.ExpirationDate; stockdetails.InboundDate = inboundplan.InboundPlanDate; stockdetails.ActualStockQty = InboundItem.ActualReceived; stockdetails.AllocatedQty = 0; stockdetails.PickedQty = 0; stockdetails.LocationCode = InboundItem.Location; stockdetails.LocationSubCode = InboundItem.SubLocation; stockdetails.LotNo = inboundplanitem.LotNo; stockdetails.PONo = inboundplanitem.PoNo; stockdetails.SupplierCode = itemcurrent_main.CusSupCode; stockdetails.SupplierCode = itemcurrent_main.CusSupCode; stockdetails.OriginalItemCode = itemcurrent_main.ItemCode; stockdetails.CaseQty = itemunit.pqc_q; stockdetails.QtyPerCase = itemunit.QtyPerCase; stockdetails.InnerCaseQty = itemunit.qpic_q; stockdetails.InnerQtyPerCase = itemunit.QtyPerInnerCase; stockdetails.UnitQty = itemunit.QtyPerUnit; //stockdetails.NW = (itemunit.QtyPerCase + itemunit.QtyPerInnerCase + itemunit.QtyPerUnit) * itemcurrent_unit.Where(c => c.Type == "") sa sunod na to stockdetails.LastInboundDate = DateTime.Now; //stockdetails.LastOutboundDate = DateTime.Now; stockdetails.SlipClass = inboundplan.SlipClass; stockdetails.SlipDate = inboundplan.SlipDate; stockdetails.SlipNo = inboundplan.SlipNo; stockdetails.SlipRemarks = inboundplan.Remarks; stockdetails.Is_Deleted = false; stockdetails.Create_Date = DateTime.Now; stockdetails.Create_User = user.UserID; stockdetails.Update_Date = DateTime.Now; stockdetails.Update_User = user.UserID; db.STstockInventoryDetails.Add(stockdetails); db.SaveChanges(); } catch (Exception err) { } return(Json(new { result = "success", InboundItem = InboundItem }, JsonRequestBehavior.AllowGet)); }