protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(_DBName))
{
DivQryCondition.Visible = false;
DivQryResult.Visible = false;
labErrMsg.Visible = true;
labErrMsg.Text = Util.getHtmlMessage(Util.HtmlMessageKind.ParaError, string.Format(SinoPac.WebExpress.Common.Properties.Resources.Msg_ParaNotFound1, "DBName"));
return;
}
if (_AllowPurgeYN.ToUpper() == "Y")
{
btnPurgeTable.Visible = true;
}
else
{
btnPurgeTable.Visible = false;
}
if (!IsPostBack)
{
btnPurgeTable.ToolTip = "清除[AppLog]所有資料";
btnPurgeTable.OnClientClick = "return confirm('確定清除[" + _DBName + "]資料庫內，[AppLog]資料表的所有資料？');";
LogType.ucSourceDictionary = _Dic_AppLogType;
LogType.Refresh();
}
}
/// <summary>
/// 初始查詢條件
/// </summary>
protected void InitQryCondition()
{
labQryHeader.Text = string.Format("[{0}] 查詢條件", _TableName);
labQryResultHeader.Text = string.Format("[{0}] 查詢結果", _TableName);
btnPurgeTable.ToolTip = string.Format("清除[{0}]所有資料", _TableName);
btnPurgeTable.OnClientClick = string.Format("return confirm('確定清除[{0}]資料庫內，[{1}]資料表的所有資料？');", _DBName, _TableName);
DataTable dtSchema = Util.getDataSchemaInfo(_DBName).Select(string.Format(" TABLE_NAME = '{0}' and TABLE_TYPE = 'BASE TABLE' ", _TableName)).CopyToDataTable();
Dictionary <string, string> dicTable = Util.getDictionary(dtSchema, "COLUMN_NAME", "IS_PKEY");
PageViewState["_TableFieldList"] = Util.getArray(dicTable);
PageViewState["_TablePKFieldList"] = dicTable.AsEnumerable().Where(r => r.Value == "Y").Select(k => k.Key).ToArray();
Util_ucTextBox oTxt;
CheckBox oChk;
for (int i = 0; i < 10; i++)
{
oTxt = (Util_ucTextBox)Util.FindControlEx(this.Page, string.Format("PKey{0}", (i + 1).ToString().PadLeft(2, '0')));
oChk = (CheckBox)Util.FindControlEx(this.Page, string.Format("IsLikePKey{0}", (i + 1).ToString().PadLeft(2, '0')));
if (oTxt != null)
{
oTxt.ucCaption = "";
oTxt.ucTextData = "";
oTxt.Visible = false;
oChk.Visible = false;
oChk.Checked = false;
}
}
for (int i = 0; i < ((string[])PageViewState["_TablePKFieldList"]).Count(); i++)
{
oTxt = (Util_ucTextBox)Util.FindControlEx(this.Page, string.Format("PKey{0}", (i + 1).ToString().PadLeft(2, '0')));
oChk = (CheckBox)Util.FindControlEx(this.Page, string.Format("IsLikePKey{0}", (i + 1).ToString().PadLeft(2, '0')));
if (oTxt != null && ((string[])PageViewState["_TablePKFieldList"])[i] != "TableLogNo")
{
oTxt.ucCaptionWidth = 100;
oTxt.ucWidth = 150;
oTxt.ucCaption = ((string[])PageViewState["_TablePKFieldList"])[i];
oTxt.ucTextData = "";
oTxt.Visible = true;
oChk.Visible = true;
}
}
LogType.ucSourceDictionary = _Dic_AppTableLogType;
LogType.Refresh();
if (_AllowPurgeYN.ToUpper() == "Y")
{
btnPurgeTable.Visible = true;
}
else
{
btnPurgeTable.Visible = false;
}
if (!Util.getRequestQueryString().IsNullOrEmpty("TableName"))
{
btnClearTableName.Visible = false;
}
else
{
btnClearTableName.Visible = true;
}
}
