//更新当前的盈利信息
void UpdateProfit()
{
DataTable dsSelecteTbl = new DataTable();
dsSelecteTbl = GetAllSelfSelected().Tables[0];
foreach (DataRow drSelect in dsSelecteTbl.Rows)
{
SelfSelectedModel oModelSelf = SelfSelectedDAL.Instance.DataRowToModel(drSelect);
EquityModel buymodel = GetFundEquityInfo.Instance.GetFormatedFundInfo(oModelSelf.Symbol, oModelSelf.BuyDate);
oModelSelf.BuyPrice = float.Parse(buymodel.unitwork);
//买入份额
double dBuyCount = oModelSelf.BuyQuant / oModelSelf.BuyPrice;
if (oModelSelf.SaleDate == null)
{
oModelSelf.SaleDate = DateTime.Today;
}
EquityModel salemodel = GetFundEquityInfo.Instance.GetFormatedFundInfo(oModelSelf.Symbol, oModelSelf.SaleDate);
oModelSelf.SalePrice = float.Parse(salemodel.unitwork);
oModelSelf.CurQuant = dBuyCount * oModelSelf.SalePrice;
oModelSelf.CurProfit = oModelSelf.CurQuant - oModelSelf.BuyQuant;
SelfSelectedDAL.Instance.Update(oModelSelf);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SelfSelectedModel DataRowToModel(DataRow row)
{
SelfSelectedModel model = new SelfSelectedModel();
if (row != null)
{
if (row["Symbol"] != null && row["Symbol"].ToString() != "")
{
model.Symbol = row["Symbol"].ToString();
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["BuyDate"] != null)
{
model.BuyDate = Convert.ToDateTime(row["BuyDate"]);
}
if (row["BuyPrice"] != null)
{
model.BuyPrice = float.Parse(row["BuyPrice"].ToString());
}
if (row["BuyQuant"] != null && row["BuyQuant"].ToString() != "")
{
model.BuyQuant = float.Parse(row["BuyQuant"].ToString());
}
if (row["SaleDate"] != null)
{
model.BuyDate = Convert.ToDateTime(row["BuyDate"]);
}
if (row["SalePrice"] != null)
{
model.BuyPrice = float.Parse(row["BuyPrice"].ToString());
}
if (row["CurQuant"] != null)
{
model.CurQuant = float.Parse(row["CurQuant"].ToString());
}
if (row["CurProfit"] != null)
{
model.CurProfit = float.Parse(row["CurProfit"].ToString());
}
if (row["Rank"] != null)
{
model.Rank = row["Rank"].ToString();
}
if (row["Kind"] != null)
{
model.Kind = row["Kind"].ToString();
}
if (row["Custom"] != null)
{
model.Custom = row["Custom"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SelfSelectedModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbl_SelfSelected(");
strSql.Append("Symbol,Name,BuyDate,BuyPrice,BuyQuant,SaleDate,SalePrice,CurQuant,CurProfit,Rank,Kind,Custom)");
strSql.Append(" values (");
strSql.Append("@Symbol,@Name,@BuyDate,@BuyPrice,@BuyQuant,@SaleDate,@SalePrice,@CurQuant,@CurProfit,@Rank,@Kind,@Custom)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Symbol", SqlDbType.VarChar, 10),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@BuyDate", SqlDbType.Date),
new SqlParameter("@BuyPrice", SqlDbType.Float),
new SqlParameter("@BuyQuant", SqlDbType.Float),
new SqlParameter("@SaleDate", SqlDbType.Date),
new SqlParameter("@SalePrice", SqlDbType.Float),
new SqlParameter("@CurQuant", SqlDbType.Float),
new SqlParameter("@CurProfit", SqlDbType.Float),
new SqlParameter("@Rank", SqlDbType.VarChar, 20),
new SqlParameter("@Kind", SqlDbType.VarChar, 10),
new SqlParameter("@Custom", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.Symbol;
parameters[1].Value = model.Name;
parameters[2].Value = model.BuyDate;
parameters[3].Value = model.BuyPrice;
parameters[4].Value = model.BuyQuant;
parameters[5].Value = model.SaleDate;
parameters[6].Value = model.SalePrice;
parameters[7].Value = model.CurQuant;
parameters[8].Value = model.CurProfit;
parameters[9].Value = model.Rank;
parameters[10].Value = model.Kind;
parameters[11].Value = model.Custom;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SelfSelectedModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbl_SelfSelected set ");
strSql.Append("Name=@Name,");
strSql.Append("BuyDate=@BuyDate,");
strSql.Append("BuyPrice=@BuyPrice,");
strSql.Append("BuyQuant=@BuyQuant,");
strSql.Append("CurQuant=@CurQuant,");
strSql.Append("CurProfit=@CurProfit,");
strSql.Append("Rank=@Rank,");
strSql.Append("Kind=@Kind,");
strSql.Append("Custom=@Custom,");
strSql.Append(" where Symbol=@Symbol,");
SqlParameter[] parameters =
{
new SqlParameter("@Symbol", SqlDbType.VarChar, 10),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@BuyDate", SqlDbType.Date),
new SqlParameter("@BuyPrice", SqlDbType.Float),
new SqlParameter("@BuyQuant", SqlDbType.Float),
new SqlParameter("@SaleDate", SqlDbType.Date),
new SqlParameter("@SalePrice", SqlDbType.Float),
new SqlParameter("@CurQuant", SqlDbType.Float),
new SqlParameter("@CurProfit", SqlDbType.Float),
new SqlParameter("@Rank", SqlDbType.VarChar, 20),
new SqlParameter("@Kind", SqlDbType.VarChar, 10),
new SqlParameter("@Custom", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.Symbol;
parameters[1].Value = model.Name;
parameters[2].Value = model.BuyDate;
parameters[3].Value = model.BuyPrice;
parameters[4].Value = model.BuyQuant;
parameters[5].Value = model.SaleDate;
parameters[6].Value = model.SalePrice;
parameters[7].Value = model.CurQuant;
parameters[8].Value = model.CurProfit;
parameters[9].Value = model.Rank;
parameters[10].Value = model.Kind;
parameters[11].Value = model.Custom;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
return(rows);
}
int UpdateSelfSelected(SelfSelectedModel model)
{
return(SelfSelectedDAL.Instance.Update(model));
}
int AddSelfSelected(SelfSelectedModel model)
{
return(SelfSelectedDAL.Instance.Add(model));
}
