private void button2_Click(object sender, EventArgs e)
{
var file =
FileDialogHelper.SaveExcel(
$"{dateTimePicker1.Value.Date.ToString("yyyyMMdd") + "-" + dateTimePicker2.Value.Date.ToString("yyyyMMdd")}.xlsx");
if (string.IsNullOrEmpty(file))
{
return;
}
//var dt = (dataGridView1.DataSource as DataTable);
var dt = DataTableHelper.GetDgvToTable(dataGridView1);
try
{
string error;
AsposeExcelTools.DataTableToExcel2(dt, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError($"导出Excel出现错误：{error}");
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == DialogResult.Yes)
{
Process.Start(file);
}
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
private void btnExportBill_Click(object sender, EventArgs e)
{
//装备单据数据
DataTable dt = PrepareBillData();
#region 导出数据
try
{
SpecialDirectories sp = new SpecialDirectories();
string fileName = FileDialogHelper.SaveExcel(string.Format("入库单({0})", DateTime.Now.ToString("yyyy-MM-dd")), sp.Desktop);
if (string.IsNullOrEmpty(fileName))
{
return;
}
string outError = "";
AsposeExcelTools.DataTableToExcel2(dt, fileName, out outError);
if (!string.IsNullOrEmpty(outError))
{
MessageDxUtil.ShowError(outError);
LogTextHelper.Error(outError);
}
else
{
Process.Start(fileName);
}
}
catch (Exception ex)
{
MessageDxUtil.ShowError(ex.Message);
LogTextHelper.Error(ex);
}
#endregion
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
List <DepartmentInfo> list = CallerFactory <IDepartmentService> .Instance.FindAll();
DataTable dtNew = DataTableHelper.CreateTable("序号|int,Id,PID,Number,Name,SortCode,Type,Address,InnerPhone,OuterPhone,Remark,CompanyId,CompanyName,FoundDate,CloseDate,Creator,CreatorId,CreateTime,EditorId,Deleted,Enabled");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["Id"] = list[i].Id;
dr["PID"] = list[i].PID;
dr["Number"] = list[i].Number;
dr["Name"] = list[i].Name;
dr["SortCode"] = list[i].SortCode;
dr["Type"] = list[i].Type;
dr["Address"] = list[i].Address;
dr["InnerPhone"] = list[i].InnerPhone;
dr["OuterPhone"] = list[i].OuterPhone;
dr["Remark"] = list[i].Remark;
dr["FoundDate"] = list[i].FoundDate;
dr["CloseDate"] = list[i].CloseDate;
dr["Creator"] = list[i].Creator;
dr["CreatorId"] = list[i].CreatorId;
dr["CreateTime"] = list[i].CreateTime;
dr["EditorId"] = list[i].EditorId;
dr["Deleted"] = list[i].Deleted;
dr["Enabled"] = list[i].Enabled;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <WeightInfo> list = BLLFactory <Weight> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,车牌号|CarNo,车卡号|CardID,毛重|MzQty,皮重|PzQty,净重|NetQty,毛重衡器号|MZ_BalanceNo,毛重时间|MZ_Time,毛重方式|MZ_Type,毛重司磅员|MZ_Operator,皮重衡器号|PZ_BalanceNo,皮重时间|PZ_Time,皮重方式|PZ_Type,皮重司磅员|PZ_Operator,打印状态|PrintStatus,数据状态|DataStatus,备注|Remark,建立时间|InsertTime");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["车牌号"] = list[i].CarNo;
dr["车卡号"] = list[i].CardID;
dr["毛重"] = list[i].MzQty;
dr["皮重"] = list[i].PzQty;
dr["净重"] = list[i].NetQty;
dr["毛重衡器号"] = list[i].MZ_BalanceNo;
dr["毛重时间"] = list[i].MZ_Time;
dr["毛重方式"] = list[i].MZ_Type;
dr["毛重司磅员"] = list[i].MZ_Operator;
dr["皮重衡器号"] = list[i].PZ_BalanceNo;
dr["皮重时间"] = list[i].PZ_Time;
dr["皮重方式"] = list[i].PZ_Type;
dr["皮重司磅员"] = list[i].PZ_Operator;
dr["打印状态"] = list[i].PrintStatus;
dr["数据状态"] = list[i].DataStatus;
dr["备注"] = list[i].Remark;
dr["建立时间"] = list[i].InsertTime;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
if (!HasFunction("OperationLog/Export"))
{
MessageDxUtil.ShowError(Const.NoAuthMsg);
return;
}
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <OperationLogInfo> list = BLLFactory <OperationLog> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,登录用户ID,登录名,真实名称,所属公司ID,所属公司名称,操作表名称,操作类型,日志描述,IP地址,Mac地址,创建时间");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["登录用户ID"] = list[i].User_ID;
dr["登录名"] = list[i].LoginName;
dr["真实名称"] = list[i].FullName;
dr["所属公司ID"] = list[i].Company_ID;
dr["所属公司名称"] = list[i].CompanyName;
dr["操作表名称"] = list[i].TableName;
dr["操作类型"] = list[i].OperationType;
dr["日志描述"] = list[i].Note;
dr["IP地址"] = list[i].IPAddress;
dr["Mac地址"] = list[i].MacAddress;
dr["创建时间"] = list[i].CreateTime;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmOperationLog));
MessageDxUtil.ShowError(ex.Message);
}
}
}
public void ProcessRequest(HttpContext context)
{
HttpRequest request = System.Web.HttpContext.Current.Request;
string StartTime = request["StartTime"];
string EndTime = request["EndTime"];
int Flag = Convert.ToInt32(request["Flag"]); //按天，flag=2,按小时，flag=1
string st_no = request["st_no"];
string method = request["method"];
string JsonStr = "[]";
DataTable outtable;
if (string.IsNullOrWhiteSpace(method))
{
volumn_report_BLL.GetAddupProducts(method, StartTime, EndTime, Flag, st_no, out outtable);
//ExcelHelper.ExportDTtoExcel(outtable, "产量报表", HttpContext.Current.Request.MapPath("~/App_Data/产量报表.xlsx"));
if (outtable != null)
{
JsonStr = FunCommon.DataTableToJson(outtable);
}
context.Response.ContentType = "text/plain";
context.Response.Write(JsonStr);
context.Response.End();
}
else
{
//DataReader.GetAddupProducts(method, StartTime, EndTime, Flag, st_no, out outtable);
volumn_report_BLL.GetAddupProducts(method, StartTime, EndTime, Flag, st_no, out outtable);
if (outtable != null)
{
try
{
string fileName = HttpContext.Current.Request.MapPath("~/App_Data/产量报表.xlsx");
// ExcelHelper.ExportDTtoExcel(outtable, "产量报表", HttpContext.Current.Request.MapPath("~/App_Data/产量报表.xlsx"));
string err = "";
AsposeExcelTools.DataTableToExcel2(outtable, fileName, out err);
string ss = "true";
if (err.Length < 1)
{
ss = "true";
}
else
{
ss = "false";
}
JsonStr = ss;
}
catch
{
JsonStr = "false";
}
}
context.Response.ContentType = "json";
context.Response.Write(JsonStr);
context.Response.End();
}
}
private void NormalExport()
{
string columns = @"流水号,备注,供货商,操作员,库房名称,备件编号（pm码）,备件名称,图号,规格型号,材质,备件属类,备件类别,单位,最新单价（元）,出库数量,总价,出库日期,来源,库位,成本中心,使用位置";
DataTable dt = DataTableHelper.CreateTable(columns);
DataRow row = null;
for (int i = 0; i < this.lvwDetail.Items.Count; i++)
{
PurchaseDetailInfo info = this.lvwDetail.Items[i].Tag as PurchaseDetailInfo;
if (info != null)
{
row = dt.NewRow();
row["流水号"] = this.txtHandNo.Text;
row["备注"] = this.txtNote.Text;
row["供货商"] = this.txtManufacture.Text;
row["操作员"] = this.txtCreator.Text;
row["库房名称"] = this.txtWareHouse.Text;
row["备件编号（pm码）"] = info.ItemNo;
row["备件名称"] = info.ItemName;
row["图号"] = info.MapNo;
row["规格型号"] = info.Specification;
row["材质"] = info.Material;
row["备件属类"] = info.ItemBigType;
row["备件类别"] = info.ItemType;
row["单位"] = info.Unit;
row["最新单价（元）"] = info.Price.ToString("C2");
row["出库数量"] = info.Quantity.ToString();
row["总价"] = info.Amount.ToString("C2");
row["出库日期"] = this.txtCreateDate.DateTime.ToString();
row["来源"] = info.Source;
row["库位"] = info.StoragePos;
row["成本中心"] = this.txtCostCenter.Text;
row["使用位置"] = info.UsagePos;
dt.Rows.Add(row);
}
}
try
{
string fileName = FileDialogHelper.SaveExcel();
string outError = "";
AsposeExcelTools.DataTableToExcel2(dt, fileName, out outError);
if (!string.IsNullOrEmpty(outError))
{
MessageDxUtil.ShowError(outError);
LogTextHelper.Error(outError);
}
else
{
Process.Start(fileName);
}
}
catch (Exception ex)
{
MessageDxUtil.ShowError(ex.Message);
LogTextHelper.Error(ex);
}
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", "优惠券信息数据" + DateTime.Now.ToString("yyyyMMddHHmmss")));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <CouponInfo> list = BLLFactory <Coupon> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,优惠券序列号,分类名称,操作公司,创建人,创建人ID,创建时间,使用人,使用人ID,使用时间,联系电话,联系人,有效开始日期,有效结束日期,是否使用");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["优惠券序列号"] = list[i].ID;
dr["分类名称"] = list[i].CouponCategory_Name;
dr["操作公司"] = list[i].Company_Name;
dr["创建人"] = list[i].Creator;
dr["创建人ID"] = list[i].Creator_ID;
dr["创建时间"] = list[i].CreateTime;
dr["使用人"] = list[i].Editor;
dr["使用人ID"] = list[i].Editor_ID;
dr["使用时间"] = list[i].EditTime;
dr["联系电话"] = list[i].MobilePhone;
dr["联系人"] = list[i].FullName;
dr["有效开始日期"] = list[i].StartTime;
dr["有效结束日期"] = list[i].EndTime;
dr["是否使用"] = list[i].DELETED == 0?"否":"是";
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmCouponCategory));
MessageDxUtil.ShowError(ex.Message);
}
}
}
/// <summary>
/// 导出的操作
/// </summary>
private void ExportData()
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <物料ng替换记录表Info> list = BLLFactory <物料ng替换记录表> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,NG替换时间,物料生产批次号,设备ID,工序ID,工位号,物料GUID,替换前治具GUID,替换前治具RFID,替换前治具孔号,前治具生产批次号,替换后治具GUID,替换后治具RFID,替换后治具孔号,后治具生产批次号");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["NG替换时间"] = list[i].Ng替换时间;
dr["物料生产批次号"] = list[i].物料生产批次号;
dr["设备ID"] = list[i].设备id;
dr["工序ID"] = list[i].设备名称;
dr["工位号"] = list[i].工位号;
dr["物料GUID"] = list[i].物料guid;
dr["替换前治具GUID"] = list[i].替换前治具guid;
dr["替换前治具RFID"] = list[i].替换前治具rfid;
dr["替换前治具孔号"] = list[i].替换前治具孔号;
dr["前治具生产批次号"] = list[i].前治具生产批次号;
dr["替换后治具GUID"] = list[i].替换后治具guid;
dr["替换后治具RFID"] = list[i].替换后治具rfid;
dr["替换后治具孔号"] = list[i].替换后治具孔号;
dr["后治具生产批次号"] = list[i].后治具生产批次号;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <CardInfo> list = BLLFactory <Card> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,车卡号|CardID,车牌号|CarNo,司机|Driver,运输单位|TransportUnit,注册时间|RegisterTime,,过期时间|ExpireTime,操作员|Operator,货物种类|Goods,联系电话|TelNo,生成时间|InsertTime,数据状态|DataStatus,备注|Reamark");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["车卡号"] = list[i].CardID;
dr["车牌号"] = list[i].CarNo;
dr["司机"] = list[i].Driver;
dr["运输单位"] = list[i].TransportUnit;
dr["注册时间"] = list[i].RegisterTime;
dr["过期时间"] = list[i].ExpireTime;
dr["操作员"] = list[i].Operator;
dr["货物种类"] = list[i].Goods;
dr["联系电话"] = list[i].TelNo;
dr["生成时间"] = list[i].InsertTime;
dr["数据状态"] = list[i].DataStatus;
dr["备注"] = list[i].Reamark;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <LoginLogInfo> list = BLLFactory <LoginLog> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,登录用户ID,登录名,真实名称,所属公司ID,所属公司名称,日志描述,IP地址,Mac地址,更新时间,系统编号");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["用户Id"] = list[i].UserId;
dr["用户名"] = list[i].Name;
dr["登陆名"] = list[i].LoginName;
dr["公司Id"] = list[i].CompanyId;
//dr["公司名字"] = list[i].CompanyName;
dr["备注"] = list[i].Remark;
dr["IP地址"] = list[i].IP;
dr["Mac地址"] = list[i].Mac;
dr["最后更新时间"] = list[i].LastUpdateTime;
dr["系统编号"] = list[i].SystemtypeId;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmLoginLog));
MessageDxUtil.ShowError(ex.Message);
}
}
}
public void ProcessRequest(HttpContext context)
{//excel
HttpRequest request = System.Web.HttpContext.Current.Request;
string StartTime = request["StartTime"];
string EndTime = request["EndTime"];
int Flag = Convert.ToInt32(request["Flag"]);
string st_no = request["st_no"];
string method = request["method"];
if (string.IsNullOrWhiteSpace(method))
{
DataTable resTable = Time_ReportBLL.TimeProducts(StartTime, EndTime, Flag, st_no);
string JsonStr = "[]";
if (resTable != null)
{
JsonStr = FunCommon.DataTableToJson(resTable);
}
context.Response.ContentType = "text/plain";
context.Response.Write(JsonStr);
context.Response.End();
}
else
{
string json = "";
try
{
DataTable resTable = Time_ReportBLL.TimeProducts(StartTime, EndTime, Flag, st_no);
//ExcelHelper.ExportDTtoExcel(resTable, "", HttpContext.Current.Request.MapPath("~/App_Data/时间信息报表.xlsx"));
string fileName = HttpContext.Current.Request.MapPath("~/App_Data/时间信息报表.xlsx");
string err = "";
AsposeExcelTools.DataTableToExcel2(resTable, fileName, out err);
string ss = "true";
if (err.Length < 1)
{
ss = "true";
}
else
{
ss = "false";
}
json = ss;
}
catch
{
json = "false";
}
context.Response.ContentType = "json";
context.Response.Write(json);
}
}
//do the new excel document work using the background worker
private void bg_DoWork(object sender, DoWorkEventArgs e)
{
DataTable dtExport = this.dataSource;
if (TableToExport != null && isExportAllPage)
{
dtExport = TableToExport;
}
string outError = "";
AsposeExcelTools.DataTableToExcel2(dtExport, (String)e.Argument, out outError);
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
List <MenuInfo> list = BLLFactory <Menus> .Instance.GetAll();
DataTable dtNew = DataTableHelper.CreateTable("序号|int,父ID,显示名称,图标,排序,功能ID,菜单可见,Winform窗体类型,Web界面的菜单图标,Web界面Url地址,系统编号");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["父ID"] = list[i].PID;
dr["显示名称"] = list[i].Name;
dr["图标"] = list[i].Icon;
dr["排序"] = list[i].Seq;
dr["功能ID"] = list[i].FunctionId;
dr["菜单可见"] = list[i].Visible;
dr["Winform窗体类型"] = list[i].WinformType;
dr["Web界面的菜单图标"] = list[i].WebIcon;
dr["Web界面Url地址"] = list[i].Url;
dr["系统编号"] = list[i].SystemType_ID;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmMenu));
MessageDxUtil.ShowError(ex.Message);
}
}
}
/// <summary>
/// 使用背景线程导出Excel文档
/// </summary>
private void All_DoWork(object sender, DoWorkEventArgs e)
{
string where = "1=1";
PagerInfo info = new PagerInfo();
info.PageSize = int.MaxValue;
info.CurrenetPageIndex = 1;
DataTable table = FindToDataTable(where, info);
string outError = "";
string filePath = (String)e.Argument;
AsposeExcelTools.DataTableToExcel2(table, filePath, out outError);
e.Result = filePath;
}
/// <summary>
/// 导出的操作
/// </summary>
private void ExportData()
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <设备状态表Info> list = BLLFactory <设备状态表> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,发生时间,设备id,设备名称,设备状态,报警信息");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["发生时间"] = list[i].发生时间;
dr["设备id"] = list[i].设备id;
dr["设备名称"] = list[i].设备名称;
dr["设备状态"] = list[i].设备状态;
dr["报警信息"] = list[i].报警信息;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <AddressGroupInfo> list = BLLFactory <AddressGroup> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,排序序号,分组名称,备注");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["排序序号"] = list[i].Seq;
dr["分组名称"] = list[i].Name;
dr["备注"] = list[i].Remark;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmAddressGroup));
MessageDxUtil.ShowError(ex.Message);
}
}
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <ProcCardEmployeeInfo> list = BLLFactory <ProcCardEmployee> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,班组,姓名,代号");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["班组"] = list[i].TeamId;
dr["姓名"] = list[i].Name;
dr["代号"] = list[i].Code;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
public void Export(string type, string pd)
{
string ret = "";
try
{
ReportOP op = new ReportOP();
DataSet dsExport = null;
string strJson = Server.UrlDecode(Request["w"]);
//string strjson2 = Server.UrlDecode(pd);
List <I.MES.Models.WhereCondition> whereList;
List <I.MES.Models.ExportCell> whereList2;
if (!string.IsNullOrWhiteSpace(strJson))
{
whereList = strJson.ToEntities <List <I.MES.Models.WhereCondition> >();
whereList2 = pd.ToEntities <List <ExportCell> >();
dsExport = op.GetAllReport(whereList, whereList2, type);
}
Workbook workbook = AsposeExcelTools.DataTableToExcel2(dsExport.Tables[1]);
if (workbook != null)
{
this.DeleteDownLoadTempFile();
//直接导出
Stream outputStream = Response.OutputStream;
string filename = "/DownLoad/" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";
workbook.Save(Server.MapPath(filename), SaveFormat.Xlsx);
ret = filename;
}
}
catch (Exception ex)
{
throw ex;
}
// Response.Buffer = false;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx");
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentType = "application/vnd.ms-excel";
Response.Write(ret);
Response.Flush();
Response.End();
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <StaffInfo> list = CallerFactory <IStaffService> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,Id,Number,Name,Gender,Birthday,NativePlace,Nationality,IdentityCard,Phone,OfficePhone,Email,HomeAddress,Political,PartyDate,Education,Degree,WorkingDate,Marriage,ChildStatus,Titles,Duty,JobType,Introduce,Remark,AttachId,CompanyId,DepartmentId,PositionId,Creator,CreatorId,CreateTime,EditorId,Deleted,Enabled");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["Id"] = list[i].Id;
dr["Number"] = list[i].Number;
dr["Name"] = list[i].Name;
dr["Gender"] = list[i].Gender;
dr["Birthday"] = list[i].Birthday;
dr["NativePlace"] = list[i].NativePlace;
dr["Nationality"] = list[i].Nationality;
dr["IdentityCard"] = list[i].IdentityCard;
dr["Phone"] = list[i].Phone;
dr["OfficePhone"] = list[i].OfficePhone;
dr["Email"] = list[i].Email;
dr["HomeAddress"] = list[i].HomeAddress;
dr["Political"] = list[i].Political;
dr["PartyDate"] = list[i].PartyDate;
dr["Education"] = list[i].Education;
dr["Degree"] = list[i].Degree;
dr["WorkingDate"] = list[i].WorkingDate;
dr["Marriage"] = list[i].Marriage;
dr["ChildStatus"] = list[i].ChildStatus;
dr["Titles"] = list[i].Titles;
dr["Duty"] = list[i].Duty;
dr["JobType"] = list[i].JobType;
dr["Introduce"] = list[i].Introduce;
dr["Remark"] = list[i].Remark;
dr["AttachId"] = list[i].AttachId;
dr["CompanyId"] = list[i].CompanyId;
dr["DepartmentId"] = list[i].DepartmentId;
dr["PositionId"] = list[i].PositionId;
dr["Creator"] = list[i].Creator;
dr["CreatorId"] = list[i].CreatorId;
dr["CreateTime"] = list[i].CreateTime;
dr["EditorId"] = list[i].EditorId;
dr["Deleted"] = list[i].Deleted;
dr["Enabled"] = list[i].Enabled;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
/// <summary>
/// 导出的操作
/// </summary>
private void ExportData()
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <生产批次生成表Info> list = BLLFactory <生产批次生成表> .Instance.Find(where);
DataTable dtNew = DataTableHelper.CreateTable("序号|int,时间,班次,组装线体号,机种,镜框日期,镜筒模穴号,镜框批次,穴号105,穴号104,穴号102,日期105,日期104,日期102,角度,系列号,镜框投料数,隔圈模穴号113B,成型日113B,隔圈模穴号112,成型日112,隔圈投料数,G3来料供应商,G3镜片来料日期,G1来料供应商,G1来料日期,镜片105投料数,镜片104投料数,镜片G3投料数,镜片102投料数,镜片95B投料数,配对监控批次,计划投入数,上线数,下线数,状态,生成出的生产批次号");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["时间"] = list[i].时间;
dr["班次"] = list[i].班次;
dr["组装线体号"] = list[i].组装线体号;
dr["机种"] = list[i].机种;
dr["镜框日期"] = list[i].镜框日期;
dr["镜筒模穴号"] = list[i].镜筒模穴号;
dr["镜框批次"] = list[i].镜框批次;
dr["穴号105"] = list[i].穴号105;
dr["穴号104"] = list[i].穴号104;
dr["穴号102"] = list[i].穴号102;
dr["日期105"] = list[i].日期105;
dr["日期104"] = list[i].日期104;
dr["日期102"] = list[i].日期102;
dr["角度"] = list[i].角度;
dr["系列号"] = list[i].系列号;
dr["镜框投料数"] = list[i].镜框投料数;
dr["隔圈模穴号113B"] = list[i].隔圈模穴号113b;
dr["成型日113B"] = list[i].成型日113b;
dr["隔圈模穴号112"] = list[i].隔圈模穴号112;
dr["成型日112"] = list[i].成型日112;
dr["隔圈投料数"] = list[i].隔圈投料数;
dr["G3来料供应商"] = list[i].G3来料供应商;
dr["G3镜片来料日期"] = list[i].G3镜片来料日期;
dr["G1来料供应商"] = list[i].G1来料供应商;
dr["G1来料日期"] = list[i].G1来料日期;
dr["镜片105投料数"] = list[i].镜片105投料数;
dr["镜片104投料数"] = list[i].镜片104投料数;
dr["镜片G3投料数"] = list[i].镜片g3投料数;
dr["镜片102投料数"] = list[i].镜片102投料数;
dr["镜片95B投料数"] = list[i].镜片95b投料数;
dr["配对监控批次"] = list[i].配对监控批次;
dr["计划投入数"] = list[i].计划投入数;
dr["上线数"] = list[i].线数;
dr["下线数"] = list[i].线数;
dr["状态"] = list[i].状态;
dr["生成出的生产批次号"] = list[i].生产批次号;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogTextHelper.Error(ex);
MessageDxUtil.ShowError(ex.Message);
}
}
}
private void btnExportBill_Click(object sender, EventArgs e)
{
#region 准备数据
string columns = @"流水号,备注,供货商,操作员,库房名称,备件编号（pm码）,备件名称,图号,规格型号,材质,备件属类,备件类别,单位,最新单价（元）,入库数量,总价,入库日期,来源,库位,部门,使用位置";
DataTable dt = DataTableHelper.CreateTable(columns);
DataRow row = null;
for (int i = 0; i < this.lvwDetail.Items.Count; i++)
{
PurchaseDetailInfo info = this.lvwDetail.Items[i].Tag as PurchaseDetailInfo;
if (info != null)
{
row = dt.NewRow();
row["流水号"] = this.txtHandNo.Text;
row["备注"] = this.txtNote.Text;
row["供货商"] = this.txtManufacture.Text;
row["操作员"] = this.txtCreator.Text;
row["入库日期"] = this.txtCreateDate.DateTime.ToString();
row["库房名称"] = info.WareHouse;
row["备件编号（pm码）"] = info.ItemNo;
row["备件名称"] = info.ItemName;
row["图号"] = info.MapNo;
row["规格型号"] = info.Specification;
row["材质"] = info.Material;
row["备件属类"] = info.ItemBigType;
row["备件类别"] = info.ItemType;
row["单位"] = info.Unit;
row["最新单价（元）"] = info.Price.ToString("C2");
row["入库数量"] = info.Quantity.ToString();
row["总价"] = info.Amount.ToString("C2");
row["来源"] = info.Source;
row["库位"] = info.StoragePos;
row["部门"] = info.Dept;
row["使用位置"] = info.UsagePos;
dt.Rows.Add(row);
}
}
#endregion
#region 导出数据
try
{
SpecialDirectories sp = new SpecialDirectories();
string fileName = FileDialogHelper.SaveExcel(string.Format("入库单({0})", DateTime.Now.ToString("yyyy-MM-dd")), sp.Desktop);
if (string.IsNullOrEmpty(fileName))
{
return;
}
string outError = "";
AsposeExcelTools.DataTableToExcel2(dt, fileName, out outError);
if (!string.IsNullOrEmpty(outError))
{
MessageDxUtil.ShowError(outError);
LogTextHelper.Error(outError);
}
else
{
Process.Start(fileName);
}
}
catch (Exception ex)
{
MessageDxUtil.ShowError(ex.Message);
LogTextHelper.Error(ex);
}
#endregion
}
private void btnExportDetail_Click(object sender, EventArgs e)
{
if (this.winGridView1.gridView1.RowCount == 0)
{
return;
}
#region 构造数据列表
//HandNo,ItemNo,ItemName,MapNo,Specification,Material,ItemBigType,ItemType,Unit,Price,Quantity,Amount,Source,StoragePos,UsagePos,d.WareHouse,d.Dept
string columns = "货单号,项目编号,项目名称,图号,规格型号,材质,备件属类,备件类别,单位,单价|decimal,数量|int,金额|decimal,来源,库位,使用位置,库房,部门";
DataTable dtDetail = DataTableHelper.CreateTable(columns);
DataGridViewRow row;
for (int i = 0; i < winGridView1.gridView1.RowCount; i++)
{
string ID = this.winGridView1.gridView1.GetRowCellDisplayText(i, "ID");
if (!string.IsNullOrEmpty(ID))
{
DataTable dt = BLLFactory <PurchaseDetail> .Instance.GetPurchaseDetailReportByID(Convert.ToInt32(ID));
dt.Rows.Add(dt.NewRow());
//复制到中文列的表中
for (int k = 0; k < dt.Rows.Count; k++)
{
DataRow r = dtDetail.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
r[j] = dt.Rows[k][j];
}
dtDetail.Rows.Add(r);
}
}
}
#endregion
#region 导出数据操作
SpecialDirectories sp = new SpecialDirectories();
string fileToSave = FileDialogHelper.SaveExcel(string.Format("入库单明细({0})", DateTime.Now.ToString("yyyy-MM-dd")), sp.Desktop);
if (string.IsNullOrEmpty(fileToSave))
{
return;
}
try
{
string fileName = fileToSave;
string outError = "";
AsposeExcelTools.DataTableToExcel2(dtDetail, fileName, out outError);
if (!string.IsNullOrEmpty(outError))
{
MessageDxUtil.ShowError(outError);
LogTextHelper.Error(outError);
}
else
{
Process.Start(fileName);
}
}
catch (Exception ex)
{
MessageDxUtil.ShowError(ex.Message);
LogTextHelper.Error(ex);
}
#endregion
}
/// <summary>
/// 使用背景线程导出Excel文档
/// </summary>
private void bg_DoWork(object sender, DoWorkEventArgs e)
{
DataTable table = new DataTable();
if (AllToExport != null && isExportAllPage)
{
if (AllToExport is DataView)
{
DataView dv = (DataView)AllToExport;//默认导出显示内容
table = dv.ToTable();
}
else if (AllToExport is DataTable)
{
table = AllToExport as DataTable;
}
else
{
table = ReflectionUtil.CreateTable(AllToExport);
}
//解析标题
string originalName = string.Empty;
foreach (DataColumn column in table.Columns)
{
originalName = column.Caption;
if (columnNameAlias.ContainsKey(originalName.ToUpper()))
{
column.Caption = columnNameAlias[originalName.ToUpper()];
column.ColumnName = columnNameAlias[originalName.ToUpper()];
}
}
//for (int i = 0; i < this.gridView1.Columns.Count; i++)
//{
// if (!this.gridView1.Columns[i].Visible)
// {
// table.Columns.Remove(this.gridView1.Columns[i].FieldName);
// }
//}
}
else
{
DataColumn column;
DataRow row;
for (int i = 0; i < this.gridView1.Columns.Count; i++)
{
if (this.gridView1.Columns[i].Visible)
{
column = new DataColumn(this.gridView1.Columns[i].FieldName, typeof(string));
column.Caption = this.gridView1.Columns[i].Caption;
table.Columns.Add(column);
}
}
object cellValue = "";
string fieldName = "";
for (int i = 0; i < gridView1.RowCount; i++)
{
row = table.NewRow();
for (int j = 0; j < gridView1.Columns.Count; j++)
{
if (this.gridView1.Columns[j].Visible)
{
fieldName = gridView1.Columns[j].FieldName;
cellValue = gridView1.GetRowCellValue(i, fieldName);
row[fieldName] = cellValue ?? "";
}
}
table.Rows.Add(row);
}
}
string outError = "";
AsposeExcelTools.DataTableToExcel2(table, (String)e.Argument, out outError);
}
public void Export(HttpContext context)
{
string start_time = context.Request["start_time"];
string end_time = context.Request["end_time"];
string fl_id = context.Request["fl_id"];
int PageSize = Convert.ToInt32(context.Request["rows"]);
int PageIndex = Convert.ToInt32(context.Request["page"]);
StringBuilder commandText = new StringBuilder();
string where = "";
if (string.IsNullOrEmpty(start_time))
{
DateTime t = DateTime.Now;
start_time = t.ToString("yyyy-MM-dd HH:mm:ss");
}
string StartTime = start_time;
if (string.IsNullOrEmpty(end_time))
{
DateTime t = DateTime.Now;
end_time = t.ToString("yyyy-MM-dd HH:mm:ss");
}
string EndTime = end_time;
// DataListModel<Production_AlarmModel> userList = Production_AlarmTrendReport_BLL.GetWaringListNew(fl_id, StartTime, EndTime, StartIndex, EndIndex);
// string json = JSONTools.ScriptSerialize<DataListModel<Production_AlarmModel>>(userList);
string json = "";
string fileName = HttpContext.Current.Request.MapPath("~/App_Data/报警信息报表.xlsx");
try
{
int StartIndex = 1;
int EndIndex = -1;
int totalcount = 0;
DataTable resTable = Production_AlarmTrendReport_BLL.GetWaringDataTable(fl_id, StartTime, EndTime, StartIndex, EndIndex);
//ExcelHelper.ExportDTtoExcel(resTable, "报警信息报表", fileName);
string err = "";
AsposeExcelTools.DataTableToExcel2(resTable, fileName, out err);
string ss = "true";
if (err.Length < 1)
{
ss = "true";
}
else
{
ss = "false";
}
///
//////
json = "{\"Result\":\"" + ss + "\"}";
}
catch (Exception e)
{
string ss1 = "false";
json = "{\"Result\":\"" + ss1 + "\"}";
}
context.Response.ContentType = "json";
context.Response.Write(json);
}
void Export() //点检查询结果导出
{
string json = "";
DataTable ResTable = new DataTable();
JavaScriptSerializer s = new JavaScriptSerializer();
HttpRequest request = HttpContext.Current.Request;
string AssemblyLine = request.Params["fl_name"];
string Station = request.Params["st_no"];
string StartTime = request.Params["StartTime"];
string EndTime = request.Params["EndTime"];
int PageIndex = Convert.ToInt32(request["page"]);
int PageSize = Convert.ToInt32(request["rows"]);
string where = "";
if (!string.IsNullOrEmpty(AssemblyLine))
{
where = " and a.StationNO LIKE '" + AssemblyLine + "%'";
}
if (!string.IsNullOrEmpty(Station))
{
where = " and a.StationNO = '" + Station + "'";
}
if (!string.IsNullOrEmpty(StartTime))
{
where += " and cast(a.CreateTime as datetime) > '" + StartTime + "'";
}
if (!string.IsNullOrEmpty(EndTime))
{
where += " and cast(a.CreateTime as datetime) < '" + EndTime + "'";
}
int StartIndex = PageSize * (PageIndex - 1) + 1;
int EndIndex = StartIndex + PageSize - 1;
int totalcount;
ResTable = checkReport_BLL.getTableExcel(PageSize, PageIndex, StartIndex, EndIndex, sort, order, where, out totalcount);
//}
try
{
#region 导出代码
//ExcelHelper.ExportDTtoExcel(ResTable, "", HttpContext.Current.Request.MapPath("~/App_Data/点检记录报表.xlsx"));
string fileName = HttpContext.Current.Request.MapPath("~/App_Data/点检记录报表.xlsx");
string err = "";
AsposeExcelTools.DataTableToExcel2(ResTable, fileName, out err);
string ss = "true";
if (err.Length < 1)
{
ss = "true";
}
else
{
ss = "false";
}
json = ss;
#endregion
}
catch
{
json = "false";
}
Response.Write(json);
}
/// <summary>
/// 导出Excel的操作
/// </summary>
private void btnExport_Click(object sender, EventArgs e)
{
string file = FileDialogHelper.SaveExcel(string.Format("{0}.xls", moduleName));
if (!string.IsNullOrEmpty(file))
{
string where = GetConditionSql();
List <AddressInfo> list = new List <AddressInfo>();
TreeNode selectedNode = this.treeView1.SelectedNode;
if (isUserGroupName && selectedNode != null)
{
string groupName = "";
//只有是数据库的分组才使用条件
if (selectedNode.Text != "所有联系人" && selectedNode.Text != "未分组联系人")
{
groupName = this.treeView1.SelectedNode.Text;
}
list = BLLFactory <Address> .Instance.FindByGroupName(LoginUserInfo.Id, groupName);
}
else
{
list = BLLFactory <Address> .Instance.Find(where);
}
DataTable dtNew = DataTableHelper.CreateTable("序号|int,姓名,性别,出生日期,手机,电子邮箱,QQ,家庭电话,办公电话,家庭住址,办公地址,传真号码,公司单位,部门,职位,其他,备注,创建人,创建时间");
DataRow dr;
int j = 1;
for (int i = 0; i < list.Count; i++)
{
dr = dtNew.NewRow();
dr["序号"] = j++;
dr["姓名"] = list[i].Name;
dr["性别"] = list[i].Gender;
dr["出生日期"] = list[i].Birthday;
dr["手机"] = list[i].MobilePhone;
dr["电子邮箱"] = list[i].Email;
dr["QQ"] = list[i].QQ;
dr["家庭电话"] = list[i].HomePhone;
dr["办公电话"] = list[i].OfficePhone;
dr["家庭住址"] = list[i].HomeAddress;
dr["办公地址"] = list[i].OfficeAddress;
dr["传真号码"] = list[i].Fax;
dr["公司单位"] = list[i].CompanyName;
dr["部门"] = list[i].DeptName;
dr["职位"] = list[i].WorkPosition;
dr["其他"] = list[i].Other;
dr["备注"] = list[i].Remark;
dr["创建人"] = list[i].CreatorId;
dr["创建时间"] = list[i].CreatorTime;
dtNew.Rows.Add(dr);
}
try
{
string error = "";
AsposeExcelTools.DataTableToExcel2(dtNew, file, out error);
if (!string.IsNullOrEmpty(error))
{
MessageDxUtil.ShowError(string.Format("导出Excel出现错误：{0}", error));
}
else
{
if (MessageDxUtil.ShowYesNoAndTips("导出成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(file);
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmAddress));
MessageDxUtil.ShowError(ex.Message);
}
}
}
public void ProcessRequest(HttpContext context)
{
HttpRequest request = System.Web.HttpContext.Current.Request;
string StartTime = request["start_time"];
string EndTime = request["end_time"];
string clnameid = request["clnameid"];
string method = context.Request["method"];
int PageSize = Convert.ToInt32(request["rows"]);
int PageIndex = Convert.ToInt32(request["page"]);
string SortFlag = request["sort"];
string sortOrder = request["order"];
string where = "";
if (!string.IsNullOrEmpty(StartTime))
{
where += " and cl_starttime>='" + StartTime + "'";
}
if (!string.IsNullOrEmpty(EndTime))
{
where += " and cl_endtime<='" + EndTime + "'";
}
if (!string.IsNullOrEmpty(clnameid))
{
where += " and cl_name like'%" + clnameid + "%'";
}
int totalcount;
DataTable resTable = new DataTable();
sort = SortFlag;
order = sortOrder;
int StartIndex = PageSize * (PageIndex - 1) + 1;
int EndIndex = StartIndex + PageSize - 1;
if (string.IsNullOrEmpty(method))
{
resTable = FTT_BLL.getTable(PageSize, PageIndex, StartIndex, EndIndex, sort, order, where, out totalcount);
string JsonStr = FunCommon.DataTableToJson2(totalcount, resTable);
context.Response.ContentType = "text/plain";
context.Response.Write(JsonStr);
context.Response.End();
}
if (method == "Export")
{
string json = "";
string fileName = HttpContext.Current.Request.MapPath("~/App_Data/FTT数据查询.xlsx");
try
{
string err = "";
StartIndex = 1;
EndIndex = -1;
totalcount = 0;
resTable = FTT_BLL.getTableExcel(PageSize, PageIndex, StartIndex, EndIndex, sort, order, where, out totalcount);
// ExcelHelper.ExportDTtoExcel(resTable, "生产线报警趋势报表", fileName);
AsposeExcelTools.DataTableToExcel2(resTable, fileName, out err);
string ss = "true";
if (err.Length < 1)
{
ss = "true";
}
else
{
ss = "false";
}
json = "{\"Result\":\"" + ss + "\"}";
}
catch (Exception e)
{
string ss1 = "false";
json = "{\"Result\":\"" + ss1 + "\"}";
}
context.Response.ContentType = "json";
context.Response.Write(json);
}
}
public void ProcessRequest(HttpContext context)
{
JavaScriptSerializer s = new JavaScriptSerializer();
HttpRequest request = HttpContext.Current.Request;
string StartTime = request["StartTime"];
string EndTime = request["EndTime"];
string OrderCode = request["OrderCode"];
string StationNo = request["StationNo"];
string method = request["method"];
if (string.IsNullOrEmpty(StartTime))
{
DateTime t = DateTime.Now.AddMonths(-1);
StartTime = t.ToString("yyyy-MM-dd HH:mm:ss");
}
if (string.IsNullOrEmpty(EndTime))
{
DateTime t = DateTime.Now;
EndTime = t.ToString("yyyy-MM-dd HH:mm:ss");
}
if (OrderCode == "请选择")
{
OrderCode = "";
}
if (StationNo == "请选择")
{
StationNo = "FSA210";
}
int totalcount;
string JsonStr = "";
DateTime date = DateTime.Now;
string JsonStr3 = "";
string neirong = "";
string yee = "";
int PageIndex = Convert.ToInt32(request["page"]);
int PageSize = Convert.ToInt32(request["rows"]);
if (string.IsNullOrWhiteSpace(method))
{
JsonStr3 = checkRepair_BLL.getTableString(StartTime, EndTime, OrderCode, StationNo, PageIndex, out totalcount);
context.Response.ContentType = "json";
context.Response.Write(JsonStr3);
}
else if (method == "GetListNew")
{
JsonStr3 = checkRepair_BLL.GetListNew(StartTime, EndTime, OrderCode, StationNo, PageIndex, PageSize, out totalcount);
context.Response.ContentType = "json";
context.Response.Write(JsonStr3);
}
#region 导出代码
else if (method == "Export")
{
DataTable ResTable4 = checkRepair_BLL.getTableExcel(StartTime, EndTime, OrderCode, StationNo, PageIndex, out totalcount);
string str = "";
try
{
// ExcelHelper.ExportDTtoExcel(ResTable4, "", HttpContext.Current.Request.MapPath("~/App_Data/检测返修报表.xlsx"));
AsposeExcelTools.DataTableToExcel2(ResTable4, HttpContext.Current.Request.MapPath("~/App_Data/检测返修报表.xlsx"), out str);
if (str.Length < 1)
{
JsonStr3 = "true";
}
else
{
JsonStr3 = "false";
}
}
catch
{
JsonStr3 = "false";
}
context.Response.ContentType = "json";
context.Response.Write(JsonStr3);
}
#endregion
}
public void Export(HttpContext context)
{
string start_time = context.Request["start_time"];
string end_time = context.Request["end_time"];
int PageSize = Convert.ToInt32(context.Request["rows"]);
int PageIndex = Convert.ToInt32(context.Request["page"]);
StringBuilder commandText = new StringBuilder();
string where = "";
if (string.IsNullOrEmpty(start_time))
{
DateTime t = DateTime.Now.AddMonths(-1);
start_time = t.ToString("yyyy-MM-dd");
}
string StartTime = start_time.Substring(0, 10);
if (string.IsNullOrEmpty(end_time))
{
DateTime t = DateTime.Now;
end_time = t.ToString("yyyy-MM-dd");
}
string EndTime = end_time.Substring(0, 10);
string sidx = RequstString("sidx"); //排序名称
string sort = RequstString("sord"); //排序方式
if ("-1" == sort)
{
sort = "id";
}
if ("-1" == order)
{
order = "asc";
}
string err = "";
string json = "";
string fileName = HttpContext.Current.Request.MapPath("~/App_Data/生产线报警趋势报表.xlsx");
try
{
int StartIndex = 1;
int EndIndex = -1;
int totalcount = 0;
DataTable resTable = Production_AlarmTrendReport_BLL.getTable(StartTime, EndTime, PageSize, StartIndex, EndIndex, sort, order, where, out totalcount);
// ExcelHelper.ExportDTtoExcel(resTable, "生产线报警趋势报表", fileName);
AsposeExcelTools.DataTableToExcel2(resTable, fileName, out err);
string ss = "true";
if (err.Length < 1)
{
ss = "true";
}
else
{
ss = "false";
}
json = "{\"Result\":\"" + ss + "\"}";
}
catch (Exception e)
{
string ss1 = "false";
json = "{\"Result\":\"" + ss1 + "\"}";
}
context.Response.ContentType = "json";
context.Response.Write(json);
}