//=====================================================================
// FunctionName : Initalize
/// <summary>
/// 重载初始化函数
/// </summary>
//=====================================================================
protected override void Initalize()
{
DetailPage = true;
gvList.Columns[intKCYYBHColumnIndex].Visible = chkShowKCYYBH.Checked;
gvList.Columns[intKCBBHColumnIndex].Visible = chkShowKCBBH.Checked;
gvList.Columns[intHYBHColumnIndex].Visible = chkShowHYBH.Checked;
gvList.Columns[intYYSJColumnIndex].Visible = chkShowYYSJ.Checked;
gvList.Columns[intYYBZColumnIndex].Visible = chkShowYYBZ.Checked;
gvList.Columns[intSKZTColumnIndex].Visible = chkShowSKZT.Checked;
gvList.Columns[intXHKSColumnIndex].Visible = chkShowXHKS.Checked;
gvList.Columns[intKTZPColumnIndex].Visible = chkShowKTZP.Checked;
gvList.Columns[intJSPJColumnIndex].Visible = chkShowJSPJ.Checked;
gvList.Columns[intPJRColumnIndex].Visible = chkShowPJR.Checked;
gvList.Columns[intPJSJColumnIndex].Visible = chkShowPJSJ.Checked; YYSJ.Attributes.Add("onclick", "setday(this);");
YYSJBegin.Attributes.Add("onclick", "setday(this);");
YYSJEnd.Attributes.Add("onclick", "setday(this);");
PJSJ.Attributes.Add("onclick", "setday(this);");
PJSJBegin.Attributes.Add("onclick", "setday(this);");
PJSJEnd.Attributes.Add("onclick", "setday(this);");
// 数据查询
appData = new T_BM_KCYYXXApplicationData();
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_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();
}
protected override void Initalize()
{
// 读取记录详细资料
appData = new T_BM_KCYYXXApplicationData();
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["KCBBH"].ToString();
string strLogContent = MessageManager.GetMessageInfo(MessageManager.LOG_MSGID_0012, strMessageParam);
RICH.Common.LM.LogLibrary.LogWrite(strLogTypeID, strLogContent, null, drTemp["ObjectID"].ToString(), null);
//记录日志结束
}
}
}
//=====================================================================
// 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 T_BM_KCYYXXApplicationData();
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["KCBBH"].ToString();
string strLogContent = MessageManager.GetMessageInfo(MessageManager.LOG_MSGID_0012, strMessageParam);
RICH.Common.LM.LogLibrary.LogWrite(strLogTypeID, strLogContent, null, drTemp["ObjectID"].ToString(), null);
//记录日志结束
}
}
}
//=====================================================================
// FunctionName : Initalize
/// <summary>
/// 重载初始化函数
/// </summary>
//=====================================================================
protected override void Initalize()
{
// 创建信息标题
lblCaption.Text = GetTableCaption();
gvPrint.CaptionAlign = TableCaptionAlign.Left;
// 数据统计
appData = new T_BM_KCYYXXApplicationData();
CountRecord();
gvPrint.DataSource = appData.ResultSet;
gvPrint.DataBind();
}
protected override void Initalize()
{
DetailPage = true;
// 数据查询
appData = new T_BM_KCYYXXApplicationData();
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 T_BM_KCYYXXApplicationData();
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 override string GetObjectID()
{
appData = new T_BM_KCYYXXApplicationData();
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 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 + "/" + "T_BM_KCYYXX", dt, true, true);
T_BM_KCYYXXApplicationLogic instanceT_BM_KCYYXXApplicationLogic = (T_BM_KCYYXXApplicationLogic)CreateApplicationLogicInstance(typeof(T_BM_KCYYXXApplicationLogic));
foreach (DataRow dr in dt.Rows)
{
appData = new T_BM_KCYYXXApplicationData();
appData.KCYYBH = instanceT_BM_KCYYXXApplicationLogic.AutoGenerateKCYYBH(appData);
int i = 0;
appData = instanceT_BM_KCYYXXApplicationLogic.Add(appData);
}
}
//=====================================================================
// FunctionName : Initalize
/// <summary>
/// 重载初始化函数
/// </summary>
//=====================================================================
protected override void Initalize()
{
// 初始化界面
YYSJ.Attributes.Add("onclick", "setday(this);"); YYBZ.ImageGalleryPath = "~/Media/Image/FreeTextBox/" + Session[RICH.Common.ConstantsManager.SESSION_USER_ID] + "/"; JSPJ.ImageGalleryPath = "~/Media/Image/FreeTextBox/" + Session[RICH.Common.ConstantsManager.SESSION_USER_ID] + "/"; PJSJ.Attributes.Add("onclick", "setday(this);");
// 界面控件状态
if (ViewMode || EditMode || CopyMode)
{
// 读取要修改记录详细资料
appData = new T_BM_KCYYXXApplicationData
{
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"]);
KCYYBH.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["KCYYBH"]);
KCBBH.SelectedValue = GetValue(appData.ResultSet.Tables[0].Rows[0]["KCBBH"]);
HYBH.SelectedValue = GetValue(appData.ResultSet.Tables[0].Rows[0]["HYBH"]);
YYSJ.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["YYSJ"]);
YYBZ.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["YYBZ"]);
SKZT.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["SKZT"]);
XHKS.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["XHKS"]);
KTZP.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["KTZP"]);
JSPJ.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["JSPJ"]);
PJR.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["PJR"]);
PJSJ.Text = GetValue(appData.ResultSet.Tables[0].Rows[0]["PJSJ"]);
}
}
if (AddMode)
{
// 初始化传入参数
// 初始化默认值
}
}
//=====================================================================
// FunctionName : Initalize
/// <summary>
/// ÖØÔسõʼ»¯º¯Êý
/// </summary>
//=====================================================================
protected override void Initalize()
{
try
{
appData = new T_BM_KCYYXXApplicationData();
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()
{
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>
/// 重载ExportToFile
/// </summary>
//=====================================================================
protected override void ExportToFile()
{
appData = new T_BM_KCYYXXApplicationData();
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()
{
appData = new T_BM_KCYYXXApplicationData();
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 void btnInfoFromDS_Click(object sender, EventArgs e)
{
int totalCount = 0;
int importCount = 0;
int updateCount = 0;
try
{
var appDatas = T_BM_KCYYXXApplicationData.GetDataFromDataFile <T_BM_KCYYXXApplicationData>(InfoFromDoc.Text, true, true, recordStartLine: T_BM_KCYYXXContants.ImportDataSetStartLineNum);
T_BM_KCYYXXApplicationLogic instanceT_BM_KCYYXXApplicationLogic = (T_BM_KCYYXXApplicationLogic)CreateApplicationLogicInstance(typeof(T_BM_KCYYXXApplicationLogic));
totalCount = appDatas.Count;
foreach (var app in appDatas)
{
app.KCYYBH = instanceT_BM_KCYYXXApplicationLogic.AutoGenerateKCYYBH(app);
string strKCBBH = GetValue(new RICH.Common.BM.T_BM_KCBXX.T_BM_KCBXXApplicationLogicBase().GetValueByFixCondition("KCBH", app.KCBBH, "KCBBH"));
if (!DataValidateManager.ValidateIsNull(strKCBBH))
{
app.KCBBH = strKCBBH;
}
if (!KCBBH.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.KCBBH = Convert.ToString(KCBBH.SelectedValue);
}
string strHYBH = GetValue(new RICH.Common.BM.T_BM_HYXX.T_BM_HYXXApplicationLogicBase().GetValueByFixCondition("HYXM", app.HYBH, "HYBH"));
if (!DataValidateManager.ValidateIsNull(strHYBH))
{
app.HYBH = strHYBH;
}
if (!HYBH.SelectedValue.IsHtmlNullOrWiteSpace())
{
app.HYBH = Convert.ToString(HYBH.SelectedValue);
}
if (!YYSJ.Text.IsHtmlNullOrWiteSpace())
{
app.YYSJ = Convert.ToDateTime(YYSJ.Text);
}
if (!YYBZ.Text.IsHtmlNullOrWiteSpace())
{
app.YYBZ = Convert.ToString(YYBZ.Text);
}
if (!SKZT.Text.IsHtmlNullOrWiteSpace())
{
app.SKZT = Convert.ToString(SKZT.Text);
}
if (!XHKS.Text.IsHtmlNullOrWiteSpace())
{
app.XHKS = Convert.ToInt32(XHKS.Text);
}
if (!KTZP.Text.IsHtmlNullOrWiteSpace())
{
app.KTZP = Convert.ToString(KTZP.Text);
}
if (!JSPJ.Text.IsHtmlNullOrWiteSpace())
{
app.JSPJ = Convert.ToString(JSPJ.Text);
}
string strPJR = GetValue(new RICH.Common.BM.T_PM_UserInfo.T_PM_UserInfoApplicationLogicBase().GetValueByFixCondition("UserNickName", app.PJR, "UserID"));
if (!DataValidateManager.ValidateIsNull(strPJR))
{
app.PJR = strPJR;
}
if (!PJR.Text.IsHtmlNullOrWiteSpace())
{
app.PJR = Convert.ToString(PJR.Text);
}
if (!PJSJ.Text.IsHtmlNullOrWiteSpace())
{
app.PJSJ = Convert.ToDateTime(PJSJ.Text);
}
instanceT_BM_KCYYXXApplicationLogic.Add(app);
if (app.ResultCode == RICH.Common.Base.ApplicationData.ApplicationDataBase.ResultState.Succeed)
{
importCount++;
}
else
{
app.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.PK;
instanceT_BM_KCYYXXApplicationLogic.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);
}
}
