public static void Export(string id, string path, string userid)
{
MSExcelUtil msExcelUtil = new MSExcelUtil();
Workbook workbook = msExcelUtil.OpenExcelByMSExcel(path);
Worksheet sheet = workbook.ActiveSheet;
try
{
service.ConstractTemplateDtlDelete(new ConstractTemplateDtl()
{
ConstractTemplateId = int.Parse(id)
});
int maxRow = 100000;
int startRowIndex = 2;
while (true)
{
string type = msExcelUtil.GetCellValue(sheet, 1, startRowIndex);
string content = msExcelUtil.GetCellValue(sheet, 2, startRowIndex);
if (string.IsNullOrWhiteSpace(type))
{
break;
}
type = type.Trim();
ConstractTemplateDtl constractTemplateDtl = new ConstractTemplateDtl();
constractTemplateDtl.ConstractTemplateId = int.Parse(id);
constractTemplateDtl.InDateTime = DateTime.Now;
constractTemplateDtl.InUserId = userid;
constractTemplateDtl.OrderNO = 0;
if (fixContentArray.Contains(type))
{
constractTemplateDtl.ContentType = "固定内容";
constractTemplateDtl.ContentType2 = type;
}
else
{
constractTemplateDtl.ContentType = type;
constractTemplateDtl.TemplateContent = content;
}
service.ConstractTemplateDtlSave(constractTemplateDtl);
startRowIndex++;
if (startRowIndex > maxRow)
{
break;
}
}
}
catch (Exception ex)
{
Utils.log(ex.ToString());
}
msExcelUtil.dispose();
}
public ActionResult DeleteConstractTemplateDtl(ConstractTemplateDtl dtl)
{
service.ConstractTemplateDtlDelete(dtl);
return(Json(""));
}
