//=================================================================
// 【傳入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());
}