public MySqlCommand GetAddCommand(OrderInfo obj)
{
MySqlCommand cmd = new MySqlCommand();
string sql="insert into testdb.order_info(order_number,name) values(?order_number, ?name)";
cmd.CommandText = sql;
cmd.Parameters.Add(new MySqlParameter("?order_number", SqlDataUtil.ToDBNullValue(obj.Order_Number)));
cmd.Parameters.Add(new MySqlParameter("?name", SqlDataUtil.ToDBNullValue(obj.Name)));
return cmd;
}
public MySqlCommand GetUpdateCommand(OrderInfo obj)
{
MySqlCommand cmd = new MySqlCommand();
string sql="update testdb.order_info set order_number=?order_number,name=?name where id=?id ";
cmd.CommandText = sql;
cmd.Parameters.Add(new MySqlParameter("?id", SqlDataUtil.ToDBNullValue(obj.Id)));
cmd.Parameters.Add(new MySqlParameter("?order_number", SqlDataUtil.ToDBNullValue(obj.Order_Number)));
cmd.Parameters.Add(new MySqlParameter("?name", SqlDataUtil.ToDBNullValue(obj.Name)));
return cmd;
}
public static int Add(OrderInfo obj)
{
return helper.Add(obj);
}
public OrderInfo FindByKey(int id)
{
MySqlCommand cmd = GetFindCommand(id);
DataSet dataSet = SqlUtil.ExecuteQuery(cmd);
if (dataSet.Tables[0].Rows.Count < 1)
{
return null;
}
DataRow dr = dataSet.Tables[0].Rows[0];
OrderInfo obj = new OrderInfo();
DataUtil.DataRowToObject(dr,obj);
return obj;
}
public int Update(OrderInfo obj)
{
MySqlCommand cmd = GetUpdateCommand(obj);
return (int)SqlUtil.ExecuteNonQuery(cmd);
}