living in my life (史蘭諾系統整合服務)

[ASP.NET]如何解決The state server has closed an expired TCP/IP connection(How to solve the state server has closed an expired TCP / IP connection)

2020-01-03T10:43:00.000+08:00

問題

解決The state server has closed an expired TCP/IP connection

解決方法

1.Web.config stateNetworkTimeout加大(秒)

 <sessionState 
            stateNetworkTimeout="10"
        />

2.調整ASP.NET state server
Step1.服務=>ASP.NET State server=>停用
Step2.執行=>Regedt32.exe
Step3.找到HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\aspnet_state\Parameters
Step4.右鍵=>新增DWORD=>SocketTimeout=>輸入整數時間
Step5.服務=>ASP.NET State server=>自動

參考https://support.microsoft.com/en-us/help/308097/state-server-logs-event-id-1072-or-event-id-1076

[C#]如何不安裝OracleClient使用OraOLEDB.Oracle.1連OracleDB(How to use OraOLEDB.Oracle.1 to connect DB without installing Oracle Client)

2019-06-04T15:25:00.000+08:00

問題

如何不安裝OracleClient使用OleDbDataAdapte provider=OraOLEDB.Oracle.1連 OracleDB r

解決方法

1.下載ODAC(for 10 g使用ODAC 11.2 Release 6 (11.2.0.4.0)版本)

2.解壓縮後開cmd=>輸入[cd 解壓縮目錄]切換路徑=>輸入如下

install.bat oledb     c:\oracle myhome true

3.系統環境變量設置=>系統=>進階系統設定=>環境變數,Path點選編輯輸入如下(設定後需要重開機)

c:\oracle;c:\oracle\bin

4.連線設定放置tnsnames.ora於C:\oracle\network\admin底下

5.程式連線設定

Provider=OraOLEDB.Oracle.1;Data Source=DBnameInTNS;User ID=test;Password=test;;Persist Security Info=False

[PL/SQL Developer]如何不安裝OracleClient連OracleDB(How not to install Oracle Client even OracleDB in PL/SQL Developer)

2019-01-31T10:48:00.000+08:00

問題

如何不安裝OracleClient連OracleDB

解決方法

先下載Instant Client Package,請參考
於PL/SQL Developer=>Tools=>Preferances=>

Oracle Home=>輸入Instant Client位置
OCI Libary=>輸入Instant Client位置\oci.dll

[QNAP]如何於Container Station上建立mritd/shadowsocks容器(How to create a mritd/shadowsocks container on QNAP Container Station)

2019-01-31T10:33:00.001+08:00

問題

如何於Container Station上建立mritd/shadowsocks服務

解決方法

1.建立映像檔
左邊欄[建立]=>輸入[shadowsocks]=>找到mritd/shadowsocks=>點擊[建立]

2.建立容器
左邊欄[映像檔]=>找到mritd/shadowsocks=>點擊[+]

3.設定容器
於進入點輸入

/entrypoint.sh -s "-s 0.0.0.0 -p 6444 -m aes-256-gcm -k passward --fast-open" -k "-t 127.0.0.1:6444 -l :6544 -mode fast2" -x

說明:

0.0.0.0   採用Host IP,不需變更
6444      監聽端口,可自行設置
aes-256-gcm  加密方式,可自行設置(aes-256-cfb/xchacha20-ietf-poly1305/aes-256-gcm/rc4-md5)

點擊[進階設定]=>[網段]=>網路模式=>選擇Host=>點擊[建立]

[Mantis]如何設定PHP Mantis調整上傳檔案大小(How to set Mantis to adjust upload file size in PHP)

2018-06-14T17:16:00.000+08:00

問題

如何設定PHP Mantis調整上傳檔案大小

解決方法

PHP=>php.ini

max_execution_time=3600
max_input_time=3600
upload_max_filesize = 1024M
post_max_size = 1024M

Mantis=>config_inc.php

$g_allow_file_upload = ON;
$g_max_file_size = 1024000000; # 1024MB
$g_file_upload_method = DISK;

[ReportViewer]如何抽取ReportViewer所需組件讓Server不需另外安裝軟件(How to extract the required components of ReportViewer so that Server does not need to install additional software.)

2018-05-15T18:05:00.001+08:00

問題

如何抽取ReportViewer所需組件讓Server不需另外安裝軟件

解決方法

1.將以下內容存成.bat檔後執行

@SET destFolder=.\bin
@XCOPY /I /Y %SYSTEMDRIVE%\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.ProcessingObjectModel\10.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.ProcessingObjectModel.dll %destFolder%\
@XCOPY /I /Y %SYSTEMDRIVE%\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.Common\10.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.Common.dll %destFolder%\
@XCOPY /I /Y %SYSTEMDRIVE%\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.DataVisualization\10.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.DataVisualization.dll %destFolder%\
@XCOPY /I /Y "%SYSTEMDRIVE%\Program Files\Microsoft Visual Studio 10.0\ReportViewer\Microsoft.ReportViewer.WinForms.dll" %destFolder%\
@XCOPY /I /Y "%SYSTEMDRIVE%\Program Files\Microsoft Visual Studio 10.0\ReportViewer\zh-CN" %destFolder%\zh-CN\
@explorer.exe %destFolder%

@XCOPY /I /Y "%SYSTEMDRIVE%\Program Files\Microsoft Visual Studio 10.0\ReportViewer\Microsoft.ReportViewer.DataVisualization.dll" %destFolder%\
@XCOPY /I /Y "%SYSTEMDRIVE%\Program Files\Microsoft Visual Studio 10.0\ReportViewer\zh-CN" %destFolder%\zh-CN\
@explorer.exe %destFolder%

2.複製C:\Program Files (x86)\Microsoft Visual Studio 10.0\ReportViewer下的檔案
Microsoft.ReportViewer.Common.dll
Microsoft.ReportViewer.WebForms.dll
Microsoft.ReportViewer.WinForms.dll

[ReportViewer]解決預先編譯程式後,發佈到Server上出現 The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.

2018-05-15T18:00:00.001+08:00

問題

預先編譯程式後,,發佈到Server上,出現

The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.

解決方法

將原rdlc檔案複製一份過去即可

[QNAP]解決 QNAP升級韌體4.3.4後iSCSI儲存遺失顯示"指定的目標沒有可用的LUN"(Resolve QNAP Upgrade Firmware 4.3.4 Loss of iSCSI Storage After Display "Specified Target Has No Available LUNs")

2018-02-21T22:50:00.001+08:00

問題

QNAP升級韌體4.3.4後iSCSI儲存遺失顯示"指定的目標沒有可用的LUN"

解決方法

1.選取iSCSI目標清單
=>點擊儲存與快照總管=>iSCSI=>iSCSI儲存

2.停用異常的LUN磁區
=>點擊LUN磁區=>右上方動作=>停用=>提示"所有存在的連線都會中斷"=>點確定=>該LUN磁區的狀態會變為停用

3.卸載異常的LUN磁區
=>點擊LUN磁區=>右上方動作=>卸載=>該LUN磁區會被標在"未掛載iSCSI磁碟清單"

4.建立新的iSCSI目標
=>上方建立=>選擇建立一個iSCSI目標=>下一步=>輸入iSCSI目標名稱(ex:test1)=>下一步=>下一步=>下一步=>完成

5.將LUN磁區掛載到新的iSCSI目標 =>點擊LUN磁區=>右上方動作=>掛載=>選擇步驟4建立的iSCSI目標(ex:test1)=>套用

[Mantis]如何升級Mantis 2.6至2.11(How to upgrade Mantis 2.6 to 2.11 under phpstudy)

2018-02-21T20:06:00.000+08:00

問題

如何於phpstudy下Mantis 2.6升級2.11

解決方法

1.Mantis 2.11最低版本需要PHP 5.5,故需點擊phpstudy程式介面上[PHP版本],切換至PHP 5.5後[確定]
2.PHP 5.5版本需要MSVC11 (Visual C++ 2012) 版本,若失敗,則需下載MSVC11 (Visual C++ 2012) 版本並安裝,安裝過程不需重新開機
3.將現有mantis整個資料夾複製到另一個資料夾,ex:mantis_backup
4.將mantis 2.11解壓,改名為目標名稱,ex:mantis
5.於phpstudy=>其他選單=>查看phpinfo,確認已切換至PHP 5.5
6.於phpstudy=>其他選項=>PHP擴展及設置=>參數值設置=>date_timezone=>輸入Asia/Taipei=>確定
7.複製瀏覽器顯示出的路徑ex:http://localhost:8080/phpinfo.php=>改為http://localhost:8080/mantis/admin/install.php,按照指示進行安裝
8.安裝完以後,將備份的設定檔mantis_backup/config/config_inc.php內的設定資料複製到mantis 2.11版本設定檔內
9.若有上傳是存在file形式,則將原mantis_backup內的上傳檔案資料夾複製到mantis 2.11版本內就可以了

[Mantis]如何安裝Mantis與使用PHPMailer寄送郵件 (How to install Mantis with mail sent using PHPMailer)

2017-09-29T00:58:00.001+08:00

問題

如何安裝Mantis

解決方法

1.下載phpsStudy頁面(phpStudy.zip)
2.下載Microsoft Visual C++ 2008 可轉散發套件 (x86)
3.下載Mantis /PHPMailer_5.2.0.zip
4.解壓縮phpStudy.zip,並點擊exe檔進行安裝phpStudy,安裝後如下圖

5.設定php.ini的date_timezone,
=>其他選項菜單=>PHP擴展及設置=>參數值設置=>date_timezone=>輸入Asia/Taipei=>確定

6.檢查phpStudy上是否Apache與MySQL皆綠燈(正常執行),若是紅燈,通常是PORT被占用,調整一下就可以
=>其他選項菜單=>phpStudy設置=>端口常規設置

=>http端口(預設是80),改掉後點擊phpStudy重啟按鈕就可以

7.安裝MySQL,預設值帳密都一樣: root / root
=>其他選項菜單=>phpMyAdmin

=>登入輸入密碼root=>接下來通常都採預設,直到安裝完成

8.解壓縮Mantis,放置在phpStudy安裝位置下的WWW資料夾下

=>Mantis解壓後保持一層就好

=>解壓縮PHPMailer_5.2.0=>將資料夾改名為phpmailer(一樣一層)=>放置在mantis/core資料夾下
9.安裝Mantis
=>其他選項菜單=>查看phpInfo

=>更改路徑為mantis=>進入安裝mantis頁面(管理者預設帳密administrator / root)

=>進入安裝
10.設定Mantis使用PHPMailer發送mail
=>找到mantis資料夾底下config_inc.php=>以文字開啟=>增加以下

$g_enable_email_notification = ON;--------啟用寄發mail功能
$g_smtp_host = '10.87.46.10';--------smtp伺服器
$g_smtp_username = 'username';--------smtp伺服器使用者帳號(可空白)
$g_smtp_password = 'password';--------smtp伺服器使用者密碼(可空白)
$g_use_phpMailer = ON;--------使用phpmailer
$g_phpMailer_path = './core/phpmailer/';--------phpmailer放置路徑
$g_phpMailer_method = 2;
$g_return_path_email = '12345@sina.com';--------完整邮箱名稱(通常是發mail的共用帳號)

11.新增加使用者,若增加使用者後收到mail通知,則mail設置完成!

[VISUAL STUDIO]解決 Windows 7升級Windows 10後,開啟VisualStudio時,發生 System.Windows.Interop.OSVersionHelper”的类型初始值设定项引发异常(After you upgrade Windows 7 to upgrade Windows 10, when you start Visual Studio, the System.Windows.Interop.OSVersionHelper "type initial setting item throws an exception)

2017-09-28T23:45:00.002+08:00

問題

將Windows 7升級到Windows 10後,開啟VisualStudio時,發生

“System.Windows.Interop.OSVersionHelper”的类型初始值设定项引发异常。

解決方法

1.下載Microsoft .NET Framework 4.6.2 (Offline Installer)並安裝
2.重新開機

[SSD]How to fix BSOD after cloning HDD to SSD Intel DC S3700 in Windows 7 0x0000001E

2017-09-25T16:35:00.001+08:00

問題

將Windows 7系統Clone到SSD後,以SSD當開機硬碟,開機後進入登入畫面,隨即藍屏!
試過進入安全模式,也是到一半就藍屏!
錯誤代碼為0x0000001E

解決方法

1.在原系統上操作=>電腦=>右鍵管理=>裝置管理員

2.找到IDE ATA/ATAPI控制器=>點開加號=>以右鍵解除安裝,把底下所有裝置都移除(驅動程式也要勾選移除)

3.全部移除後,系統會自行安裝驅動程式,並且重新啟動兩次
4.此時再次Clone系統到SSD上就可以正常啟動了!

[IIS]解決無法載入檔案或組件 'XXXX' 或其相依性的其中之一。試圖載入格式錯誤的程式。

2017-06-02T22:00:00.000+08:00

問題

WEB專案在64位元下使用VisualStudio開發服務器執行Web程式正常!
但佈署到IIS底下發生
無法載入檔案或組件 'GCSC-MIT Web' 或其相依性的其中之一。試圖載入格式錯誤的程式。描述: 在執行目前 Web 要求的過程中發生未處理的例外狀況。請檢閱堆疊追蹤以取得錯誤的詳細資訊，以及在程式碼中產生的位置。例外狀況詳細資訊: System.BadImageFormatException: 無法載入檔案或組件 'GCSC-MIT Web' 或其相依性的其中之一。試圖載入格式錯誤的程式。

解決方法

IIS=>ApplicationPool=>選擇應用程式對應的ApplicationPool=>進階設定=>啟用32位元應用程式

[IIS]解決 Windows7上IIS執行asp網頁時出現因為網頁伺服器上設定的多用途網際網路郵件延伸標準 (MIME) 對應原則，而無法提供您要求的網頁。如果此網頁為指令碼，請新增處理常式，而且如果它是應該要下載的檔案，請新增 MIME 對應。(Resolving IIS on Windows7 occurs when the asp web page is executed because of the principle of multipurpose Internet mail extension standard (MIME) that is set on the web server, and can not provide the page you requested. If this page is a script, add a handler, and if it is a file that should be downloaded, add a MIME counterpart.)

2017-05-31T20:00:00.000+08:00

問題

Windows7上IIS執行app網頁時出現錯誤

因為網頁伺服器上設定的多用途網際網路郵件延伸標準 (MIME) 對應原則，而無法提供您要求的網頁。如果此網頁為指令碼，請新增處理常式，而且如果它是應該要下載的檔案，請新增 MIME 對應。

解決方法

控制台=>開啟或關閉WINDOW功能=>INTERNET INFORMATION SERVICES=>WORLD WIDE WEB服務=>應用程式開發功能=>勾選ASP=>完成

[NB]解決 HP ProBook 440睡眠後不定時發生無法喚醒的錯誤(To resolve the HP ProBook 440 sleep can not wake up after the error can not wake up)

2017-05-03T11:17:00.002+08:00

問題

最近不定時發生ProBook 440在闔上螢幕後再開啟時,發生無法喚醒直接不正常關機的情形,對此使用了blue_screen_view檢示錯誤訊息,

原來是由於dxgmms1.sys錯誤引起
而dxgmms1.sys錯誤在微軟論壇裡有被提出,指出原因是由於顯示卡引起,

因此到HP官方網站下載對應AMD顯示卡驅動程式https://support.hp.com/tw-zh/drivers,但是即便更新了以後,狀況還是發生,因此乾脆直接放棄AMD顯卡改用Intel內建的顯卡,結果這問題就解決了!

解決方法

1.控制台=>系統及安全性=>右側點系統=>左側點裝置管理員
2.點開顯示卡(會看到AMD與Intel兩個顯卡)=>選AMD顯卡後右鍵選解除安裝
3.之後系統會預設安裝"標準VGA繪圖卡"去取代原先AMD顯卡的驅動程式=>選擇標準VGA繪圖卡右鍵選停用=>重新開機

[QNAP]解決 Virtualization Station透過虛擬交換器無法連線到網路 (Resolve Virtualization Station can not connect to the network through virtual switch)

2017-04-27T20:58:00.001+08:00

問題

虛擬交換器中顯示Virtualization Station內VM以連線到網路

但是實際上Virtualization Station內VM卻無法連上網路

解決方法

1.關閉Virtualization Station內網路連線有問題的VM
2.Virtualization Station中於該VM內=>設定=>網路=>刪除網路卡

3.刪除後選擇上方的新增裝置

4.裝置種類選網路=>類型預設為Intel(建議VirtIO),因為Intel為模擬1G,VirtIO為模擬10G網路=>選好後確定

5.重新啟動VM

[SSH]解決 SSH連線時發生can't agree a host key algorithm錯誤 (To solve the SSH connection can not agree a host key algorithm error)

2017-04-21T16:45:00.000+08:00

問題

SSH連線時發生can't agree a host key algorithm錯誤

解決方法

1.下載Putty
2.Putty選用Telnet遠端連線,輸入IP與PORT並點選下方OPEN按鈕,接著輸入帳號=>ENTER=>接著輸入密碼=>ENTER,成功進入後會出現#,輸入以下各行指令並每一行按下ENTER

chmod 0600 /etc/ssh/ssh_host_rsa_key
chmod 0600 /etc/ssh/ssh_host_dsa_key
chmod 0600 /etc/config/ssh/ssh_host_rsa_key
chmod 0600 /etc/config/ssh/ssh_host_dsa_key
chmod 0644 /etc/ssh/*.pub
chmod 0644 /etc/config/ssh/*.pub

接著重開Putty選用SSH遠端連線,輸入IP與PORT並點選下方OPEN按鈕以連線

[Android]如何使用鈦備份完整還原LINE(包含原有資料與變更AndroidID)(How to use Titanium Backup Complete Restore LINE (including original data and change AndroidID))

2017-03-28T22:00:00.000+08:00

問題

如何使用鈦備份完整還原LINE(包含原有資料與變更AndroidID)

解決方法

1.一部ROOTED後的ANDROID手機,所需用到的相關軟體有:
鈦備份
SQLite Editor
Device Id Changer [ROOT]
2.鈦備份操作=>上方備份/還原=>上方打勾圖式按鈕=>還原所有遺失的程式(含使用者資料)=>打勾LINE=>等待執行完成

3.SQLite Editor操作=>LINE=>naver_line=>setting=>點右上角...=>Delete All=>等待執行完成

4.更改AndroidID操作=>舊手機上執行Device Id Changer [ROOT]=>紀錄Current Andrid ID=>新手機上執行Device Id Changer [ROOT]=>New Android ID裡輸入舊手機的Andrid ID=>執行APPLY=>手動重新開機

[Shadowsocks]如何於QNAP NAS上設定Shadowsocks Server

2017-03-28T20:05:00.002+08:00

問題

如何於QNAP NAS上設定Shadowsocks Server

解決方法

1.在QNAP上安裝對應版本的Shadowsocks Server
2.安裝好後開啟Shadowsocks

這時候如果進不去,就代表這台NAS躲在ROUTER後面,所以先進區網內才有辦法設定
可是在區往內開啟後,可能收到這個畫面

這時候,把dns改為內網的NAS IP就可以了!

點選Config File,你會看到設定畫面,這就是這篇說的重點!!!!!

設定會像這樣

{
"server":"192.168.1.100",
"server_port":8388,
"local_port":1080,
"password":"password1234",
"timeout":600,
"method":"aes-256-cfb"
}

NAS在ROUTER內的話

{
"server":"內網NAS的IP",
"server_port":8388,
"local_port":1080,
"password":"可以自訂",
"timeout":600,
"method":"aes-256-cfb"
}

METHOD是指加密方式隨喜好,推荐是aes-256-cfb
ROUTER的port forward設定為

TCP+UDP port 8388
local host 內網NAS的IP
local port 留空白

NAS不在ROUTER內的話

{
"server":"對外IP或DNS NAME",
"server_port":8388,
"local_port":1080,
"password":"可以自訂",
"timeout":600,
"method":"aes-256-cfb"
}

設定好後按下Modify,先關閉Shadowsocks Server後,再啟用
成功後使用Client連接測試下載位置

[Titanium Backup]如何在MIUI 8 還原鈦備份已備份資料 (How do I restore my backed up data from Titanium Backup in MIUI 8)

2017-03-27T03:19:00.000+08:00

問題

在MIUI 8使用鈦備份要還原程式時,進度一直在0%,毫無進度!

解決方法

開啟開發人員選項
Step1.設定(滑到最下面)=>關於手機=>MIUI版本點擊直到出現[你已是開發人員訊息出現]
Step2.設定(系統和設備)=>更多設定=>開發人員選項=>啟用MIUI優化(預設為勾選改為=>不勾選)=>確定後系統會重啟
Step3.設定(系統和設備)=>更多設定=>開發人員選項=>USB偵錯(預設為不勾選改為=>勾選) 還有下方 USB安裝(預設為不勾選改為=>勾選)

SUPERSU造成還原問題
Step1.開啟SUPERSU=>設定=>安裝空間分離(預設為勾選改為=>不勾選)
Step2.重新啟動系統!重新啟動系統!重新啟動系統!>很重要!所以說三次!!!!!

以上都做完以後,就可以成功還原囉!!

[GridView]如何使用GridView做出動態排序與超連結 ( How to use the GridView to make dynamic sorting and hyperlinks)

2017-02-20T17:16:00.000+08:00

問題

如何使用GridView做出動態排序與超連結

解決方法

.aspx

<asp:GridView ID="gvResult" runat="server" OnDataBound="gvContent_DataBound" OnPreRender="gvContent_PreRender"
    EmptyDataText="No Data" AllowSorting="True" OnSorting="gvResult_Sorting" CellSpacing="1"
    BorderColor="Black" HeaderStyle-BackColor="Blue" HeaderStyle-ForeColor="White">
    <RowStyle HorizontalAlign="Center" Wrap="False" BorderWidth="1px" BorderColor="Black" />
    <HeaderStyle BackColor="Blue" ForeColor="White" HorizontalAlign="Center" />
</asp:GridView>

.cs

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
        InitData();
}
private void InitData()
{
    DataTable data = get source....
    ViewState["data"] = data;
    ViewState["dataSortName"] = "";
    ViewState["dataSortSeq"] = "";
    this.gvResult.DataSource = data;
    this.gvResult.DataBind();
}
protected void gvResult_Sorting(object sender, GridViewSortEventArgs e)
{
    if (ViewState["dataSortName"].ToString() == e.SortExpression)
        if (ViewState["dataSortSeq"].ToString() == "ASC")
            ViewState["dataSortSeq"] = "DESC";
        else
            ViewState["dataSortSeq"] = "ASC";
    else
    {
        ViewState["dataSortName"] = e.SortExpression;
        ViewState["dataSortSeq"] = "ASC";
    }
    DataTable data = (DataTable)ViewState["data"];
    data.DefaultView.Sort = string.Format("{0} {1}", ViewState["dataSortName"], ViewState["dataSortSeq"]);
    data = data.DefaultView.ToTable();
    this.gvResult.DataSource = data;
    this.gvResult.DataBind();
    ViewState["data"] = data;
}
protected void gvContent_DataBound(object sender, EventArgs e)
{

}
protected void gvContent_PreRender(object sender, EventArgs e)
{
 
    DataTable data = (DataTable)ViewState["data"];
    if (data == null || data.Rows.Count == 0)
        return;
 //以下是動態超連結...可不做
#region 取得欄位的位置
    int productIndex = 0;
    for (int i = 0; i < gvResult.HeaderRow.Cells.Count; i++)
    {
        if (((LinkButton)(gvResult.HeaderRow.Controls[i].Controls[0])).Text == "PRODUCT_ID")//須超連結的欄位
            productIndex = i;
    }
#endregion
#region 須超連結的欄位
    foreach (GridViewRow gvItem in gvResult.Rows)
    {
  LinkButton obj = new LinkButton();
        obj.Text = gvItem.Cells[productIndex].Text.Trim();
        obj.OnClientClick = string.Format(@"javascript:subpop('www.google.com/tw?product={0}');return false;", product);
        gvItem.Cells[productIndex].Controls.Add(obj);
    }
#endregion
}

[Javascript]如何使用Javascript產生動態遮罩 (How to generate dynamic masks)

2017-02-15T09:41:00.000+08:00

問題

如何使用Javascript產生動態遮罩

解決方法

<script language="javascript">
var docEle = function() { 
 return document.getElementById(arguments[0]) || false; 
} 

function showMask() { 
 createMask();
} 

function hideMask() { 
 var m = "autoMask"; 
 if (docEle(m)) document.removeChild(docEle(m)); 
}

function createMask() {
 var m = "autoMask"; 
 if (docEle(m)) document.removeChild(docEle(m)); 
 var newDiv = document.createElement("div"); 
 newDiv.id = 'autoMask';
 newDiv.style.cssText="zoom: 1;filter: alpha(opacity=50);opacity: 0.5;width: 100%;background-color: Gray;height: 100%;position: absolute;left: 0;top: 0;z-index: 9999999;text-align: center;margin-top: 0px;";
 newDiv.innerHTML="<table width='100%'><tr><td style='height: 300px;text-align: center;'><h2>L O A D I N G . . . . . .</h2></td></tr></table>";
 document.body.appendChild(newDiv); 
}

</script>

<body>
<a href="#" onclick="showMask();">showMask</a>
</body>

[Javascript]如何使用顯示訊息後focus到TextBox (How to use the display message after the focus to the TextBox)

2017-02-14T16:51:00.000+08:00

問題

如何使用顯示訊息後focus到TextBox

解決方法

.aspx

<script type="text/javascript">

 function alertAfterFocus(message, objID) {

  alert(message);

  window.setTimeout(function() {

   document.getElementById(objID).focus();

  }, 0);

 }

</script>

.cs

private void ShowMessage(string msg, string objID)

{

    msg = msg.Replace("\n", "\\n");

    msg = msg.Replace("\'", string.Empty);

    string message = string.Format("alertAfterFocus('{0}','{1}');", msg, objID);

    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert" + System.Guid.NewGuid().ToString(), message, true);

}

how to use

ShowMessage("xxx must keyin!!", this.textBox1.ClientID);

[ListView]使用 ListView維護表單 (Use the ListView to maintain the form)

2017-02-14T16:42:00.001+08:00

問題

使用 ListView維護表單

解決方法

<%@ Register Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
    Namespace="System.Web.UI.WebControls" TagPrefix="asp" %>

.aspx

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
  <asp:UpdatePanel ID="UP_Modify" runat="server" UpdateMode="Conditional">
        <ContentTemplate>
            <asp:ListView ID="lv_Modify" runat="server" InsertItemPosition="FirstItem" EnableModelValidation="True"
                OnItemCanceling="lv_Modify_ItemCanceling" OnItemDeleting="lv_Modify_ItemDeleting"
                OnItemInserting="lv_Modify_ItemInserting" OnItemUpdating="lv_Modify_ItemUpdating"
                OnItemEditing="lv_Modify_ItemEditing" 
                OnItemDataBound="lv_Modify_ItemDataBound" onitemcreated="lv_Modify_ItemCreated">
                <LayoutTemplate>
                    <table id="Table1" runat="server">
                        <tr id="Tr1" runat="server">
                            <td id="Td1" runat="server">
                                <table id="itemPlaceholderContainer" runat="server" align="left" border="1" cellpadding="3"
                                    cellspacing="0" style="margin-left: 0px; border-collapse: collapse; border-color: #696969;
                                    font-size: small;">
                                    <tr id="Tr2" runat="server" style="color: #FFFFFF; background-color: #0000FF">
                                        <th id="Th2" runat="server">
                                            FUNCTION
                                        </th>
                                        <th id="Th19" runat="server">
                                            rule_seq
                                        </th>
                                        <th id="Th8" runat="server">
                                            system_key
                                        </th>
                                        <th id="Th20" runat="server">
                                            table_column
                                        </th>
                                        <th id="Th21" runat="server">
                                            column_value
                                        </th>
                                    </tr>
                                    <tr id="itemPlaceholder" runat="server">
                                    </tr>
                                </table>
                            </td>
                        </tr>
                        <tr id="Tr3" runat="server">
                            <td id="Td2" runat="server" style="">
                            </td>
                        </tr>
                    </table>
                </LayoutTemplate>
                <ItemTemplate>
                    <tr style="background-color: #FFFFCC">
                        <td>
                            <asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="編輯" />
                            <asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="刪除" />
                        </td>
                        <td>
                            <asp:Label ID="lblrule_seq" runat="server" Text='<%# Eval("rule_seq") %>' />
                        </td>
                        <td>
                            <asp:Label ID="lblsystem_key" runat="server" Text='<%# Eval("system_key") %>' />
                        </td>
                        <td>
                            <asp:DropDownList ID="ddltable_column" runat="server">
                            </asp:DropDownList>
                            <asp:HiddenField ID="hdtable_column" runat="server" Value='<%# Eval("table_column") %>' />
                        </td>
                        <td>
                            <asp:Label ID="lblcolumn_value" runat="server" Text='<%# Eval("column_value") %>' />
                        </td>
                    </tr>
                </ItemTemplate>
                <EditItemTemplate>
                    <tr style="background-color: #FFFF66">
                        <td>
                            <asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="更新" />
                            <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="取消" />
                        </td>
                        <td>
                            <asp:Label ID="lblrule_seq" runat="server" Text='<%# Eval("rule_seq") %>' />
                        </td>
                        <td>
                            <asp:TextBox ID="txtsystem_key" runat="server" Text='<%# Bind("system_key") %>' />
                        </td>
                        <td>
                            <asp:DropDownList ID="ddltable_column" runat="server">
                            </asp:DropDownList>
                            <asp:HiddenField ID="hdtable_column" runat="server" Value='<%# Eval("table_column") %>' />
                        </td>
                        <td>
                            <asp:TextBox ID="txtcolumn_value" runat="server" Text='<%# Bind("column_value") %>' />
                        </td>
                    </tr>
                </EditItemTemplate>
                <EmptyDataTemplate>
                    <table id="Table2" runat="server" style="">
                        <tr>
                            <td>
                                未傳回資料。
                            </td>
                        </tr>
                    </table>
                </EmptyDataTemplate>
                <InsertItemTemplate>
                    <tr style="background-color: #00FF00">
                        <td>
                            <asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="插入" />
                            <asp:Button ID="CancelButton0" runat="server" CommandName="Cancel" Text="清除" />
                        </td>
                        <td>
                            系統處理
                        </td>
                        <td>
                            <asp:TextBox ID="txtsystem_key" runat="server" Text='<%# Bind("system_key") %>' />
                        </td>
                        <td>
                            <asp:DropDownList ID="ddltable_column" runat="server">
                            </asp:DropDownList>
                        </td>
                        <td>
                            <asp:TextBox ID="txtcolumn_value" runat="server" Text='<%# Bind("column_value") %>' />
                        </td>
                    </tr>
                </InsertItemTemplate>
            </asp:ListView>
        </ContentTemplate>
    </asp:UpdatePanel>

.cs

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            initRuleDropDownList();
            GetModifyData();
        }
    }
 protected void lv_Modify_ItemCanceling(object sender, ListViewCancelEventArgs e)
    {
        lv_Modify.EditIndex = -1;
        DataBindListView(lv_Modify, GetData());
    }
 protected void lv_Modify_ItemDeleting(object sender, ListViewDeleteEventArgs e)
    {
        if (lv_Modify.EditIndex >= 0) return;
        ListViewDataItem DItem = lv_Modify.Items[e.ItemIndex];

        DBItem.obj1 obj = new DBItem.obj1();
        obj.rule_seq = Convert.ToInt32(((Label)DItem.FindControl("lblrule_seq")).Text.ToString().Trim());
        obj.system_key = ((Label)DItem.FindControl("lblsystem_key")).Text.ToString().Trim();
        obj.table_column = ((DropDownList)DItem.FindControl("ddltable_column")).SelectedValue.Trim();
        obj.column_value = ((Label)DItem.FindControl("lblcolumn_value")).Text.ToString().Trim();
        //process...
        //reget data
    }
 protected void lv_Modify_ItemEditing(object sender, ListViewEditEventArgs e)
    {
        lv_Modify.EditIndex = e.NewEditIndex;
        DataBindListView(lv_Modify, GetData());
    }
 protected void lv_Modify_ItemInserting(object sender, ListViewInsertEventArgs e)
    {
        if (lv_Modify.EditIndex >= 0) return;

        string system_key = ((TextBox)e.Item.FindControl("txtsystem_key")).Text.ToString().Trim();
        string table_column = ((DropDownList)e.Item.FindControl("ddltable_column")).SelectedValue.Trim();
        string column_value = ((TextBox)e.Item.FindControl("txtcolumn_value")).Text.ToString().Trim();
        //process...
        //reget data
    }
 protected void lv_Modify_ItemUpdating(object sender, ListViewUpdateEventArgs e)
    {
        ListViewDataItem DItem = lv_Modify.Items[e.ItemIndex];
  
        string system_key = ((TextBox)DItem.FindControl("txtsystem_key")).Text.ToString().Trim();
        string table_column = ((DropDownList)DItem.FindControl("ddltable_column")).SelectedValue.Trim();
        string column_value = ((TextBox)DItem.FindControl("txtcolumn_value")).Text.ToString().Trim();
        int rule_seq = Convert.ToInt32(((Label)DItem.FindControl("lblrule_seq")).Text);
        //process...
        //reget data
    }
 private DataTable GetData()
    {
       return data....
    }
 protected void DataBindListView(ListView lv, Object list)
    {
        lv.DataSource = list;
        lv.DataBind();
    }
 protected void GetModifyData()
    {
        lv_Modify.EditIndex = -1;
        DataBindListView(lv_Modify, GetData());
    }
 private void initRuleDropDownList()
    {
        List<string> ruleList = dropdownlist source....
        ViewState["RuleDropDownList"] = ruleList;
    }
 protected void lv_Modify_ItemDataBound(object sender, ListViewItemEventArgs e)
    {
        if (e.Item.ItemType != ListViewItemType.EmptyItem)
        {
            DropDownList ddl = (DropDownList)e.Item.FindControl("ddltable_column");
            if (ViewState["RuleDropDownList"] == null)
                initRuleDropDownList();
            ddl.DataSource = ViewState["RuleDropDownList"];
            ddl.DataBind();
        }
        if (e.Item.ItemType == ListViewItemType.DataItem)
        {
            DropDownList ddl = (DropDownList)e.Item.FindControl("ddltable_column");
            HiddenField hd = (HiddenField)e.Item.FindControl("hdtable_column");
            ddl.SelectedValue = hd.Value;
        }
    }
 protected void lv_Modify_ItemCreated(object sender, ListViewItemEventArgs e)
    {
        if (e.Item.ItemType == ListViewItemType.InsertItem)
        {
            DropDownList ddl = (DropDownList)e.Item.FindControl("ddltable_column");
            if (ViewState["RuleDropDownList"] == null)
                initRuleDropDownList();
            ddl.DataSource = ViewState["RuleDropDownList"];
            ddl.DataBind();
        }
    }

[adb logcat]使用adb logcat取得裝置權限( Use adb logcat to get device permissions)

2016-11-08T00:26:00.000+08:00

問題

使用adb logcat取得裝置權限

解決方法

backup

cmd=>exe adb.exe=>adb backup -apk -all -nosystem -f "D:\test.ab"

restore

cmd=>exe adb.exe=>adb restore "D:\test.ab"

if no responsed

cmd=>exe adb.exe=>adb logcat

living in my life (史蘭諾系統整合服務)

[ASP.NET]如何 解決The state server has closed an expired TCP/IP connection(How to solve the state server has closed an expired TCP / IP connection)

[C#]如何 不安裝OracleClient使用OraOLEDB.Oracle.1連OracleDB(How to use OraOLEDB.Oracle.1 to connect DB without installing Oracle Client)

[PL/SQL Developer]如何 不安裝OracleClient連OracleDB(How not to install Oracle Client even OracleDB in PL/SQL Developer)

[QNAP]如何 於Container Station上建立mritd/shadowsocks容器(How to create a mritd/shadowsocks container on QNAP Container Station)

[Mantis]如何 設定PHP Mantis調整上傳檔案大小(How to set Mantis to adjust upload file size in PHP)

[ReportViewer]如何 抽取ReportViewer所需組件讓Server不需另外安裝軟件(How to extract the required components of ReportViewer so that Server does not need to install additional software.)

[ReportViewer]解決 預先編譯程式後,發佈到Server上出現 The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.

The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.

[QNAP]解決 QNAP升級韌體4.3.4後iSCSI儲存遺失 顯示"指定的目標沒有可用的LUN"(Resolve QNAP Upgrade Firmware 4.3.4 Loss of iSCSI Storage After Display "Specified Target Has No Available LUNs")

[Mantis]如何 升級Mantis 2.6至2.11(How to upgrade Mantis 2.6 to 2.11 under phpstudy)

[Mantis]如何 安裝Mantis與使用PHPMailer寄送郵件 (How to install Mantis with mail sent using PHPMailer)

[SSD]How to fix BSOD after cloning HDD to SSD Intel DC S3700 in Windows 7 0x0000001E

[IIS]解決 無法載入檔案或組件 'XXXX' 或其相依性的其中之一。 試圖載入格式錯誤的程式。

[NB]解決 HP ProBook 440睡眠後不定時發生無法喚醒的錯誤(To resolve the HP ProBook 440 sleep can not wake up after the error can not wake up)

[QNAP]解決 Virtualization Station透過虛擬交換器無法連線到網路 (Resolve Virtualization Station can not connect to the network through virtual switch)

[SSH]解決 SSH連線時發生can't agree a host key algorithm錯誤 (To solve the SSH connection can not agree a host key algorithm error)

[Android]如何使用 鈦備份完整還原LINE(包含原有資料與變更AndroidID)(How to use Titanium Backup Complete Restore LINE (including original data and change AndroidID))

[Shadowsocks]如何 於QNAP NAS上設定Shadowsocks Server

[Titanium Backup]如何在MIUI 8 還原鈦備份已備份資料 (How do I restore my backed up data from Titanium Backup in MIUI 8)

[GridView]如何 使用GridView做出動態排序與超連結 ( How to use the GridView to make dynamic sorting and hyperlinks)

[Javascript]如何 使用Javascript產生動態遮罩 (How to generate dynamic masks)

[Javascript]如何 使用顯示訊息後focus到TextBox (How to use the display message after the focus to the TextBox)

[ListView]使用 ListView維護表單 (Use the ListView to maintain the form)

[adb logcat]使用adb logcat取得裝置權限( Use adb logcat to get device permissions)

[ASP.NET]如何解決The state server has closed an expired TCP/IP connection(How to solve the state server has closed an expired TCP / IP connection)

[C#]如何不安裝OracleClient使用OraOLEDB.Oracle.1連OracleDB(How to use OraOLEDB.Oracle.1 to connect DB without installing Oracle Client)

[PL/SQL Developer]如何不安裝OracleClient連OracleDB(How not to install Oracle Client even OracleDB in PL/SQL Developer)

[QNAP]如何於Container Station上建立mritd/shadowsocks容器(How to create a mritd/shadowsocks container on QNAP Container Station)

[Mantis]如何設定PHP Mantis調整上傳檔案大小(How to set Mantis to adjust upload file size in PHP)

[ReportViewer]如何抽取ReportViewer所需組件讓Server不需另外安裝軟件(How to extract the required components of ReportViewer so that Server does not need to install additional software.)

[ReportViewer]解決預先編譯程式後,發佈到Server上出現 The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.

[QNAP]解決 QNAP升級韌體4.3.4後iSCSI儲存遺失顯示"指定的目標沒有可用的LUN"(Resolve QNAP Upgrade Firmware 4.3.4 Loss of iSCSI Storage After Display "Specified Target Has No Available LUNs")

[Mantis]如何升級Mantis 2.6至2.11(How to upgrade Mantis 2.6 to 2.11 under phpstudy)

[Mantis]如何安裝Mantis與使用PHPMailer寄送郵件 (How to install Mantis with mail sent using PHPMailer)

[IIS]解決無法載入檔案或組件 'XXXX' 或其相依性的其中之一。試圖載入格式錯誤的程式。

[Android]如何使用鈦備份完整還原LINE(包含原有資料與變更AndroidID)(How to use Titanium Backup Complete Restore LINE (including original data and change AndroidID))

[Shadowsocks]如何於QNAP NAS上設定Shadowsocks Server

[GridView]如何使用GridView做出動態排序與超連結 ( How to use the GridView to make dynamic sorting and hyperlinks)

[Javascript]如何使用Javascript產生動態遮罩 (How to generate dynamic masks)

[Javascript]如何使用顯示訊息後focus到TextBox (How to use the display message after the focus to the TextBox)