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}'"; }
public static void AddOrUpdate(SpareEntities db, TB_INVENTORY_DETAIL detail) { db.TB_INVENTORY_DETAIL.AddOrUpdate(p => p.UID, detail); }