/// <summary> /// 得到一个对象实体 /// </summary> public static yny_005.Model.StockRightConfig DataRowToModel(DataRow row) { yny_005.Model.StockRightConfig model = new yny_005.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_005.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); }