//요율표 저장 public string setBaseOutPutRate(BaseOutPutRateModels model, out string error_str) { error_str = ""; CommFunction comModel = new CommFunction(); DataTable data = comModel.getUploadExcelData(model.File.FILE, out error_str); if (error_str != "") { return(error_str); } //유효성 검사 double test = 0; if (data != null && data.Rows.Count != 0) { for (int i = 0; i < data.Rows.Count; i++) { try { test = Convert.ToDouble(data.Rows[i][0].ToString().Trim()); test = Convert.ToDouble(data.Rows[i][1].ToString().Trim()); } catch { error_str = "[" + i + "] 행에 문제가 있습니다."; return(error_str); } } } List <string> exeQueryList = new List <string>(); List <string> linqList = new List <string>(); string exeQueryStr = " INSERT INTO conf_customs_fee (EST_CODE, NATION_CODE, RELEASE_CODE, WEIGHT, CUSTOMS_FEE ) VALUES "; if (data != null && data.Rows.Count != 0) { for (int i = 0; i < data.Rows.Count; i++) { linqList.Add("( '00000', '" + model.Item.NATION_CODE + "', '" + model.Item.RELEASE_CODE + "', " + data.Rows[i][0].ToString().Trim() + " , " + data.Rows[i][1].ToString().Trim() + " )"); } } exeQueryStr += string.Join(",", linqList); exeQueryList.Add("DELETE FROM conf_customs_fee WHERE EST_CODE = '00000' AND NATION_CODE = '" + model.Item.NATION_CODE + "' AND RELEASE_CODE = '" + model.Item.RELEASE_CODE + "'"); exeQueryList.Add(exeQueryStr); exeQuery(exeQueryList, out error_str); return(error_str); }