정훈's 프로그래밍

"NPOI.dll"을 이용한 엑셀 다운로드 방법. public ActionResult DownloadExcel(string serviceNationCode, int qprimeTypeId, string originNationCode, string destinationNationCode) { int qprimeContractCompanyCode = GetQprimeContractCompanyCode(serviceNationCode, qprimeTypeId, originNationCode, destinationNationCode); RateTable[] rateTableInfo = GetRateTable("DE", qprimeContractCompanyCode, "", "", "").ToArray(); va..

public enum State { [Description("Karnataka")] KARNATAKA = 1, [Description("Gujarat")] GUJRAT = 2, [Description("Assam")] ASSAM = 3, [Description("Maharashtra")] MAHARASHTRA = 4, [Description("Goa")] GOA = 5 }State stateVal = State.GOA; string stateName = GetEnumDescription(stateVal);int stateVal = 2; string stateName = GetEnumDescription((State)stateVal); public static string GetEnumDescription..

* web form 파일 다운로드Response.Clear();Response.ContentType = "Application/txt";Response.AppendHeader("Content-Disposition", "attachment; filename=SR3012081920181005110130.txt");Response.OutputStream.Write(Encoding.Default.GetBytes(stringBuilder.ToString()), 0, stringBuilder.Length);Response.End(); *ASP.NET MVC 파일 다운로드public ActionResult Index(){return File(bytes, "application/vnd.ms-excel", saveAsF..

private void UploadFile() { //excel 생성. // Get the object used to communicate with the server. FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://000.000.000.000/up_gmkt_get_delivery_driver_list.sql"); request.Method = WebRequestMethods.Ftp.UploadFile; // This example assumes the FTP site uses anonymous logon. request.Credentials = new NetworkCredential("your id", "your password"); ..

/*=============================================================================================-- Author:장정훈-- Description:상품 목록을 가져온다.-- Note:-- Modify Log::-- Test:exec QfsInventoryList_james '100054651', '0000019358', '', '', '', N''============================================================================================= */alter procedure dbo.QfsInventoryList_james@customerNo varchar(10),..

public ActionResult GetInventoryExcel(GetInventoryListModel getInventoryListModel) { // Validation if (getInventoryListModel.SearchStartDate == DateTime.MinValue) { getInventoryListModel.SearchStartDate = DateTime.Now.AddYears(-50); } if (getInventoryListModel.SearchEndDate == DateTime.MinValue) { getInventoryListModel.SearchEndDate = DateTime.Now; } getInventoryListModel.CustomerNo = LoginServi..

CallConvertToList(datatableResource) Methodpublic List ConvertToList(DataTable dt) { dt = dt ?? new DataTable(); var columnNames = dt.Columns.Cast() .Select(c => c.ColumnName) .ToList(); var properties = typeof(T).GetProperties(); return dt.AsEnumerable().Select(row => { var objT = System.Activator.CreateInstance(); foreach (var pro in properties) { if (columnNames.Contains(pro.Name)) pro.SetVal..

string[] arrivalSkuNo if (arrivalSkuNo.Count(n => n == skuNo) > 1){ModelState.AddModelError("", ""); break;}

File.cspublic class ProductsController : ApiController { Product[] products = new Product[] { new Product { Category = "category1", Id = 1, Name = "name1", Price = 1 } , new Product { Category = "category2", Id = 2, Name = "name2", Price = 2 } }; public IEnumerable GetAllProducts() { return products; } public IHttpActionResult GetProduct(int id) { var product = products.FirstOrDefault((p) => p.I..