/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.StockInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update StockInfo set "); strSql.Append("stockcode=@stockcode,"); strSql.Append("Type=@Type,"); strSql.Append("OneHand=@OneHand,"); strSql.Append("Name=@Name,"); strSql.Append("PointIndex=@PointIndex,"); strSql.Append("YestClose=@YestClose,"); strSql.Append("Unknow1=@Unknow1,"); strSql.Append("Unknow2=@Unknow2,"); strSql.Append("Unknow3=@Unknow3"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@stockcode", SqlDbType.NVarChar, 50), new SqlParameter("@Type", SqlDbType.NVarChar, 50), new SqlParameter("@OneHand", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@PointIndex", SqlDbType.NVarChar, 50), new SqlParameter("@YestClose", SqlDbType.Decimal, 9), new SqlParameter("@Unknow1", SqlDbType.NVarChar, 50), new SqlParameter("@Unknow2", SqlDbType.NVarChar, 50), new SqlParameter("@Unknow3", SqlDbType.NVarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.stockcode; parameters[1].Value = model.Type; parameters[2].Value = model.OneHand; parameters[3].Value = model.Name; parameters[4].Value = model.PointIndex; parameters[5].Value = model.YestClose; parameters[6].Value = model.Unknow1; parameters[7].Value = model.Unknow2; parameters[8].Value = model.Unknow3; parameters[9].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.StockInfo DataRowToModel(DataRow row) { Model.StockInfo model = new Model.StockInfo(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["stockcode"] != null) { model.stockcode = row["stockcode"].ToString(); } if (row["Type"] != null) { model.Type = row["Type"].ToString(); } if (row["OneHand"] != null) { model.OneHand = row["OneHand"].ToString(); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["PointIndex"] != null) { model.PointIndex = row["PointIndex"].ToString(); } if (row["YestClose"] != null && row["YestClose"].ToString() != "") { model.YestClose = decimal.Parse(row["YestClose"].ToString()); } if (row["Unknow1"] != null) { model.Unknow1 = row["Unknow1"].ToString(); } if (row["Unknow2"] != null) { model.Unknow2 = row["Unknow2"].ToString(); } if (row["Unknow3"] != null) { model.Unknow3 = row["Unknow3"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.StockInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into StockInfo("); strSql.Append("stockcode,Type,OneHand,Name,PointIndex,YestClose,Unknow1,Unknow2,Unknow3)"); strSql.Append(" values ("); strSql.Append("@stockcode,@Type,@OneHand,@Name,@PointIndex,@YestClose,@Unknow1,@Unknow2,@Unknow3)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@stockcode", SqlDbType.NVarChar, 50), new SqlParameter("@Type", SqlDbType.NVarChar, 50), new SqlParameter("@OneHand", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@PointIndex", SqlDbType.NVarChar, 50), new SqlParameter("@YestClose", SqlDbType.Decimal, 9), new SqlParameter("@Unknow1", SqlDbType.NVarChar, 50), new SqlParameter("@Unknow2", SqlDbType.NVarChar, 50), new SqlParameter("@Unknow3", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.stockcode; parameters[1].Value = model.Type; parameters[2].Value = model.OneHand; parameters[3].Value = model.Name; parameters[4].Value = model.PointIndex; parameters[5].Value = model.YestClose; parameters[6].Value = model.Unknow1; parameters[7].Value = model.Unknow2; parameters[8].Value = model.Unknow3; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.StockInfo GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,stockcode,Type,OneHand,Name,PointIndex,YestClose,Unknow1,Unknow2,Unknow3 from StockInfo "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.StockInfo model = new Model.StockInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }