/// <summary>
/// 得到一个对象实体
/// </summary>
public static M_ExpectStock DataRowToModel(DataRow row)
{
M_ExpectStock model = new M_ExpectStock();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
model.StockNo = row["StockNo"].ToString();
model.StockName = row["StockName"].ToString();
if (row["ExpectPrice"].ToString() != "")
{
model.ExpectPrice = Double.Parse(row["ExpectPrice"].ToString());
}
if (row["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString());
}
if (row["Price"].ToString() != "")
{
model.Price = Double.Parse(row["Price"].ToString());
}
if (row["OrderIndex"].ToString() != "")
{
model.OrderIndex = int.Parse(row["OrderIndex"].ToString());
}
}
return(model);
}
/// <summary>
/// 置顶操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MenuItemToTop_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(commonDataGridView1.dgv_HoldStock.CurrentRow.Cells["ID"].Value.ToString());
M_ExpectStock model = ExpectStock.GetModel(id);
model.OrderIndex = 1;
DataTable dt = ExpectStock.GetList("1=1 order by OrderIndex").Tables[0];
int i = 1;
foreach (DataRow dr in dt.Rows)
{
i++;
M_ExpectStock modelUpdate = ExpectStock.DataRowToModel(dr);
if (!modelUpdate.StockName.Equals(model.StockName, StringComparison.CurrentCultureIgnoreCase))
{
modelUpdate.OrderIndex = i;
ExpectStock.Update(modelUpdate);
}
}
ExpectStock.Update(model);
dt_expectStock = GetStockHold();
commonDataGridView1.dgv_HoldStock.DataSource = dt_expectStock;
//ExpectStock.Delete(id);
//dt_expectStock = GetStockHold();
}
private void btnSaveExpectPrice_Click(object sender, EventArgs e)
{
foreach (KeyValuePair <int, double> keyvalue in dicExpectPrice)
{
M_ExpectStock saveExpect = ExpectStock.GetModel(keyvalue.Key);
saveExpect.ExpectPrice = keyvalue.Value;
ExpectStock.Update(saveExpect);
}
//MessageBox.Show("保存成功");
dicExpectPrice.Clear();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static M_ExpectStock GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, StockNo, StockName, Price, ExpectPrice, UpdateTime,OrderIndex ");
strSql.Append(" from ExpectStock ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
M_ExpectStock model = new M_ExpectStock();
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]["ExpectPrice"].ToString() != "")
{
model.ExpectPrice = Double.Parse(ds.Tables[0].Rows[0]["ExpectPrice"].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());
}
if (ds.Tables[0].Rows[0]["OrderIndex"].ToString() != "")
{
model.OrderIndex = int.Parse(ds.Tables[0].Rows[0]["OrderIndex"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 把从网络上获取的股票价格信息更新到后台数据库
/// </summary>
/// <param name="listUrlStock"></param>
private void RefreshExpectData(List <M_UrlStock> listUrlStock)
{
foreach (M_UrlStock stock in listUrlStock)
{
M_ExpectStock mExpectStock = null;
string stockNo = stock.StockNo;
string strWhere = string.Format("{0}='{1}'", "StockNo", stockNo);
DataTable dt = ExpectStock.GetList(1, strWhere, "StockNo").Tables[0];
if (dt.Rows.Count != 0)
{
int id = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
mExpectStock = ExpectStock.GetModel(id);
mExpectStock.Price = stock.Price;
mExpectStock.UpdateTime = stock.UpdateTime;
ExpectStock.Update(mExpectStock);
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(M_ExpectStock model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [ExpectStock] set ");
strSql.Append("[StockNo]=@StockNo,");
strSql.Append("[StockName]=@StockName,");
strSql.Append("[Price]=@Price,");
strSql.Append("[ExpectPrice]=@ExpectPrice,");
strSql.Append("[UpdateTime]=@UpdateTime,");
strSql.Append("[OrderIndex]=@OrderIndex");
strSql.Append(" where [ID]=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@StockNo", OleDbType.VarChar, 255),
new OleDbParameter("@StockName", OleDbType.VarChar, 255),
new OleDbParameter("@Price", OleDbType.Double),
new OleDbParameter("@ExpectPrice", OleDbType.Double),
new OleDbParameter("@UpdateTime", OleDbType.Date),
new OleDbParameter("@OrderIndex", OleDbType.Integer),
new OleDbParameter("@ID", OleDbType.Integer, 4),
};
parameters[0].Value = model.StockNo;
parameters[1].Value = model.StockName;
parameters[2].Value = model.Price;
parameters[3].Value = model.ExpectPrice;
parameters[4].Value = model.UpdateTime;
parameters[5].Value = model.OrderIndex;
parameters[6].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
string stockNo = txtStockNo.Text.Trim();
M_UrlStock urlStock = CommonFunction.GetNowStockInfo(stockNo);
if (ExpectStock.Exists(stockNo))
{
MessageBox.Show("此股票已存在！");
return;
}
if (urlStock == null || string.IsNullOrEmpty(urlStock.StockNo))
{
return;
}
M_ExpectStock expectStock = new M_ExpectStock();
expectStock.StockNo = urlStock.StockNo;
expectStock.StockName = urlStock.StockName;
expectStock.Price = urlStock.Price;
expectStock.ExpectPrice = double.Parse(numExpectPrice.Value.ToString());
expectStock.UpdateTime = urlStock.UpdateTime;
ExpectStock.Add(expectStock);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(M_ExpectStock model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ExpectStock(");
strSql.Append("StockNo,StockName,Price,ExpectPrice,UpdateTime,OrderIndex");
strSql.Append(") values (");
strSql.Append("@StockNo,@StockName,@Price,@ExpectPrice,@UpdateTime,@OrderIndex");
strSql.Append(") ");
//strSql.Append(";select @@IDENTITY");
OleDbParameter[] parameters =
{
new OleDbParameter("@StockNo", OleDbType.VarChar, 255),
new OleDbParameter("@StockName", OleDbType.VarChar, 255),
new OleDbParameter("@Price", OleDbType.Double),
new OleDbParameter("@ExpectPrice", OleDbType.Double),
new OleDbParameter("@UpdateTime", OleDbType.Date),
new OleDbParameter("@OrderIndex", OleDbType.Integer)
};
parameters[0].Value = model.StockNo;
parameters[1].Value = model.StockName;
parameters[2].Value = model.Price;
parameters[3].Value = model.ExpectPrice;
parameters[4].Value = model.UpdateTime;
parameters[5].Value = model.OrderIndex;
object obj = DbHelperOleDb.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
