private void fillDeadReasons()
{
_cmd.CommandText = "ALTER TABLE `deadreasons` DISABLE KEYS;";
_cmd.ExecuteNonQuery();
for (int i = 0; i < Mia.Graphform.reasons.size.value(); i++)
{
//Application.DoEvents();
MFListItem li = Mia.Graphform.reasons.items[i];
_cmd.CommandText = String.Format("INSERT INTO deadreasons(d_name,d_rate) VALUES('{0:s}', {1:s});", li.caption.value(), li.subs[0].value());
_cmd.ExecuteNonQuery();
}
_cmd.CommandText = "ALTER TABLE `deadreasons` ENABLE KEYS;";
_cmd.ExecuteNonQuery();
}
public void FillDeadFromLost()
{
//deleteTableContent(Tables.DeadReasons);
Debug("filling Dead Rabbits From Lost List");
fillDeadReasons();
int cnt = (int)Mia.Graphform.lost.size.value();
_cmd.CommandText = "ALTER TABLE `rabbits` DISABLE KEYS;";
_cmd.ExecuteNonQuery();
for (int i = 0; i < Mia.Graphform.lost.size.value(); i++)
{
Mia.Setpb(i, cnt);
MFListItem li = Mia.Graphform.lost.items[i];
String sex = "void";
if (li.subs[2].value() == "м")
{
sex = "male";
}
if (li.subs[2].value() == "ж")
{
sex = "female";
}
int weight = 0;
if (!int.TryParse(li.subs[5].value(), out weight))
{
weight = 0;
}
String ddt = li.caption.value();
String[] names = li.subs[0].value().Split(' ');
String address = li.subs[1].value();
String stat = li.subs[3].value();
int age = int.Parse(li.subs[4].value());
int group = 1;
String notes = "";
if (li.subitems.value() >= 9)
{
notes = li.subs[8].value();
}
int reason = GetReason(li.subs[6].value());
if (names[names.Length - 1].Length > 0)
{
if (names[names.Length - 1].Trim()[0] == '[')
{
String grp = names[names.Length - 1].Trim();
grp = grp.Replace("[", "").Replace("]", "");
group = int.Parse(grp);
names[names.Length - 1] = "";
}
}
String nm = names[0];
String xx = "";
uint nid = Findname(nm, ref xx);
if (nid != 0)
{
nm = "";
if (names.Length > 1)
{
nm = names[1];
}
}
uint suid = 0, seid = 0;
String[] nms = nm.Split('-');
if (nms.Length > 0)
{
if (nms[0].Trim() != "")
{
suid = FindSurname(nms[0].Trim(), sex, group, 2);
}
}
if (nms.Length > 1 && nms[1].Trim() != "")
{
seid = FindSurname(nms[1].Trim(), sex, group, 1);
}
int farm = 0;
int tier = 0;
int tierID = 0;
int area = 0;
string sa = "";
int j = 0;
while (j < address.Length && address[j] >= '0' && address[j] <= '9')
{
sa += address[j];
j++;
}
if (sa != "")
{
farm = int.Parse(sa);
if (j < address.Length)
{
switch (address[j])
{
case '^': tierID = 1; j++; break;
case '-': tierID = 2; j++; break;
case 'б': area = 1; break;
case 'в': area = 2; break;
case 'г': area = 3; break;
}
}
}
_cmd.CommandText = String.Format(@"INSERT INTO rabbits(r_sex, r_name, r_surname, r_secname, r_notes, r_group, r_born, r_farm, r_tier_id, r_tier, r_area, r_breed)
VALUES('{0:s}', {1:d}, {2:d}, {3:d}, '{4:s}', {5:d}, {6:s}-INTERVAL {7:d} DAY, {8:d}, {9:d}, {10:d}, {11:d}, 1);",
sex, nid, suid, seid, notes, group, Convdt(ddt), age, farm, tierID, tier, area);
_cmd.ExecuteNonQuery();
long lid = _cmd.LastInsertedId;
_cmd.CommandText = String.Format("CALL killRabbitDate({0:d},1,'',{1:s});", lid, Convdt(ddt));
_cmd.ExecuteNonQuery();
}
_cmd.CommandText = "ALTER TABLE `rabbits` ENABLE KEYS;";
_cmd.ExecuteNonQuery();
}
