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); }
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; }
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 }
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); }