protected override void Initalize()
{
// 读取记录详细资料
appData = new FilterReportApplicationData();
appData.ObjectID = ObjectID;
appData.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID;
QueryRecord();
Header.DataBind();
rptDetail.DataSource = appData.ResultSet;
rptDetail.DataBind();
if (!IsPostBack)
{
foreach (DataRow drTemp in appData.ResultSet.Tables[0].Rows)
{
//记录日志开始
string strLogTypeID = "A10";
strMessageParam[0] = (string)Session[ConstantsManager.SESSION_USER_LOGIN_NAME];
strMessageParam[1] = "报表信息";
strMessageParam[2] = drTemp["BGMC"].ToString();
string strLogContent = MessageManager.GetMessageInfo(MessageManager.LOG_MSGID_0012, strMessageParam);
RICH.Common.LM.LogLibrary.LogWrite(strLogTypeID, strLogContent, null, drTemp["ObjectID"].ToString(), null);
//记录日志结束
}
}
}
protected void btnDeleteFilterReport_Click(object sender, EventArgs e)
{
if (MainContentPlaceHolder != null)
{
var FilterReportList = MainContentPlaceHolder.FindControl("FilterReportList") as DropDownList;
var FilterReportName = MainContentPlaceHolder.FindControl("FilterReportName") as TextBox;
if (FilterReportList != null && FilterReportName != null)
{
FilterReportApplicationLogic filterReportApplicationLogic = (FilterReportApplicationLogic)CreateApplicationLogicInstance(typeof(FilterReportApplicationLogic));
FilterReportApplicationData filterReportApplicationData = new FilterReportApplicationData();
if (FilterReportList.SelectedIndex <= 0 || !string.Equals(FilterReportName.Text.TrimIfNotNullOrWhiteSpace(), FilterReportList.SelectedItem.Text, StringComparison.OrdinalIgnoreCase))
{
return;
}
filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
if (filterReportApplicationData.XTBG != "0")
{
MessageContent += @"<font color=""red"">没有权限删除系统报告。</font>";
}
else if (!filterReportApplicationData.UserID.Equals((string)Session[ConstantsManager.SESSION_USER_ID]))
{
MessageContent += @"<font color=""red"">没有权限删除共享报告。</font>";
}
else
{
filterReportApplicationLogic.Delete(new FilterReportApplicationData()
{
ObjectID = filterReportApplicationData.ObjectID, OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID
});
FilterReportDataBind((string)Session[ConstantsManager.SESSION_USER_ID], FilterReportList);
FilterReportList_SelectedIndexChanged(sender, e);
}
}
}
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new T_BG_0601ApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
T_BG_0601ApplicationData obj = new T_BG_0601ApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as T_BG_0601ApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
BT.Text = GetValue(appData.BT);
FBLM.SelectedValue = GetValue(appData.FBLMBatch);
FBBM.SelectedValue = GetValue(appData.FBBM);
XXNR.Text = GetValue(appData.XXNR);
FBSJRQ.Text = GetValue(appData.FBSJRQBegin);
FBSJRQ.Text = GetValue(appData.FBSJRQEnd);
FBSJRQ.Text = GetValue(appData.FBSJRQ);
FBH.Text = GetValue(appData.FBH);
XXLX.SelectedValue = GetValue(appData.XXLX);
IsTop.SelectedValue = GetValue(appData.IsTop);
IsBest.SelectedValue = GetValue(appData.IsBest);
FBRJGH.Text = GetValue(appData.FBRJGH);
}
Initalize();
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new T_PM_UserInfoApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
T_PM_UserInfoApplicationData obj = new T_PM_UserInfoApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as T_PM_UserInfoApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
UserLoginName.Text = GetValue(appData.UserLoginName);
UserGroupID.SelectedValues = GetValue(appData.UserGroupIDBatch);
SubjectID.SelectedValue = GetValue(appData.SubjectIDBatch);
UserNickName.Text = GetValue(appData.UserNickName);
SJH.Text = GetValue(appData.SJH);
Email.Text = GetValue(appData.Email);
UserStatus.SelectedValue = GetValue(appData.UserStatus);
QQH.Text = GetValue(appData.QQH);
XB.SelectedValue = GetValue(appData.XBBatch);
SFZH.Text = GetValue(appData.SFZH);
MZ.SelectedValue = GetValue(appData.MZBatch);
ZZMM.SelectedValue = GetValue(appData.ZZMMBatch);
BGDH.Text = GetValue(appData.BGDH);
JTDH.Text = GetValue(appData.JTDH);
}
Initalize();
}
protected override void Initalize()
{
// 初始化界面
// 界面控件状态
if (ViewMode || EditMode || CopyMode)
{
// 读取要修改记录详细资料
appData = new FilterReportApplicationData
{
ObjectID = base.ObjectID,
OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID
};
QueryRecord();
// 控件赋值
if (appData.RecordCount > 0)
{
ObjectID.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["ObjectID"]);
BGMC.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["BGMC"]);
UserID.SelectedValue = GetValue(appData.ResultSet.Tables[0].Rows[0]["UserID"]);
BGLX.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["BGLX"]);
GXBG.SelectedValue = GetValue(appData.ResultSet.Tables[0].Rows[0]["GXBG"]);
XTBG.SelectedValue = GetValue(appData.ResultSet.Tables[0].Rows[0]["XTBG"]);
BGCXTJ.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["BGCXTJ"]);
BGCJSJ.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["BGCJSJ"]);
}
}
if (AddMode)
{
// 初始化传入参数
// 初始化默认值
}
}
//=====================================================================
// FunctionName : Initalize
/// <summary>
/// 重载初始化函数
/// </summary>
//=====================================================================
protected override void Initalize()
{
// 界面初始化
// 初始化打印页面大小
ddlPrintPageSize.Items.Add(new System.Web.UI.WebControls.ListItem("A4", "A4"));
ddlPrintPageSize.Items.Add(new System.Web.UI.WebControls.ListItem("A3", "A3"));
// 初始化打印页面方向大小
ddlPrintPageOrientation.Items.Add(new System.Web.UI.WebControls.ListItem("竖向", "portrait"));
ddlPrintPageOrientation.Items.Add(new System.Web.UI.WebControls.ListItem("横向", "landscape"));
// 读取记录详细资料
appData = new FilterReportApplicationData();
appData.ObjectID = ObjectID;
appData.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID;
QueryRecord();
Header.DataBind();
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
if (IsPostBack != true)
{
foreach (DataRow drTemp in appData.ResultSet.Tables[0].Rows)
{
//记录日志开始
string strLogTypeID = "A10";
strMessageParam[0] = (string)Session[ConstantsManager.SESSION_USER_LOGIN_NAME];
strMessageParam[1] = "报表信息";
strMessageParam[2] = drTemp["BGMC"].ToString();
string strLogContent = MessageManager.GetMessageInfo(MessageManager.LOG_MSGID_0012, strMessageParam);
RICH.Common.LM.LogLibrary.LogWrite(strLogTypeID, strLogContent, null, drTemp["ObjectID"].ToString(), null);
//记录日志结束
}
}
}
//=====================================================================
// 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;
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new T_BM_HYXXApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
T_BM_HYXXApplicationData obj = new T_BM_HYXXApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as T_BM_HYXXApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
HYBH.Text = GetValue(appData.HYBH);
HYXM.Text = GetValue(appData.HYXM);
HYNC.Text = GetValue(appData.HYNC);
HYSR.Text = GetValue(appData.HYSRBegin);
HYSR.Text = GetValue(appData.HYSREnd);
HYSR.Text = GetValue(appData.HYSR);
HYXX.Text = GetValue(appData.HYXX);
HYBJ.Text = GetValue(appData.HYBJ);
JZXM.Text = GetValue(appData.JZXM);
JZDH.Text = GetValue(appData.JZDH);
ZCSJ.Text = GetValue(appData.ZCSJBegin);
ZCSJ.Text = GetValue(appData.ZCSJEnd);
ZCSJ.Text = GetValue(appData.ZCSJ);
ZKSS.Text = GetValue(appData.ZKSS);
XHKSS.Text = GetValue(appData.XHKSS);
SYKSS.Text = GetValue(appData.SYKSS);
}
Initalize();
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new T_BM_KCYYXXApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
T_BM_KCYYXXApplicationData obj = new T_BM_KCYYXXApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as T_BM_KCYYXXApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
KCBBH.SelectedValue = GetValue(appData.KCBBH);
HYBH.SelectedValue = GetValue(appData.HYBH);
YYSJ.Text = GetValue(appData.YYSJBegin);
YYSJ.Text = GetValue(appData.YYSJEnd);
YYSJ.Text = GetValue(appData.YYSJ);
YYBZ.Text = GetValue(appData.YYBZ);
SKZT.Text = GetValue(appData.SKZT);
PJR.Text = GetValue(appData.PJR);
PJSJ.Text = GetValue(appData.PJSJBegin);
PJSJ.Text = GetValue(appData.PJSJEnd);
PJSJ.Text = GetValue(appData.PJSJ);
}
Initalize();
}
//=====================================================================
// FunctionName : Initalize
/// <summary>
/// 重载初始化函数
/// </summary>
//=====================================================================
protected override void Initalize()
{
// 创建信息标题
lblCaption.Text = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
// 数据统计
appData = new FilterReportApplicationData();
CountRecord();
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
}
protected override void Initalize()
{
DetailPage = true;
// 数据查询
appData = new FilterReportApplicationData();
QueryRecord();
rptList.DataSource = appData.ResultSet;
rptList.DataBind();
ViewState["RecordCount"] = appData.RecordCount;
ViewState["CurrentPage"] = appData.CurrentPage;
ViewState["PageSize"] = appData.PageSize;
ViewState["PageCount"] = FunctionManager.RoundInt(((int)ViewState["RecordCount"] / (float)(int)ViewState["PageSize"]));
InitPageInfo();
}
protected override void btnSaveFilterReport_Click(object sender, EventArgs e)
{
if (FilterReportName.Text.IsHtmlNullOrWiteSpace())
{
return;
}
appData = new DictionaryApplicationData();
GetQueryInputParameter();
FilterReportApplicationLogic filterReportApplicationLogic = (FilterReportApplicationLogic)CreateApplicationLogicInstance(typeof(FilterReportApplicationLogic));
FilterReportApplicationData filterReportApplicationData = new FilterReportApplicationData()
{
BGMC = FilterReportName.Text.TrimIfNotNullOrWhiteSpace(),
UserID = (string)Session[ConstantsManager.SESSION_USER_ID],
BGLX = FilterReportType,
GXBG = "0",
XTBG = "0",
BGCXTJ = JsonHelper.ObjectToJson(appData),
BGCJSJ = DateTime.Now,
};
FilterReportApplicationData filterReportQueryApplicationData;
if (!FilterReportName.Text.IsHtmlNullOrWiteSpace())
{
filterReportQueryApplicationData = new FilterReportApplicationData()
{
BGMC = FilterReportName.Text.TrimIfNotNullOrWhiteSpace(),
UserID = (string)Session[ConstantsManager.SESSION_USER_ID],
BGLX = FilterReportType,
XTBG = "0",
CurrentPage = 1,
PageSize = 1000,
};
filterReportQueryApplicationData = filterReportApplicationLogic.Query(filterReportQueryApplicationData);
if (filterReportQueryApplicationData.ResultSet.Tables.Count > 0)
{
foreach (DataRow item in filterReportQueryApplicationData.ResultSet.Tables[0].Rows)
{
filterReportApplicationLogic.Delete(new FilterReportApplicationData()
{
ObjectID = GetValue(item["ObjectID"]), OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID
});
}
}
}
filterReportApplicationLogic.Add(filterReportApplicationData);
FilterReportDataBind((string)Session[ConstantsManager.SESSION_USER_ID], FilterReportList);
FilterReportList.Items.FindByText(FilterReportName.Text.TrimIfNotNullOrWhiteSpace()).Selected = true;
}
protected void btnInfoFromDocBatch_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = GetTemplateColumn(dt);
dt = FileLibrary.GetDataFromWordBatch(ConstantsManager.WEBSITE_VIRTUAL_ROOT_DIR + "/" + ConstantsManager.UPLOAD_DOC_DIR + "/" + "FilterReport", dt, true, true);
FilterReportApplicationLogic instanceFilterReportApplicationLogic = (FilterReportApplicationLogic)CreateApplicationLogicInstance(typeof(FilterReportApplicationLogic));
foreach (DataRow dr in dt.Rows)
{
appData = new FilterReportApplicationData();
int i = 0;
appData = instanceFilterReportApplicationLogic.Add(appData);
}
}
protected override string GetObjectID()
{
appData = new FilterReportApplicationData();
appData.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ALL;
appData.PageSize = 1;
appData.CurrentPage = 1;
QueryRecord();
if (appData.RecordCount == 1)
{
return(GetValue(appData.ResultSet.Tables[0].Rows[0]["ObjectID"]));
}
else
{
return(string.Empty);
}
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new DictionaryTypeApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
DictionaryTypeApplicationData obj = new DictionaryTypeApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as DictionaryTypeApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
DM.Text = GetValue(appData.DM);
MC.Text = GetValue(appData.MC);
SM.Text = GetValue(appData.SM);
}
Initalize();
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new T_BG_0602ApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
T_BG_0602ApplicationData obj = new T_BG_0602ApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as T_BG_0602ApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
LMM.Text = GetValue(appData.LMM);
SJLMH.SelectedValue = GetValue(appData.SJLMH);
LMLBYS.SelectedValue = GetValue(appData.LMLBYS);
LMNR.Text = GetValue(appData.LMNR);
}
Initalize();
}
//=====================================================================
// FunctionName : Initalize
/// <summary>
/// 重载初始化函数
/// </summary>
//=====================================================================
protected override void Initalize()
{
gvList.Columns[intBGMCColumnIndex].Visible = chkShowBGMC.Checked;
gvList.Columns[intUserIDColumnIndex].Visible = chkShowUserID.Checked;
gvList.Columns[intBGLXColumnIndex].Visible = chkShowBGLX.Checked;
gvList.Columns[intGXBGColumnIndex].Visible = chkShowGXBG.Checked;
gvList.Columns[intXTBGColumnIndex].Visible = chkShowXTBG.Checked;
gvList.Columns[intBGCJSJColumnIndex].Visible = chkShowBGCJSJ.Checked; BGCJSJ.Attributes.Add("onclick", "setday(this);");
// 数据查询
appData = new FilterReportApplicationData();
QueryRecord();
gvList.DataSource = appData.ResultSet;
gvList.DataBind();
ViewState["RecordCount"] = appData.RecordCount;
ViewState["CurrentPage"] = appData.CurrentPage;
ViewState["PageSize"] = appData.PageSize;
ViewState["PageCount"] = FunctionManager.RoundInt(((int)ViewState["RecordCount"] / (float)(int)ViewState["PageSize"]));
InitPageInfo();
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new T_PM_UserGroupInfoApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
T_PM_UserGroupInfoApplicationData obj = new T_PM_UserGroupInfoApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as T_PM_UserGroupInfoApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
UserGroupID.Text = GetValue(appData.UserGroupID);
UserGroupName.Text = GetValue(appData.UserGroupName);
UserGroupContent.Text = GetValue(appData.UserGroupContent);
UserGroupRemark.Text = GetValue(appData.UserGroupRemark);
}
Initalize();
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new T_BM_DWXXApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
T_BM_DWXXApplicationData obj = new T_BM_DWXXApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as T_BM_DWXXApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
DWMC.Text = GetValue(appData.DWMC);
SJDWBH.SelectedValue = GetValue(appData.SJDWBH);
LXR.Text = GetValue(appData.LXR);
DWBH.Text = GetValue(appData.DWBH);
DZ.Text = GetValue(appData.DZ);
}
Initalize();
}
protected void FilterReportDataBind(string userID, DropDownList filterReportList, string defaultSelectValue = null)
{
FilterReportApplicationLogic filterReportApplicationLogic = (FilterReportApplicationLogic)CreateApplicationLogicInstance(typeof(FilterReportApplicationLogic));
FilterReportApplicationData filterReportApplicationData = new FilterReportApplicationData()
{
UserID = userID,
BGLX = FilterReportType,
GXBG = "0",
XTBG = "0",
CurrentPage = 1,
PageSize = 1000,
};
filterReportApplicationData = filterReportApplicationLogic.Query(filterReportApplicationData);
filterReportList.DataSource = filterReportApplicationData.ResultSet;
filterReportList.DataBind();
filterReportList.Items.Insert(0, new ListItem("选择报告", ""));
if (!defaultSelectValue.IsNullOrWhiteSpace())
{
filterReportList.SelectedValue = defaultSelectValue;
}
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new FilterReportApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
FilterReportApplicationData obj = new FilterReportApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as FilterReportApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
BGMC.Text = GetValue(appData.BGMC);
UserID.SelectedValue = GetValue(appData.UserID);
BGLX.Text = GetValue(appData.BGLX);
GXBG.SelectedValue = GetValue(appData.GXBG);
XTBG.SelectedValue = GetValue(appData.XTBG);
BGCJSJ.Text = GetValue(appData.BGCJSJ);
}
Initalize();
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载ExportToFile
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
appData = new FilterReportApplicationData();
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;
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new T_BM_KCXLXXApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
T_BM_KCXLXXApplicationData obj = new T_BM_KCXLXXApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as T_BM_KCXLXXApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
KCXLBH.Text = GetValue(appData.KCXLBH);
KCXLMC.Text = GetValue(appData.KCXLMC);
KCXLSJBH.SelectedValue = GetValue(appData.KCXLSJBH);
KCXLJJ.Text = GetValue(appData.KCXLJJ);
NLD.Text = GetValue(appData.NLD);
KSS.Text = GetValue(appData.KSS);
}
Initalize();
}
//=====================================================================
// FunctionName : Initalize
/// <summary>
/// ÖØÔسõʼ»¯º¯Êý
/// </summary>
//=====================================================================
protected override void Initalize()
{
try
{
appData = new FilterReportApplicationData();
appData.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID;
appData.ObjectID = (string)Request.QueryString["ObjectID"];
QueryRecord();
if (appData.ResultSet.Tables[0].Rows.Count > 0)
{
if (appData.ResultSet.Tables[0].Rows[0][Request.QueryString["ImageField"]] != DBNull.Value)
{
Response.ContentType = "application/octet-stream";
Response.BinaryWrite((Byte[])appData.ResultSet.Tables[0].Rows[0][Request.QueryString["ImageField"]]);
Response.End();
}
else
{
Response.ClearContent();
Response.ContentType = "image/Png";
Response.BinaryWrite(RICH.Common.GenerateImage.GetStringImage("ÔÝÎÞͼƬ", 130, 160, 18, 10, 0).ToArray());
Response.End();
}
}
else
{
Response.ClearContent();
Response.ContentType = "image/Png";
Response.BinaryWrite(RICH.Common.GenerateImage.GetStringImage("ÔÝÎÞͼƬ", 130, 160, 18, 10, 0).ToArray());
Response.End();
}
}
catch (Exception)
{
Response.ContentType = "image/Png";
Response.BinaryWrite(RICH.Common.GenerateImage.GetStringImage("ÔÝÎÞͼƬ", 130, 160, 18, 10, 0).ToArray());
Response.End();
}
}
//=====================================================================
// FunctionName : ExportToFile
/// <summary>
/// 重载导出到文件函数
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
appData = new FilterReportApplicationData();
CountRecord();
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
// 创建信息标题
gvPrint.Caption = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
switch (ddlExportFileFormat.SelectedValue.ToLower())
{
case "xls":
FileLibrary.ExportToExcelFileWithoutControl(gvPrint, "Result");
break;
case "doc":
FileLibrary.ExportToWordFileWithoutControl(gvPrint, "Result");
break;
default:
FileLibrary.ExportToExcelFileWithoutControl(gvPrint, "Result");
break;
}
}
protected override void FilterReportList_SelectedIndexChanged(object sender, EventArgs e)
{
appData = new ShortMessageApplicationData();
FilterReportName.Text = string.Empty;
if (FilterReportList.SelectedIndex > 0)
{
FilterReportApplicationData filterReportApplicationData = FilterReportBusinessEntity.GetDataByObjectID(FilterReportList.SelectedValue);
ShortMessageApplicationData obj = new ShortMessageApplicationData();
appData = JsonHelper.JsonToObject(filterReportApplicationData.BGCXTJ, appData) as ShortMessageApplicationData;
FilterReportName.Text = filterReportApplicationData.BGMC;
}
if (appData != null)
{
DXXBT.Text = GetValue(appData.DXXBT);
DXXNR.Text = GetValue(appData.DXXNR);
FSSJ.Text = GetValue(appData.FSSJBegin);
FSSJ.Text = GetValue(appData.FSSJEnd);
FSSJ.Text = GetValue(appData.FSSJ);
FSR.Text = GetValue(appData.FSR);
JSR.SelectedValues = GetValue(appData.JSRBatch);
FSBM.Text = GetValue(appData.FSBM);
}
Initalize();
}
protected void btnInfoFromDS_Click(object sender, EventArgs e)
{
int totalCount = 0;
int importCount = 0;
int updateCount = 0;
try
{
var appDatas = FilterReportApplicationData.GetDataFromDataFile <FilterReportApplicationData>(InfoFromDoc.Text, true, true, recordStartLine: FilterReportContants.ImportDataSetStartLineNum);
FilterReportApplicationLogic instanceFilterReportApplicationLogic = (FilterReportApplicationLogic)CreateApplicationLogicInstance(typeof(FilterReportApplicationLogic));
totalCount = appDatas.Count;
foreach (var app in appDatas)
{
if (!BGMC.Text.IsHtmlNullOrWiteSpace())
{
app.BGMC = Convert.ToString(BGMC.Text);
}
app.UserID = (string)Session[ConstantsManager.SESSION_USER_ID];
string strUserID = GetValue(new RICH.Common.BM.T_PM_UserInfo.T_PM_UserInfoApplicationLogicBase().GetValueByFixCondition("UserLoginName", app.UserID, "UserID"));
if (!DataValidateManager.ValidateIsNull(strUserID))
{
app.UserID = strUserID;
}
if (!BGLX.Text.IsHtmlNullOrWiteSpace())
{
app.BGLX = Convert.ToString(BGLX.Text);
}
string strGXBG = GetValue(new RICH.Common.BM.Dictionary.DictionaryApplicationLogicBase().GetValueByFixCondition("MC", app.GXBG, "DM"));
if (!DataValidateManager.ValidateIsNull(strGXBG))
{
app.GXBG = strGXBG;
}
if (!GXBG.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.GXBG = Convert.ToString(GXBG.SelectedValue);
}
string strXTBG = GetValue(new RICH.Common.BM.Dictionary.DictionaryApplicationLogicBase().GetValueByFixCondition("MC", app.XTBG, "DM"));
if (!DataValidateManager.ValidateIsNull(strXTBG))
{
app.XTBG = strXTBG;
}
if (!XTBG.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.XTBG = Convert.ToString(XTBG.SelectedValue);
}
if (!BGCXTJ.Text.IsHtmlNullOrWiteSpace())
{
app.BGCXTJ = Convert.ToString(BGCXTJ.Text);
}
app.BGCJSJ = DateTime.Now;
instanceFilterReportApplicationLogic.Add(app);
if (app.ResultCode == RICH.Common.Base.ApplicationData.ApplicationDataBase.ResultState.Succeed)
{
importCount++;
}
else
{
app.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.PK;
instanceFilterReportApplicationLogic.Modify(app);
if (app.ResultCode == RICH.Common.Base.ApplicationData.ApplicationDataBase.ResultState.Succeed)
{
updateCount++;
}
}
}
MessageContent += @"<font color=""green"">共{0}条数据，导入数据{1}条，更新数据{2}条。</font>".FormatInvariantCulture(totalCount, importCount, updateCount);
}
catch (Exception ex)
{
MessageContent += @"<font color=""red"">导入数据过程出错：{0}<br/>共{1}条数据，已导入数据{2}条，已更新数据{3}条。</font>".FormatInvariantCulture(ex.Message, totalCount, importCount, updateCount);
}
}
