public IActionResult Excel()
{
List <List <string[]> > title = new List <List <string[]> >();
title.Add(new List <string[]>()
{
new string[2] {
"XX公司", "@"
}
});
title.Add(new List <string[]>()
{
new string[2] {
"員工", "@"
}
});
title.Add(new List <string[]>()
{
new string[2] {
"部門", "@"
},
new string[2] {
"人事部", "@"
}
});
var dto = DataToExcel.DataToExcelDataType(employees, title, new string[]
{ nameof(Employee.Id),
nameof(Employee.Name),
nameof(Employee.Salary),
nameof(Employee.Seniority),
nameof(Employee.Currency) });
return(DataToExcel.ToExcel(this, dto, "XX公司-員工表", "員工表"));
}
private void ToExcel()
{
if (Session["DataTables"] == null)
{
this.RegisterStartupScript("无结果", "<script>alert('请先进行统计！');</script>");
return;
}
Dictionary <string, DataTable> dataTables = Session["DataTables"] as Dictionary <string, DataTable>;
if (dataTables == null)
{
this.RegisterStartupScript("无结果", "<script>alert('请先进行统计！');</script>");
return;
}
try
{
DataToExcel dte = new DataToExcel();
dte.DataGridViewToExcel(dataTables);
}
catch (Exception ex)
{
SeatManage.SeatManageComm.WriteLog.Write(ex.ToString());
}
}
void ExpoertExcel()
{
//Response.Write("<script>CallWriteExportStat('12');</script>");
//Response.Write("<script>CallWriteExportStat(12,35)</script>");
//Page.ClientScript.RegisterClientScriptBlock(this.GetType(),"xx","alert('12');");
// return;
string condtion = GetCondtion();
string sql = @"select
(select module_name from module_info where id = (select exami_module from exam_layout where id = b.layout_id)) as module_name,
(select user_name from user_info where id =b.user_id ) as user_name,
(select user_sex from user_info where id = b.user_id) as user_sex,
b.user_card,
(select work_name from work_info where id = b.work_id) as work_name,
(select exami_name from exam_layout where id = b.layout_id ) as exami_name,
b.score from exami_info b";
//计算统计总数，总分页数
DataTable Art_Table = DataCenter.Instans.SearchTb(string.Format("select count(id) as ct from exami_info b {0}", condtion));
int Datacount = int.Parse(Art_Table.Rows[0]["ct"].ToString());
double dx = ((double)Datacount / EvPage);
int SumPage = (int)Math.Ceiling(dx);//总页数
//组合导出条件
var item = new ExportContion()
{
sql = sql, condtion = condtion, DataCount = Datacount, SumPage = SumPage, EvePage = EvPage
};
DataToExcel.ExportExcelTemplate(item, ExcelPath, "公考成绩查询统计表", 3, 1, "", "", "");
}
//public Vector3 Update(Vector3 in_to_target, float in_time)
//{
// float prev_vel = _velocity;
// shift = _velocity * in_time + _acceleration * in_time * in_time / 2;
// _velocity += _acceleration * in_time;
// _current_time += in_time;
// float time_left = _time_to_approach / 2 - _current_time;
// //if (in_to_target.magnitude <= 0.01f)
// // return Vector3.negativeInfinity;
// if (time_left >= 0.00001f && !Mathf.Approximately(time_left, 0f))
// {
// _acceleration = CalculateAcceleration((in_to_target - _initial_distance / 2).magnitude, _velocity, time_left);
// Debug.Log(string.Format("ACCELERATION Time Left = {0}; Velocity = {1}, Acceleration = {2}, Shift = {3}, Distance to Target = {4}",
// time_left, _velocity, _acceleration, shift, (in_to_target - _initial_distance / 2).magnitude));
// }
// else
// {
// if (!_initial_velocity_to_deaccelerate.HasValue)
// _initial_velocity_to_deaccelerate = _velocity;
// time_left = _time_to_approach / 2 + time_left;
// _acceleration = CalculateDeaccelerationDistance(_initial_velocity_to_deaccelerate.Value, _time_to_approach / 2);
// Debug.Log(string.Format("DEACCELERATION Time Left = {0}; Velocity = {1} [{5}], Acceleration = {2}, Shift = {3}, Distance to Target = {4}",
// time_left, _velocity, _acceleration, shift, in_to_target.magnitude, prev_vel));
// }
// return shift * in_to_target.normalized;
//}
public Vector3 Update(float in_time, Vector3 cur_pos, Vector3 end_pos)
{
_current_time += in_time;
float time_left = _time_to_approach / 2 - _current_time;
//return WeightedAverage(cur_pos, end_pos, 3f);
float new_pos_x = SmoothMovement(in_time, cur_pos.x, end_pos.x, ref _velocity_vector.x, time_left, _max_velocity);
float new_pos_y = SmoothMovement(in_time, cur_pos.y, end_pos.y, ref _velocity_vector.y, time_left, _max_velocity);
float new_pos_z = SmoothMovement(in_time, cur_pos.z, end_pos.z, ref _velocity_vector.z, time_left, _max_velocity);
_velocity_vector = new Vector3(_velocity_vector.x, _velocity_vector.y, _velocity_vector.z);
Vector3 new_pos = new Vector3(new_pos_x, new_pos_y, new_pos_z);
Debug.Log(string.Format("Time Left = {0}; Velocity = {1}, Distance to Target = {2}",
time_left, _velocity_vector.magnitude, (end_pos - cur_pos).magnitude));
if (time_left >= 0)
{
DataToExcel new_data = new DataToExcel(_velocity_vector.magnitude, _current_time);
_excel_data.Add(new_data);
WriteToExcel();
}
return(new_pos);
}
public IActionResult XunchaExport(string ids)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var column = new List <string>()
{
"巡查人", "巡查地点", "巡查时间", "情况上报", "状态", "联系电话"
};
var column2 = new List <string>()
{
"XunchaInfoRen", "XunchaAddress", "XunchaTime", "QingkShangbao", "Staues", "FuzerPhone"
};
if (!string.IsNullOrEmpty(ids))
{
var parameters = ids.Trim().Split(",");
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].ToUpper();
}
var query = _dbContext.XunchaInfo.Where(x => x.IsDeleted != 1 && parameters.Contains(x.XunchaInfoUuid.ToString())).Select(x => new
{
XunchaInfoRen = x.XunchaInfoRen,
XunchaAddress = x.XunchaAddress,
XunchaTime = x.XunchaTime,
QingkShangbao = x.QingkShangbao,
Staues = x.Staues,
FuzerPhone = x.FuzerPhone
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "巡查记录信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:巡查信息数据", _dbContext);
return(Ok(response));
}
else
{
var query = _dbContext.XunchaInfo.Where(x => x.IsDeleted != 1).Select(x => new
{
XunchaInfoRen = x.XunchaInfoRen,
XunchaAddress = x.XunchaAddress,
XunchaTime = x.XunchaTime,
QingkShangbao = x.QingkShangbao,
Staues = x.Staues,
FuzerPhone = x.FuzerPhone
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "巡查记录信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:巡查信息数据", _dbContext);
return(Ok(response));
}
}
}
/// <summary>
/// Myxls导出Excel，保存在客户端
/// </summary>
private void DataTableExportToExcel(long applyId, string xlsName, string sheetName)
{
//表头
//决定Datatable显示哪些内容
DataSet ds = new DataSet();
DataTable dt = ds.Tables.Add("Sheet1");
DataRow dr;
DataColumn column;
//1---序号
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "序号";
ds.Tables["Sheet1"].Columns.Add(column);
//2---准考证号
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "准考证号";
ds.Tables["Sheet1"].Columns.Add(column);
//3---姓名
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "姓名";
ds.Tables["Sheet1"].Columns.Add(column);
//4---专业
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "专业";
ds.Tables["Sheet1"].Columns.Add(column);
var ml = new BLL.CCOM.Examination_arrangement_detail().GetModelList(" Ea_id='" + applyId + "' order by newid()");
for (int row = 0; row < ml.Count; row++)
{
var m = ml[row];
//申请人基本信息
//学生用户
try
{
Model.CCOM.View_UserAgency model = new BLL.CCOM.View_UserAgency().GetModel(" User_id='" + m.User_id + "'");
dr = ds.Tables["Sheet1"].NewRow();
dr[0] = row + 1;
dr[1] = model.UP_CCOM_number;
dr[2] = model.User_realname;
dr[3] = model.Agency_name;
ds.Tables["Sheet1"].Rows.Add(dr);
}
catch
{
continue;
}
}
//导出EXCEL，速度有点慢
DataToExcel.ExportToExcel(ds, Server.MapPath("/upload/excel/"), xlsName + ".xlsx", this.Page);
}
public IActionResult RenyuzhuanyExport(string ids)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var column = new List <string>()
{
"需转移人员", "响应等级", "转移情况", "负责人", "负责人电话"
};
var column2 = new List <string>()
{
"Xzhuanyi", "XiangyingDj", "ZhaunyiQingk", "Fuzeren", "FuzerenPhone"
};
if (!string.IsNullOrEmpty(ids))
{
var parameters = ids.Trim().Split(",");
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].ToUpper();
}
var query = _dbContext.RenyuZhuany.Where(x => x.IsDeleted != 1 && parameters.Contains(x.RenyuZhuanyUuid.ToString())).Select(x => new
{
Xzhuanyi = x.Xzhuanyi,
XiangyingDj = x.XiangyingDj,
ZhaunyiQingk = x.ZhaunyiQingk,
Fuzeren = x.Fuzeren,
FuzerenPhone = x.FuzerenPhone
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "人员转移信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:人员转移信息数据", _dbContext);
return(Ok(response));
}
else
{
var query = _dbContext.RenyuZhuany.Where(x => x.IsDeleted != 1).Select(x => new
{
Xzhuanyi = x.Xzhuanyi,
XiangyingDj = x.XiangyingDj,
ZhaunyiQingk = x.ZhaunyiQingk,
Fuzeren = x.Fuzeren,
FuzerenPhone = x.FuzerenPhone
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "人员转移信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:人员转移信息数据", _dbContext);
return(Ok(response));
}
}
}
public IActionResult ExportPass(string ids)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var column = new List <string>()
{
"姓名", "地点", "身份证号", "联系电话", "时间", "状态"
};
var column2 = new List <string>()
{
"SecurityName", "SecurityAddress", "IdentityCard", "Phone", "SecurityTime", "SecurityStaues"
};
if (!string.IsNullOrEmpty(ids))
{
var parameters = ids.Trim().Split(",");
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].ToUpper();
}
var query = _dbContext.Security.Where(x => x.IsDeleted != 1 && parameters.Contains(x.SecurityUuid.ToString())).Select(x => new Security
{
SecurityName = x.SecurityName,
SecurityAddress = x.SecurityAddress,
IdentityCard = x.IdentityCard,
Phone = x.Phone,
SecurityTime = x.SecurityTime,
SecurityStaues = x.SecurityStaues,
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportBuidingExcel\\";
string uploadtitle = "安防人员信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportBuidingExcel\\" + uploadtitle + ".xlsx");
return(Ok(response));
}
else
{
var query = _dbContext.Security.Where(x => x.IsDeleted != 1).Select(x => new Security
{
SecurityName = x.SecurityName,
SecurityAddress = x.SecurityAddress,
IdentityCard = x.IdentityCard,
Phone = x.Phone,
SecurityTime = x.SecurityTime,
SecurityStaues = x.SecurityStaues,
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportBuidingExcel\\";
string uploadtitle = "安防人员信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportBuidingExcel\\" + uploadtitle + ".xlsx");
return(Ok(response));
}
}
}
public static void Start()
{
List <VideoData> vdList = new List <VideoData>();
ParseUrl(vdList, "http://search.kdnet.net/?q=%C5%ED%D6%DD%CA%AF%BB%AF&sa=%CB%D1%CB%F7&category=title&boardid=0&arrival=2013-12-29&departure=2016-12-29");
DataToExcel.CreateExcel("凯迪社区", vdList);
}
public static void Start()
{
List <VideoData> vdList = new List <VideoData>();
ParseUrl(vdList, "http://search.home.news.cn/forumbookSearch.do?sw=%E5%BD%AD%E5%B7%9E%E7%9F%B3%E5%8C%96&srchType=1");
DataToExcel.CreateExcel("发展论坛", vdList);
}
public static void Start()
{
List <VideoData> vdList = new List <VideoData>();
ParseUrl(vdList, "http://bbs1.people.com.cn/quickSearch.do?field=title&threadtype=1&content=%E5%BD%AD%E5%B7%9E%E7%9F%B3%E5%8C%96");
DataToExcel.CreateExcel("强国论坛", vdList);
}
public IActionResult UAVExport(string ids)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var column = new List <string>()
{
"无人机名称", "无人机编号", "链接地址", "无人机监控地址"
};
var column2 = new List <string>()
{
"UAVName", "UAVNumber", "UAVUrl", "UAVAddress"
};
if (!string.IsNullOrEmpty(ids))
{
var parameters = ids.Trim().Split(",");
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].ToUpper();
}
var query = _dbContext.Uav.Where(x => x.IsDeleted != 1 && parameters.Contains(x.Uavuuid.ToString())).Select(x => new
{
UAVName = x.Uavname,
UAVNumber = x.Uavnumber,
UAVUrl = x.Uavurl,
UAVAddress = x.Uavaddress
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "无人机信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:无人机信息数据", _dbContext);
return(Ok(response));
}
else
{
var query = _dbContext.Uav.Where(x => x.IsDeleted != 1).Select(x => new
{
UAVName = x.Uavname,
UAVNumber = x.Uavnumber,
UAVUrl = x.Uavurl,
UAVAddress = x.Uavaddress
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "无人机信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:无人机信息数据", _dbContext);
return(Ok(response));
}
}
}
public IActionResult RescueTeamExport(string ids)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var column = new List <string>()
{
"队名", "小队人数", "队长", "联系电话"
};
var column2 = new List <string>()
{
"TeamName", "TeamRenshu", "TeamCaptain", "TeamPhone"
};
if (!string.IsNullOrEmpty(ids))
{
var parameters = ids.Trim().Split(",");
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].ToUpper();
}
var query = _dbContext.RescueTeam.Where(x => x.IsDeleted != 1 && parameters.Contains(x.RescueTeamUuid.ToString())).Select(x => new
{
TeamName = x.TeamName,
TeamRenshu = x.TeamRenshu,
TeamCaptain = x.TeamCaptain,
TeamPhone = x.TeamPhone,
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "救援小队信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:救援小队信息数据", _dbContext);
return(Ok(response));
}
else
{
var query = _dbContext.RescueTeam.Where(x => x.IsDeleted != 1).Select(x => new
{
TeamName = x.TeamName,
TeamRenshu = x.TeamRenshu,
TeamCaptain = x.TeamCaptain,
TeamPhone = x.TeamPhone,
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "救援小队信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:救援小队信息数据", _dbContext);
return(Ok(response));
}
}
}
public IActionResult VillageMemberExport(string ids)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var column = new List <string>()
{
"村庄名称", "姓名", "性别", "联系电话"
};
var column2 = new List <string>()
{
"VillageName", "MemberName", "MemberSex", "MemberPhone"
};
if (!string.IsNullOrEmpty(ids))
{
var parameters = ids.Trim().Split(",");
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].ToUpper();
}
var query = _dbContext.VillageMember.Where(x => x.IsDelete != 1 && parameters.Contains(x.VillageMemberUuid.ToString())).Select(x => new
{
VillageName = x.VillageUu.VillageName,
MemberName = x.MemberName,
MemberSex = x.MemberSex,
MemberPhone = x.MemberPhone
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "村庄成员信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:村干部信息数据", _dbContext);
return(Ok(response));
}
else
{
var query = _dbContext.VillageMember.Where(x => x.IsDelete != 1).Select(x => new
{
VillageName = x.VillageUu.VillageName,
MemberName = x.MemberName,
MemberSex = x.MemberSex,
MemberPhone = x.MemberPhone
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "村庄成员信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:村干部信息数据", _dbContext);
return(Ok(response));
}
}
}
public static void Start()
{
List <VideoData> vdList = new List <VideoData>();
for (int i = 1; i < 76; i++)
{
ParseUrl(vdList, "http://search.tianya.cn/bbs?q=%E5%BD%AD%E5%B7%9E%E7%9F%B3%E5%8C%96&pn=" + i);
}
DataToExcel.CreateExcel("天涯论坛", vdList);
}
public static void Start()
{
List <VideoData> vdList = new List <VideoData>();
for (int i = 1; i < 2; i++)
{
ParseUrl(vdList, "http://search.mop.com/cse/search?q=%E5%BD%AD%E5%B7%9E%E7%9F%B3%E5%8C%96&click=" + i + "&s=10030666497398670337&nsid=");
}
DataToExcel.CreateExcel("猫扑社区", vdList);
}
/// <summary>
/// 导出数据
/// </summary>
protected override void DoExport(object sender)
{
DataTable dt = new DataTable();
int[] rows = _SummaryView.GetSelectedRows();
if (rows.Length < 1)
{
Msg.Warning("请选择至少1条数据！");
return;
}
else
{
WaiteServer.ShowWaite(this);
int sucess = 0;
Dictionary <string, object> dic = new Dictionary <string, object>();
if (!String.IsNullOrEmpty(txts_RETURN_STATUS.Text))
{
dic.Add("RETURN_STATUS", txts_RETURN_STATUS.EditValue);
}
if (!String.IsNullOrEmpty(txts_STAR_TIME.Text))
{
dic.Add("STAR_TIME", txts_STAR_TIME.EditValue);
}
if (!String.IsNullOrEmpty(txts_END_TIME.Text))
{
dic.Add("END_TIME", txts_END_TIME.EditValue);
}
foreach (int k in rows)
{
string Key = ConvertEx.ToString(_SummaryView.GetDataRow(k)[_bll.SummaryModel.PrimaryKey]);
if (!String.IsNullOrEmpty(Key))
{
dic.Add("G_NAME" + sucess.ToString(), ",'" + Key + "'");
}
sucess++;
}
dt = bll.GetListData(dic);//获得需要绑定的数据
}
if (DataToExcel.ExportToExcel(dt, "商品汇总", Lists))
{
WaiteServer.CloseWaite();
Msg.ShowInformation("导出成功！");
}
WaiteServer.CloseWaite();
}
internal static void DownLoadTemplateFile()
{
var excelPackage = DataToExcel.CreateEmptyTemplate();
SaveFileDialog saveFileDialog = new();
saveFileDialog.Filter = "xlsx files (*.xlsx)|*.xlsx|xls files (*.xls)|*.xls";
saveFileDialog.FilterIndex = 1;
if (saveFileDialog.ShowDialog() == true)
{
FileInfo fi = new FileInfo(saveFileDialog.FileName);
excelPackage.SaveAs(fi);
}
}
private void MyExcel()
{
DataSet ds = new lgk.BLL.tb_bonus().GetListByUser(getWhere2());//获取所有时间段的奖金信息
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
string FilePath = Server.MapPath("/userfiles/");// +"\\" + ExcelFolder + "\\";
if (!Directory.Exists(FilePath))
{
Directory.CreateDirectory(FilePath);
}
//生成列的中文对应表
Hashtable nameList = new Hashtable();
nameList.Add("UserCode", "用户名");
nameList.Add("sf", "应发奖金");
nameList.Add("BankAccountUser", "开户姓名");
nameList.Add("BankName", "开户行");
nameList.Add("BankAccount", "卡号");
nameList.Add("BankBranch", "支行名称");
//利用excel对象
DataToExcel dte = new DataToExcel();
string filename = "";
try
{
if (ds.Tables[0].Rows.Count > 0)
{
filename = dte.DataExcel(ds.Tables[0], "奖金", FilePath, nameList);
}
}
catch
{
//dte.KillExcelProcess();
}
if (filename != "")
{
string path = FilePath + filename;
Response.Redirect("/userfiles/" + filename, true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('当前无数据导出!');", true);
}
}
private void ToExcel()
{
if (Session["DataTables"] == null)
{
this.RegisterStartupScript("无结果", "<script>alert('请先进行统计！');</script>");
return;
}
Dictionary <string, DataTable> dataTables = Session["DataTables"] as Dictionary <string, DataTable>;
if (dataTables == null)
{
this.RegisterStartupScript("无结果", "<script>alert('请先进行统计！');</script>");
return;
}
DataToExcel dte = new DataToExcel();
dte.DataGridViewToExcel(dataTables);
}
public ActionResult getExcel(string cols, string data)
{
DataTable dt = Newtonsoft.Json.JsonConvert.DeserializeObject <DataTable>(cols);
List <Dictionary <string, object> > list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(data);
DataToExcel converter = new DataToExcel();
var bytes = converter.tOExcel(dt, list);
//return new FileStreamResult(stream, "application/x-xls");
Response.Charset = "UTF-8";
Response.ContentType = "application/octet-stream";
//Response.ContentEncoding = encoding;
Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode("导出.xls", System.Text.Encoding.UTF8));
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
return(new EmptyResult());
}
public ActionResult getExcelServer(string modelID, string keyword, string filter, string order, bool isCustom, string cols, string formstate)
{
try
{
// var data = this._service.getModelTreeDataALL(modelID, keyword, filter, order);
DataTable dt = Newtonsoft.Json.JsonConvert.DeserializeObject <DataTable>(cols);
var dict = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, object> >(formstate);
List <Dictionary <string, object> > data;
if (isCustom)
{
data = this._serviceCutomDS.getModelTreeDataALL(modelID, keyword, filter, order, dict);
}
else
{
data = this._service.getModelTreeDataALL(modelID, keyword, filter, order);
}
DataToExcel converter = new DataToExcel();
var bytes = converter.tOExcel(dt, data);
Response.Charset = "UTF-8";
Response.ContentType = "application/octet-stream";
//Response.ContentEncoding = encoding;
Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode("导出.xls", System.Text.Encoding.UTF8));
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
return(new EmptyResult());
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult HeDaowaterExport(string ids)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var column = new List <string>()
{
"地址", "时间", "水位", "临界点", "水位预警", "防汛等级"
};
var column2 = new List <string>()
{
"HeDaowaterAddress", "HeDaowaterTime", "HeDaoHeDaowaterSw", "Ljiedian", "HeDaowaterYujin", "FangxunDj"
};
if (!string.IsNullOrEmpty(ids))
{
var parameters = ids.Trim().Split(",");
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].ToUpper();
}
var query = _dbContext.HeDaowater.Where(x => x.IsDeleted != 1 && parameters.Contains(x.HeDaowaterUuid.ToString())).Select(x => new
{
HeDaowaterAddress = x.HeDaowaterAddress,
HeDaowaterTime = x.HeDaowaterTime,
HeDaoHeDaowaterSw = x.HeDaoHeDaowaterSw,
Ljiedian = x.Ljiedian,
HeDaowaterYujin = x.HeDaowaterYujin,
FangxunDj = x.FangxunDj,
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "河道水位信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:河道水位监测信息数据", _dbContext);
return(Ok(response));
}
else
{
var query = _dbContext.HeDaowater.Where(x => x.IsDeleted != 1).Select(x => new
{
HeDaowaterAddress = x.HeDaowaterAddress,
HeDaowaterTime = x.HeDaowaterTime,
HeDaoHeDaowaterSw = x.HeDaoHeDaowaterSw,
Ljiedian = x.Ljiedian,
HeDaowaterYujin = x.HeDaowaterYujin,
FangxunDj = x.FangxunDj,
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\";
string uploadtitle = "河道水位信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:河道水位监测信息数据", _dbContext);
return(Ok(response));
}
}
}
protected void exportexcel_ServerClick(object sender, EventArgs e)
{
string order = "AEE_score DESC, AEE_sequence DESC ,UP_CCOM_number asc";
string strWhere = CombSqlTxt(this.keywords);
try
{
string order1 = "";
string strWhere1 = " Major_Agency_id=" + major_id + " AND Period_id=" + period_id + " AND Subject_level=2";
subList = new BLL.CCOM.Subject().GetModelList(strWhere1 + order1);
count = subList.Count;
BLL.CCOM.View_AEE_Score bll = new BLL.CCOM.View_AEE_Score();
List <Model.CCOM.View_AEE_Score> modelList = bll.GetModelList(strWhere + " order by " + order);
DataSet _ds = new DataSet();
_ds.Tables.Clear();
DataTable dt = _ds.Tables.Add("Sheet1");
DataRow dr;
DataColumn column;
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "序号";
_ds.Tables["Sheet1"].Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "考生号";
_ds.Tables["Sheet1"].Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "姓名";
_ds.Tables["Sheet1"].Columns.Add(column);
if (count > 0)
{
foreach (var model in subList)
{
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = model.Subject_title;
_ds.Tables["Sheet1"].Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = model.Subject_title + "序";
_ds.Tables["Sheet1"].Columns.Add(column);
}
}
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "总成绩";
_ds.Tables["Sheet1"].Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "总平均序";
_ds.Tables["Sheet1"].Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "专业排名";
_ds.Tables["Sheet1"].Columns.Add(column);
int _count = modelList.Count;
for (int i = 0, num = 1; i < _count; i++, num++)
{
dr = _ds.Tables["Sheet1"].NewRow();
dr["序号"] = num.ToString();
dr["姓名"] = modelList[i].User_realname;
dr["考生号"] = modelList[i].UP_CCOM_number;
int t = 0;
if (count > 0)
{
foreach (var model in subList)
{
dr[3 + t] = getSubjectAverageScore(modelList[i].User_id.ToString(), model.Subject_id.ToString());
dr[3 + t + 1] = getSubjectAverageXu(modelList[i].User_id.ToString(), model.Subject_id.ToString());
t += 2;
}
}
dr["总成绩"] = ((decimal)(modelList[i].AEE_score)).ToString("F2");
dr["总平均序"] = ((decimal)modelList[i].AEE_sequence).ToString("F2");
dr["专业排名"] = modelList[i].AEE_ranking;
_ds.Tables["Sheet1"].Rows.Add(dr);
}
DataToExcel.ExportToExcel(_ds, Server.MapPath("/upload/excel/"), "艺考科目成绩_" + DateTime.Now.ToFileTime().ToString() + ".xlsx", this.Page);
}
catch
{
JscriptMsg("获取艺考科目成绩出错", "", "Error");
}
}
protected void exportexcel_ServerClick(object sender, EventArgs e)
{
string order = "UP_CCOM_number asc";
string strWhere = CombSqlTxt(this.keywords);
try
{
BLL.CCOM.View_AEE_Subject_Score bll = new BLL.CCOM.View_AEE_Subject_Score();
List <Model.CCOM.View_AEE_Subject_Score> modelList = bll.GetModelList(strWhere + " order by " + order);
DataSet ds = new DataSet();
ds.Tables.Clear();
DataTable dt = ds.Tables.Add("Sheet1");
DataRow dr;
DataColumn column;
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "序号";
ds.Tables["Sheet1"].Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "考生号";
ds.Tables["Sheet1"].Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "姓名";
ds.Tables["Sheet1"].Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "科目名称";
ds.Tables["Sheet1"].Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "科目成绩";
ds.Tables["Sheet1"].Columns.Add(column);
int count = modelList.Count;
for (int i = 0, num = 1; i < count; i++, num++)
{
dr = ds.Tables["Sheet1"].NewRow();
dr["序号"] = num.ToString();
dr["姓名"] = modelList[i].User_realname;
dr["考生号"] = modelList[i].UP_CCOM_number;
dr["科目名称"] = getSubjectName(modelList[i].Subject_id.ToString());
string score = getSubjectScore(modelList[i].User_id.ToString(), modelList[i].Subject_id.ToString(), this.judge_id.ToString());
if (score != null && score != "")
{
dr["科目成绩"] = score;
}
ds.Tables["Sheet1"].Rows.Add(dr);
}
DataToExcel.ExportToExcel(ds, Server.MapPath("/upload/excel/"), "考生科目成绩_" + DateTime.Now.ToFileTime().ToString() + ".xlsx", this.Page);
}
catch
{
JscriptMsg("获取考生科目成绩出错", "", "Error");
}
}
public IActionResult ParkingLotExport(string ids)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var column = new List <string>()
{
"名称", "位置", "总车位", "已用车位", "剩余车位", "经度", "纬度"
};
var column2 = new List <string>()
{
"ParkingLotName", "ParkingLotAddress", "Zchewei", "Ychewei", "Schewei", "Lon", "Lat"
};
if (!string.IsNullOrEmpty(ids))
{
var parameters = ids.Trim().Split(",");
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].ToUpper();
}
var query1 = _dbContext.ParkingLot.Where(x => x.IsDeleted != 1 && parameters.Contains(x.ParkingLotUuid.ToString())).Select(x => new
{
Id = x.Id,
ParkingLotName = x.ParkingLotName,
ParkingLotAddress = x.ParkingLotAddress,
Zchewei = x.Zchewei,
Ychewei = x.Ychewei,
Schewei = x.Schewei,
ParkingLotsru = x.ParkingLotsru,
Lon = x.Lon,
Lat = x.Lat,
});
var query = query1.OrderByDescending(x => x.Id).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportIntelligenttravelExcel\\";
string uploadtitle = "停车场信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportIntelligenttravelExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:停车场信息数据", _dbContext);
return(Ok(response));
}
else
{
var query1 = _dbContext.ParkingLot.Where(x => x.IsDeleted != 1).Select(x => new
{
Id = x.Id,
ParkingLotName = x.ParkingLotName,
ParkingLotAddress = x.ParkingLotAddress,
Zchewei = x.Zchewei,
Ychewei = x.Ychewei,
Schewei = x.Schewei,
ParkingLotsru = x.ParkingLotsru,
Lon = x.Lon,
Lat = x.Lat,
});
var query = query1.OrderByDescending(x => x.Id).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportIntelligenttravelExcel\\";
string uploadtitle = "停车场信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportIntelligenttravelExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:停车场信息数据", _dbContext);
return(Ok(response));
}
}
}
private void MyExcel()
{
DataSet ds = GetAgentList(getWhere2());//获取信息
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
string FilePath = Server.MapPath("/userfiles/");// +"\\" + ExcelFolder + "\\";
if (!Directory.Exists(FilePath))
{
Directory.CreateDirectory(FilePath);
}
//生成列的中文对应表
Hashtable nameList = new Hashtable();
nameList.Add("AgentCode", "代理中心编号");
nameList.Add("UserCode", "会员编号");
nameList.Add("TrueName", "会员姓名");
nameList.Add("LevelName", "会员级别");
nameList.Add("Quyu", "代理区域");
nameList.Add("AppliTime", "申请日期");
nameList.Add("OpenTime", "确认日期");
DataTable dt = ds.Tables[0];
dt.Columns.Remove("ID");
dt.Columns.Remove("AgentType");
dt.Columns.Remove("Flag");
dt.Columns.Remove("UserID");
dt.Columns.Remove("LevelID");
dt.Columns.Remove("AgentsID");
dt.Columns.Remove("User006");
DataTable newTable = new DataTable();
DataColumn newCol = new DataColumn();
newCol.ColumnName = "Quyu";
newTable.Columns.Add(newCol);
foreach (DataColumn col in dt.Columns)
{
DataColumn c = new DataColumn();
c.ColumnName = col.ColumnName;
newTable.Columns.Add(c);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = newTable.NewRow();
dr["Quyu"] = dt.Rows[i]["AgentInProvince"].ToString() + dt.Rows[i]["AgentInCity"].ToString() + dt.Rows[i]["AgentAddress"].ToString();
foreach (DataColumn ncol in dt.Columns)
{
dr[ncol.ColumnName] = dt.Rows[i][ncol.ColumnName];
}
newTable.Rows.Add(dr);
}
newTable.Columns.Remove("AgentInProvince");
newTable.Columns.Remove("AgentInCity");
newTable.Columns.Remove("AgentAddress");
//利用excel对象
DataToExcel dte = new DataToExcel();
string filename = "";
try
{
if (ds.Tables[0].Rows.Count > 0)
{
filename = dte.DataExcel(newTable, "已开通代理中心", FilePath, nameList);
}
}
catch
{
//dte.KillExcelProcess();
}
if (filename != "")
{
string path = FilePath + filename;
Response.Redirect("/userfiles/" + filename, true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('当前无数据导出!');", true);
}
}
public IActionResult GtoiletExport(string ids)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var column = new List <string>()
{
"名称", "位置", "经度", "纬度", "使用情况", "空气质量", "水量预警"
};
var column2 = new List <string>()
{
"GtoiletName", "GtoiletAddress", "Lon", "Lat", "GtoiletStaues", "KongqiZhil", "WaterYujin"
};
if (!string.IsNullOrEmpty(ids))
{
var parameters = ids.Trim().Split(",");
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].ToUpper();
}
var query = _dbContext.Gtoilet.Where(x => x.IsDeleted != 1 && parameters.Contains(x.GtoiletUuid.ToString())).Select(x => new
{
GtoiletName = x.GtoiletName,
GtoiletAddress = x.GtoiletAddress,
Lon = x.Lon,
Lat = x.Lat,
GtoiletStaues = x.GtoiletStaues,
KongqiZhil = x.KongqiZhil,
WaterYujin = x.WaterYujin
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportIntelligenttravelExcel\\";
string uploadtitle = "3A公厕信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportIntelligenttravelExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:3A公厕信息数据", _dbContext);
return(Ok(response));
}
else
{
var query = _dbContext.Gtoilet.Where(x => x.IsDeleted != 1).Select(x => new
{
GtoiletName = x.GtoiletName,
GtoiletAddress = x.GtoiletAddress,
Lon = x.Lon,
Lat = x.Lat,
GtoiletStaues = x.GtoiletStaues,
KongqiZhil = x.KongqiZhil,
WaterYujin = x.WaterYujin
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportIntelligenttravelExcel\\";
string uploadtitle = "3A公厕信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportIntelligenttravelExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:3A公厕信息数据", _dbContext);
return(Ok(response));
}
}
}
public IActionResult XlProjectExport(string ids)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var column = new List <string>()
{
"设备ID", "设备类型", "位置", "经度", "纬度", "管理人信息", "设备状态"
};
var column2 = new List <string>()
{
"XlShebeiId", "XlShebeiType", "ShebeiAddress", "Lon", "Lat", "AdminInfo", "ShebeiType"
};
if (!string.IsNullOrEmpty(ids))
{
var parameters = ids.Trim().Split(",");
for (int i = 0; i < parameters.Length; i++)
{
parameters[i] = parameters[i].ToUpper();
}
var query = _dbContext.XlProject.OrderByDescending(x => x.Id).Where(x => x.IsDeleted != 1 && parameters.Contains(x.XlProjectUuid.ToString())).Select(x => new
{
XlShebeiId = x.XlShebeiId,
XlShebeiType = x.XlShebeiType,
ShebeiAddress = x.ShebeiAddress,
Lon = x.Lon,
Lat = x.Lat,
AdminInfo = x.AdminInfo,
ShebeiType = x.ShebeiType
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportSocialGovernExcel\\";
string uploadtitle = "雪亮工程信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportSocialGovernExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:雪亮工程信息数据", _dbContext);
return(Ok(response));
}
else
{
var query = _dbContext.XlProject.OrderByDescending(x => x.Id).Where(x => x.IsDeleted != 1).Select(x => new
{
XlShebeiId = x.XlShebeiId,
XlShebeiType = x.XlShebeiType,
ShebeiAddress = x.ShebeiAddress,
Lon = x.Lon,
Lat = x.Lat,
AdminInfo = x.AdminInfo,
ShebeiType = x.ShebeiType
}).ToList();
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportSocialGovernExcel\\";
string uploadtitle = "雪亮工程信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss");
string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx";
DataToExcel.TablesToExcel(query, sFileName, column, column2);
response.SetData("\\UploadFiles\\ImportSocialGovernExcel\\" + uploadtitle + ".xlsx");
ToLog.AddLog("导出", "成功:导出:雪亮工程信息数据", _dbContext);
return(Ok(response));
}
}
}
public static void ExportToExcel(DataSet ds, Hashtable displaycol_nameList, string otherInfo)
{
common_file.common_app.get_czsj();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string filePath = "";
string fileName = "";
string get_fileName = "";
Hashtable nameList = new Hashtable();
nameList = displaycol_nameList;
SaveFileDialog saveFileDialog1;
FolderBrowserDialog folderBrowserDialog1;
//利用excel对象
DataToExcel dte = new DataToExcel();
try
{
common_file.common_app.get_czsj();
if (ds.Tables[0].Rows.Count > 0)
{
common_file.common_app.get_czsj();
saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "Excel files (*.xls)|*.xls";
folderBrowserDialog1 = new FolderBrowserDialog();
if (defaulPath.Trim() != "")
{
folderBrowserDialog1.SelectedPath = defaulPath;
}
if (folderBrowserDialog1.ShowDialog() == DialogResult.OK)
{
common_file.common_app.get_czsj();
filePath = folderBrowserDialog1.SelectedPath + "\\";
defaulPath = folderBrowserDialog1.SelectedPath;
get_fileName = dte.DataExcel(ds.Tables[0], otherInfo, filePath, nameList).Trim();
if (get_fileName != "")
{
fileName = filePath + get_fileName;
}
else
{
return;
}
}
}
}
catch
{
dte.KillExcelProcess();
}
if (get_fileName.Trim() != "")
{
common_file.common_app.get_czsj();
common_file.common_app.Message_box_show(common_file.common_app.message_title, "导出成功!");
//Response.Redirect((ExcelFolder+"\\"+filename,true);
//StreamWriter aWriter = new StreamWriter(fileName); aWriter.Write(fileName); aWriter.Close();
}
}
Cursor.Current = Cursors.Default;
}
