Exemplo n.º 1
0
        public List <DC_LG_DeliveryFee_Territory> GetList(DataSourceRequest request, string whereCondition)
        {
            List <SqlParameter> param = new List <SqlParameter>();

            param.Add(new SqlParameter("@Page", 1));
            param.Add(new SqlParameter("@PageSize", 99999));
            param.Add(new SqlParameter("@WhereCondition", whereCondition));
            DataTable dt  = new SqlHelper().ExecuteQuery("p_get_DeliveryFee_Territory", param);
            var       lst = new List <DC_LG_DeliveryFee_Territory>();

            foreach (DataRow row in dt.Rows)
            {
                var item = new DC_LG_DeliveryFee_Territory();
                item.DeliveryFeeID       = !row.IsNull("DeliveryFeeID") ? int.Parse(row["DeliveryFeeID"].ToString()) : 0;
                item.ProvinceID          = !row.IsNull("ProvinceID") ? row["ProvinceID"].ToString() : "";
                item.DistrictID          = !row.IsNull("DistrictID") ? row["DistrictID"].ToString() : "";
                item.PickingProvinceID   = !row.IsNull("PickingProvinceID") ? row["PickingProvinceID"].ToString() : "";
                item.PickingDistrictID   = !row.IsNull("PickingDistrictID") ? row["PickingDistrictID"].ToString() : "";
                item.ProvinceName        = !row.IsNull("ProvinceName") ? row["ProvinceName"].ToString() : "";
                item.DistrictName        = !row.IsNull("DistrictName") ? row["DistrictName"].ToString() : "";
                item.PickingProvinceName = !row.IsNull("PickingProvinceName") ? row["PickingProvinceName"].ToString() : "";
                item.PickingDistrictName = !row.IsNull("PickingDistrictName") ? row["PickingDistrictName"].ToString() : "";
                item.DeliveryFeeName     = !row.IsNull("DeliveryFeeName") ? row["DeliveryFeeName"].ToString() : "";

                lst.Add(item);
            }

            return(lst);
        }
Exemplo n.º 2
0
        public DataSourceResult GetPage(int page, int pageSize, string whereCondition)
        {
            List <SqlParameter> param = new List <SqlParameter>();

            param.Add(new SqlParameter("@Page", page));
            param.Add(new SqlParameter("@PageSize", pageSize));
            param.Add(new SqlParameter("@WhereCondition", whereCondition));
            DataTable dt  = new SqlHelper().ExecuteQuery("p_get_DeliveryFee_Territory", param);
            var       lst = new List <DC_LG_DeliveryFee_Territory>();

            foreach (DataRow row in dt.Rows)
            {
                var item = new DC_LG_DeliveryFee_Territory();
                item.DeliveryFeeID       = !row.IsNull("DeliveryFeeID") ? int.Parse(row["DeliveryFeeID"].ToString()) : 0;
                item.ProvinceID          = !row.IsNull("ProvinceID") ? row["ProvinceID"].ToString() : "";
                item.DistrictID          = !row.IsNull("DistrictID") ? row["DistrictID"].ToString() : "";
                item.PickingProvinceID   = !row.IsNull("PickingProvinceID") ? row["PickingDistrictID"].ToString() : "";
                item.PickingDistrictID   = !row.IsNull("PickingDistrictID") ? row["PickingDistrictID"].ToString() : "";
                item.ProvinceName        = !row.IsNull("ProvinceName") ? row["ProvinceName"].ToString() : "";
                item.DistrictName        = !row.IsNull("DistrictName") ? row["DistrictName"].ToString() : "";
                item.PickingProvinceName = !row.IsNull("PickingProvinceName") ? row["PickingProvinceName"].ToString() : "";
                item.PickingDistrictName = !row.IsNull("PickingDistrictName") ? row["PickingDistrictName"].ToString() : "";
                item.DeliveryFeeName     = !row.IsNull("DeliveryFeeName") ? row["DeliveryFeeName"].ToString() : "";

                lst.Add(item);
            }
            DataSourceResult result = new DataSourceResult();

            result.Data  = lst;
            result.Total = dt.Rows.Count > 0 ? Convert.ToInt32(dt.Rows.Count) : 0;
            return(result);
        }
        public DataSourceResult GetPage(int page, int pageSize, string whereCondition)
        {
            List<SqlParameter> param = new List<SqlParameter>();
            param.Add(new SqlParameter("@Page", page));
            param.Add(new SqlParameter("@PageSize", pageSize));
            param.Add(new SqlParameter("@WhereCondition", whereCondition));
            DataTable dt = new SqlHelper().ExecuteQuery("p_get_DeliveryFee_Territory",param);
            var lst = new List<DC_LG_DeliveryFee_Territory>();
            foreach (DataRow row in dt.Rows)
            {
                var item = new DC_LG_DeliveryFee_Territory();
                item.DeliveryFeeID = !row.IsNull("DeliveryFeeID") ? int.Parse(row["DeliveryFeeID"].ToString()) : 0;
                item.ProvinceID = !row.IsNull("ProvinceID") ? row["ProvinceID"].ToString() : "";
                item.DistrictID = !row.IsNull("DistrictID") ? row["DistrictID"].ToString() : "";
                item.PickingProvinceID = !row.IsNull("PickingProvinceID") ? row["PickingDistrictID"].ToString() : "";
                item.PickingDistrictID = !row.IsNull("PickingDistrictID") ? row["PickingDistrictID"].ToString() : "";
                item.ProvinceName = !row.IsNull("ProvinceName") ? row["ProvinceName"].ToString() : "";
                item.DistrictName = !row.IsNull("DistrictName") ? row["DistrictName"].ToString() : "";
                item.PickingProvinceName = !row.IsNull("PickingProvinceName") ? row["PickingProvinceName"].ToString() : "";
                item.PickingDistrictName = !row.IsNull("PickingDistrictName") ? row["PickingDistrictName"].ToString() : "";
                item.DeliveryFeeName = !row.IsNull("DeliveryFeeName") ? row["DeliveryFeeName"].ToString() : "";

                lst.Add(item);
            }
            DataSourceResult result = new DataSourceResult();
            result.Data = lst;
            result.Total = dt.Rows.Count > 0 ? Convert.ToInt32(dt.Rows.Count) : 0;
            return result;
        }
        public List<DC_LG_DeliveryFee_Territory> GetList(DataSourceRequest request, string whereCondition)
        {
            List<SqlParameter> param = new List<SqlParameter>();
            param.Add(new SqlParameter("@Page", 1));
            param.Add(new SqlParameter("@PageSize", 99999));
            param.Add(new SqlParameter("@WhereCondition", whereCondition));
            DataTable dt = new SqlHelper().ExecuteQuery("p_get_DeliveryFee_Territory", param);
            var lst = new List<DC_LG_DeliveryFee_Territory>();
            foreach (DataRow row in dt.Rows)
            {
                var item = new DC_LG_DeliveryFee_Territory();
                item.DeliveryFeeID = !row.IsNull("DeliveryFeeID") ? int.Parse(row["DeliveryFeeID"].ToString()) : 0;
                item.ProvinceID = !row.IsNull("ProvinceID") ? row["ProvinceID"].ToString() : "";
                item.DistrictID = !row.IsNull("DistrictID") ? row["DistrictID"].ToString() : "";
                item.PickingProvinceID = !row.IsNull("PickingProvinceID") ? row["PickingProvinceID"].ToString() : "";
                item.PickingDistrictID = !row.IsNull("PickingDistrictID") ? row["PickingDistrictID"].ToString() : "";
                item.ProvinceName = !row.IsNull("ProvinceName") ? row["ProvinceName"].ToString() : "";
                item.DistrictName = !row.IsNull("DistrictName") ? row["DistrictName"].ToString() : "";
                item.PickingProvinceName = !row.IsNull("PickingProvinceName") ? row["PickingProvinceName"].ToString() : "";
                item.PickingDistrictName = !row.IsNull("PickingDistrictName") ? row["PickingDistrictName"].ToString() : "";
                item.DeliveryFeeName = !row.IsNull("DeliveryFeeName") ? row["DeliveryFeeName"].ToString() : "";

                lst.Add(item);
            }

            return lst;
        }
