public void ImportPackData(String path, bool doClear)
{
ExportPackData(String.Format("backup/{0} {1}.csv", tablename, DateTime.Now.Ticks));
if (doClear)
{
MysqlService.ClearData(tablename);
data.Clear();
}
StreamReader sr = new StreamReader(path, Encoding.Default);
string line;
int result;
while ((line = sr.ReadLine()) != null)
{
string[] infos = line.Split(',');
if (!int.TryParse(infos[0], out result))
{
continue;
}
AddPackData(new List <String>(infos));
}
sr.Close();
}
public void EditPackData(int id, String fieldname, String value)
{
int index = GetPackIndexByName(fieldname);
data[id][index] = value;
MysqlService.UpdateData(tablename, header[0], id, fieldname, value);
}
public void EditPackData(BiData dat, String fieldname, String value)
{
int index = GetPackIndexByName(fieldname);
data[dat][index] = value;
MysqlService.UpdateData(tablename, header[0], dat.a, header[1], dat.b, fieldname, value);
}
public static OldTriDataPack GetPack(String packname)
{
if (!datas.ContainsKey(packname))
{
OldTriDataPack data = MysqlService.GetAllTriData(packname);
datas.Add(packname, data);
}
return(datas[packname]);
}
public void RemovePackData(BiData dat)
{
data.Remove(dat);
int keyid = dat.a;
keys[keyid]--;
if (keys[keyid] == 0)
{
keys.Remove(keyid);
}
MysqlService.RemoveData(tablename, header[0], dat.a, header[1], dat.b);
}
public void AddPackData(List <String> item)
{
BiData dat = new BiData(int.Parse(item[0]), int.Parse(item[1]));
data.Add(dat, item);
int keyid = int.Parse(item[0]);
if (keys.ContainsKey(keyid))
{
keys[keyid]++;
}
else
{
keys.Add(keyid, 1);
}
MysqlService.InsertData(tablename, item);
}
public void RemovePackData(int id)
{
data.Remove(id);
MysqlService.RemoveData(tablename, header[0], id);
}
public void AddPackData(int id, List <String> item)
{
data.Add(id, item);
MysqlService.InsertData(tablename, item);
}
