//=================================================================
        // 【傳入table name】 取得該table的select語句,代換成delete語句
        //=================================================================
        private string GetDeleteScript(string script)
        {
            GetDataDao dao = new GetDataDao();

            string scriptString = string.Empty;

            scriptString = dao.GetScriptString(script, strRefPdtCode);

            scriptString = scriptString.Replace("select * ", "delete ");

            return(scriptString);
        }
        private string GenerateAllSelectScript(string strNewPdt, string strRefPdt, List <string> checkedScript)
        {
            GetDataDao    dao = new GetDataDao();
            StringBuilder sb  = new StringBuilder();

            sb.AppendLine();

            foreach (var script in checkedScript)
            {
                if (script.Equals("RPT_SECTION_D") || script.Equals("PLI_PDTRIDERSUM"))
                {
                    sb.AppendLine(dao.GetScriptString(script, strRefPdt));
                }
                else
                {
                    sb.AppendLine(dao.GetScriptString(script, strNewPdt));
                }
                sb.AppendLine(dao.GetScriptString(script, strRefPdt));
                sb.AppendLine();
            }

            return(sb.ToString());
        }