/// <summary>
/// 导出报表(用户数据)
/// </summary>
/// <param name="TradeAccount">客户账号</param>
/// <param name="UserName">客户姓名</param>
/// <param name="TelPhone">手机号码</param>
/// <param name="Broker">经纪人</param>
/// <param name="orgid">会员名称</param>
/// <param name="IsBroker">是否经纪人</param>
/// <param name="starttime">开始时间</param>
/// <param name="endtime">结束时间</param>
/// <param name="reporttype">报表类型</param>
/// <param name="LoginID">登陆标识</param>
/// <returns>报表地址</returns>
public ReportForms GetReportFormsUser(string TradeAccount,string UserName,string TelPhone,string Broker,string orgid,string IsBroker,
DateTime starttime, DateTime endtime, int reporttype, string LoginID)
{
ReportForms forms = new ReportForms();
string rfile = string.Empty;
try
{
TradeUser TdUser = new TradeUser();
#region 判断登陆标识是否过期
if (!ComFunction.ExistUserLoginID(LoginID, ref TdUser))
{
forms.Result = false;
forms.Desc = ResCode.UL003Desc;
return forms;
}
if (UserType.NormalType == TdUser.UType)
{
forms.Result = false;
forms.Desc = ComFunction.NotRightUser;
return forms;
}
string LoginOrgID = "";
if (UserType.OrgType == TdUser.UType && !string.IsNullOrEmpty(TdUser.OrgId))
{
//PartSearchCondition = " and orgid in (select orgid from #tmp) ";
LoginOrgID = TdUser.OrgId;
}
#endregion
if (!(reporttype >= 0 && reporttype <= 11))
{
forms.Result = false;
forms.Desc = "报表类型错误";
return forms;
}
DateTime dt = DateTime.Now;
switch (reporttype) //确定导出文件名称
{
case 11: rfile = string.Format("U{0}.xls", dt.ToString("yyyyMMddHHmmssfff"));
break;
}
System.Data.Common.DbParameter OutputParam = DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@Result", DbParameterType.String, 1, ParameterDirection.Output);
string path = ComFunction.ReportFilePath + "\\" + dt.ToString("yyyyMM");
DbHelper.RunProcedureExecuteSql("P_ReportExportExcelUser",
new System.Data.Common.DbParameter[]{
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@LoginOrgID",DbParameterType.String,LoginOrgID,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@TradeAccount",DbParameterType.String,TradeAccount,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@UserName",DbParameterType.String,UserName,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@TelPhone",DbParameterType.String,TelPhone,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@Broker",DbParameterType.String,Broker,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@orgid",DbParameterType.String,orgid,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@IsBroker",DbParameterType.String,IsBroker,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@BeginDate",DbParameterType.DateTime,starttime,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@EndDate",DbParameterType.DateTime,endtime,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@ReportType",DbParameterType.Int,reporttype,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@ReportDir",DbParameterType.String,path,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@ReportFile",DbParameterType.String,rfile,ParameterDirection.Input),
OutputParam});
if (0 == Convert.ToInt32(OutputParam.Value))
{
forms.Result = true;
forms.Desc = "报表导出成功";
forms.ReportAddr = ComFunction.ReportAddr + dt.ToString("yyyyMM") + "/" + rfile; //URL地址
}
else
{
forms.Result = false;
forms.Desc = "报表导出失败";
forms.ReportAddr = string.Empty;
}
}
catch (Exception ex)
{
ComFunction.WriteErr(ex);
forms.Result = false;
forms.Desc = "报表导出错误";
forms.ReportAddr = string.Empty;
}
return forms;
}
/// <summary>
/// 导出报表
/// </summary>
/// <param name="starttime">开始时间</param>
/// <param name="endtime">结束时间</param>
/// <param name="reporttype">报表类型(0有效订单,1限价挂单,2入库单,3平仓,4资金变动,5账户结余)</param>
/// <param name="LoginID">管理员或组织登陆标识</param>
/// <returns>报表地址</returns>
public ReportForms GetReportForms(DateTime starttime, DateTime endtime, int reporttype, string LoginID)
{
string reportAddr = string.Empty;
ReportForms forms = new ReportForms();
string rfile = string.Empty;
try
{
TradeUser TdUser = new TradeUser();
#region 判断登陆标识是否过期
if (!ComFunction.ExistUserLoginID(LoginID, ref TdUser))
{
forms.Result = false;
forms.Desc = ResCode.UL003Desc;
return forms;
}
if (UserType.NormalType == TdUser.UType)
{
forms.Result = false;
forms.Desc = ComFunction.NotRightUser;
return forms;
}
#endregion
if (!(reporttype >= 0 && reporttype <= 10))
{
forms.Result = false;
forms.Desc = "报表类型错误";
return forms;
}
DateTime dt = DateTime.Now;
switch (reporttype) //确定导出文件名称
{
case 0: rfile = string.Format("Y{0}.xls", dt.ToString("yyyyMMddHHmmssfff"));
break;
case 1: rfile = string.Format("X{0}.xls", dt.ToString("yyyyMMddHHmmssfff"));
break;
case 2: rfile = string.Format("R{0}.xls", dt.ToString("yyyyMMddHHmmssfff"));
break;
case 3: rfile = string.Format("T{0}.xls", dt.ToString("yyyyMMddHHmmssfff"));
break;
case 4: rfile = string.Format("Z{0}.xls", dt.ToString("yyyyMMddHHmmssfff"));
break;
case 5: rfile = string.Format("M{0}.xls", dt.ToString("yyyyMMddHHmmssfff"));
break;
default: rfile = string.Format("B{0}.xls", dt.ToString("yyyyMMddHHmmssfff"));
break;
}
System.Data.Common.DbParameter OutputParam = DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@Result", DbParameterType.String, 1, ParameterDirection.Output);
if (UserType.OrgType == TdUser.UType && !string.IsNullOrEmpty(TdUser.OrgId))
{
DbHelper.RunProcedureExecuteSql("P_ReportExportExcelAgent",
new System.Data.Common.DbParameter[]{
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@BeginDate",DbParameterType.DateTime,starttime,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@EndDate",DbParameterType.DateTime,endtime,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@Agentid",DbParameterType.String,TdUser.OrgId,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@ReportType",DbParameterType.Int,reporttype,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@ReportDir",DbParameterType.String,ComFunction.ReportFilePath + "\\" + dt.ToString("yyyyMM"),ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@ReportFile",DbParameterType.String,rfile,ParameterDirection.Input),
OutputParam});
}
else
{
string path = ComFunction.ReportFilePath + "\\" + dt.ToString("yyyyMM");
DbHelper.RunProcedureExecuteSql("P_ReportExportExcel",
new System.Data.Common.DbParameter[]{
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@BeginDate",DbParameterType.DateTime,starttime,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@EndDate",DbParameterType.DateTime,endtime,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@ReportType",DbParameterType.Int,reporttype,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@ReportDir",DbParameterType.String,path,ParameterDirection.Input),
DbHelper.CreateDbParameter(JinTong.Jyrj.Data.DataBase.Type,
"@ReportFile",DbParameterType.String,rfile,ParameterDirection.Input),
OutputParam});
}
if (0 == Convert.ToInt32(OutputParam.Value))
{
forms.Result = true;
forms.Desc = "报表导出成功";
forms.ReportAddr = ComFunction.ReportAddr + dt.ToString("yyyyMM") + "/" + rfile; //URL地址
}
else
{
forms.Result = false;
forms.Desc = "报表导出失败";
forms.ReportAddr = string.Empty;
}
}
catch (Exception ex)
{
ComFunction.WriteErr(ex);
forms.Result = false;
forms.Desc = "报表导出错误";
forms.ReportAddr = string.Empty;
}
return forms;
}