Ejemplo n.º 1
0
    private void FileUpLoadApp(string ChkType, FileUpload UpLoadBar, TextBox UpLoadText, string UpLoadStr, string UpLoadType, System.Web.UI.WebControls.Image UpLoadView, HyperLink UpLoadLink)
    {
        GBClass001 MyBassAppPj = new GBClass001();
        string     SwcFileName = "";
        string     CaseId      = TXTETIDNo.Text + "";

        if (UpLoadBar.HasFile)
        {
            string filename = UpLoadBar.FileName;   // UpLoadBar.FileName 只有 "檔案名稱.附檔名",並沒有 Client 端的完整理路徑

            string extension = Path.GetExtension(filename).ToLowerInvariant();

            // 判斷是否為允許上傳的檔案附檔名

            switch (ChkType)
            {
            case "PIC":
                List <string> allowedExtextsion01 = new List <string> {
                    ".jpg", ".png"
                };

                if (allowedExtextsion01.IndexOf(extension) == -1)
                {
                    error_msg.Text = MyBassAppPj.AlertMsg("請選擇 JPG PNG 檔案格式上傳,謝謝!!");
                    return;
                }
                break;

            case "DOC":
                List <string> allowedExtextsion02 = new List <string> {
                    ".jpg", ".png", "doc", "pdf", "dwg", "dxf"
                };

                if (allowedExtextsion02.IndexOf(extension) == -1)
                {
                    error_msg.Text = MyBassAppPj.AlertMsg("請選擇 JPG PNG DOC PDF DWG DXF 檔案格式上傳,謝謝!!");
                    return;
                }
                break;
            }

            // 限制檔案大小,限制為 10MB
            int filesize = UpLoadBar.PostedFile.ContentLength;

            if (filesize > 10000000)
            {
                error_msg.Text = MyBassAppPj.AlertMsg("請選擇 10Mb 以下檔案上傳,謝謝!!");
                return;
            }

            // 檢查 Server 上該資料夾是否存在,不存在就自動建立
            string serverDir = ConfigurationManager.AppSettings["SwcFileTemp"] + CaseId;

            if (Directory.Exists(serverDir) == false)
            {
                Directory.CreateDirectory(serverDir);
            }

            Session[UpLoadStr] = "有檔案";
            //SwcFileName = CaseId + UpLoadType + System.IO.Path.GetExtension(UpLoadBar.FileName);
            SwcFileName     = Path.GetFileNameWithoutExtension(filename) + UpLoadType + System.IO.Path.GetExtension(UpLoadBar.FileName);
            UpLoadText.Text = SwcFileName;

            // 判斷 Server 上檔案名稱是否有重覆情況,有的話必須進行更名
            // 使用 Path.Combine 來集合路徑的優點
            //  以前發生過儲存 Table 內的是 \\ServerName\Dir(最後面沒有 \ 符號),
            //  直接跟 FileName 來進行結合,會變成 \\ServerName\DirFileName 的情況,
            //  資料夾路徑的最後面有沒有 \ 符號變成還需要判斷,但用 Path.Combine 來結合的話,
            //  資料夾路徑沒有 \ 符號,會自動補上,有的話,就直接結合

            string serverFilePath = Path.Combine(serverDir, SwcFileName);
            string fileNameOnly   = Path.GetFileNameWithoutExtension(SwcFileName);
            int    fileCount      = 1;

            //while (File.Exists(serverFilePath))
            //{
            //    // 重覆檔案的命名規則為 檔名_1、檔名_2 以此類推
            //    filename = string.Concat(fileNameOnly, "_", fileCount, extension);
            //    serverFilePath = Path.Combine(serverDir, filename);
            //    fileCount++;
            //}

            // 把檔案傳入指定的 Server 內路徑
            try
            {
                UpLoadBar.SaveAs(serverFilePath);
                //error_msg.Text = "檔案上傳成功";

                switch (ChkType)
                {
                case "PIC":
                    UpLoadView.Attributes.Add("src", "..\\UpLoadFiles\\temp\\" + CaseId + "\\" + SwcFileName + "?ts=" + System.DateTime.Now.Millisecond);
                    //UpLoadView.ImageUrl = "..\\UpLoadFiles\\temp\\" + CaseId +"\\"+ geohfilename;

                    imagestitch(UpLoadView, serverDir + "\\" + SwcFileName, 320, 180);
                    break;

                case "DOC":
                    UpLoadLink.Text        = SwcFileName;
                    UpLoadLink.NavigateUrl = "..\\UpLoadFiles\\temp\\" + CaseId + "\\" + SwcFileName + "?ts=" + System.DateTime.Now.Millisecond;
                    UpLoadLink.Visible     = true;
                    break;
                }
            }
            catch (Exception ex)
            {
                //error_msg.Text = "檔案上傳失敗";
            }
        }
        else
        {
            Session[UpLoadStr] = "";
        }
    }
