/// <summary>
/// 导出execl
/// </summary>
/// <param name="execlModel"></param>
/// <returns></returns>
public List <UserReferDetail> ExportExeclss(ExportExeclModel execlModel)
{
bool result = false;
List <UserReferDetail> list = null;
//查询数据
var req = Mapper.Map <ExportExeclModel, QueryUserReferListRequest>(execlModel);
var userReferResult = OpcClient.Send <QueryUserReferListResponse>(req);
if (userReferResult.DoFlag)
{
list = Mapper.MappGereric <User_ReferExt, UserReferDetail>(userReferResult.ReferDos);
}
return(list);
}
/// <summary>
/// 导出execl
/// </summary>
/// <param name="execlModel"></param>
/// <returns></returns>
public JsonResult ExportExecl(ExportExeclModel execlModel)
{
var result = new BaseResponse();
List <UserReferDetail> list = null;
//查询数据
list = UserReferClient.Instance.ExportExeclss(execlModel);
try
{
string strFile = "咨询管理-" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".csv"; //生成的Excel名称
StringBuilder sb = new StringBuilder();
sb.Append("编号,用户编号,商品编号,商品名称,咨询内容.,咨询类型,咨询日期,回复内容,回复人,回复日期,是否可见");
sb.AppendLine();
if (list != null && list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
sb.Append(list[i].IntReferID + "," + list[i].IntUserID + "," + list[i].IntProductID + "," +
list[i].VchProductName + "," + list[i].VchContent + "," + list[i].IntReferType +
"," +
list[i].DtDatetime + "," + list[i].VchReplyContent + "," + list[i].VchReplyPerson +
"," + list[i].DtReplyDatetime + "," + list[i].IntOtherIsVisible);
sb.AppendLine();
}
}
StringWriter sw = new StringWriter(sb);
Response.Clear();
Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", "e:\\" + strFile));
Response.ContentType = "text/xml";
Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.Write(sw);
Response.Flush();
Response.End();
sw.Close();
result.DoFlag = true;
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}