//요율표 저장
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);
}