Ejemplo n.º 2
0
    protected void AddNewAcc_Click(object sender, EventArgs e)
    {
        string SaveDate    = "Y";
        string NewAccount  = TXTETIDNo.Text + "";
        string gETID1      = TXTETPW.Text + "";
        string gETID2      = TXTETPWChk.Text + "";
        string gETName     = TXTETName.Text + "";
        string gETTel      = TXTETTel.Text + "";
        string gETEmail    = TXTETEmail.Text + "";
        string gETOrgName  = TXTETOrgName.Text + "";
        string gETOrgGUINo = TXTETOrgGUINo.Text = "";
        string gETOrgAddr  = TXTETOrgAddr.Text + "";
        string gETOrgTel   = TXTETOrgTel.Text + "";
        string gETCOPC     = TXTETCOPC.Text + "";
        string gETTCNo01   = TXTETTCNo01.Text + "";
        string gETTCNo02   = TXTETTCNo02.Text + "";
        string gETTCNo03   = TXTETTCNo03.Text + "";
        string gETTCNo04   = TXTETTCNo04.Text + "";
        string gETOrgIssNo = TXTETOrgIssNo.Text + "";
        string gSYSID      = TXTSYSID.Text + "";
        string gTCNo01ED   = TXTTCNo01ED.Text + "";
        string gTCNo02ED   = TXTTCNo02ED.Text + "";
        string gTCNo03ED   = TXTTCNo03ED.Text + "";
        string gTCNo04ED   = TXTTCNo04ED.Text + "";
        string gETCOPCExp  = TXTETCOPCExp.Text + "";


        GBClass001 SBApp = new GBClass001();

        NewAccount = NewAccount.ToUpper();

        if (NewAccount == "")
        {
            error_msg.Text = SBApp.AlertMsg("身分證字號務必填登,謝謝!!");
            TXTETIDNo.Focus();
            return;
        }
        if (gETID1 != gETID2)
        {
            error_msg.Text = SBApp.AlertMsg("密碼與確認密碼不符");
            TXTETPW.Focus();
            return;
        }

        //帳號重覆檢查
        ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];

        using (SqlConnection SWCConn = new SqlConnection(connectionString.ConnectionString))
        {
            SWCConn.Open();

            string strSQLUS = " select ETIDNo from ETUsers ";
            strSQLUS = strSQLUS + " where ETIDNo ='" + NewAccount + "' ";

            SqlDataReader readerUser;
            SqlCommand    objCmdUser = new SqlCommand(strSQLUS, SWCConn);
            readerUser = objCmdUser.ExecuteReader();

            if (readerUser.HasRows)
            {
                Response.Write("<script>alert('您好,此帳號已重複申請,請再次確認密碼,或與大地工程處聯繫,謝謝。'); location.href='SWC000.aspx'; </script>");
                TXTETIDNo.Focus();
                SaveDate = "N";
                return;
            }
        }

        string UserSqlStr = "";

        if (SaveDate == "Y")
        {
            UserSqlStr = UserSqlStr + " INSERT INTO ETUsers (ETID,ETIDNo,ETStatus,status) VALUES ('" + NewAccount + "','" + NewAccount + "','0','申請中') ;";

            UserSqlStr = UserSqlStr + " Update ETUsers Set ";

            UserSqlStr = UserSqlStr + " ETPW =N'" + gETID1 + "', ";
            UserSqlStr = UserSqlStr + " ETName =N'" + gETName + "', ";
            UserSqlStr = UserSqlStr + " ETTel =N'" + gETTel + "', ";
            UserSqlStr = UserSqlStr + " ETEmail =N'" + gETEmail + "', ";
            UserSqlStr = UserSqlStr + " ETOrgName =N'" + gETOrgName + "', ";
            UserSqlStr = UserSqlStr + " ETOrgGUINo =N'" + gETOrgGUINo + "', ";
            UserSqlStr = UserSqlStr + " ETOrgAddr =N'" + gETOrgAddr + "', ";
            UserSqlStr = UserSqlStr + " ETOrgTel =N'" + gETOrgTel + "', ";
            UserSqlStr = UserSqlStr + " ETCOPC =N'" + gETCOPC + "', ";
            UserSqlStr = UserSqlStr + " ETTCNo01 =N'" + gETTCNo01 + "', ";
            UserSqlStr = UserSqlStr + " ETTCNo02 =N'" + gETTCNo02 + "', ";
            UserSqlStr = UserSqlStr + " ETTCNo03 =N'" + gETTCNo03 + "', ";
            UserSqlStr = UserSqlStr + " ETTCNo04 =N'" + gETTCNo04 + "', ";
            UserSqlStr = UserSqlStr + " ETOrgIssNo =N'" + gETOrgIssNo + "', ";
            UserSqlStr = UserSqlStr + " TCNo01ED =N'" + gTCNo01ED + "', ";
            UserSqlStr = UserSqlStr + " TCNo02ED =N'" + gTCNo02ED + "', ";
            UserSqlStr = UserSqlStr + " TCNo03ED =N'" + gTCNo03ED + "', ";
            UserSqlStr = UserSqlStr + " TCNo04ED =N'" + gTCNo04ED + "', ";
            UserSqlStr = UserSqlStr + " ETCOPCExp =N'" + gETCOPCExp + "', ";
            UserSqlStr = UserSqlStr + " SYSID ='" + gSYSID + "', ";
            UserSqlStr = UserSqlStr + " saveuser = '******', ";
            UserSqlStr = UserSqlStr + " savedate = getdate() ";
            UserSqlStr = UserSqlStr + " Where ETIDNo = '" + NewAccount + "'";

            using (SqlConnection SWCConn = new SqlConnection(connectionString.ConnectionString))
            {
                SWCConn.Open();

                SqlCommand objCmdUser = new SqlCommand(UserSqlStr, SWCConn);
                objCmdUser.ExecuteNonQuery();
                objCmdUser.Dispose();

                GBClass001 CL01 = new GBClass001();

                CL01.Mail_Send(GetMailTo(), MailSub(), MailBody());
            }

            //上傳檔案…
            UpLoadTempFileMoveChk(NewAccount);
        }
        GetUserData(NewAccount);

        Response.Write("<script>alert('已送出帳號申請,請等待審核通知,申請結果將以E-mail通知。'); location.href='SWC000.aspx'; </script>");
    }
