public void exeout(string procInstID)
{
//0:最后经办人邮箱,1:导出人邮箱
string MasterFile = ConfigurationManager.AppSettings["MasterFile"];
IWorkbook workbook = null;
#region 加载打开已有EXCEL
ISheet sheet = null;
//FileStream fs = new FileStream("资金业务付款流程导出模板2022.xlsx", FileMode.OpenOrCreate, FileAccess.ReadWrite);
var fileName = MasterFile;
string extension = Path.GetExtension(fileName);//取文件后缀名
using (FileStream tempfs = new FileStream(base.Server.MapPath("~/UploadFiles/"+ MasterFile), FileMode.Open, FileAccess.Read))
{
if (fileName.IndexOf(".xlsx") > 0|| fileName.IndexOf(".XLSX") > 0) // 2007版本
workbook = new XSSFWorkbook(tempfs);
else if (fileName.IndexOf(".xls") > 0 || fileName.IndexOf(".XLS") >0) // 2003版本
workbook = new HSSFWorkbook(tempfs);
}
if (workbook != null)
{
sheet = workbook.GetSheetAt(0);
}
#endregion
string[] ProcInstIDList = null;
ProcInstIDList = procInstID.Split(',');
#region 写入数据并导出
int rowIndex = 6;//默认从第七行开始写入数据
//当期导出人邮箱
IHrPerson userinfo = BaseModelManager.HrPersonDAO.RetrieveInstanceByUserId(this.CurrentUserId);
string strwhere = "";
string format = " and ID in({0}) and Topic like '%{1}%' ";
strwhere = string.Format(format, procInstID.TrimEnd(','), "资金业务相关付款");
//取
IList<IFlowInst> flowinstlist = BPMModelManager.FlowInstDAO.RetrieveListByWhere(strwhere);
if (flowinstlist != null && flowinstlist.Count > 0)
{
foreach (var item in flowinstlist)
{
try
{
string Originator = item.Originator.ToString();
int indexcount = Originator.IndexOf("\\");
# region 当前流程最后一个审批人邮箱,如果无值用申请人
string jobwhere = "";
string jobformat = " and ProcInstID ={0} and ActivityK2Name<>'' order by ID desc ";
jobwhere = string.Format(jobformat, procInstID.TrimEnd(','));
IHrPerson itemuserinfo = BaseModelManager.HrPersonDAO.Retrie