/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.s_stock_codeInfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, stock_code, stock_name, stock_name_capital, rd_decl, rd_deal, rd_num, rd_money, rd_txt, remark, input_time ");
strSql.Append(" from sys_stock_code ");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
Model.s_stock_codeInfo model = new Model.s_stock_codeInfo();
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.s_stock_codeInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sys_stock_code set ");
strSql.Append(" stock_code = @stock_code , ");
strSql.Append(" stock_name = @stock_name , ");
strSql.Append(" stock_name_capital = @stock_name_capital , ");
strSql.Append(" rd_decl = @rd_decl , ");
strSql.Append(" rd_deal = @rd_deal , ");
strSql.Append(" rd_num = @rd_num , ");
strSql.Append(" rd_money = @rd_money , ");
strSql.Append(" rd_txt = @rd_txt , ");
strSql.Append(" remark = @remark , ");
strSql.Append(" input_time = @input_time ");
strSql.Append(" where id=@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),
new MySqlParameter("@id", MySqlDbType.Int32, 11)
};
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;
parameters[10].Value = model.id;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <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);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.s_stock_codeInfo GetModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, stock_code, stock_name, stock_name_capital, rd_decl, rd_deal, rd_num, rd_money, rd_txt, remark, input_time ");
strSql.Append(" from sys_stock_code ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" limit 0,1");
Model.s_stock_codeInfo model = new Model.s_stock_codeInfo();
DataSet ds = DbHelperMySQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 将对象转换为实体
/// </summary>
public Model.s_stock_codeInfo DataRowToModel(DataRow row)
{
Model.s_stock_codeInfo model = new Model.s_stock_codeInfo();
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();
model.stock_name_capital = row["stock_name_capital"].ToString();
if (row["rd_decl"] != null && row["rd_decl"].ToString() != "")
{
model.rd_decl = DateTime.Parse(row["rd_decl"].ToString());
}
if (row["rd_deal"] != null && row["rd_deal"].ToString() != "")
{
model.rd_deal = DateTime.Parse(row["rd_deal"].ToString());
}
if (row["rd_num"] != null && row["rd_num"].ToString() != "")
{
model.rd_num = decimal.Parse(row["rd_num"].ToString());
}
if (row["rd_money"] != null && row["rd_money"].ToString() != "")
{
model.rd_money = decimal.Parse(row["rd_money"].ToString());
}
model.rd_txt = row["rd_txt"].ToString();
model.remark = row["remark"].ToString();
if (row["input_time"] != null && row["input_time"].ToString() != "")
{
model.input_time = DateTime.Parse(row["input_time"].ToString());
}
}
return(model);
}