Ejemplo n.º 3
0
    protected void SwcLogin_Click(object sender, ImageClickEventArgs e)
    {
        Boolean LoginR = false;

        string sUserType = loginChange.SelectedValue + "";
        string sInputID  = TXTID.Text + "";
        string sInputPW  = TXTPW.Text + "";

        GBClass001     SwcApp  = new GBClass001();
        LoadSwcClass01 LoadApp = new LoadSwcClass01();

        error_msg.Text = "";

        sInputID = SwcApp.SDQQSTR(sInputID);
        //sInputPW = SwcApp.SDQQSTR(sInputPW);

        if (sInputID == "" || sInputPW == "")
        {
            error_msg.Text = SwcApp.AlertMsg("請輸入帳號或密碼!!!");
        }
        else
        {
            switch (sUserType)
            {
            case "水土保持義務人":
                LoginR = SwcApp.GetLoginStatus(sInputID, sInputPW, "01");
                break;

            case "承辦/監造技師":
                LoginR = SwcApp.GetLoginStatus(sInputID, sInputPW, "02");
                break;

            case "工務局大地工程處":
                LoginR = SwcApp.GetLoginStatus(sInputID, sInputPW, "03");

                if (LoginR)
                {
                    string ssUserName = Session["NAME"] + "";
                    //LoadApp.LoadSwcCase("03", ssUserName);
                }
                break;

            case "審查/檢查單位":
                LoginR = SwcApp.GetLoginStatus(sInputID, sInputPW, "04");

                if (LoginR)
                {
                    string ssUserName = Session["NAME"] + "";
                    //LoadApp.LoadSwcCase("04", ssUserName);
                }
                break;
            }

            if (LoginR)
            {
                Response.Redirect("~/PriPage/SwcPrivacy_01.aspx");
            }
            else
            {
                error_msg.Text = SwcApp.AlertMsg("密碼輸入錯誤 如忘記密碼請聯繫大地工程處02-27591109");
            }
        }
    }
