public EquipStatus[] GetStatus()
{
var status = new EquipStatus[_Items.Count];
int i = 0;
foreach (var item in _Items)
{
status[i++] = new EquipStatus()
{
Item = item.Value.Name, Part = item.Key
};
}
return(status);
}
/// <summary>
/// 根据物理主码查询
/// </summary>
/// <param name="id">id</param>
/// <returns>结果</returns>
public EquipStatus SELECT_BY_ID(long id)
{
try
{
EquipStatus rd = new EquipStatus();
S_equipstatus temp = (from row in db.S_equipstatus where row.id == id select row).First();
rd.Id = temp.id;
rd.Name = temp.name;
rd.Isused = temp.isused;
return(rd);
}
catch
{
return(null);
}
}
/// <summary>
/// 插入函数
/// </summary>
/// <param name="info">Model</param>
/// <returns>影响数据物理ID</returns>
public long INSERT(EquipStatus info)
{
try
{
S_equipstatus temp = new S_equipstatus();
//temp.id = info.Id;
temp.name = info.Name;
temp.isused = info.Isused;
Table <S_equipstatus> table = db.GetTable <S_equipstatus>();
table.InsertOnSubmit(temp);
db.SubmitChanges();
return(temp.id);
}
catch
{
return(-2);
}
}
/// <summary>
/// 更新函数
/// </summary>
/// <param name="info">Model</param>
/// <returns>影响数据物理ID，已存在逻辑主码返回-1</returns>
public long UPDATE(EquipStatus info)
{
try
{
S_equipstatus temp = new S_equipstatus();
Table <S_equipstatus> table = db.GetTable <S_equipstatus>();
temp = (from row in db.S_equipstatus where row.id == info.Id select row).First();
//temp.id = info.Id;
temp.name = info.Name;
temp.isused = info.Isused;
db.SubmitChanges();
return(temp.id);
}
catch
{
return(-2);
}
}
public static Equip GetEquip(string equipName)
{
return(GetEquip(equipName, 0));
EquipStatus equipStatus = new EquipStatus();
try
{
FileStream stream = new FileStream(equipName, FileMode.Open, FileAccess.Read, FileShare.Read);
byte[] data = new byte[stream.Length];
stream.Read(data, 0, data.Length);
stream.Close();
equipStatus = JsonUtility.FromJson <EquipStatus>(Encoding.UTF8.GetString(data));
}catch (Exception e)
{
Debug.Log(e);
}
//Debug.Log(JsonUtility.ToJson(t));
//JsonUtility.FromJson<EquipStatus>("");
//FileStream stream = new FileStream(EquipmentFilePath.DataDirectory + EquipmentFilePath.Test, FileMode.Create);
//byte[] data = Encoding.UTF8.GetBytes(JsonUtility.ToJson(t));
//stream.Write(data, 0, data.Length);
//stream.Close();
//Debug.Log("TTTT");
//FileStream readStream = new FileStream(EquipmentFilePath.DataDirectory + EquipmentFilePath.Test, FileMode.Open);
//byte[] readData = new byte[readStream.Length];
//readStream.Read(readData, 0, readData.Length);
//readStream.Close();
//EquipStatus tt = JsonUtility.FromJson<EquipStatus>(Encoding.UTF8.GetString(readData));
//Debug.Log(tt.cls);
//Debug.Log(tt.type);
//Debug.Log(tt.cls == EquipClass.Archer);
Equip equip = new Equip();
equip.name = equipStatus.name;
equip.img = equipStatus.img;
return(equip);
}
/// <summary>
/// 根据使用状态查询
/// </summary>
/// <param name="isused">是否使用</param>
/// <returns>结果列表</returns>
public IList <EquipStatus> SELECT_BY_ISUSED(bool isused)
{
try
{
IList <EquipStatus> result = new List <EquipStatus>();
var temp = (from row in db.S_equipstatus where row.isused == isused select row).GetEnumerator();
while (temp.MoveNext())
{
EquipStatus element = new EquipStatus();
element.Id = temp.Current.id;
element.Name = temp.Current.name;
element.Isused = temp.Current.isused;
result.Add(element);
}
return(result);
}
catch
{
return(null);
}
}
