/// <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 : ""))));
}