Ejemplo n.º 4
0
    protected void SaveAccount_Click(object sender, EventArgs e)
    {
        error_msg.Text = "";

        string SSPW = Session["PW"] + "";

        string SaveDate    = "Y";
        string NewAccount  = TXTETIDNo.Text + "";
        string gETID1      = TXTETPW.Text + "";
        string gETID2      = TXTETPWChk.Text + "";
        string gETName     = TXTETName.Text + "";
        string gETTel      = TXTETTel.Text + "";
        string gETEmail    = TXTETEmail.Text + "";
        string gETOrgName  = TXTETOrgName.Text + "";
        string gETOrgGUINo = TXTETOrgGUINo.Text + "";
        string gETOrgAddr  = TXTETOrgAddr.Text + "";
        string gETOrgTel   = TXTETOrgTel.Text + "";
        string gETCOPC     = TXTETCOPC.Text + "";
        string gETTCNo01   = TXTETTCNo01.Text + "";
        string gETTCNo02   = TXTETTCNo02.Text + "";
        string gETTCNo03   = TXTETTCNo03.Text + "";
        string gETTCNo04   = TXTETTCNo04.Text + "";
        string gETOrgIssNo = TXTETOrgIssNo.Text + "";
        string gSYSID      = TXTSYSID.Text + "";
        string gOldPw      = TXTETPWOLD.Text + "";
        string gTCNo01ED   = TXTTCNo01ED.Text + "";
        string gTCNo02ED   = TXTTCNo02ED.Text + "";
        string gTCNo03ED   = TXTTCNo03ED.Text + "";
        string gTCNo04ED   = TXTTCNo04ED.Text + "";
        string gETCOPCExp  = TXTETCOPCExp.Text + "";

        GBClass001 SBApp = new GBClass001();

        if (gOldPw == "" && (gETID1 != "" || gETID2 != ""))
        {
            SaveDate       = "N";
            error_msg.Text = SBApp.AlertMsg("請輸入舊密碼,謝謝!!");
            TXTETIDNo.Focus();
            return;
        }
        if (gOldPw != "" && (SSPW != gOldPw))
        {
            SaveDate       = "N";
            error_msg.Text = SBApp.AlertMsg("密碼不正確請重新輸入,謝謝!!");
            TXTETIDNo.Focus();
            return;
        }

        if (gETID1 != gETID2)
        {
            SaveDate       = "N";
            error_msg.Text = SBApp.AlertMsg("密碼與確認密碼不符");
            TXTETPW.Focus();
            return;
        }

        if (SaveDate == "Y")
        {
            string UserSqlStr = "";

            UserSqlStr = UserSqlStr + " Update ETUsers Set ";
            if (gETID1 != "")
            {
                UserSqlStr    = UserSqlStr + " ETPW ='" + gETID1 + "', ";
                Session["PW"] = gETID1;
            }
            UserSqlStr = UserSqlStr + " ETName =N'" + gETName + "', ";
            UserSqlStr = UserSqlStr + " ETTel =N'" + gETTel + "', ";
            UserSqlStr = UserSqlStr + " ETEmail =N'" + gETEmail + "', ";
            UserSqlStr = UserSqlStr + " ETOrgName =N'" + gETOrgName + "', ";
            UserSqlStr = UserSqlStr + " ETOrgGUINo =N'" + gETOrgGUINo + "', ";
            UserSqlStr = UserSqlStr + " ETOrgAddr =N'" + gETOrgAddr + "', ";
            UserSqlStr = UserSqlStr + " ETOrgTel =N'" + gETOrgTel + "', ";
            UserSqlStr = UserSqlStr + " ETCOPC =N'" + gETCOPC + "', ";
            UserSqlStr = UserSqlStr + " ETTCNo01 =N'" + gETTCNo01 + "', ";
            UserSqlStr = UserSqlStr + " ETTCNo02 =N'" + gETTCNo02 + "', ";
            UserSqlStr = UserSqlStr + " ETTCNo03 =N'" + gETTCNo03 + "', ";
            UserSqlStr = UserSqlStr + " ETTCNo04 =N'" + gETTCNo04 + "', ";
            UserSqlStr = UserSqlStr + " ETOrgIssNo =N'" + gETOrgIssNo + "', ";
            UserSqlStr = UserSqlStr + " TCNo01ED =N'" + gTCNo01ED + "', ";
            UserSqlStr = UserSqlStr + " TCNo02ED =N'" + gTCNo02ED + "', ";
            UserSqlStr = UserSqlStr + " TCNo03ED =N'" + gTCNo03ED + "', ";
            UserSqlStr = UserSqlStr + " TCNo04ED =N'" + gTCNo04ED + "', ";
            UserSqlStr = UserSqlStr + " ETCOPCExp =N'" + gETCOPCExp + "', ";
            UserSqlStr = UserSqlStr + " SYSID =N'" + gSYSID + "', ";
            UserSqlStr = UserSqlStr + " saveuser = N'" + NewAccount + "', ";
            UserSqlStr = UserSqlStr + " savedate = getdate() ";
            UserSqlStr = UserSqlStr + " Where ETIDNo = '" + NewAccount + "'";

            ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
            using (SqlConnection SWCConn = new SqlConnection(connectionString.ConnectionString))
            {
                SWCConn.Open();

                SqlCommand objCmdUser = new SqlCommand(UserSqlStr, SWCConn);
                objCmdUser.ExecuteNonQuery();
                objCmdUser.Dispose();
            }

            //上傳檔案…
            UpLoadTempFileMoveChk(NewAccount);

            GetUserData(NewAccount);

            Response.Write("<script>alert('資料已存檔'); location.href='SWC001.aspx'; </script>");
        }
    }
