private void FrmStockHoldAdd_Load(object sender, EventArgs e)
{
if (!AddFlag)
{
M_HoldStock m_holdStock = HoldStock.GetModel(modifyId);
this.txtHoldAmount.Text = m_holdStock.HoldAmount.ToString();
this.txtStockNo.Text = m_holdStock.StockNo;
this.txtPrice.Text = m_holdStock.Price.ToString();
this.txtStockName.Text = m_holdStock.StockName;
this.dtpupdateDate.Value = DateTime.Now;
}
}
/// <summary>
/// 把从网络上获取的股票价格信息更新到后台数据库
/// </summary>
/// <param name="listUrlStock"></param>
private void RefreshHoldData(List <M_UrlStock> listUrlStock)
{
foreach (M_UrlStock stock in listUrlStock)
{
M_HoldStock mHoldStock = null;
string stockNo = stock.StockNo;
string strWhere = string.Format("{0}='{1}'", "StockNo", stockNo);
DataTable dt = HoldStock.GetList(1, strWhere, "StockNo").Tables[0];
if (dt.Rows.Count != 0)
{
int id = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
mHoldStock = HoldStock.GetModel(id);
mHoldStock.Price = stock.Price;
mHoldStock.UpdateTime = stock.UpdateTime;
HoldStock.Update(mHoldStock);
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static M_HoldStock GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, StockNo, StockName, HoldAmount, Price, UpdateTime ");
strSql.Append(" from HoldStock ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
M_HoldStock model = new M_HoldStock();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
model.StockNo = ds.Tables[0].Rows[0]["StockNo"].ToString();
model.StockName = ds.Tables[0].Rows[0]["StockName"].ToString();
if (ds.Tables[0].Rows[0]["HoldAmount"].ToString() != "")
{
model.HoldAmount = int.Parse(ds.Tables[0].Rows[0]["HoldAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Price"].ToString() != "")
{
model.Price = Double.Parse(ds.Tables[0].Rows[0]["Price"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(M_HoldStock model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [HoldStock] set ");
strSql.Append("[StockNo]=@StockNo,");
strSql.Append("[StockName]=@StockName,");
strSql.Append("[HoldAmount]=@HoldAmount,");
strSql.Append("[Price]=@Price,");
strSql.Append("[UpdateTime]=@UpdateTime");
strSql.Append(" where [ID]=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@StockNo", OleDbType.VarChar, 255),
new OleDbParameter("@StockName", OleDbType.VarChar, 255),
new OleDbParameter("@HoldAmount", OleDbType.Integer, 4),
new OleDbParameter("@Price", OleDbType.Double),
new OleDbParameter("@UpdateTime", OleDbType.Date),
new OleDbParameter("@ID", OleDbType.Integer, 4),
};
parameters[0].Value = model.StockNo;
parameters[1].Value = model.StockName;
parameters[2].Value = model.HoldAmount;
parameters[3].Value = model.Price;
parameters[4].Value = model.UpdateTime;
parameters[5].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(M_HoldStock model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HoldStock(");
strSql.Append("StockNo,StockName,HoldAmount,Price,UpdateTime");
strSql.Append(") values (");
strSql.Append("@StockNo,@StockName,@HoldAmount,@Price,@UpdateTime");
strSql.Append(") ");
//strSql.Append(";select @@IDENTITY");
OleDbParameter[] parameters =
{
new OleDbParameter("@StockNo", OleDbType.VarChar, 255),
new OleDbParameter("@StockName", OleDbType.VarChar, 255),
new OleDbParameter("@HoldAmount", OleDbType.Integer, 4),
new OleDbParameter("@Price", OleDbType.Double),
new OleDbParameter("@UpdateTime", OleDbType.Date)
};
parameters[0].Value = model.StockNo;
parameters[1].Value = model.StockName;
parameters[2].Value = model.HoldAmount;
parameters[3].Value = model.Price;
parameters[4].Value = model.UpdateTime;
object obj = DbHelperOleDb.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
