private bool ReadExcel(string job_id)
{
FileInfo excel = new FileInfo(Server.MapPath("~/EXCEL/" + job_id + ".xlsx"));
using (var package = new ExcelPackage(excel))
{
var workbook = package.Workbook;
//*** Sheet 1
var worksheet = workbook.Worksheets["Sheet1"];
//*** Result
MODEL.Criteria.job job = new MODEL.Criteria.job();
job.job_name = worksheet.Cells["A3"].Text;
string tmpD;
tmpD = worksheet.Cells["B1"].Text;
// RET M/dd/yyyy 1/27/2018
job.job_date = retDate(tmpD);
job.job_id = job_id;
job.place_type = worksheet.Cells["K5"].Text.Trim();
// jobDetail
List <MODEL.Criteria.jobDetail> lstJobDetail = new List <MODEL.Criteria.jobDetail>();
int i = 5;
do
{
MODEL.jobDetail jobDetail = new MODEL.jobDetail();
jobDetail.place_get_job = worksheet.Cells[i, 1].Text;
jobDetail.container_type = worksheet.Cells[i, 2].Text;
jobDetail.container_dim = worksheet.Cells[i, 3].Text;
jobDetail.cust_dest = worksheet.Cells[i, 4].Text;
jobDetail.code_name = worksheet.Cells[i, 5].Text;
jobDetail.appointed_time = worksheet.Cells[i, 6].Text;
jobDetail.doc_no = worksheet.Cells[i, 7].Text;
jobDetail.place_send_job = worksheet.Cells[i, 8].Text;
jobDetail.send_company = worksheet.Cells[i, 9].Text;
jobDetail.remark = worksheet.Cells[i, 10].Text;
jobDetail.place_type = worksheet.Cells[i, 11].Text;
lstJobDetail.Add(jobDetail);
i++;
} while (worksheet.Cells[i, 1].Text != "");
job.createby = Session["NAME"].ToString();
InsertJob(job, lstJobDetail);
}
return(true);
}
protected void getExcel()
{
// FileInfo excel = new FileInfo(Server.MapPath(@"C:\_CODE\WEB_APP\QR_CODE\QRCODE.PROJECT\Xls\รูปแบบเอกสารสำหรับเข้ารับงาน R1.xls"));
FileInfo excel = new FileInfo("C://Book1.xlsx");
using (var package = new ExcelPackage(excel))
{
var workbook = package.Workbook;
//*** Sheet 1
var worksheet = workbook.Worksheets["Sheet1"];
//*** Result
MODEL.job job = new MODEL.job();
job.job_name = worksheet.Cells["A3"].Text;
job.job_date = worksheet.Cells["B1"].Text;
// jobDetail
List <MODEL.jobDetail> lstJobDetail = new List <MODEL.jobDetail>();
int i = 5;
do
{
MODEL.jobDetail jobDetail = new MODEL.jobDetail();
jobDetail.place_get_job = worksheet.Cells[i, 1].Text;
jobDetail.container_type = worksheet.Cells[i, 2].Text;
jobDetail.container_dim = worksheet.Cells[i, 3].Text;
jobDetail.cust_dest = worksheet.Cells[i, 4].Text;
jobDetail.code_name = worksheet.Cells[i, 5].Text;
jobDetail.appointed_time = worksheet.Cells[i, 6].Text;
jobDetail.doc_no = worksheet.Cells[i, 7].Text;
jobDetail.place_send_job = worksheet.Cells[i, 8].Text;
jobDetail.send_company = worksheet.Cells[i, 9].Text;
jobDetail.remark = worksheet.Cells[i, 10].Text;
lstJobDetail.Add(jobDetail);
i++;
} while (worksheet.Cells[i, 1].Text != "");
//jobDetail.place_get_job2 = worksheet.Cells["A6"].Text;
//jobDetail.container_type2 = worksheet.Cells["B6"].Text;
//jobDetail.container_dim2 = worksheet.Cells["C6"].Text;
//jobDetail.cust_dest2 = worksheet.Cells["D6"].Text;
//jobDetail.code_name2 = worksheet.Cells["E6"].Text;
//jobDetail.appointed_time2 = worksheet.Cells["F6"].Text;
//jobDetail.doc_no2 = worksheet.Cells["G6"].Text;
//jobDetail.place_send_job2 = worksheet.Cells["H6"].Text;
//jobDetail.send_company2 = worksheet.Cells["I6"].Text;
//jobDetail.remark2 = worksheet.Cells["J6"].Text;
string tmp = worksheet.Cells["A7"].Text;
// genQR(job, jobDetail);
}
}