private static string GetFormatedText(EF6.StocktakeHeader_HHT target, string[] textField, string textFormatString) { for (int i = 0; i < textField.Length; i++) { PropertyInfo pi = target.GetType().GetProperty(textField[i]); textFormatString = textFormatString.Replace("{" + i.ToString() + "}", pi != null ? pi.GetValue(target, null).ToString() : string.Empty); } return(textFormatString); }
private Guid CreateStockTakeHHTHeader(string txNumber, string hhtId, Guid workplaceId, DateTime uploadOn, bool overwrite) { Guid result = Guid.Empty; using (var ctx = new EF6.RT2020Entities()) { EF6.StocktakeHeader_HHT hhtHeader; if (overwrite) { string sql = "TxNumber = '" + txNumber + "' AND HHTId ='" + hhtId + "'"; hhtHeader = ctx.StocktakeHeader_HHT.Where(x => x.TxNumber == txNumber && x.HHTId == hhtId).FirstOrDefault(); } else { hhtHeader = new EF6.StocktakeHeader_HHT(); hhtHeader.HeaderId = Guid.NewGuid(); hhtHeader.CreatedBy = ConfigHelper.CurrentUserId; hhtHeader.CreatedOn = DateTime.Now; ctx.StocktakeHeader_HHT.Add(hhtHeader); } hhtHeader.TxNumber = txNumber; hhtHeader.HHTId = hhtId; hhtHeader.UploadedOn = uploadOn; hhtHeader.WorkplaceId = workplaceId; hhtHeader.TotalRows = 0; hhtHeader.TOTALQTY = 0; hhtHeader.MissingQty = 0; hhtHeader.MissingRows = 0; hhtHeader.Remarks = this.Remarks; hhtHeader.Status = (int)EnumHelper.Status.Draft; hhtHeader.ModifiedBy = ConfigHelper.CurrentUserId; hhtHeader.ModifiedOn = DateTime.Now; ctx.SaveChanges(); result = hhtHeader.HeaderId; } return(result); }
private Guid CreateStockTakeHHTHeader(string txNumber, string hhtId, DateTime uploadedOn, Guid workplaceId, string hhtTxNumber, decimal totalLine, decimal totalQty, decimal missingLine, decimal missingQty) { Guid result = Guid.Empty; using (var ctx = new EF6.RT2020Entities()) { string sql = "TxNumber = '" + txNumber + "'"; var hhtHeader = ctx.StocktakeHeader_HHT.Where(x => x.TxNumber == txNumber).FirstOrDefault(); if (hhtHeader == null) { hhtHeader = new EF6.StocktakeHeader_HHT(); hhtHeader.HeaderId = Guid.NewGuid(); hhtHeader.TxNumber = txNumber; hhtHeader.Status = (int)EnumHelper.Status.Draft; hhtHeader.CreatedBy = ConfigHelper.CurrentUserId; hhtHeader.CreatedOn = DateTime.Now; ctx.StocktakeHeader_HHT.Add(hhtHeader); } hhtHeader.HHTId = hhtId; hhtHeader.UploadedOn = uploadedOn; hhtHeader.WorkplaceId = workplaceId; hhtHeader.Remarks = hhtTxNumber; hhtHeader.TotalRows = (int)totalLine; hhtHeader.TOTALQTY = totalQty; hhtHeader.MissingRows = (int)missingLine; hhtHeader.MissingQty = missingQty; hhtHeader.ModifiedBy = ConfigHelper.CurrentUserId; hhtHeader.ModifiedOn = DateTime.Now; ctx.SaveChanges(); result = hhtHeader.HeaderId; } return(result); }