Esempio n. 1
0
 private void _report_Initialize(GridppReport report, TB_INVENTORY_DETAIL locBill, string detailTableName, string indexColumnName)
 {
     Console.WriteLine(report.Parameters.Count);
     report.ParameterByName("BillNum").AsString  = locBill.BillNum;
     report.ParameterByName("LocCode").AsString  = locBill.CheckLocCode;
     report.ParameterByName("BillTime").AsString = ((DateTime)locBill.CheckTime).ToString(GlobalVar.LongTimeString);
     report.ParameterByName("OperName").AsString = locBill.OperName;
     report.ParameterByName("CheckQty").AsString = locBill.CheckQty.ToString();
     report.ConnectionString = EntitiesFactory.WmsConnectionString;
     report.DetailGrid.Recordset.ConnectionString = EntitiesFactory.WmsConnectionString;
     report.DetailGrid.Recordset.QuerySQL         = $"select * from {detailTableName} where {indexColumnName} = '{locBill.BillNum}' and CheckLocCode='{_inventorydetail.CheckLocCode}'";
 }
Esempio n. 2
0
 public static void AddOrUpdate(SpareEntities db, TB_INVENTORY_DETAIL detail)
 {
     db.TB_INVENTORY_DETAIL.AddOrUpdate(p => p.UID, detail);
 }