public void RunAgent()
{
DoExport objDoExport = new DoExport(this);
objDoExport.InitialiseAllApiObj();
objDoExport.DoAgentOps();
}
public ActionResult DeriveData()
{
ReturnMessage RM = new ReturnMessage();
try
{
string paramData = Request.Form["paramData"];
StringBuilder strSql = new StringBuilder("select LoginName as '登录名',UserName as '用户名',dept_New as '所属部门', 'role_name' as '角色',Remark '备注' from View_User_Role where 1=1");
if (string.IsNullOrEmpty(paramData))
{
string keyword = Request["keyword"];
string Depart = Request["Depart"];
if (!string.IsNullOrWhiteSpace(keyword))
{
strSql.Append(" and (LoginName like '%" + keyword + "%' or UserName like '%" + keyword + "%')");
}
if (!string.IsNullOrWhiteSpace(Depart))
{
strSql.Append(" and (dept_New ='" + Depart + "')");
}
strSql.Append(" and " + whe);
}
else
{
string[] tblRcdidArr = paramData.Split('*');
strSql.Append(" and tblrcdid in " + DBContext.DataDecision.AssemblyInCondition(tblRcdidArr.ToList()));
}
strSql.Append(" order by LoginName,UserName ");
DataTable dt = DBContext.DataDecision.GetDataTable(strSql.ToString());
DataTable User_Roles_dt = DBContext.DataDecision.GetDataTable("select distinct LoginName,Role_Name from dbo.View_User_Roles where LoginName is not null and LoginName<>'' and Role_Name is not null and Role_Name<>'' order by LoginName,Role_Name");
for (int i = 0; i < dt.Rows.Count; i++)
{
string LoginName = Convert.ToString(dt.Rows[i]["登录名"]);
string Role_NameList = "";
DataRow[] datarow = User_Roles_dt.Select("LoginName='" + LoginName + "'");
for (int j = 0; j < datarow.Length; j++)
{
Role_NameList += Convert.ToString(datarow[j]["Role_Name"]) + ",";
}
dt.Rows[i]["角色"] = Role_NameList;
}
string sheetName = "用户表";
//返回路径
string absoluFilePath = DoExport.ExportDataTableToExcel(dt, sheetName, "用户表");
RM.IsSuccess = true;
RM.Text = HttpUtility.UrlEncode(absoluFilePath);
}
catch (Exception ex)
{
RM.IsSuccess = false;
RM.Message = ex.Message;
}
return(Json(RM, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// trigger an export of an item programatically.
/// </summary>
/// <param name="folder">folder to use for export</param>
/// <param name="entityTypes">entity types to trigger export for</param>
/// <param name="options">handler options to use for handlers</param>
public static void TriggerExport(string folder, IEnumerable <string> entityTypes, SyncHandlerOptions options)
{
DoExport?.Invoke(new uSyncTriggerArgs()
{
EntityTypes = entityTypes,
Folder = folder,
HandlerOptions = options
});
}
public ActionResult DeriveData()
{
ReturnMessage RM = new ReturnMessage();
try
{
string paramData = Request.Form["paramData"];
//StringBuilder strSql = new StringBuilder("select Module_Name '模块名称 ',Module_Id '模块ID ', Group_Name '分组名称 ',Group_Id '分组ID', Right_Name '页面名称 ',Right_Id '页面ID',Right_Url '页面路径',Remark as '备注' from FunctionalAuthority where 1=1");
StringBuilder strSql = new StringBuilder("select Module_Name '模块名称 ', Group_Name '分组名称 ', Right_Name '页面名称 ',Right_Url '页面路径',Remark as '备注' from FunctionalAuthority where 1=1");
if (string.IsNullOrEmpty(paramData))
{
string Module_Name = Request["Module_Name"];
string Group_Name = Request["Group_Name"];
string Right_Name = Request["Right_Name"];
StringBuilder where = new StringBuilder(" 1=1");
if (!string.IsNullOrWhiteSpace(Module_Name))
{
where.Append(" and Module_Name like '%" + Module_Name + "%'");
}
if (!string.IsNullOrWhiteSpace(Group_Name))
{
where.Append(" and Group_Name like '%" + Group_Name + "%'");
}
if (!string.IsNullOrWhiteSpace(Right_Name))
{
where.Append(" and Right_Name like '%" + Right_Name + "%'");
}
strSql.Append(" and " + where.ToString());
}
else
{
string[] RidArr = paramData.Split('*');
strSql.Append(" and Rid in " + DBContext.DataDecision.AssemblyInCondition(RidArr.ToList()));
}
strSql.Append(" order by Module_Id,Group_Id,Right_Id");
DataTable dt = DBContext.DataDecision.GetDataTable(strSql.ToString());
string sheetName = "模块信息";
//返回路径
string absoluFilePath = DoExport.ExportDataTableToExcel(dt, sheetName, "模块信息");
RM.IsSuccess = true;
RM.Text = HttpUtility.UrlEncode(absoluFilePath);
}
catch (Exception ex)
{
RM.IsSuccess = false;
RM.Message = ex.Message;
}
return(Json(RM, JsonRequestBehavior.AllowGet));
}
public ActionResult DeriveData()
{
ReturnMessage RM = new ReturnMessage();
try
{
string paramData = Request.Form["paramData"];
string PageTitle = Request["PageTitle"];
string PageUrl = Request["PageUrl"];
string ViewCount = Request["ViewCount"];
string RecordDate = Request["RecordDate"];
DateTime now = DateTime.Now;
string stateDate = null;
string endDate = null;
string where = " 1=1 ";
if (!string.IsNullOrWhiteSpace(stateDate))
{
where += " and (RecordDate>='" + stateDate + "')";
}
if (!string.IsNullOrEmpty(endDate))
{
where += " and (RecordDate<= '" + endDate + "')";
}
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append("PageTitle as '页面标题'");
strSql.Append(",PageUrl as '页面路径'");
strSql.Append(",count(Rid) as '访问数量'");
strSql.Append(" from tblPageView");
strSql.Append(" where" + where);
strSql.Append("group by PageTitle, PageUrl");
DataTable dt = DBContext.DataDecision.GetDataTable(strSql.ToString());
string sheetName = "页面访问统计";
//返回路径
string absoluFilePath = DoExport.ExportDataTableToExcel(dt, sheetName, "页面访问统计");
RM.IsSuccess = true;
RM.Text = HttpUtility.UrlEncode(absoluFilePath);
}
catch (Exception e)
{
RM.IsSuccess = false;
RM.Message = e.Message;
}
return(Json(RM, JsonRequestBehavior.AllowGet));
}
public ActionResult DeriveData()
{
ReturnMessage RM = new ReturnMessage();
try
{
string paramData = Request.Form["paramData"];
StringBuilder strSql = new StringBuilder("1=1");
if (string.IsNullOrWhiteSpace(paramData))
{
strSql = new StringBuilder("select Sender as '发送人', Accepter as '接收人', MsgType as '消息类型', MsgTitle as '消息标题', MsgContent as '消息内容', CONVERT(varchar, SendDate, 23 ) as '发送日期' from tblMessage ");
string loginName = CurrentHelper.CurrentUser.User.UserName.ToString();
strSql.Append(" where 1=1 and Accepter='" + loginName + "'");
//string Accepter = Request.Form["Accepter"];//接收人
//if (!string.IsNullOrWhiteSpace(Accepter))
//{
// strSql.Append(" and (Accepter like '%" + Accepter + "%')");
//}
strSql.Append(" order by SendDate desc");
}
else
{
string[] RidArr = paramData.Split('*');
strSql = new StringBuilder("select Sender as '发送人', Accepter as '接收人', MsgType as '消息类型', MsgTitle as '消息标题', MsgContent as '消息内容', CONVERT(varchar, SendDate, 23 ) as '发送日期' from tblMessage where Rid in " + DBContext.DataDecision.AssemblyInCondition(RidArr.ToList()));
strSql.Append(" order by SendDate desc");
}
DataTable dt = DBContext.DataDecision.GetDataTable(strSql.ToString());
string sheetName = "个人消息列表 ";
//返回路径
string absoluFilePath = DoExport.ExportDataTableToExcel(dt, sheetName, "个人消息列表");
RM.IsSuccess = true;
RM.Text = HttpUtility.UrlEncode(absoluFilePath);
}
catch (Exception ex)
{
RM.IsSuccess = false;
RM.Message = ex.Message;
}
return(Json(RM, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 根据条件获取日常工作记录数据下载地址
/// </summary>
/// <param name="ids">id列表,id列表为空则根据其他条件查询</param>
/// <param name="Seller">业务员</param>
/// <param name="Actor">客户名称</param>
/// <param name="queryFields">查询字段,默认查询全部</param>
/// <param name="orderBy">排序条件</param>
/// <returns>返回下载文件地址</returns>
public string GetDownloadPathCalendar(List <int> ids, string Seller = null, string Actor = null, string queryFields = "*", string orderBy = "")
{
string path = string.Empty;
try
{
queryFields = @"Seller as '业务员',Convert(varchar(100),AffairTime,23) as '拜访日期'
,case IsRegister when 1 then '是' else '否' end as '已登记',Actor as '客户名称',AdContent as '广告品牌'
,Place as '地点'
,Subject as '主题'
,Content as '事件描述'
,ContractName1 as '联系人'
,Convert(varchar(100),RegDate,23) as '登记日期'
,Remark as '备注' ";
if (String.IsNullOrWhiteSpace(orderBy))
{
orderBy = " TblRcdId Desc";
}
StringBuilder where = new StringBuilder(" 1=1");
if (ids == null || ids.Count == 0)
{
if (!string.IsNullOrWhiteSpace(Seller))
{
where.Append(" and Seller = '" + Seller + "'");
}
if (!string.IsNullOrWhiteSpace(Actor))
{
where.Append(" and Actor like '%" + Actor + "%'");
}
}
else
{
where.Append(" and TblRcdId in " + DBContext.PTMMHZ.AssemblyInCondition(ids));
}
string sql = string.Format("select {0} from tblCalendar where {1} order by {2}", queryFields, where.ToString(), orderBy);
DataTable dt = DBContext.PTMMHZ.GetDataTable(sql);
string sheetName = "日常工作记录";
path = DoExport.ExportDataTableToExcel(dt, sheetName, sheetName);
}
catch (Exception ex)
{
Bitshare.PTMM.Common.LogManager.Error("GetDownloadPathCalendar()", ex);
}
return(path);
}
public ActionResult DeriveData(string keyword = null)
{
ReturnMessage RM = new ReturnMessage();
try
{
string paramData = Request.Form["paramData"];
StringBuilder strSql = new StringBuilder("1=1");
strSql = new StringBuilder("select UserName as '职员 ', Leader as '直隶上级', ReMark as '备注' from tblLevelManange where 1=1");
if (string.IsNullOrEmpty(paramData))
{
string UserName = Request["UserName"];
string Leader = Request["Leader"];
if (!string.IsNullOrWhiteSpace(keyword))
{
strSql.AppendFormat(" and (UserName like '%{0}%' or Leader like '%{0}%')", keyword);
}
}
else
{
string[] tblRcdidArr = paramData.Split('*');
strSql.Append(" and TblRcdId in " + DBContext.DataDecision.AssemblyInCondition(tblRcdidArr.ToList()));
}
strSql.Append(" order by UserName");
DataTable dt = DBContext.DataDecision.GetDataTable(strSql.ToString());
string sheetName = "业务上下级信息表";
//返回路径
string absoluFilePath = DoExport.ExportDataTableToExcel(dt, sheetName, "业务上下级信息表");
RM.IsSuccess = true;
RM.Text = HttpUtility.UrlEncode(absoluFilePath);
}
catch (Exception ex)
{
RM.IsSuccess = false;
RM.Message = ex.Message;
}
return(Json(RM, JsonRequestBehavior.AllowGet));
}
public ActionResult DeriveData()
{
ReturnMessage RM = new ReturnMessage();
try
{
string paramData = Request.Form["paramData"];
StringBuilder strSql = new StringBuilder("select ButtonName '按钮名称 ', Remark as '备注' from tblButtonName where 1=1");
if (string.IsNullOrEmpty(paramData))
{
string keyword = Request.QueryString["keyword"];
if (!string.IsNullOrWhiteSpace(keyword))
{
strSql.Append(" and (ButtonName like '%" + keyword + "%')");
}
strSql.Append(" and " + whe);
}
else
{
string[] RidArr = paramData.Split('*');
strSql.Append(" and Rid in " + DBContext.DataDecision.AssemblyInCondition(RidArr.ToList()));
}
strSql.Append(" order by ButtonName");
DataTable dt = DBContext.DataDecision.GetDataTable(strSql.ToString());
string sheetName = "按钮名称";
//返回路径
string absoluFilePath = DoExport.ExportDataTableToExcel(dt, sheetName, "按钮名称");
RM.IsSuccess = true;
RM.Text = HttpUtility.UrlEncode(absoluFilePath);
}
catch (Exception ex)
{
RM.IsSuccess = false;
RM.Message = ex.Message;
}
return(Json(RM, JsonRequestBehavior.AllowGet));
}
public ActionResult DeriveData()
{
ReturnMessage RM = new ReturnMessage();
try
{
string paramData = Request.Form["paramData"];
StringBuilder strSql = new StringBuilder("select ProcessName as '流程名称', NodeName as '节点名称',NoticeRole as '通知角色', Remark as '备注' from tblProcessNotice where 1=1");
if (string.IsNullOrEmpty(paramData))
{
string ProcessName = Request.Form["ProcessName"];
if (!string.IsNullOrWhiteSpace(ProcessName))
{
strSql.Append(" and (ProcessName like '%" + ProcessName + "%')");
}
strSql.Append(" and " + wheres);
}
else
{
string[] tblRcdidArr = paramData.Split('*');
strSql.Append(" and TblRcdId in " + DBContext.DataDecision.AssemblyInCondition(tblRcdidArr.ToList()));
}
strSql.Append(" order by ProcessName");
DataTable dt = DBContext.DataDecision.GetDataTable(strSql.ToString());
string sheetName = "流程消息设置表";
//返回路径
string absoluFilePath = DoExport.ExportDataTableToExcel(dt, sheetName, "流程消息设置表");
RM.IsSuccess = true;
RM.Text = HttpUtility.UrlEncode(absoluFilePath);
}
catch (Exception ex)
{
RM.IsSuccess = false;
RM.Message = ex.Message;
}
return(Json(RM, JsonRequestBehavior.AllowGet));
}
public ActionResult DeriveData()
{
ReturnMessage RM = new ReturnMessage();
try
{
string paramData = Request.Form["paramData"];
string[] tblRcdidArr = paramData.Split('*');
StringBuilder strSql = new StringBuilder("select ModelName as '模块名称', PageName as '页面名称',DetailName as '明细名称', Remark as '备注' from tblPageDetail where 1=1 ");
if (string.IsNullOrEmpty(paramData))
{
string keyword = Request["keyword"];
if (!string.IsNullOrWhiteSpace(keyword))
{
strSql.Append(" and (ModelName like '%" + keyword + "%' or PageName like '%" + keyword + "%')");
}
}
else
{
strSql.Append(" and TblRcdId in " + DBContext.DataDecision.AssemblyInCondition(tblRcdidArr.ToList()));
}
strSql.Append(" order by ModelName,PageName,DetailName");
DataTable dt = DBContext.DataDecision.GetDataTable(strSql.ToString());
string sheetName = "明细权限管理";
//返回路径
string absoluFilePath = DoExport.ExportDataTableToExcel(dt, sheetName, "明细权限管理");
RM.IsSuccess = true;
RM.Text = HttpUtility.UrlEncode(absoluFilePath);
}
catch (Exception ex)
{
RM.IsSuccess = false;
RM.Message = ex.Message;
}
return(Json(RM, JsonRequestBehavior.AllowGet));
}
public ActionResult DeriveData()
{
ReturnMessage RM = new ReturnMessage();
try
{
string paramData = Request.Form["paramData"];
StringBuilder strSql = new StringBuilder("select role_name '角色名', role_desc as '备注' from sys_role where 1=1");
if (string.IsNullOrEmpty(paramData))
{
string roleName = Request.QueryString["roleName"];
if (!string.IsNullOrWhiteSpace(roleName))
{
strSql.Append(" and (role_name like '%" + roleName + "%')");
}
strSql.Append(" and " + whe);
}
else
{
string[] tblRcdidArr = paramData.Split('*');
strSql.Append(" and TblRcdId in " + DBContext.DataDecision.AssemblyInCondition(tblRcdidArr.ToList()));
}
strSql.Append(" order by role_name");
DataTable dt = DBContext.DataDecision.GetDataTable(strSql.ToString());
string sheetName = "角色表";
//返回路径
string absoluFilePath = DoExport.ExportDataTableToExcel(dt, sheetName, "角色表");
RM.IsSuccess = true;
RM.Text = HttpUtility.UrlEncode(absoluFilePath);
}
catch (Exception ex)
{
RM.IsSuccess = false;
RM.Message = ex.Message;
}
return(Json(RM, JsonRequestBehavior.AllowGet));
}
