protected void imgDaochu_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
// CSid Rid CusID Cid Destination Kilo Price Resdate IsSet Remark
if (GridView1.Visible == true)
{
Register.Add("Rid", "面单号");
Register.Add("Destination", "目的地");
Register.Add("Kilo", "公斤数");
Register.Add("Price", "运费");
Register.Add("Resdate", "揽件时间");
OutExcelHelper.ExportExcel(allInfo, "无头件信息.xls", Register);
}
Register.Add("CSid", "编号");
Register.Add("Rid", "面单号");
Register.Add("customer", "客户名称");
Register.Add("carriecompany", "公司名称");
Register.Add("Destination", "目的地");
Register.Add("Kilo", "公斤数");
Register.Add("Price", "运费");
Register.Add("Resdate", "揽件时间");
Register.Add("IsSet", "是否结算");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allInfo, "客户发件表.xls", Register);
}
public string OnlineExportData(ExportDataModel exp)
{
EasyMan.Dtos.ErrorInfo err = new EasyMan.Dtos.ErrorInfo();
err.IsError = false;
try
{
//非压缩导出
string strFileName = exp.FileName;
//lngDbServerId = (long)exp.DbServerId;
strMapPathAll = "";
strPathAll = "";
string strPath = exp.FilePath;
Easyman.Common.Fun.GetPath(ref strFileName, exp.FileFormat, ref strMapPathAll, ref strPath);//重新整理保存路径
#region 表结果dt
DataTable dt = new DataTable();
if (exp.DbServerId == null)
{
dt = DbHelper.ExecuteGetTable(exp.Sql);
}
else
{
dt = _dbServerAppService.ExecuteGetTable((int)exp.DbServerId, exp.Sql); //要导出的数据集
}
#endregion
string ColumnHeader = "";
switch (exp.FileFormat.ToLower())
{
case ".xlsx":
ColumnHeader = GetHeadStr(exp.TopFields); //将表头对像转成字符串
OutExcelHelper.ExportExcel(dt, strFileName, strMapPathAll, ColumnHeader, true);
break;
case ".csv":
OutExcelHelper.ExportCsv(dt, strFileName, strMapPathAll, ColumnHeader, true);
break;
case ".txt":
OutExcelHelper.ExportTxt(dt, strFileName, strMapPathAll, ColumnHeader, true);
break;
default:
ColumnHeader = GetHeadStr(exp.TopFields); //将表头对像转成字符串
OutExcelHelper.ExportExcel(dt, strFileName, strMapPathAll, ColumnHeader, true);
break;
}
exp.FileName += exp.FileFormat;
SavaDBSql(strPath, strMapPathAll, exp);
return(strPath);
}
catch (Exception ex)
{
err.IsError = true;
err.Message = ex.Message;
throw;
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
// DelID CusID DelUnitPrice Remark
Register.Add("DelID", "编号");
Register.Add("customer", "客户姓名");
Register.Add("DelUnitPrice", "送货单价");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allInfo, "送货价格表.xls", Register);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
// UID LoginId Password Telephone Email Question AKey Remark
Register.Add("UID", "编号");
Register.Add("LoginId", "用户名");
Register.Add("Telephone", "电话");
Register.Add("Email", "邮箱");
Register.Add("Question", "密报问题");
Register.Add("AKey", "问题答案");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allInfo, "管理员信息.xls", Register);
}
protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
// IAEid CusID IAEDate IAEName Price ISsettle Remark
Register.Add("IAEid", "编号");
Register.Add("customer", "客户姓名");
Register.Add("IAEDate", "收支日期");
Register.Add("IAEName", "费用名称");
Register.Add("ISsettle", "是否结算");
Register.Add("Price", "金额");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allInfo, "其他费用表.xls", Register);
}
//导出表格
protected void imgDaochu_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
// CusID CusName CusTel IsCounterman Remark
Register.Add("CusID", "客户ID");
Register.Add("CusName", "客户姓名");
Register.Add("CusTel", "联系电话");
Register.Add("IsCounterman", "是否为业务员");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allCustomers, "客户信息.xls", Register);
}
protected void imgDaochu_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
// Cid CoName Clinkman LinkmanTel Cmoney Remark
Register.Add("Cid", "公司ID");
Register.Add("CoName", "公司名称");
Register.Add("Clinkman", "联系人");
Register.Add("LinkmanTel", "联系电话");
Register.Add("Cmoney", "面单费");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allCompany, "公司信息.xls", Register);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
// Rid Cid BeginNo EndNo Buydate Remark
Register.Add("Rid", "编号");
Register.Add("CCompany", "公司名称");
Register.Add("BeginNo", "面单起始号");
Register.Add("EndNo", "面单结束号");
Register.Add("Buydate", "购买时间");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allInfo, "面单购入表.xls", Register);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
// CEid CusID ECount EAllPrice ISsettle EDate Remark
Register.Add("CEid", "编号");
Register.Add("Ccustomer", "客户姓名");
Register.Add("ECount", "派送个数");
Register.Add("EAllPrice", "派件邮费");
Register.Add("ISsettle", "是否结算");
Register.Add("EDate", "派件年月");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allInfo, "客户送件表.xls", Register);
}
protected void imgDaochu_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
// Cpid CusID Cid PNo CpName Remark
Register.Add("Cpid", "编号");
Register.Add("customer", "客户名称");
Register.Add("carriecomapny", "公司名称");
Register.Add("PNo", "模板编号");
Register.Add("CpName", "模板名称");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allInfo, "客户价格表.xls", Register);
}
protected void imgDaochu_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
//Aid CusID Cid CSid Price ISsettle BeginDate Remark
Register.Add("Nid", "编号");
Register.Add("cust", "客户名称");
Register.Add("company", "公司名称");
Register.Add("CSid", "面单号");
Register.Add("Price", "金额");
Register.Add("ISsettle", "是否已结算");
Register.Add("BeginDate", "起运时间");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allInfo, "面单分配表.xls", Register);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
//Nid CusID Cid BeginNO EndNo Dtime Sum IsSet Remark
Register.Add("Nid", "编号");
Register.Add("Customer", "客户名称");
Register.Add("CarrieCompany", "公司名称");
Register.Add("BeginNo", "面单起始号");
Register.Add("EndNo", "面单结束号");
Register.Add("Dtime", "分配时间");
Register.Add("Sum", "金额");
Register.Add("IsSet", "是否已结算");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allInfo, "面单分配表.xls", Register);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Dictionary <string, string> Register = new Dictionary <string, string>();
Register.Add("CPid", "编号");
Register.Add("customer", "客户姓名");
Register.Add("DateMon", "费用年月");
Register.Add("OddMon", "面单费用");
Register.Add("SendMon", "发件费");
Register.Add("GiveMon", "送件费");
Register.Add("BackMon", "收到付件返利");
Register.Add("AccMon", "派到付件款");
Register.Add("OtherMon", "其他费用");
Register.Add("AllMon", "总计");
Register.Add("ISsettle", "是否结款");
Register.Add("Remark", "备注");
OutExcelHelper.ExportExcel(allInfo, "结算.xls", Register);
}
/// <summary>
/// 多线程执行体
/// </summary>
/// <param name="exp"></param>
private static void OutExportFile(object exp)
{
ExportDataModel ExportDataM = (ExportDataModel)exp;
DataTable dt = (DataTable)ExportDataM.ObjParam;
switch (ExportDataM.FileFormat.ToLower())
{
case ".xlsx":
OutExcelHelper.ExportExcel(dt, ExportDataM.FileName, ExportDataM.FilePath, ExportDataM.ColumnHeader, false);
break;
case ".csv":
OutExcelHelper.ExportCsv(dt, ExportDataM.FileName, ExportDataM.FilePath, ExportDataM.ColumnHeader, false);
break;
case ".txt":
OutExcelHelper.ExportTxt(dt, ExportDataM.FileName, ExportDataM.FilePath, ExportDataM.ColumnHeader, false);
break;
default:
OutExcelHelper.ExportExcel(dt, ExportDataM.FileName, ExportDataM.FilePath, ExportDataM.ColumnHeader, false);
break;
}
}
