protected void Page_Load(object sender, EventArgs e)
{
ErrorMsgLabel.Text = "";
if (!IsPostBack)
{
PageTimeStamp.Value =
string.Format("{0}{1}{2}{3}{4}{5}",
DateTime.Now.Year.ToString(),
DateTime.Now.Month.ToString().PadLeft(2, '0'),
DateTime.Now.Day.ToString().PadLeft(2, '0'),
DateTime.Now.Hour.ToString().PadLeft(2, '0'),
DateTime.Now.Minute.ToString().PadLeft(2, '0'),
DateTime.Now.Second.ToString().PadLeft(2, '0')
);
ddlTABTYPE.Items.Clear();
ddlTABTYPE.Items.Add(new ListItem("全部", ""));
ddlTABTYPE.Items.Add(new ListItem("TABLE", "TABLE"));
ddlTABTYPE.Items.Add(new ListItem("VIEW", "VIEW"));
ddlTABTYPE.SelectedIndex = 0;
//載入ModuleName
IFM06_BCO BCO = new IFM06_BCO(ConntionDB);
ParameterList.Clear();
ParameterList.Add(DBNull.Value);
DataTable dt = BCO.QueryModuleName(ParameterList);
cblModule.Items.Clear();
foreach (DataRow dr in dt.Rows)
{
cblModule.Items.Add(new ListItem(dr["CODE"].ToString() + ' ' + dr["DESCRIPTION"].ToString(), dr["CODE"].ToString()));
}
}
else
{
//UnSetClinetFocus();
}
ToolBarInit();
}
private void AddSheetData1(ref Worksheet sheet, string strSheetName, DataTable dtTab)
{
//設定Worksheet各column 寬度
sheet.Font.Size = 10;
sheet.Font.Name = "新細明體";
sheet.Columns(0).Width = 55;
sheet.Columns(1).Width = 190;
sheet.Columns(2).Width = 100;
sheet.Columns(3).Width = 50;
sheet.Columns(4).Width = 60;
sheet.Columns(5).Width = 65;
sheet.Columns(6).Width = 50;
sheet.Columns(7).Width = 450;
int iRow = 0;
sheet.Name = strSheetName;
sheet.FreezeLeftColumns = 0;
sheet.FreezeTopRows = 1;
sheet.PrintOptions.Orientation = PageOrientation.Landscape;
sheet.PrintOptions.SetMargins(0.5, 0.4, 0.5, 0.4);
iRow = 0;
sheet[0, iRow].Value = "TABLE 種類";
sheet[1, iRow].Value = "Table 英文名稱";
sheet[2, iRow].Value = "欄位名稱";
sheet[3, iRow].Value = "是否為PK";
sheet[4, iRow].Value = "可否為NULL";
sheet[5, iRow].Value = "型態";
sheet[6, iRow].Value = "欄位長度";
sheet[7, iRow].Value = "欄位說明";
iRow++;
int iTab = 0;
DataTable dtData = new DataTable();
DataTable dtTemp = new DataTable();
IFM06_BCO BCO = new IFM06_BCO(ConntionDB);
//有選擇模組代碼
foreach (DataRow dr in dtTab.Rows)
{
//V_TABTYPE varchar2,
//V_TABLE_NAME varchar2,
ParameterList.Clear();
ParameterList.Add(dr["TABLE_TYPE"].ToString().Trim());
ParameterList.Add(dr["TABLE_NAME"].ToString().Trim());
dtTemp = BCO.QuerytTabColumn(ParameterList);
if (iTab == 0)
dtData = dtTemp;
else
dtData.Merge(dtTemp);
iTab++;
}
foreach (DataRow dr in dtData.Rows)
{
sheet[0, iRow].Value = dr["TABLE_TYPE"].ToString();
sheet[1, iRow].Value = dr["TABLE_NAME"].ToString();
sheet[2, iRow].Value = dr["COLUMN_NAME"].ToString();
sheet[3, iRow].Value = dr["CONSTRAINT_TYPE"].ToString();
sheet[4, iRow].Value = dr["NULLABLE"].ToString();
sheet[5, iRow].Value = dr["DATA_TYPE"].ToString();
sheet[6, iRow].Value = dr["LENGTH"].ToString();
sheet[7, iRow].Value = dr["COMMENTS"].ToString();
iRow++;
}
}
private DataTable AddSheetData0(ref Worksheet sheet, string strSheetName)
{
//設定Worksheet各column 寬度
sheet.Font.Size = 10;
sheet.Font.Name = "新細明體";
sheet.Columns(0).Width = 55;
sheet.Columns(1).Width = 55;
sheet.Columns(2).Width = 190;
sheet.Columns(3).Width = 450;
int iRow = 0;
sheet.Name = strSheetName;
sheet.FreezeLeftColumns = 0;
sheet.FreezeTopRows = 1;
sheet.PrintOptions.Orientation = PageOrientation.Landscape;
sheet.PrintOptions.SetMargins(0.5, 0.4, 0.5, 0.4);
iRow = 0;
sheet[0, iRow].Value = "TABLE 種類";
sheet[1, iRow].Value = "模組代碼";
sheet[2, iRow].Value = "Table 英文名稱";
sheet[3, iRow].Value = "Table 中文名稱";
iRow++;
int iSel = 0;
DataTable dtData = new DataTable();
DataTable dtTemp = new DataTable();
IFM06_BCO BCO = new IFM06_BCO(ConntionDB);
//有選擇模組代碼
for (int i = 0; i < cblModule.Items.Count; i++)
{
if (cblModule.Items[i].Selected == true)
{
//V_TABTYPE varchar2,
//V_MODULE varchar2,
//V_TABLE_NAME varchar2,
//V_COMMENTS varchar2,
ParameterList.Clear();
ParameterList.Add(ddlTABTYPE.Text.Trim());
ParameterList.Add(cblModule.Items[i].Value.ToString());
ParameterList.Add("%" + txtTABLE_NAME.Text.Trim() + "%");
ParameterList.Add("%" + txtCOMMENTS.Text.Trim() + "%");
dtTemp = BCO.QueryModuleTab(ParameterList);
if (iSel == 0)
dtData = dtTemp;
else
dtData.Merge(dtTemp);
iSel++;
}
}
//完全沒選擇模組代碼
if (iSel == 0)
{
ParameterList.Clear();
ParameterList.Add(ddlTABTYPE.Text.Trim());
ParameterList.Add(DBNull.Value);
ParameterList.Add("%" + txtTABLE_NAME.Text.Trim() + "%");
ParameterList.Add("%" + txtCOMMENTS.Text.Trim() + "%");
dtData = BCO.QueryModuleTab(ParameterList);
}
dtData.DefaultView.Sort = "TABLE_TYPE,CODE";
dtData = dtData.DefaultView.ToTable();
foreach (DataRow dr in dtData.Rows)
{
sheet[0, iRow].Value = dr["TABLE_TYPE"].ToString();
sheet[1, iRow].Value = dr["CODE"].ToString();
sheet[2, iRow].Value = dr["TABLE_NAME"].ToString();
sheet[3, iRow].Value = dr["COMMENTS"].ToString();
iRow++;
}
return dtData;
}