Ejemplo n.º 5
0
    private void Data2Page(string v, string v2)
    {
        GBClass001 SBApp = new GBClass001();

        ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];

        using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
        {
            SwcConn.Open();

            string strSQLRV = " select * from SWCCASE ";
            strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";

            SqlDataReader readeSwc;
            SqlCommand    objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
            readeSwc = objCmdSwc.ExecuteReader();

            while (readeSwc.Read())
            {
                string tSWC002   = readeSwc["SWC002"] + "";
                string tSWC005   = readeSwc["SWC005"] + "";
                string tSWC007   = readeSwc["SWC007"] + "";
                string tSWC013ID = readeSwc["SWC013ID"] + "";
                string tSWC013   = readeSwc["SWC013"] + "";
                string tSWC014   = readeSwc["SWC014"] + "";
                string tSWC021ID = readeSwc["SWC021ID"] + "";
                string tSWC021   = readeSwc["SWC021"] + "";
                string tSWC023   = readeSwc["SWC023"] + "";
                string tSWC038   = readeSwc["SWC038"] + "";
                string tSWC039   = readeSwc["SWC039"] + "";
                string tSWC043   = readeSwc["SWC043"] + "";
                string tSWC044   = readeSwc["SWC044"] + "";
                string tSWC051   = readeSwc["SWC051"] + "";
                string tSWC052   = readeSwc["SWC052"] + "";

                LBSWC000.Text = v;
                LBSWC002.Text = tSWC002;
                LBSWC005.Text = tSWC005;
                //LBSWC005a.Text = tSWC005;
                LBSWC007.Text         = tSWC007;
                LBSWC013ID.Text       = tSWC013ID;
                LBSWC013.Text         = tSWC013;
                LBSWC014.Text         = tSWC014;
                LBSWC021.Text         = tSWC021;
                LBSWC021Name.Text     = SBApp.GetETUser(tSWC021ID, "OrgName");
                LBSWC021OrgIssNo.Text = SBApp.GetETUser(tSWC021ID, "OrgIssNo");
                LBSWC021OrgGUINo.Text = SBApp.GetETUser(tSWC021ID, "OrgGUINo");
                LBSWC021OrgTel.Text   = SBApp.GetETUser(tSWC021ID, "OrgTel");

                TXTDTL004.Text = tSWC023;
                LBSWC038.Text  = SBApp.DateView(tSWC038, "00");
                LBSWC039.Text  = tSWC039;
                LBSWC043.Text  = SBApp.DateView(tSWC043, "00");
                LBSWC044.Text  = tSWC044;
                LBSWC051.Text  = SBApp.DateView(tSWC051, "00");
                LBSWC052.Text  = SBApp.DateView(tSWC052, "00");
            }

            readeSwc.Close();
            objCmdSwc.Dispose();

            if (v2 == "AddNew")
            {
                string nIDA       = GetDTLAID(v);
                string ssUserName = Session["NAME"] + "";

                LBDTL001.Text  = nIDA;
                TXTDTL004.Text = ssUserName;
            }
            else
            {
                string strSQLRV2 = " select * from SWCDTL03 ";
                strSQLRV2 = strSQLRV2 + " where SWC000 = '" + v + "' ";
                strSQLRV2 = strSQLRV2 + " and DTLC001 = '" + v2 + "' ";

                SqlDataReader readeDTL;
                SqlCommand    objCmdDTL = new SqlCommand(strSQLRV2, SwcConn);
                readeDTL = objCmdDTL.ExecuteReader();

                while (readeDTL.Read())
                {
                    string tDTLC001 = readeDTL["DTLC001"] + "";
                    string tDTLC002 = readeDTL["DTLC002"] + "";
                    string tDTLC003 = readeDTL["DTLC003"] + "";
                    string tDTLC004 = readeDTL["DTLC004"] + "";
                    string tDTLC005 = readeDTL["DTLC005"] + "";
                    string tDTLC006 = readeDTL["DTLC006"] + "";
                    string tDTLC007 = readeDTL["DTLC007"] + "";
                    string tDTLC008 = readeDTL["DTLC008"] + "";
                    string tDTLC009 = readeDTL["DTLC009"] + "";
                    string tDTLC010 = readeDTL["DTLC010"] + "";
                    string tDTLC011 = readeDTL["DTLC011"] + "";
                    string tDTLC012 = readeDTL["DTLC012"] + "";
                    string tDTLC013 = readeDTL["DTLC013"] + "";
                    string tDTLC014 = readeDTL["DTLC014"] + "";
                    string tDTLC015 = readeDTL["DTLC015"] + "";
                    string tDTLC016 = readeDTL["DTLC016"] + "";
                    string tDTLC017 = readeDTL["DTLC017"] + "";
                    string tDTLC018 = readeDTL["DTLC018"] + "";
                    string tDTLC019 = readeDTL["DTLC019"] + "";
                    string tDTLC020 = readeDTL["DTLC020"] + "";
                    string tDTLC021 = readeDTL["DTLC021"] + "";
                    string tDTLC022 = readeDTL["DTLC022"] + "";
                    string tDTLC023 = readeDTL["DTLC023"] + "";
                    string tDTLC024 = readeDTL["DTLC024"] + "";
                    string tDTLC025 = readeDTL["DTLC025"] + "";
                    string tDTLC026 = readeDTL["DTLC026"] + "";
                    string tDTLC027 = readeDTL["DTLC027"] + "";
                    string tDTLC028 = readeDTL["DTLC028"] + "";
                    string tDTLC029 = readeDTL["DTLC029"] + "";
                    string tDTLC030 = readeDTL["DTLC030"] + "";
                    string tDTLC031 = readeDTL["DTLC031"] + "";
                    string tDTLC032 = readeDTL["DTLC032"] + "";
                    string tDTLC033 = readeDTL["DTLC033"] + "";
                    string tDTLC034 = readeDTL["DTLC034"] + "";
                    string tDTLC035 = readeDTL["DTLC035"] + "";
                    string tDTLC036 = readeDTL["DTLC036"] + "";
                    string tDTLC037 = readeDTL["DTLC037"] + "";
                    string tDTLC038 = readeDTL["DTLC038"] + "";
                    string tDTLC039 = readeDTL["DTLC039"] + "";
                    string tDTLC040 = readeDTL["DTLC040"] + "";
                    string tDTLC041 = readeDTL["DTLC041"] + "";
                    string tDTLC042 = readeDTL["DTLC042"] + "";
                    string tDTLC043 = readeDTL["DTLC043"] + "";
                    string tDTLC044 = readeDTL["DTLC044"] + "";
                    string tDTLC045 = readeDTL["DTLC045"] + "";
                    string tDTLC046 = readeDTL["DTLC046"] + "";
                    string tDTLC047 = readeDTL["DTLC047"] + "";
                    string tDTLC048 = readeDTL["DTLC048"] + "";
                    string tDTLC049 = readeDTL["DTLC049"] + "";
                    string tDTLC050 = readeDTL["DTLC050"] + "";
                    string tDTLC051 = readeDTL["DTLC051"] + "";
                    string tDTLC052 = readeDTL["DTLC052"] + "";
                    string tDTLC053 = readeDTL["DTLC053"] + "";
                    string tDTLC054 = readeDTL["DTLC054"] + "";
                    string tDTLC055 = readeDTL["DTLC055"] + "";
                    string tDTLC056 = readeDTL["DTLC056"] + "";
                    string tDTLC057 = readeDTL["DTLC057"] + "";
                    string tDTLC058 = readeDTL["DTLC058"] + "";
                    string tDTLC059 = readeDTL["DTLC059"] + "";
                    string tDTLC060 = readeDTL["DTLC060"] + "";
                    string tDTLC061 = readeDTL["DTLC061"] + "";
                    string tDTLC062 = readeDTL["DTLC062"] + "";
                    string tDTLC063 = readeDTL["DTLC063"] + "";
                    string tDTLC064 = readeDTL["DTLC064"] + "";
                    string tDTLC065 = readeDTL["DTLC065"] + "";
                    string tDTLC066 = readeDTL["DTLC066"] + "";
                    string tDTLC067 = readeDTL["DTLC067"] + "";
                    string tDTLC068 = readeDTL["DTLC068"] + "";

                    string tDATALOCK = readeDTL["DATALOCK"] + "";

                    LBDTL001.Text           = tDTLC001;
                    TXTDTL002.Text          = SBApp.DateView(tDTLC002, "00");
                    TXTDTL003.Text          = tDTLC003.Trim() == "" ? TXTDTL003.Text:tDTLC003;
                    TXTDTL004.Text          = tDTLC004;
                    TXTDTL005.Text          = tDTLC005;
                    DDLDTL006.SelectedValue = tDTLC006;
                    TXTDTL007.Text          = tDTLC007;
                    DDLDTL008.SelectedValue = tDTLC008;
                    TXTDTL009.Text          = tDTLC009;
                    DDLDTL010.SelectedValue = tDTLC010;
                    TXTDTL011.Text          = tDTLC011;
                    DDLDTL012.SelectedValue = tDTLC012;
                    TXTDTL013.Text          = tDTLC013;
                    DDLDTL014.SelectedValue = tDTLC014;
                    TXTDTL015.Text          = tDTLC015;
                    DDLDTL016.SelectedValue = tDTLC016;
                    TXTDTL017.Text          = tDTLC017;
                    DDLDTL018.SelectedValue = tDTLC018;
                    TXTDTL019.Text          = tDTLC019;
                    DDLDTL020.SelectedValue = tDTLC020;
                    TXTDTL021.Text          = tDTLC021;
                    DDLDTL022.SelectedValue = tDTLC022;
                    TXTDTL023.Text          = tDTLC023;
                    DDLDTL024.SelectedValue = tDTLC024;
                    TXTDTL025.Text          = tDTLC025;
                    DDLDTL026.SelectedValue = tDTLC026;
                    TXTDTL027.Text          = tDTLC027;
                    DDLDTL028.SelectedValue = tDTLC028;
                    TXTDTL029.Text          = tDTLC029;
                    DDLDTL030.SelectedValue = tDTLC030;
                    TXTDTL031.Text          = tDTLC031;
                    DDLDTL032.SelectedValue = tDTLC032;
                    TXTDTL033.Text          = tDTLC033;
                    DDLDTL034.SelectedValue = tDTLC034;
                    TXTDTL035.Text          = tDTLC035;
                    DDLDTL036.SelectedValue = tDTLC036;
                    TXTDTL037.Text          = tDTLC037;
                    DDLDTL038.SelectedValue = tDTLC038;
                    TXTDTL039.Text          = tDTLC039;
                    DDLDTL040.SelectedValue = tDTLC040;
                    TXTDTL041.Text          = tDTLC041;
                    DDLDTL042.SelectedValue = tDTLC042;
                    TXTDTL043.Text          = tDTLC043;
                    DDLDTL044.SelectedValue = tDTLC044;
                    TXTDTL045.Text          = tDTLC045;
                    DDLDTL046.SelectedValue = tDTLC046;
                    TXTDTL047.Text          = tDTLC047;
                    TXTDTL048.Text          = tDTLC048;
                    TXTDTL049.Text          = SBApp.DateView(tDTLC049, "00");
                    TXTDTL050.Text          = tDTLC050;
                    TXTDTL051.Text          = tDTLC051;
                    TXTDTL052.Text          = tDTLC052;
                    DDLDTL053.SelectedValue = tDTLC053;
                    TXTDTL054.Text          = tDTLC054;
                    TXTDTL055.Text          = tDTLC055;
                    TXTDTL056.Text          = tDTLC056;
                    //TXTDTL057.Text = tDTLC057;
                    //TXTDTL058.Text = tDTLC058;
                    //TXTDTL059.Text = tDTLC059;
                    //TXTDTL060.Text = tDTLC060;
                    //TXTDTL061.Text = tDTLC061;
                    //TXTDTL062.Text = tDTLC062;
                    //TXTDTL063.Text = tDTLC063;
                    //TXTDTL064.Text = tDTLC064;
                    //TXTDTL065.Text = tDTLC065;
                    //TXTDTL066.Text = tDTLC066;
                    //TXTDTL067.Text = tDTLC067;
                    //TXTDTL068.Text = tDTLC068;


                    //點擊放大圖片類處理
                    string[] arrayFileName2 = new string[] { tDTLC056 };
                    System.Web.UI.WebControls.HyperLink[] arrayImgAppobj2 = new System.Web.UI.WebControls.HyperLink[] { HyperLink056 };

                    for (int i = 0; i < arrayFileName2.Length; i++)
                    {
                        string strFileName = arrayFileName2[i];
                        System.Web.UI.WebControls.HyperLink ImgFileObj = arrayImgAppobj2[i];

                        if (strFileName == "")
                        {
                        }
                        else
                        {
                            string tempImgPateh = SwcUpLoadFilePath + v + "/" + strFileName;
                            ImgFileObj.ImageUrl    = tempImgPateh + "?ts=" + DateTime.Now.Millisecond;
                            ImgFileObj.NavigateUrl = tempImgPateh + "?ts=" + DateTime.Now.Millisecond;
                        }
                    }

                    ////圖片類處理
                    //string[] arrayFileName = new string[] { tDTLC057, tDTLC059, tDTLC061, tDTLC063, tDTLC065, tDTLC067 };
                    //System.Web.UI.WebControls.Image[] arrayImgAppobj = new System.Web.UI.WebControls.Image[] { TXTDTL057_img, TXTDTL059_img, TXTDTL061_img, TXTDTL063_img, TXTDTL065_img, TXTDTL067_img };

                    //for (int i = 0; i < arrayFileName.Length; i++)
                    //{
                    //    string strFileName = arrayFileName[i];
                    //    System.Web.UI.WebControls.Image ImgFileObj = arrayImgAppobj[i];

                    //    if (strFileName == "")
                    //    {
                    //    }
                    //    else
                    //    {
                    //        string tempImgPateh = SwcUpLoadFilePath + v + "/" + strFileName;
                    //        ImgFileObj.Attributes.Add("src", tempImgPateh + "?ts=" + DateTime.Now.Millisecond);
                    //    }
                    //}

                    //按鈕處理
                    if (tDATALOCK == "Y")
                    {
                        DataLock.Visible = false;
                        SaveCase.Visible = false;

                        error_msg.Text = SBApp.AlertMsg("資料已送出,目前僅供瀏覽。");
                    }
                }
            }
        }
    }