/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.stock_t_lineInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into c_stock_t_line("); strSql.Append("stock_code,stock_name,update_time,fprice,fvol,famount,remark"); strSql.Append(") values ("); strSql.Append("@stock_code,@stock_name,@update_time,@fprice,@fvol,@famount,@remark"); strSql.Append("); Select LAST_INSERT_ID() "); MySqlParameter[] parameters = { new MySqlParameter("@stock_code", MySqlDbType.VarChar, 12), new MySqlParameter("@stock_name", MySqlDbType.VarChar, 32), new MySqlParameter("@update_time", MySqlDbType.DateTime), new MySqlParameter("@fprice", MySqlDbType.Decimal, 13), new MySqlParameter("@fvol", MySqlDbType.Int32, 13), new MySqlParameter("@famount", MySqlDbType.Decimal, 16), new MySqlParameter("@remark", MySqlDbType.Text) }; parameters[0].Value = model.stock_code; parameters[1].Value = model.stock_name; parameters[2].Value = model.update_time; parameters[3].Value = model.fprice; parameters[4].Value = model.fvol; parameters[5].Value = model.famount; parameters[6].Value = model.remark; int rows = Convert.ToInt32(DbHelperMySQL.GetSingle(strSql.ToString(), parameters)); return(rows); }
/// <summary> /// 将对象转换为实体 /// </summary> public Model.stock_t_lineInfo DataRowToModel(DataRow row) { Model.stock_t_lineInfo model = new Model.stock_t_lineInfo(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } model.stock_code = row["stock_code"].ToString(); model.stock_name = row["stock_name"].ToString(); if (row["update_time"] != null && row["update_time"].ToString() != "") { model.update_time = DateTime.Parse(row["update_time"].ToString()); } if (row["fprice"] != null && row["fprice"].ToString() != "") { model.fprice = decimal.Parse(row["fprice"].ToString()); } if (row["fvol"] != null && row["fvol"].ToString() != "") { model.fvol = int.Parse(row["fvol"].ToString()); } if (row["famount"] != null && row["famount"].ToString() != "") { model.famount = decimal.Parse(row["famount"].ToString()); } model.remark = row["remark"].ToString(); } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.stock_t_lineInfo GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, stock_code, stock_name, update_time, fprice, fvol, famount, remark "); strSql.Append(" from c_stock_t_line "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; Model.stock_t_lineInfo model = new Model.stock_t_lineInfo(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.stock_t_lineInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update c_stock_t_line set "); strSql.Append(" stock_code = @stock_code , "); strSql.Append(" stock_name = @stock_name , "); strSql.Append(" update_time = @update_time , "); strSql.Append(" fprice = @fprice , "); strSql.Append(" fvol = @fvol , "); strSql.Append(" famount = @famount , "); strSql.Append(" remark = @remark "); strSql.Append(" where id=@id "); MySqlParameter[] parameters = { new MySqlParameter("@stock_code", MySqlDbType.VarChar, 12), new MySqlParameter("@stock_name", MySqlDbType.VarChar, 32), new MySqlParameter("@update_time", MySqlDbType.DateTime), new MySqlParameter("@fprice", MySqlDbType.Decimal, 13), new MySqlParameter("@fvol", MySqlDbType.Int32, 13), new MySqlParameter("@famount", MySqlDbType.Decimal, 16), new MySqlParameter("@remark", MySqlDbType.Text), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.stock_code; parameters[1].Value = model.stock_name; parameters[2].Value = model.update_time; parameters[3].Value = model.fprice; parameters[4].Value = model.fvol; parameters[5].Value = model.famount; parameters[6].Value = model.remark; parameters[7].Value = model.id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.stock_t_lineInfo GetModel(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, stock_code, stock_name, update_time, fprice, fvol, famount, remark "); strSql.Append(" from c_stock_t_line "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" limit 0,1"); Model.stock_t_lineInfo model = new Model.stock_t_lineInfo(); DataSet ds = DbHelperMySQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }