public static StoreTransfer UpdateStoreTransfer(Dictionary <string, string> values) { string stNumber = values["STNumber"]; string stId = values["STID"]; StoreTransfer ST = GetStoreTransfer(stNumber); ST.Id = string.IsNullOrEmpty(stId) ? 0 : int.Parse(stId); ST.STDate = values.ContainsKey("Date") ? DateTime.Parse(values["Date"]) : DateTime.Now; ST.Customer = values.ContainsKey("Customer") ? CustomerManager.GetCustomerRef(values["Customer"]) : CustomerManager.GetDefaultRef(); ST.Origin = values.ContainsKey("Origin") ? CommonDataManager.GetOrigin(values["Origin"]) : CommonDataManager.GetDefaultRef(); ST.Size = values.ContainsKey("Size") ? CommonDataManager.GetOrigin(values["Size"]) : CommonDataManager.GetDefaultRef(); ST.Vessel = values.ContainsKey("Vessel") ? CommonDataManager.GetOrigin(values["Vessel"]) : CommonDataManager.GetDefaultRef(); ST.Quantity = values.ContainsKey("Quantity") ? decimal.Parse(values["Quantity"]) : 0; ST.FromStoreId = values.ContainsKey("FromStore") ? GetStoreRef(values["FromStore"]) : GetDefaultRef(); ST.ToStoreId = values.ContainsKey("ToStore") ? GetStoreRef(values["ToStore"]) : GetDefaultRef(); ST.VehicleNo = values.ContainsKey("VehicleNo") ? values["VehicleNo"] : ""; ST.BiltyNo = values.ContainsKey("BiltyNo") ? values["BiltyNo"] : ""; ST.BiltyDate = values.ContainsKey("BiltyDate") ? DateTime.Parse(values["BiltyDate"]) : DateTime.MinValue; ST.RRInvoice = values.ContainsKey("Invoice") ? values["Invoice"] : ""; ST.CCMNumber = values.ContainsKey("CCMNo") ? values["CCMNo"] : ""; ST.Transporter = values.ContainsKey("Transporter") ? CommonDataManager.GetTrader(values["Transporter"]) : CommonDataManager.GetDefaultRef(); ST.StoreInDate = DateTime.MinValue; ST.StoreInQuantity = 0; ST.Remarks = values.ContainsKey("Remarks") ? values["Remarks"] : ""; StoreDataManager.UpdateStoreTransfer(StoreMap.reMapStoreTransferData(ST)); ResetCache(); return(ST); }
public static StoreTransfer CreateStoreTransfer(Dictionary <string, string> values) { StoreTransfer ST = NewStoreTransfer(); ST.STDate = values.ContainsKey("Date") ? DateTime.Parse(values["Date"]) : DateTime.Now; ST.Customer = values.ContainsKey("Customer") ? CustomerManager.GetCustomerRef(values["Customer"]) : CustomerManager.GetDefaultRef(); ST.Origin = values.ContainsKey("Origin") ? CommonDataManager.GetOrigin(values["Origin"]) : CommonDataManager.GetDefaultRef(); ST.Size = values.ContainsKey("Size") ? CommonDataManager.GetOrigin(values["Size"]) : CommonDataManager.GetDefaultRef(); ST.Vessel = values.ContainsKey("Vessel") ? CommonDataManager.GetOrigin(values["Vessel"]) : CommonDataManager.GetDefaultRef(); ST.Quantity = values.ContainsKey("Quantity") ? decimal.Parse(values["Quantity"]) : 0; ST.FromStoreId = values.ContainsKey("FromStore") ? StoreManager.GetStoreRef(values["FromStore"]) : StoreManager.GetDefaultRef(); ST.ToStoreId = values.ContainsKey("ToStore") ? StoreManager.GetStoreRef(values["ToStore"]) : StoreManager.GetDefaultRef(); ST.VehicleNo = values.ContainsKey("VehicleNo") ? values["VehicleNo"] : ""; ST.BiltyNo = values.ContainsKey("BiltyNo") ? values["BiltyNo"] : ""; ST.BiltyDate = values.ContainsKey("BiltyDate") ? DateTime.Parse(values["BiltyDate"]) : DateTime.MinValue; ST.RRInvoice = values.ContainsKey("Invoice") ? values["Invoice"] : ""; ST.CCMNumber = values.ContainsKey("CCMNo") ? values["CCMNo"] : ""; ST.Transporter = values.ContainsKey("Transporter") ? CommonDataManager.GetTrader(values["Transporter"]) : CommonDataManager.GetDefaultRef(); ST.StoreInDate = DateTime.MinValue; ST.StoreInQuantity = 0; ST.Remarks = values.ContainsKey("Remarks") ? values["Remarks"] : ""; StoreDataManager.CreateStoreTransfer(StoreMap.reMapStoreTransferData(ST)); // ztodo: create store movement record ResetCache(); return(ST); }
public ActionResult Create(StoreTransfer storetransfer) { if (ModelState.IsValid) { rb.Create <StoreTransfer>(storetransfer); return(RedirectToAction("Index")); } return(View(storetransfer)); }
public IActionResult Delete(StoreTransfer storeTransfer) { var result = _storeTransferService.Delete(storeTransfer); if (result.Success) { return Ok(result.Message); } return BadRequest(result.Message); }
public ActionResult Delete(int id = 0, int version = 0) { StoreTransfer storetransfer = rb.Find <StoreTransfer>(id, version); //StoreTransfer storetransfer = db.StoreTransfers.Find(id); if (storetransfer == null) { return(HttpNotFound()); } return(View(storetransfer)); }
public ActionResult Edit(StoreTransfer storetransfer) { if (ModelState.IsValid) { rb.Edit <StoreTransfer>(storetransfer); //db.Entry(storetransfer).State = EntityState.Modified; //db.SaveChanges(); return(RedirectToAction("Index")); } return(View(storetransfer)); }
public static List <StoreTransfer> MapStoreTransferData(DataTable dTstore) { List <StoreTransfer> ListStores = new List <StoreTransfer>(); foreach (DataRow dr in dTstore.Rows) { StoreTransfer mapData = new StoreTransfer(); mapData.Id = int.Parse(dr["id"].ToString()); mapData.InOut = (StoreMovementType)Enum.Parse(typeof(StoreMovementType), dr["Type"].ToString()); mapData.Status = (StoreTransferStatus)Enum.Parse(typeof(StoreTransferStatus), dr["Status"].ToString()); mapData.Customer = dr["CustomerId"] != null?CustomerManager.GetCustomerRef(dr["CustomerId"].ToString()) : CustomerManager.GetDefaultRef(); mapData.CreatedOn = dr["CreatedOn"] != DBNull.Value ? DateTime.Parse(dr["CreatedOn"].ToString()) : DateTime.MinValue; mapData.CreatedBy = dr["CreatedBy"] != null?UserManager.GetUserRef(dr["CreatedBy"].ToString()) : UserManager.GetDefaultRef(); mapData.ModifiedOn = dr["ModifiedOn"] != DBNull.Value ? DateTime.Parse(dr["ModifiedOn"].ToString()) : DateTime.MinValue; mapData.ModifiedBy = dr["ModifiedBy"] != null?UserManager.GetUserRef(dr["ModifiedBy"].ToString()) : UserManager.GetDefaultRef(); mapData.CompletedOn = dr["CompletedOn"] != DBNull.Value ? DateTime.Parse(dr["CompletedOn"].ToString()) : DateTime.MinValue; mapData.LeadId = dr["LeadId"] != null?UserManager.GetUserRef(dr["LeadId"].ToString()) : UserManager.GetDefaultRef(); mapData.STNumber = dr["SMNumber"] != null ? dr["SMNumber"].ToString() : ""; mapData.STDate = dr["SMDate"] != DBNull.Value ? DateTime.Parse(dr["SMDate"].ToString()) : DateTime.MinValue; mapData.Origin = dr["Origin"] != null?CommonDataManager.GetOrigin(dr["Origin"].ToString()) : CommonDataManager.GetDefaultRef(); mapData.Size = dr["Size"] != null?CommonDataManager.GetSize(dr["Size"].ToString()) : CommonDataManager.GetDefaultRef(); mapData.Vessel = dr["Vessel"] != null?CommonDataManager.GetVessel(dr["Vessel"].ToString()) : CommonDataManager.GetDefaultRef(); mapData.Quantity = dr["Quantity"] != null?decimal.Parse(dr["Quantity"].ToString()) : 0; mapData.FromStoreId = dr["FromStoreId"] != null?StoreManager.GetStoreRef(dr["FromStoreId"].ToString()) : StoreManager.GetDefaultRef(); mapData.ToStoreId = dr["ToStoreId"] != null?StoreManager.GetStoreRef(dr["ToStoreId"].ToString()) : StoreManager.GetDefaultRef(); mapData.VehicleNo = dr["VehicleNo"] != null ? dr["VehicleNo"].ToString() : ""; mapData.BiltyNo = dr["BiltyNo"] != null ? dr["BiltyNo"].ToString() : ""; mapData.BiltyDate = dr["BiltyDate"] != DBNull.Value ? DateTime.Parse(dr["BiltyDate"].ToString()) : DateTime.MinValue; mapData.RRInvoice = dr["RRInvoice"] != null ? dr["RRInvoice"].ToString() : ""; mapData.CCMNumber = dr["CCMNumber"] != null ? dr["CCMNumber"].ToString() : ""; mapData.Transporter = dr["Transporter"] != null?CommonDataManager.GetTrader(dr["Transporter"].ToString()) : CommonDataManager.GetDefaultRef(); mapData.StoreInDate = dr["StoreInDate"] != DBNull.Value ? DateTime.Parse(dr["StoreInDate"].ToString()) : DateTime.MinValue; mapData.StoreInQuantity = dr["StoreInQuantity"] != null?decimal.Parse(dr["StoreInQuantity"].ToString()) : 0; ListStores.Add(mapData); mapData = null; } return(ListStores); }
public static StoreTransfer NewStoreTransfer() { StoreTransfer St = new StoreTransfer(); St.InOut = StoreMovementType.Active; St.Status = StoreTransferStatus.InTransit; St.CreatedOn = St.ModifiedOn = St.STDate = DateTime.Now; St.CreatedBy = St.ModifiedBy = St.LeadId = new Reference() { Id = Common.CurrentUser.Id, Name = Common.CurrentUser.Name };; St.STNumber = GenerateNextSTNumber(); return(St); }
public static Dictionary <string, object> reMapStockMovementSTOutData(StoreTransfer ST) { Dictionary <string, object> keyValues = new Dictionary <string, object>(); keyValues.Add("@Store", ST.FromStoreId.Id); keyValues.Add("@CustomerId", ST.Customer.Id); keyValues.Add("@Type", StMovType.StoreMovement); keyValues.Add("@Quantity", ST.Quantity); keyValues.Add("@InOut", false); keyValues.Add("@Reference", ST.STNumber); keyValues.Add("@Vessel", ST.Vessel.Index); keyValues.Add("@Origin", ST.Origin.Index); keyValues.Add("@Size", ST.Size.Index); keyValues.Add("@Remarks", ST.Remarks); return(keyValues); }
public StoreTransferModel(StoreTransfer storeTransfer) : base(storeTransfer) { this.CodeNo = storeTransfer.CodeNo; this.OrderCode = storeTransfer.OrderCode; this.OrderTimeStr = storeTransfer.OrderTime.ToString("yyyy-MM-dd HH:mm:ss"); if (storeTransfer.FromStore != null) { this.FromStoreId = storeTransfer.FromStore.Id; this.FromStoreName = storeTransfer.FromStore.Name; } if (storeTransfer.ToStore != null) { this.ToStoreId = storeTransfer.ToStore.Id; this.ToStoreName = storeTransfer.ToStore.Name; } this.Note = storeTransfer.Note; }
public ActionResult SaveOrUpdate(StoreTransfer obj, string sgoods) { try { if (obj.Id > 0) { obj = this.StoreTransferRepository.Get(obj.Id); TryUpdateModel(obj); var jser = new JavaScriptSerializer(); IList <StoreTransferDetailModel> datas = jser.Deserialize <IList <StoreTransferDetailModel> >(sgoods); var list = this.StoreTransferDetailRepository.GetAll(new StoreTransferDetailQuery { StoreTransferId = obj.Id }); IList <StoreTransferDetail> dts = new List <StoreTransferDetail>(); //找到存在的进行更新,不存在的删除 foreach (var item1 in list) { bool bFlag = false; for (int i = datas.Count - 1; i >= 0; i--) { var item2 = datas[i]; if (item1.Goods.Id == item2.Id) { item1.Price = item2.Price; item1.Quantity = item2.StoreGoodsQuantity; item1.TotalAomount = item2.TotalAomount; item1.Note = item2.StoreGoodsNote; dts.Add(item1); datas.Remove(item2); bFlag = true; } } if (!bFlag) { this.StoreTransferDetailRepository.Delete(item1); } } //添加新增的 foreach (var item in datas) { dts.Add(new StoreOutDetail() { StoreOut = obj, Goods = this.GoodsRepository.Get(item.Id), Price = item.Price, Quantity = item.StoreGoodsQuantity, TotalAomount = item.TotalAomount, Note = item.StoreGoodsNote }); } foreach (var item in dts) { this.StoreOutDetailRepository.SaveOrUpdate(item); } } else { if (obj.Store == null) { return(JsonError("请选择仓库")); } if (obj.Customer == null) { return(JsonError("请选择客户")); } if (obj.Seller == null) { return(JsonError("请选择销售员")); } } obj = this.StoreOutRepository.SaveOrUpdate(obj); return(JsonSuccess(obj)); } catch (Exception ex) { return(JsonError(ex.Message)); } }
public ActionResult Detail(int id) { StoreTransfer item = this.StoreTransferRepository.Get(id); return(View(item)); }
public static StoreTransferModel From(StoreTransfer storeTransfer) { return(new StoreTransferModel(storeTransfer)); }
public IResult Update(StoreTransfer storeTransfer) { _storeTransferDal.Update(storeTransfer); return(new SuccessResult(Messages.UpdatedStoreTransfer)); }
public IResult Add(StoreTransfer storeTransfer) { _storeTransferDal.Add(storeTransfer); return(new SuccessResult(Messages.AddedStoreTransfer)); }
public static Dictionary <string, object> reMapStoreTransferData(StoreTransfer ST) { Dictionary <string, object> keyValues = new Dictionary <string, object>(); if (ST.Id != 0) { keyValues.Add("@id", ST.Id); } keyValues.Add("@Type", ST.InOut); keyValues.Add("@Status", ST.Status); if (ST.CreatedOn == DateTime.MinValue) { keyValues.Add("@CreatedOn", DBNull.Value); } else { keyValues.Add("@CreatedOn", ST.CreatedOn); } keyValues.Add("@CreatedBy", ST.CreatedBy == null ? Guid.Empty : ST.CreatedBy.Id); if (ST.ModifiedOn == DateTime.MinValue) { keyValues.Add("@ModifiedOn", DBNull.Value); } else { keyValues.Add("@ModifiedOn", ST.ModifiedOn); } keyValues.Add("@ModifiedBy", ST.ModifiedBy == null ? Guid.Empty : ST.ModifiedBy.Id); if (ST.CompletedOn == DateTime.MinValue) { keyValues.Add("@CompletedOn", DBNull.Value); } else { keyValues.Add("@CompletedOn", ST.CompletedOn); } keyValues.Add("@LeadId", ST.LeadId.Id); keyValues.Add("@SMNumber", ST.STNumber); if (ST.STDate == DateTime.MinValue) { keyValues.Add("@SMDate", DBNull.Value); } else { keyValues.Add("@SMDate", ST.STDate); } keyValues.Add("@CustomerId", ST.Customer.Id); keyValues.Add("@Origin", ST.Origin.Index); keyValues.Add("@Size", ST.Size.Index); keyValues.Add("@Vessel", ST.Vessel.Index); keyValues.Add("@Quantity", ST.Quantity); keyValues.Add("@FromStoreId", ST.FromStoreId.Id); keyValues.Add("@ToStoreId", ST.ToStoreId.Id); keyValues.Add("@VehicleNo", ST.VehicleNo); keyValues.Add("@BiltyNo", ST.BiltyNo); keyValues.Add("@BiltyDate", ST.BiltyDate); keyValues.Add("@RRInvoice", ST.RRInvoice); keyValues.Add("@CCMNumber", ST.CCMNumber); keyValues.Add("@Transporter", ST.Transporter.Index); if (ST.StoreInDate == DateTime.MinValue) { keyValues.Add("@StoreInDate", DBNull.Value); } else { keyValues.Add("@StoreInDate", ST.StoreInDate); } keyValues.Add("@StoreInQuantity", ST.StoreInQuantity); //keyValues.Add("@Remarks", ST.Remarks); return(keyValues); }