/// <summary> /// 更新一条数据 /// </summary> public static bool Update(M_HoldRule model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update HoldRule set "); strSql.Append("LowPrice=@LowPrice,"); strSql.Append("HightPrice=@HightPrice,"); strSql.Append("NowPrice=@NowPrice,"); strSql.Append("UpdateTime=@UpdateTime"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@LowPrice", OleDbType.Integer, 4), new OleDbParameter("@HightPrice", OleDbType.Integer, 4), new OleDbParameter("@NowPrice", OleDbType.Integer, 4), new OleDbParameter("@UpdateTime", OleDbType.Date), new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = model.LowPrice; parameters[1].Value = model.HightPrice; parameters[2].Value = model.NowPrice; parameters[3].Value = model.UpdateTime; parameters[4].Value = model.ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public static bool Add(M_HoldRule model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into HoldRule("); strSql.Append("LowPrice,HightPrice,NowPrice,UpdateTime)"); strSql.Append(" values ("); strSql.Append("@LowPrice,@HightPrice,@NowPrice,@UpdateTime)"); OleDbParameter[] parameters = { new OleDbParameter("@LowPrice", OleDbType.Integer, 4), new OleDbParameter("@HightPrice", OleDbType.Integer, 4), new OleDbParameter("@NowPrice", OleDbType.Integer, 4), new OleDbParameter("@UpdateTime", OleDbType.Date) }; parameters[0].Value = model.LowPrice; parameters[1].Value = model.HightPrice; parameters[2].Value = model.NowPrice; parameters[3].Value = model.UpdateTime; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public static M_HoldRule DataRowToModel(DataRow row) { M_HoldRule model = new M_HoldRule(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["LowPrice"] != null && row["LowPrice"].ToString() != "") { model.LowPrice = int.Parse(row["LowPrice"].ToString()); } if (row["HightPrice"] != null && row["HightPrice"].ToString() != "") { model.HightPrice = int.Parse(row["HightPrice"].ToString()); } if (row["NowPrice"] != null && row["NowPrice"].ToString() != "") { model.NowPrice = int.Parse(row["NowPrice"].ToString()); } if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString()); } } return(model); }
private void FrmSetHoldingRate_Load(object sender, EventArgs e) { M_HoldRule mhr = new M_HoldRule(); DataTable dt = HoldRule.GetList("1=1 order by UpdateTime desc").Tables[0]; if (dt.Rows.Count > 0) { mhr = HoldRule.DataRowToModel(dt.Rows[0]); } txtSZlowest.Text = mhr.LowPrice.ToString(); txtSZhighest.Text = mhr.HightPrice.ToString(); txtSZnow.Text = mhr.NowPrice.ToString(); dtpSZupdateDate.Value = mhr.UpdateTime; }
/// <summary> /// 获取持仓参考的值 /// </summary> private void GetHoldRef() { M_HoldRule mhr = new M_HoldRule(); DataTable dt = HoldRule.GetList("1=1 order by UpdateTime desc").Tables[0]; if (dt.Rows.Count > 0) { mhr = HoldRule.DataRowToModel(dt.Rows[0]); //公式:参考持仓比率=(1-(现值-最低值)/(最高值-最低值))*%100; double holdRef = (1 - (mhr.NowPrice - mhr.LowPrice) / (mhr.HightPrice - mhr.LowPrice)) * 100; d_holdrate = holdRef / 100; string strHoldRef = Math.Round(holdRef, 2) + "%"; txtHoldRef.Text = strHoldRef; } }
private void btnCommit_Click(object sender, EventArgs e) { CheckData(); if (!GetData()) { return; } M_HoldRule mhr = new M_HoldRule(); mhr.HightPrice = highestPrice; mhr.LowPrice = lowestPrice; mhr.NowPrice = nowPrice; mhr.UpdateTime = date; HoldRule.Add(mhr); if (SetHoldRef != null) { SetHoldRef(); } this.Close(); }
/// <summary> /// 得到一个对象实体 /// </summary> public static M_HoldRule GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,LowPrice,HightPrice,NowPrice,UpdateTime from HoldRule "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; M_HoldRule model = new M_HoldRule(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }