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; }