/// <summary>
/// 得到一个对象实体
/// </summary>
public static yny_002.Model.StockRightConfig DataRowToModel(DataRow row)
{
yny_002.Model.StockRightConfig model = new yny_002.Model.StockRightConfig();
if (row != null)
{
if (row["Code"] != null)
{
model.Code = row["Code"].ToString();
}
if (row["FHCount"] != null && row["FHCount"].ToString() != "")
{
model.FHCount = int.Parse(row["FHCount"].ToString());
}
if (row["FHFloat"] != null && row["FHFloat"].ToString() != "")
{
model.FHFloat = decimal.Parse(row["FHFloat"].ToString());
}
if (row["BuyMoney"] != null && row["BuyMoney"].ToString() != "")
{
model.BuyMoney = decimal.Parse(row["BuyMoney"].ToString());
}
if (row["LimitCount"] != null && row["LimitCount"].ToString() != "")
{
model.LimitCount = int.Parse(row["LimitCount"].ToString());
}
model.SellCount = GetSellCount(model.Code, 0);
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static Hashtable Add(yny_002.Model.StockRightConfig model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into StockRightConfig(");
strSql.Append("Code,FHCount,FHFloat,BuyMoney,LimitCount)");
strSql.Append(" values (");
strSql.Append("@Code,@FHCount,@FHFloat,@BuyMoney,@LimitCount)");
SqlParameter[] parameters =
{
new SqlParameter("@Code", SqlDbType.VarChar, 10),
new SqlParameter("@FHCount", SqlDbType.Int, 4),
new SqlParameter("@FHFloat", SqlDbType.Decimal, 9),
new SqlParameter("@BuyMoney", SqlDbType.Decimal, 9),
new SqlParameter("@LimitCount", SqlDbType.Int, 4)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.FHCount;
parameters[2].Value = model.FHFloat;
parameters[3].Value = model.BuyMoney;
parameters[4].Value = model.LimitCount;
string guid = Guid.NewGuid().ToString();
strSql.AppendFormat(";select '{0}'", guid);
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
