/// <summary> /// /// </summary> /// <param name="strSql"></param> /// <returns></returns> public static bool Exists(string strSql) { object obj = DbHelperMySQL.GetSingle(strSql); int cmdresult; if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { cmdresult = 0; } else { cmdresult = int.Parse(obj.ToString()); } if (cmdresult == 0) { return(false); } else { return(true); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.stock_k_lineInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into c_stock_k_line("); strSql.Append("stock_code,stock_name,update_time,open,preClose,highest,lowest,deal_vol,deal_price,fprice"); strSql.Append(") values ("); strSql.Append("@stock_code,@stock_name,@update_time,@open,@preClose,@highest,@lowest,@deal_vol,@deal_price,@fprice"); 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("@open", MySqlDbType.Decimal, 13), new MySqlParameter("@preClose", MySqlDbType.Decimal, 13), new MySqlParameter("@highest", MySqlDbType.Decimal, 13), new MySqlParameter("@lowest", MySqlDbType.Decimal, 13), new MySqlParameter("@deal_vol", MySqlDbType.Int32, 11), new MySqlParameter("@deal_price", MySqlDbType.Decimal, 13), new MySqlParameter("@fprice", MySqlDbType.Decimal, 13) }; parameters[0].Value = model.stock_code; parameters[1].Value = model.stock_name; parameters[2].Value = model.update_time; parameters[3].Value = model.open; parameters[4].Value = model.preClose; parameters[5].Value = model.highest; parameters[6].Value = model.lowest; parameters[7].Value = model.deal_vol; parameters[8].Value = model.deal_price; parameters[9].Value = model.fprice; int rows = Convert.ToInt32(DbHelperMySQL.GetSingle(strSql.ToString(), parameters)); return(rows); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.s_stock_codeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sys_stock_code("); strSql.Append("stock_code,stock_name,stock_name_capital,rd_decl,rd_deal,rd_num,rd_money,rd_txt,remark,input_time"); strSql.Append(") values ("); strSql.Append("@stock_code,@stock_name,@stock_name_capital,@rd_decl,@rd_deal,@rd_num,@rd_money,@rd_txt,@remark,@input_time"); strSql.Append("); Select LAST_INSERT_ID() "); MySqlParameter[] parameters = { new MySqlParameter("@stock_code", MySqlDbType.VarChar, 8), new MySqlParameter("@stock_name", MySqlDbType.VarChar, 8), new MySqlParameter("@stock_name_capital", MySqlDbType.VarChar, 8), new MySqlParameter("@rd_decl", MySqlDbType.DateTime), new MySqlParameter("@rd_deal", MySqlDbType.DateTime), new MySqlParameter("@rd_num", MySqlDbType.Decimal, 12), new MySqlParameter("@rd_money", MySqlDbType.Decimal, 12), new MySqlParameter("@rd_txt", MySqlDbType.VarChar, 64), new MySqlParameter("@remark", MySqlDbType.VarChar, 128), new MySqlParameter("@input_time", MySqlDbType.DateTime) }; parameters[0].Value = model.stock_code; parameters[1].Value = model.stock_name; parameters[2].Value = model.stock_name_capital; parameters[3].Value = model.rd_decl; parameters[4].Value = model.rd_deal; parameters[5].Value = model.rd_num; parameters[6].Value = model.rd_money; parameters[7].Value = model.rd_txt; parameters[8].Value = model.remark; parameters[9].Value = model.input_time; int rows = Convert.ToInt32(DbHelperMySQL.GetSingle(strSql.ToString(), parameters)); return(rows); }
public int GetRecordCount(string strWhere) { string sql = "select count(1) from c_stock_ex {0}"; return(Convert.ToInt32(DbHelperMySQL.GetSingle(string.Format(sql, strWhere.Length > 0 ? "where " + strWhere : "")))); }
public int GetSysEventLogCount(string strWhere) { string sql = "select count(1) from sys_event_log {0}"; return(Convert.ToInt32(DbHelperMySQL.GetSingle(string.Format(sql, strWhere.Length > 0 ? "where " + strWhere : "")))); }