C# (CSharp) BLL Inventory.LoadFromRawSql示例

示例#1

文件： Inventory.cs 项目： USAID-DELIVER-PROJECT/ethiopia-hcmis-warehouse

 public static DataView SOHForFinance(int activityId, int periodId)
 {
     var query = HCMIS.Repository.Queries.Inventory.SelectSOHForFinance(activityId, periodId);
     BLL.Inventory inventory = new Inventory();
     inventory.FlushData();
     inventory.LoadFromRawSql(query);
     return inventory.DefaultView;
 }

示例#2

文件： Inventory.cs 项目： USAID-DELIVER-PROJECT/ethiopia-hcmis-warehouse

 public static DataView GetOverageShortageReport(int activityId, int warehouseId, string periodIds)
 {
     var query = HCMIS.Repository.Queries.Inventory.SelectGetOverageShortageReport(activityId, warehouseId, periodIds);
     BLL.Inventory inventory = new Inventory();
     inventory.FlushData();
     inventory.LoadFromRawSql(query);
     return inventory.DefaultView;
 }

示例#3

文件： Inventory.cs 项目： sentimental37/ethiopia-hcmis-warehouse

        public static DataView SOHForFinance(int activityId, int periodId)
        {
            var query = HCMIS.Repository.Queries.Inventory.SelectSOHForFinance(activityId, periodId);

            BLL.Inventory inventory = new Inventory();
            inventory.FlushData();
            inventory.LoadFromRawSql(query);
            return(inventory.DefaultView);
        }

示例#4

文件： Inventory.cs 项目： sentimental37/ethiopia-hcmis-warehouse

        public static DataView GetOverageShortageAggregateReport(int activityId, int warehouseId, string periodIds)
        {
            var query = HCMIS.Repository.Queries.Inventory.SelectGetOverageShortageAggregateReport(activityId, warehouseId, periodIds);

            BLL.Inventory inventory = new Inventory();
            inventory.FlushData();
            inventory.LoadFromRawSql(query);
            return(inventory.DefaultView);
        }