//创建文件
using (var fileStream = new FileStream(context.Server.MapPath(uploadpath), FileMode.Create))
{
_hssfworkbook.Write(fileStream);
fileStream.Close();
}
filePath = uploadpath;
return true;
}
调用过程
====================================
string filePath;
var data = SHelper.Search(string.Format(@"select name,cardno,sex,
birthday=CONVERT(varchar(6), birthday, 112),
insurance_begindate=CONVERT(varchar(6), insurance_begindate, 112),
用工形式='合同',在岗状况='在岗',婚姻状况='',生育状况='',月工资=declare_base,通讯地址='建设西路11号',联系电话='55199320',变更原因=''
from [dbo].[ss_member]
where deleteflag=0
and id in ({0})", ids));
var parms = new Dictionary<string, object>();
parms.Clear();