public MainPage() { InitializeComponent(); btnScanDefault.Clicked += btnScanDefault_Clicked; this.vm = new InsertSetting(); }
public LoginPopupPage() { InitializeComponent(); this.vm = new InsertSetting(); }
/// <summary> /// Builds the insert statement. /// </summary> /// <returns></returns> public override string BuildInsertStatement() { StringBuilder sb = new StringBuilder(); //cast it Insert i = insert; //sb.Append("begin "); sb.Append(this.sqlFragment.INSERT_INTO); sb.Append(stripBraces(i.Table.QualifiedName)); sb.Append("("); sb.Append(stripBraces(i.SelectColumns)); sb.Append(")"); //if the values list is set, use that InsertSetting keySetting = null; if (i.Inserts.Count > 0) { sb.Append(" VALUES ("); bool isFirst = true; foreach (InsertSetting s in i.Inserts) { if (!isFirst) { sb.Append(","); } if (!s.IsExpression && !s.IsPrimaryKey) { sb.Append(s.ParameterName); } else { sb.Append(s.Value); } isFirst = false; if (s.IsPrimaryKey) { keySetting = s; } } sb.Append(")"); } else { if (i.SelectValues != null) { string selectSql = i.SelectValues.BuildSqlStatement(); sb.AppendLine(selectSql); } else { throw new InvalidOperationException( "Need to specify Values or a Select query to insert - can't go on!"); } } //if (keySetting != null) //{ // return String.Format("DECLARE BEGIN EXECUTE IMMEDIATE '{0}'; {1} END;", sb.ToString(), "select " + keySetting.Value.ToString().Replace("Nextval", "CURRVAL") + " from DUAL"); //} //sb.Append("end;"); return(sb.ToString()); }