Exemplo n.º 5
0
 public FileResult Export_DeliveryTerritory([DataSourceRequest]DataSourceRequest request)
 {
     ExcelPackage pck = new ExcelPackage(new FileInfo(Server.MapPath("~/ExportTemplate/GoiCuocVanChuyenTheoVungMien.xlsx")));
     ExcelWorksheet ws = pck.Workbook.Worksheets["Data"];
     if (userAsset["Export"])
     {
         string whereCondition = "";
         if (request.Filters.Count > 0)
         {
             whereCondition = " AND " + new KendoApplyFilter().ApplyFilter(request.Filters[0]);
         }
         IDbConnection db = new OrmliteConnection().openConn();
         var lstResult = new DC_LG_DeliveryFee_Territory().GetList(request, whereCondition);
         int rowNum = 2;
         foreach (var item in lstResult)
         {
             ws.Cells["A" + rowNum].Value = item.DeliveryFeeID;
             ws.Cells["B" + rowNum].Value = item.DeliveryFeeName;
             ws.Cells["C" + rowNum].Value = item.ProvinceID;
             ws.Cells["D" + rowNum].Value = item.ProvinceName;
             ws.Cells["E" + rowNum].Value = item.DistrictID;
             ws.Cells["F" + rowNum].Value = item.DistrictName;
             ws.Cells["G" + rowNum].Value = item.PickingProvinceID;
             ws.Cells["H" + rowNum].Value = item.PickingProvinceName;
             ws.Cells["I" + rowNum].Value = item.PickingDistrictID;
             ws.Cells["J" + rowNum].Value = item.PickingDistrictName;
             rowNum++;
         }
         db.Close();
     }
     else
     {
         ws.Cells["A2:E2"].Merge = true;
         ws.Cells["A2"].Value = "You don't have permission to export data.";
     }
     MemoryStream output = new MemoryStream();
     pck.SaveAs(output);
     return File(output.ToArray(), //The binary data of the XLS file
                 "application/vnd.ms-excel", //MIME type of Excel files
                 "GoiCuocVanChuyenTheoVungMien" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx");     //Suggested file name in the "Save as" dialog which will be displayed to the end user
 }
Exemplo n.º 6
0
 public ActionResult Read_DeliveryFeeTerritory([DataSourceRequest]DataSourceRequest request)
 {
     string whereCondition = "";
     if (request.Filters.Count > 0)
     {
         whereCondition = new KendoApplyFilter().ApplyFilter(request.Filters[0]);
     }
     var data = new DC_LG_DeliveryFee_Territory().GetPage(request.Page, request.PageSize, whereCondition);
     return Json(data);
 }