//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new T_BM_KCXLXXApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intKCXLBHColumnIndex - 1].Visible = chkShowKCXLBH.Checked;
gvPrint.Columns[intKCXLMCColumnIndex - 1].Visible = chkShowKCXLMC.Checked;
gvPrint.Columns[intKCXLSJBHColumnIndex - 1].Visible = chkShowKCXLSJBH.Checked;
gvPrint.Columns[intNLDColumnIndex - 1].Visible = chkShowNLD.Checked;
gvPrint.Columns[intKSSColumnIndex - 1].Visible = chkShowKSS.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new DictionaryApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intDMColumnIndex - 1].Visible = chkShowDM.Checked;
gvPrint.Columns[intLXColumnIndex - 1].Visible = chkShowLX.Checked;
gvPrint.Columns[intMCColumnIndex - 1].Visible = chkShowMC.Checked;
gvPrint.Columns[intSJDMColumnIndex - 1].Visible = chkShowSJDM.Checked;
gvPrint.Columns[intSMColumnIndex - 1].Visible = chkShowSM.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载ExportToFile
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
appData = new ShortMessageApplicationData();
appData.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID;
appData.ObjectID = base.ObjectID;
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
case "pdf":
string pageSize = ddlPrintPageSize.SelectedValue;
bool boolOrientation = ddlPrintPageOrientation.SelectedValue == "landscape" ? true : false;
float marginTop = DataValidateManager.ValidateNumberFormat(txtMarginTop.Text) == true ? Convert.ToSingle(txtMarginTop.Text) : 50;
float marginRight = DataValidateManager.ValidateNumberFormat(txtMarginRight.Text) == true ? Convert.ToSingle(txtMarginRight.Text) : 50;
float marginBottom = DataValidateManager.ValidateNumberFormat(txtMarginBottom.Text) == true ? Convert.ToSingle(txtMarginBottom.Text) : 50;
float marginLeft = DataValidateManager.ValidateNumberFormat(txtMarginLeft.Text) == true ? Convert.ToSingle(txtMarginLeft.Text) : 50;
ExportToPDFFile(appData.ResultSet, "Result", pageSize, boolOrientation, marginTop, marginRight, marginBottom, marginLeft);
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new ShortMessageApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intDXXBTColumnIndex - 1].Visible = chkShowDXXBT.Checked;
gvPrint.Columns[intDXXFJColumnIndex - 1].Visible = chkShowDXXFJ.Checked;
gvPrint.Columns[intFSSJColumnIndex - 1].Visible = chkShowFSSJ.Checked;
gvPrint.Columns[intFSRColumnIndex - 1].Visible = chkShowFSR.Checked;
gvPrint.Columns[intFSBMColumnIndex - 1].Visible = chkShowFSBM.Checked;
gvPrint.Columns[intSFCKColumnIndex - 1].Visible = chkShowSFCK.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new T_BG_0602ApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intLMHColumnIndex - 1].Visible = chkShowLMH.Checked;
gvPrint.Columns[intLMMColumnIndex - 1].Visible = chkShowLMM.Checked;
gvPrint.Columns[intSJLMHColumnIndex - 1].Visible = chkShowSJLMH.Checked;
gvPrint.Columns[intLMNRColumnIndex - 1].Visible = chkShowLMNR.Checked;
gvPrint.Columns[intLMLBYSColumnIndex - 1].Visible = chkShowLMLBYS.Checked;
gvPrint.Columns[intSFLBLMColumnIndex - 1].Visible = chkShowSFLBLM.Checked;
gvPrint.Columns[intSFWBURLColumnIndex - 1].Visible = chkShowSFWBURL.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new T_PM_UserGroupInfoApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intUserGroupIDColumnIndex - 1].Visible = chkShowUserGroupID.Checked;
gvPrint.Columns[intUserGroupNameColumnIndex - 1].Visible = chkShowUserGroupName.Checked;
gvPrint.Columns[intUserGroupContentColumnIndex - 1].Visible = chkShowUserGroupContent.Checked;
gvPrint.Columns[intUserGroupRemarkColumnIndex - 1].Visible = chkShowUserGroupRemark.Checked;
gvPrint.Columns[intDefaultPageColumnIndex - 1].Visible = chkShowDefaultPage.Checked;
gvPrint.Columns[intUpdateDateColumnIndex - 1].Visible = chkShowUpdateDate.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new FilterReportApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intBGMCColumnIndex - 1].Visible = chkShowBGMC.Checked;
gvPrint.Columns[intUserIDColumnIndex - 1].Visible = chkShowUserID.Checked;
gvPrint.Columns[intBGLXColumnIndex - 1].Visible = chkShowBGLX.Checked;
gvPrint.Columns[intGXBGColumnIndex - 1].Visible = chkShowGXBG.Checked;
gvPrint.Columns[intXTBGColumnIndex - 1].Visible = chkShowXTBG.Checked;
gvPrint.Columns[intBGCJSJColumnIndex - 1].Visible = chkShowBGCJSJ.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new T_PM_UserInfoApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intUserIDColumnIndex - 1].Visible = chkShowUserID.Checked;
gvPrint.Columns[intUserLoginNameColumnIndex - 1].Visible = chkShowUserLoginName.Checked;
gvPrint.Columns[intUserGroupIDColumnIndex - 1].Visible = chkShowUserGroupID.Checked;
gvPrint.Columns[intSubjectIDColumnIndex - 1].Visible = chkShowSubjectID.Checked;
gvPrint.Columns[intUserNickNameColumnIndex - 1].Visible = chkShowUserNickName.Checked;
gvPrint.Columns[intXBColumnIndex - 1].Visible = chkShowXB.Checked;
gvPrint.Columns[intMZColumnIndex - 1].Visible = chkShowMZ.Checked;
gvPrint.Columns[intZZMMColumnIndex - 1].Visible = chkShowZZMM.Checked;
gvPrint.Columns[intSFZHColumnIndex - 1].Visible = chkShowSFZH.Checked;
gvPrint.Columns[intSJHColumnIndex - 1].Visible = chkShowSJH.Checked;
gvPrint.Columns[intBGDHColumnIndex - 1].Visible = chkShowBGDH.Checked;
gvPrint.Columns[intJTDHColumnIndex - 1].Visible = chkShowJTDH.Checked;
gvPrint.Columns[intEmailColumnIndex - 1].Visible = chkShowEmail.Checked;
gvPrint.Columns[intQQHColumnIndex - 1].Visible = chkShowQQH.Checked;
gvPrint.Columns[intLoginTimeColumnIndex - 1].Visible = chkShowLoginTime.Checked;
gvPrint.Columns[intLastLoginIPColumnIndex - 1].Visible = chkShowLastLoginIP.Checked;
gvPrint.Columns[intLastLoginDateColumnIndex - 1].Visible = chkShowLastLoginDate.Checked;
gvPrint.Columns[intLoginTimesColumnIndex - 1].Visible = chkShowLoginTimes.Checked;
gvPrint.Columns[intUserStatusColumnIndex - 1].Visible = chkShowUserStatus.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new T_BG_0601ApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intFBHColumnIndex - 1].Visible = chkShowFBH.Checked;
gvPrint.Columns[intBTColumnIndex - 1].Visible = chkShowBT.Checked;
gvPrint.Columns[intFBLMColumnIndex - 1].Visible = chkShowFBLM.Checked;
gvPrint.Columns[intFBBMColumnIndex - 1].Visible = chkShowFBBM.Checked;
gvPrint.Columns[intXXLXColumnIndex - 1].Visible = chkShowXXLX.Checked;
gvPrint.Columns[intFJXZDZColumnIndex - 1].Visible = chkShowFJXZDZ.Checked;
gvPrint.Columns[intXXZTColumnIndex - 1].Visible = chkShowXXZT.Checked;
gvPrint.Columns[intIsTopColumnIndex - 1].Visible = chkShowIsTop.Checked;
gvPrint.Columns[intTopSortColumnIndex - 1].Visible = chkShowTopSort.Checked;
gvPrint.Columns[intIsBestColumnIndex - 1].Visible = chkShowIsBest.Checked;
gvPrint.Columns[intFBRJGHColumnIndex - 1].Visible = chkShowFBRJGH.Checked;
gvPrint.Columns[intFBSJRQColumnIndex - 1].Visible = chkShowFBSJRQ.Checked;
gvPrint.Columns[intFBIPColumnIndex - 1].Visible = chkShowFBIP.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new T_BM_HYXXApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intHYBHColumnIndex - 1].Visible = chkShowHYBH.Checked;
gvPrint.Columns[intHYXMColumnIndex - 1].Visible = chkShowHYXM.Checked;
gvPrint.Columns[intHYNCColumnIndex - 1].Visible = chkShowHYNC.Checked;
gvPrint.Columns[intHYSRColumnIndex - 1].Visible = chkShowHYSR.Checked;
gvPrint.Columns[intHYXXColumnIndex - 1].Visible = chkShowHYXX.Checked;
gvPrint.Columns[intHYBJColumnIndex - 1].Visible = chkShowHYBJ.Checked;
gvPrint.Columns[intJZXMColumnIndex - 1].Visible = chkShowJZXM.Checked;
gvPrint.Columns[intJZDHColumnIndex - 1].Visible = chkShowJZDH.Checked;
gvPrint.Columns[intZCSJColumnIndex - 1].Visible = chkShowZCSJ.Checked;
gvPrint.Columns[intZKSSColumnIndex - 1].Visible = chkShowZKSS.Checked;
gvPrint.Columns[intXHKSSColumnIndex - 1].Visible = chkShowXHKSS.Checked;
gvPrint.Columns[intSYKSSColumnIndex - 1].Visible = chkShowSYKSS.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new T_BM_KCYYXXApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intKCYYBHColumnIndex - 1].Visible = chkShowKCYYBH.Checked;
gvPrint.Columns[intKCBBHColumnIndex - 1].Visible = chkShowKCBBH.Checked;
gvPrint.Columns[intHYBHColumnIndex - 1].Visible = chkShowHYBH.Checked;
gvPrint.Columns[intYYSJColumnIndex - 1].Visible = chkShowYYSJ.Checked;
gvPrint.Columns[intYYBZColumnIndex - 1].Visible = chkShowYYBZ.Checked;
gvPrint.Columns[intSKZTColumnIndex - 1].Visible = chkShowSKZT.Checked;
gvPrint.Columns[intXHKSColumnIndex - 1].Visible = chkShowXHKS.Checked;
gvPrint.Columns[intKTZPColumnIndex - 1].Visible = chkShowKTZP.Checked;
gvPrint.Columns[intJSPJColumnIndex - 1].Visible = chkShowJSPJ.Checked;
gvPrint.Columns[intPJRColumnIndex - 1].Visible = chkShowPJR.Checked;
gvPrint.Columns[intPJSJColumnIndex - 1].Visible = chkShowPJSJ.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new T_BM_BMXXApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intBMBHColumnIndex - 1].Visible = chkShowBMBH.Checked;
gvPrint.Columns[intHYBHColumnIndex - 1].Visible = chkShowHYBH.Checked;
gvPrint.Columns[intKCJGColumnIndex - 1].Visible = chkShowKCJG.Checked;
gvPrint.Columns[intKSSColumnIndex - 1].Visible = chkShowKSS.Checked;
gvPrint.Columns[intKCZKColumnIndex - 1].Visible = chkShowKCZK.Checked;
gvPrint.Columns[intSJJGColumnIndex - 1].Visible = chkShowSJJG.Checked;
gvPrint.Columns[intSKRColumnIndex - 1].Visible = chkShowSKR.Checked;
gvPrint.Columns[intBMSJColumnIndex - 1].Visible = chkShowBMSJ.Checked;
gvPrint.Columns[intBZColumnIndex - 1].Visible = chkShowBZ.Checked;
gvPrint.Columns[intLRRColumnIndex - 1].Visible = chkShowLRR.Checked;
gvPrint.Columns[intLRSJColumnIndex - 1].Visible = chkShowLRSJ.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
CustomColumnIndex();
appData = new T_BM_DWXXApplicationData();
QueryRecord();
gvPrint.Visible = true;
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
gvPrint.Columns[intDWBHColumnIndex - 1].Visible = chkShowDWBH.Checked;
gvPrint.Columns[intDWMCColumnIndex - 1].Visible = chkShowDWMC.Checked;
gvPrint.Columns[intSJDWBHColumnIndex - 1].Visible = chkShowSJDWBH.Checked;
gvPrint.Columns[intDZColumnIndex - 1].Visible = chkShowDZ.Checked;
gvPrint.Columns[intYBColumnIndex - 1].Visible = chkShowYB.Checked;
gvPrint.Columns[intLXBMColumnIndex - 1].Visible = chkShowLXBM.Checked;
gvPrint.Columns[intLXDHColumnIndex - 1].Visible = chkShowLXDH.Checked;
gvPrint.Columns[intEmailColumnIndex - 1].Visible = chkShowEmail.Checked;
gvPrint.Columns[intLXRColumnIndex - 1].Visible = chkShowLXR.Checked;
gvPrint.Columns[intSJColumnIndex - 1].Visible = chkShowSJ.Checked;
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFile(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFile(gvPrint, "Result");
break;
}
gvPrint.Visible = false;
}