public Tombo Create()
{
Tombo entity = new Tombo()
{
DataDeCriacao = DateTime.Now
};
using (Database database = new Database())
{
DbCommand command = database.CreateCommand();
StringBuilder sb = new StringBuilder("");
sb.Append("INSERT INTO [dbo].[Tombo]");
sb.Append(" ([DataDeCriacao])");
sb.Append(" SELECT @DataDeCriacao; ");
sb.Append("SELECT SCOPE_IDENTITY() AS IDENTITY_ID;");
command.CommandText = sb.ToString();
database.AddInParameter(command, "@DataDeCriacao", DbType.DateTime, entity.DataDeCriacao);
object ret = database.ExecuteScalar(command);
entity.ID = Convert.ToInt32(ret);
}
return(entity);
}
public void Delete(Tombo entity)
{
using (Database database = new Database())
{
DbCommand command = database.CreateCommand();
command.CommandText = "DELETE FROM [dbo].[Tombo] WHERE @ID = [ID];";
database.AddInParameter(command, "@ID", DbType.Int32, entity.ID);
database.ExecuteNonQuery(command);
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public override string ToString()
{
StringBuilder builder = new StringBuilder();
builder.Append(maSign.ToString("D") + " ,");
builder.Append(bollingerSign.ToString("D") + " ,");
builder.Append(ichimokuSign.ToString("D") + " ,");
builder.Append(parabolicSign.ToString("D") + " ,");
builder.Append(pivotSign.ToString("D") + " ,");
builder.Append(ROCSign.ToString("D") + " ,");
builder.Append(psychologicalSign.ToString("D") + " ,");
builder.Append(deviationSign.ToString("D") + " ,");
builder.Append(RSISign.ToString("D") + " ,");
builder.Append(RCISign.ToString("D") + " ,");
builder.Append(perRSign.ToString("D") + " ,");
builder.Append(stochasticSign.ToString("D") + " ,");
builder.Append(MACDSign.ToString("D") + " ,");
builder.Append(DMISign.ToString("D") + " ,");
builder.Append(VolumeSign.ToString("D") + " ,");
builder.Append(MFISign.ToString("D") + " ,");
builder.Append(MATrend.ToString("D") + " ,");
builder.Append(DMITrend.ToString("D") + " ,");
builder.Append(ParabolicTrend.ToString("D") + " ,");
builder.Append(MACDTrend.ToString("D") + " ,");
builder.Append(HLBand.ToString("D") + " ,");
builder.Append(TwoMA.ToString("D") + " ,");
builder.Append(FourWeeksRule.ToString("D") + " ,");
builder.Append(PFB1.ToString("D") + " ,");
builder.Append(PFB2.ToString("D") + " ,");
builder.Append(PFB3.ToString("D") + " ,");
builder.Append(PFB4.ToString("D") + " ,");
builder.Append(PFB5.ToString("D") + " ,");
builder.Append(PFS1.ToString("D") + " ,");
builder.Append(PFS2.ToString("D") + " ,");
builder.Append(minPurchasePrice + " ,");
builder.Append("NULL" + " ,");
builder.Append(WhiteMaruBozu.ToString("D") + " ,");
builder.Append(WhiteOhbikeBozu.ToString("D") + " ,");
builder.Append(WhiteYoritsukiBozu.ToString("D") + " ,");
builder.Append(BlackMaruBozu.ToString("D") + " ,");
builder.Append(BlackOhbikeBozu.ToString("D") + " ,");
builder.Append(BlackYoritsukiBozu.ToString("D") + " ,");
builder.Append(WhiteShitakage.ToString("D") + " ,");
builder.Append(WhiteUekage.ToString("D") + " ,");
builder.Append(WhiteKarakasa.ToString("D") + " ,");
builder.Append(BlackShitakage.ToString("D") + " ,");
builder.Append(BlackUekage.ToString("D") + " ,");
builder.Append(BlackKarakasa.ToString("D") + " ,");
builder.Append(Tonkachi.ToString("D") + " ,");
builder.Append(Tombo.ToString("D") + " ,");
builder.Append(Touba.ToString("D") + " ,");
builder.Append(SankuTatakikomi.ToString("D") + " ,");
builder.Append(SanteDaiInsen.ToString("D") + " ,");
builder.Append(LastIdakiInsen.ToString("D") + " ,");
builder.Append(AkenoMyojo.ToString("D") + " ,");
builder.Append(Sutegozoko.ToString("D") + " ,");
builder.Append(TakuriSen.ToString("D") + " ,");
builder.Append(Seiryokusen.ToString("D") + " ,");
builder.Append(BlackBlackHarami.ToString("D") + " ,");
builder.Append(IdakiYosen.ToString("D") + " ,");
builder.Append(Akasanpei.ToString("D") + " ,");
builder.Append(KaiFiveYosen.ToString("D") + " ,");
builder.Append(Osaekomisen.ToString("D") + " ,");
builder.Append(Agesanpo.ToString("D") + " ,");
builder.Append(SankuHumiage.ToString("D") + " ,");
builder.Append(SinneHatteRiguiSen.ToString("D") + " ,");
builder.Append(IkiDumari.ToString("D") + " ,");
builder.Append(JouiUwabanareInsen.ToString("D") + " ,");
builder.Append(YoYoHarami.ToString("D") + " ,");
builder.Append(LastIdakiYosen.ToString("D") + " ,");
builder.Append(IdakiInsen.ToString("D") + " ,");
builder.Append(VolumeRatio + " ,");
builder.Append(VolumeAmount + " ,");
builder.Append("'" + DateTime.Today + "'");
return(builder.ToString());
}
