private Guid CreateStockTakeHeader(string txNumber, Guid workplaceId) { Guid result = Guid.Empty; using (var ctx = new EF6.RT2020Entities()) { string sql = "TxNumber = '" + txNumber.Trim() + "'"; var stktkHeader = ctx.StockTakeHeader.Where(x => x.TxNumber == txNumber).FirstOrDefault(); if (stktkHeader == null) { stktkHeader = new EF6.StockTakeHeader(); stktkHeader.HeaderId = Guid.NewGuid(); stktkHeader.TxNumber = txNumber; stktkHeader.TxDate = DateTime.Now; stktkHeader.CreatedBy = ConfigHelper.CurrentUserId; stktkHeader.CreatedOn = DateTime.Now; ctx.StockTakeHeader.Add(stktkHeader); } stktkHeader.WorkplaceId = workplaceId; stktkHeader.ModifiedBy = ConfigHelper.CurrentUserId; stktkHeader.ModifiedOn = DateTime.Now; stktkHeader.Status = (int)EnumHelper.Status.Draft; ctx.SaveChanges(); result = stktkHeader.HeaderId; } return(result); }
private Guid CreateLedgerHeader(string txNumber, EF6.StockTakeHeader oBatchHeader) { Guid result = Guid.Empty; using (var ctx = new EF6.RT2020Entities()) { var oLedgerHeader = new EF6.InvtLedgerHeader(); oLedgerHeader.HeaderId = Guid.NewGuid(); oLedgerHeader.TxNumber = txNumber; oLedgerHeader.TxType = EnumHelper.TxType.ADJ.ToString(); oLedgerHeader.TxDate = DateTime.Now; oLedgerHeader.SubLedgerHeaderId = oBatchHeader.HeaderId; oLedgerHeader.WorkplaceId = oBatchHeader.WorkplaceId.Value; oLedgerHeader.StaffId = ConfigHelper.CurrentUserId; oLedgerHeader.Reference = oBatchHeader.TxNumber; oLedgerHeader.Remarks = "Stock Take #: " + oBatchHeader.TxNumber; oLedgerHeader.Status = Convert.ToInt32(EnumHelper.Status.Draft.ToString("d")); oLedgerHeader.CreatedBy = ConfigHelper.CurrentUserId; oLedgerHeader.CreatedOn = DateTime.Now; oLedgerHeader.ModifiedBy = ConfigHelper.CurrentUserId; oLedgerHeader.ModifiedOn = DateTime.Now; ctx.InvtLedgerHeader.Add(oLedgerHeader); ctx.SaveChanges(); result = oLedgerHeader.HeaderId; } return(result); }
public static EF6.StockTakeHeader GetByTxNumber(string txNumber) { EF6.StockTakeHeader result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.StockTakeHeader.Where(x => x.TxNumber == txNumber).AsNoTracking().FirstOrDefault(); } return(result); }
public static EF6.StockTakeHeader Get(Guid id) { EF6.StockTakeHeader result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.StockTakeHeader.Find(id); } return(result); }
private void CreateNewWorksheet(object sender, EventArgs e) { if (((Form)sender).DialogResult == DialogResult.OK) { string message = ((Form)sender).Controls[0].Text; if (!string.IsNullOrEmpty(message)) { int index = message.IndexOf('['); if (index >= 0) { string txNumber = message.Substring(index + 1, 12); //string sql = "TxNumber = '" + txNumber + "'"; using (var ctx = new EF6.RT2020Entities()) { var hhtHeader = ctx.StocktakeHeader_HHT .Where(x => x.TxNumber == txNumber) .FirstOrDefault(); if (hhtHeader != null) { var stkHeader = new EF6.StockTakeHeader(); stkHeader.HeaderId = Guid.NewGuid(); stkHeader.TxNumber = hhtHeader.TxNumber; stkHeader.TxDate = DateTime.Now; stkHeader.WorkplaceId = hhtHeader.WorkplaceId.Value; stkHeader.Status = (int)EnumHelper.Status.Draft; stkHeader.CreatedBy = ConfigHelper.CurrentUserId; stkHeader.CreatedOn = DateTime.Now; stkHeader.ModifiedBy = ConfigHelper.CurrentUserId; stkHeader.ModifiedOn = DateTime.Now; ctx.StockTakeHeader.Add(stkHeader); ctx.SaveChanges(); Posting(hhtHeader.HeaderId, stkHeader.HeaderId); } } } } } }