public void Write(ByteArray by)
{
by.WriteLong(mail_idx);
by.WriteByte((byte)mail_type);
by.WriteLong(sender_idx);
by.WriteString(sender_name);
by.WriteLong(send_time);
by.WriteInt(expire_time);
by.WriteUInt(flags);
by.WriteString(subject);
}
public void Write(ByteArray by)
{
by.WriteString(subject);
by.WriteString(content);
ushort count = (ushort)items.Count;
by.WriteUShort(count);
for (int i = 0; i < count; ++i)
{
ItemID obj = items[i];
obj.Write(by);
}
}
public void Write(ByteArray by)
{
by.WriteLong(mail_idx);
by.WriteByte((byte)mail_type);
by.WriteUShort(spid);
by.WriteLong(receiver_idx);
by.WriteLong(sender_idx);
by.WriteString(sender_name);
by.WriteLong(send_time);
by.WriteInt(expire_time);
by.WriteInt(delivery_time);
by.WriteUInt(flags);
by.WriteString(subject);
bin_mail_content.Write(by);
}
public void Write(ByteArray by)
{
by.WriteLong(char_idx);
by.WriteLong(account_index);
by.WriteUShort(spid);
by.WriteString(char_name);
by.WriteByte(char_type);
by.WriteUShort(ws_id);
by.WriteUShort(ss_id);
by.WriteUShort(fs_id);
by.WriteInt(pos_x);
by.WriteInt(pos_y);
by.WriteUInt(scene_type_idx);
by.WriteLong(scene_obj_idx);
by.WriteUInt(flags);
by.WriteUInt(model_idx);
by.WriteByte(job);
by.WriteUShort(level);
by.WriteUInt(exp);
by.WriteUInt(energy);
by.WriteUInt(gold);
by.WriteUInt(coin);
by.WriteUInt(hp);
by.WriteUInt(hp_max);
by.WriteUInt(hurt);
by.WriteUInt(range);
by.WriteUInt(run_speed);
by.WriteUInt(vip_grade);
by.WriteUInt(vip_flags);
by.WriteLong(time_last_login);
by.WriteLong(time_last_logout);
}
public void Write(ByteArray by)
{
by.WriteLong(char_idx);
by.WriteString(char_name);
by.WriteByte(char_type);
by.WriteUShort(level);
}
public void Write(ByteArray by)
{
by.WriteLong(char_idx);
by.WriteString(char_name);
by.WriteByte(char_type);
by.WriteUShort(spid);
by.WriteUShort(ws_id);
by.WriteUShort(ss_id);
by.WriteUShort(fs_id);
}
public void Write(ByteArray by)
{
by.WriteByte((byte)type);
switch (type)
{
case eRelationAddType.Idx: by.WriteLong(char_idx); break;
case eRelationAddType.Name: by.WriteString(char_name); break;
}
}
public void Write(ByteArray by)
{
by.WriteByte((byte)type);
if (type == eIdxNameType.CHARID)
{
by.WriteLong(char_idx);
}
else
{
by.WriteString(char_name);
}
}
public void Write(ByteArray by)
{
by.WriteUShort((ushort)type);
switch (type)
{
case eUnitModType.UMT_char_name:
by.WriteString(value_str);
break;
default:
by.WriteLong(value_i);
break;
}
}
public void Write(ByteArray by)
{
by.WriteLong(char_idx);
by.WriteUShort(spid);
by.WriteString(char_name);
by.WriteByte(char_type);
by.WriteUShort(ws_id);
by.WriteUInt(flags);
by.WriteUInt(model_idx);
by.WriteByte(job);
by.WriteUShort(level);
by.WriteUInt(exp);
by.WriteUInt(gold);
by.WriteUInt(coin);
by.WriteUInt(vip_grade);
}
public void Write(ByteArray by)
{
int start_pos = by.Tail;
by.WriteLong(char_idx);
by.WriteUShort(spid);
by.WriteString(char_name);
by.WriteByte(char_type);
by.WriteUShort(ws_id);
by.WriteByte((byte)flags);
by.WriteUInt(model_idx);
by.WriteByte(job);
by.WriteUShort(level);
by.WriteUInt(exp);
by.WriteUInt(gold);
by.WriteUInt(coin);
by.WriteUInt(vip_grade);
by.WriteEmpty(200 - (by.Tail - start_pos));
}
public void Write(ByteArray by)
{
by.WriteLong(char_idx);
by.WriteString(char_name);
by.WriteByte(char_type);
by.WriteUInt(flags);
by.WriteUInt(model_idx);
by.WriteByte(job);
by.WriteUShort(level);
by.WriteUInt(exp);
by.WriteUInt(energy);
by.WriteUInt(gold);
by.WriteUInt(coin);
by.WriteUInt(hp);
by.WriteUInt(hp_max);
by.WriteUInt(hurt);
by.WriteUInt(range);
by.WriteUInt(run_speed);
by.WriteUInt(vip_grade);
by.WriteUInt(vip_flags);
}
public void Write(ByteArray by)
{
receiver.Write(by);
by.WriteString(subject);
by.WriteString(content);
}
public void Write(ByteArray by)
{
by.WriteString(name);
}
public void Write(ByteArray by)
{
by.WriteString(char_name);
item_id.Write(by);
}
public void Write(ByteArray by)
{
by.WriteLong(char_idx);
by.WriteString(char_name);
}
private void ProcessSave(QueryInfo query_info)
{
//先收集数据
List <List <string> > list_result = new List <List <string> >();
for (int row = 0; row < m_find_result.Rows.Count; ++row)
{
List <string> list = new List <string>();
for (int col = 0; col < m_find_result.Columns.Count; col++)
{
string value = m_find_result.Rows[row].Cells[col].Value as string;
list.Add(value);
}
list_result.Add(list);
}
//序列化
ByteArray by = new ByteArray(1024 * 8, int.MaxValue);
for (int row = 0; row < list_result.Count; ++row)
{
int start_pos = by.Tail;
List <string> list_row_result = list_result[row];
for (int col = 0; col < m_list_bin_header.Count; ++col)
{
BinHeader header_info = m_list_bin_header[col];
string value = list_row_result[col];
switch (header_info.type)
{
case "int":
if (value.Length == 0)
{
value = "0";
}
long l = long.Parse(value);
byte[] b = BitConverter.GetBytes(l);
by.Write(b, header_info.length);
break;
case "uint":
if (value.Length == 0)
{
value = "0";
}
ulong ul = ulong.Parse(value);
b = BitConverter.GetBytes(ul);
by.Write(b, header_info.length);
break;
case "float":
if (value.Length == 0)
{
value = "0";
}
float f = float.Parse(value);
b = BitConverter.GetBytes(f);
by.Write(b, header_info.length);
break;
case "double":
if (value.Length == 0)
{
value = "0";
}
double d = double.Parse(value);
b = BitConverter.GetBytes(d);
by.Write(b, header_info.length);
break;
case "string":
by.WriteString(value);
break;
default: continue;
}
}
if (query_info.fixed_length > 0)
{
by.WriteEmpty(query_info.fixed_length - (by.Tail - start_pos));
}
}
//保存到db
string key_sql = query_info.sql_key_value;
if (query_info.sql_key_type == 1)
{
key_sql = "'" + key_sql + "'";
}
string sql = "replace into `" + query_info.table_name + "`" +
"(`" + query_info.sql_key_name + "`,`" + query_info.field_name + "`) " +
"values (" +
key_sql + "," +
"@bin_data)";
List <MySqlParameter> param = new List <MySqlParameter>();
MySqlParameter p = Database.MakeMysqlParam("@bin_data", query_info.bin_type, by.GetBuffer(), by.Available);
param.Add(p);
DatabaseManager.Instance.GetDB(query_info.db_type).Execute(sql, param);
}
public void Write(ByteArray by)
{
by.WriteString(data);
}
public void Write(ByteArray by)
{
content = "";
by.WriteString(content);
}
public void Write(ByteArray by)
{
by.WriteString(char_name);
by.WriteString(message);
by.WriteByte((byte)flag);
}
