コード例 #1
0
        static public List <RuntimeData> loadDataFromDatabase(DateTime startDate, DateTime endDate, int sheetNo)
        {
            BillingDataDataContext db = new BillingDataDataContext();

            db.sp_LoadToRuntimeFromDate(SecurityModule.currentUserName, sheetNo, endDate, startDate);
            return(db.RuntimeDatas.Where(x => x.SheetNo == sheetNo && x.UserId == SecurityModule.currentUserName).OrderBy(y => y.ConsignmentNo).ToList());
        }