private static GeneralRecordData LoadSingleTableItemInfo(List<string> primaryKeys) { GeneralRecordData ret = null; try { using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = DBConn.MySqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoadSingleTableItemInfo"; if(primaryKeys.Count != 1) throw new Exception("primary key number don't match !!!"); MySqlParameter inputParam; inputParam = new MySqlParameter("@_ItemGuid", MySqlDbType.UInt64); inputParam.Direction = ParameterDirection.Input; inputParam.Value = (ulong)Convert.ChangeType(primaryKeys[0],typeof(ulong)); cmd.Parameters.Add(inputParam); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { ret = new GeneralRecordData(); object val; TableItemInfo msg = new TableItemInfo(); val = reader["ItemGuid"]; msg.ItemGuid = (ulong)val; ret.PrimaryKeys.Add(val.ToString()); val = reader["UserGuid"]; msg.UserGuid = (ulong)val; ret.ForeignKeys.Add(val.ToString()); val = reader["ItemId"]; msg.ItemId = (int)val; val = reader["ItemNum"]; msg.ItemNum = (int)val; ret.DataVersion = (int)reader["DataVersion"]; ret.Data = DbDataSerializer.Encode(msg); } } } } catch (Exception ex) { DBConn.Close(); throw ex; } return ret; }
private static List<GeneralRecordData> LoadAllTableItemInfo(int start, int count) { List<GeneralRecordData> ret = new List<GeneralRecordData>(); try { using (MySqlCommand cmd = new MySqlCommand()) { cmd.Connection = DBConn.MySqlConn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoadAllTableItemInfo"; MySqlParameter inputParam; inputParam = new MySqlParameter("@_Start", MySqlDbType.Int32); inputParam.Direction = ParameterDirection.Input; inputParam.Value = start; cmd.Parameters.Add(inputParam); inputParam = new MySqlParameter("@_Count", MySqlDbType.Int32); inputParam.Direction = ParameterDirection.Input; inputParam.Value = count; cmd.Parameters.Add(inputParam); using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { GeneralRecordData record = new GeneralRecordData(); object val; TableItemInfo msg = new TableItemInfo(); val = reader["ItemGuid"]; msg.ItemGuid = (ulong)val; record.PrimaryKeys.Add(val.ToString()); val = reader["UserGuid"]; msg.UserGuid = (ulong)val; record.ForeignKeys.Add(val.ToString()); val = reader["ItemId"]; msg.ItemId = (int)val; val = reader["ItemNum"]; msg.ItemNum = (int)val; record.DataVersion = (int)reader["DataVersion"]; record.Data = DbDataSerializer.Encode(msg); ret.Add(record); } } } } catch (Exception ex) { DBConn.Close(); throw ex; } return ret; }