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);
}
