Ejemplo n.º 1
0
        public IHttpActionResult GetCardList(string key = "", string cardgroups = "", string customerid = "", string customergroups = "", string fromdate = "", string todate = "", bool desc = false, string columnQuery = "ImportDate", string ischeckbytime = "0", string accesslevelids = "", string active = "", bool isfindautocapture = false)
        {
            var str = GetListChild("", customergroups);

            var listExcel  = _tblCardService.GetExcelCardByFirstParkingTSQL(key, cardgroups, customerid, str, fromdate, todate, desc, columnQuery, ischeckbytime, "", active, isfindautocapture);
            var Dictionary = FunctionHelper.GetLocalizeDictionary("tblCard", "Index");

            var dataBytes = PK_CardCustomerFormatCell2(listExcel, Dictionary["TitleEx"], "Sheet1", "", Dictionary["Title"], fromdate + " - " + todate);

            var dataStream = new MemoryStream(dataBytes);

            return(new FileResult(dataStream, Request, Dictionary["TitleEx"]));
        }