public RP(RPList list, int id, string name, string address, int count, Rabbit.SexType sex, int age, string breedName, int parent) : this(list, id, name, address, count, sex, age, breedName) { Younger = true; this.Parent = parent; NewParent = parent; }
public RabNetEngRabbit(RabNetEngine dl, Rabbit.SexType sx) { _id = 0; _eng = dl; _sex = sx; _youngers = new YoungRabbitList(); }
public static int GetAliveChildrenCount(MySqlConnection sql, int rid, Rabbit.SexType parentSex) { MySqlCommand cmd = new MySqlCommand(String.Format("SELECT COALESCE(SUM(r_group), 0) FROM rabbits WHERE {0:s} = {1:d}", parentSex == Rabbit.SexType.FEMALE ? "r_mother" : "r_father", rid ), sql); return(Convert.ToInt32(cmd.ExecuteScalar())); }
public RabName Search(string name, Rabbit.SexType sex) { foreach (RabName rn in this) { if (rn.Name == name && rn.Sex == sex) { return(rn); } } return(null); }
private void updateNewNames(Rabbit.SexType sex) { cbNewName.Items.Clear(); cbNewName.Items.Add(""); foreach (RabName b in _names) { if (b.Sex == sex && b.Use == 0) { cbNewName.Items.Add(b.Name); } } }
public static int AddName(MySqlConnection sql, Rabbit.SexType sex, String name, String surname) { MySqlCommand cmd = new MySqlCommand(String.Format(@"INSERT INTO names(n_sex, n_name, n_surname, n_block_date) VALUES('{0:s}','{1:s}','{2:s}',NULL);", (sex == Rabbit.SexType.FEMALE) ? "female" : "male", name, surname), sql); cmd.ExecuteNonQuery(); if (cmd.LastInsertedId > int.MaxValue) ///it can't be { throw new RabNetException("ID нового имени больше максимально допустимого значения"); } return((int)cmd.LastInsertedId); }
public static String SexToRU(Rabbit.SexType s) { if (s == Rabbit.SexType.FEMALE) { return("ж"); } if (s == Rabbit.SexType.MALE) { return("м"); } return("?"); }
public RP(RP fromrp, int count) : this(fromrp.List, /*fromrp.ID*/ -1, fromrp.Name, fromrp.CurAddress, count, fromrp.Sex, fromrp.Age, fromrp.BreedName, fromrp.Parent) { MadeFrom = fromrp; fromrp.NewCount -= count; NewSex = fromrp.NewSex; int idx = List.IndexOf(fromrp); List.Insert(idx + 1, this); fromrp.Clones.Add(this); Younger = false; }
public static String SexToString(Rabbit.SexType s) { String res = "void"; if (s == Rabbit.SexType.FEMALE) { res = "female"; } if (s == Rabbit.SexType.MALE) { res = "male"; } return(res); }
public RP(RPList list, int id, string name, string address, int count, Rabbit.SexType sex, int age, string breedName) { this.List = list; this.ID = id; SName = name; this.Address = address; this.Count = count; NewCount = count; this.Sex = sex; NewSex = sex; this.Age = age; this.CanHaveNest = canTierHaveNest(address); this.BreedName = breedName; }
public RabName(int id, String name, String surname, String sex, int use, DateTime dt) { this.ID = id; this.Name = name; this.Surname = surname; this.Sex = Rabbit.GetSexType(sex); //this.sex = sex; //if (sex == "male") // this.Sex = "м"; //else // this.Sex = "ж"; this.Use = use; this.ReleaseDate = dt; }
private void button1_Click(object sender, EventArgs e) { try { if (button1.Text == btext[0]) { Rabbit.SexType sx = Rabbit.SexType.MALE; if (tabControl1.SelectedIndex == 1) { sx = Rabbit.SexType.FEMALE; } Engine.get().db().AddName(sx, textBox1.Text.Trim(), textBox2.Text.Trim()); } else { Engine.get().db().changeName(this.originName, textBox1.Text.Trim(), textBox2.Text.Trim()); } load(); } catch (Exception) { MessageBox.Show("Ошибка: Такое имя уже существует"); } }
public Rabbit(int id, string rabname, string sex, DateTime born, string breedname, int group, String bon, string rawAddress, string notes) { _id = id; _nameFull = rabname; _sex = Rabbit.SexType.VOID; if (sex == "male") { _sex = Rabbit.SexType.MALE; } if (sex == "female") { _sex = Rabbit.SexType.FEMALE; } _birthDay = born; _breedName = breedname; _group = group; _bon = bon; _rawAddress = rawAddress; _notes = notes; }
public static int cloneRabbit(MySqlConnection sql, int rabFromID, int count, Rabbit.SexType sex, int mom) { MySqlCommand cmd = new MySqlCommand(String.Format(@"INSERT INTO rabbits (r_parent, r_father, r_mother, r_name, r_surname, r_secname, r_sex, r_bon, r_okrol, r_breed, r_rate, r_group, r_flags, r_zone, r_born, r_genesis, r_status, r_last_fuck_okrol, r_event, r_event_date, r_notes, r_farm, r_tier, r_tier_id, r_area) SELECT {1:d}, r_father, r_mother, NULL, r_surname, r_secname, r_sex, r_bon, r_okrol, r_breed, r_rate, {2:d}, r_flags, r_zone, r_born, r_genesis, r_status, r_last_fuck_okrol, r_event, r_event_date, r_notes, r_farm, r_tier, r_tier_id, r_area FROM rabbits WHERE r_id={0:d};", rabFromID, DBHelper.Nullable(mom), count), sql); cmd.ExecuteNonQuery(); int cloneID = (int)cmd.LastInsertedId; cmd.CommandText = String.Format("UPDATE rabbits SET r_group=r_group-{0:d} WHERE r_id={1:d};", count, rabFromID); cmd.ExecuteNonQuery(); //клонируем прививки cmd.CommandText = String.Format("INSERT INTO rab_vac(r_id,v_id,`date`,unabled) SELECT {0:d},v_id,`date`,unabled FROM rab_vac WHERE r_id={1:d};", cloneID, rabFromID); cmd.ExecuteNonQuery(); if (sex != Rabbit.SexType.VOID) { setRabbitSex(sql, rabFromID, sex); } return(cloneID); }
public void clear() { NewAddress = ""; PlaceTo = null; PlaceWith = null; foreach (RP r in List) { if (r.Parent == ID) { r.Address = Address; } } while (Clones.Count > 0) { RP f = Clones[0]; f.clear(); Clones.RemoveAt(0); List.Remove(f); } NewCount = Count; NewSex = Sex; NewParent = Parent; }
private void sex_SelectedIndexChanged(object sender, EventArgs e) { if (!_manual) { return; } if (MessageBox.Show(this, "Сменить пол?", "Смена пола", MessageBoxButtons.YesNo) == DialogResult.Yes) { Rabbit.SexType sx = Rabbit.SexType.VOID; if (sex.SelectedIndex == 1) { sx = Rabbit.SexType.MALE; } if (sex.SelectedIndex == 2) { sx = Rabbit.SexType.FEMALE; } _rab.SetSex(sx); updateData(); } else { if (_rab.Sex == Rabbit.SexType.VOID) //todo switch { setSex(0); } else if (_rab.Sex == Rabbit.SexType.MALE) { setSex(1); } else if (_rab.Sex == Rabbit.SexType.FEMALE) { setSex(2); } } }
public RP(RPList list, int id, string name, string address, int count, Rabbit.SexType sex, int age, string breedName, bool nest) : this(list, id, name, address, count, sex, age, breedName) { this.SetNest = nest; }
internal static void AdaptExportedAscendant(MySqlConnection sql, int oldId, int clientId, int newId, Rabbit.SexType sex) { Import.AscendantDelete(sql, oldId, clientId); string query = String.Format("UPDATE {4:s} SET r_{0:s}={1:d} WHERE r_{0:s}={2:d} AND r_birthplace={3:d}", sex == Rabbit.SexType.FEMALE?"mother":"father", newId, oldId, clientId, "{0:s}"); MySqlCommand cmd = new MySqlCommand(String.Format(query, "import_ascendants"), sql); cmd.ExecuteNonQuery(); cmd.CommandText = String.Format(query, "rabbits"); cmd.ExecuteNonQuery(); }
public Dictionary <string, int> GetDeadChildrenCount(int rid, Rabbit.SexType parentSex) { return(RabbitGetter.GetDeadChildrenCount(sql, rid, parentSex)); }
public int GetAliveChildrenCount(int rid, Rabbit.SexType parentSex) { return(RabbitGetter.GetAliveChildrenCount(sql, rid, parentSex)); }
public int CloneRabbit(int rid, int count, Rabbit.SexType sex, int mom) { return(RabbitGetter.cloneRabbit(sql, rid, count, sex, mom)); }
public void setRabbitSex(int rid, Rabbit.SexType sex) { RabbitGetter.setRabbitSex(sql, rid, sex); }
public int AddName(Rabbit.SexType sex, string name, string surname) { return(Names.AddName(sql, sex, name, surname)); }
//public ICatalog getVaccines() //{ // return new Vaccines(sql); //} public string makeName(int nm, int sur, int sec, int grp, Rabbit.SexType sex) { return(RabbitGetter.makeName(sql, nm, sur, sec, grp, sex)); }
//public static void replaceYounger(MySqlConnection sql, int rabbit, int farm, int tier_id, int sec) //{ // removeParent(sql, rabbit); // placeRabbit(sql, rabbit, farm, tier_id, sec); //} public static void setRabbitSex(MySqlConnection sql, int rabbit, Rabbit.SexType sex) { MySqlCommand cmd = new MySqlCommand(String.Format(@"UPDATE rabbits SET r_sex='{0:s}' WHERE r_id={1:d};", Rabbit.SexToString(sex), rabbit), sql); cmd.ExecuteNonQuery(); }
public static Dictionary <string, int> GetDeadChildrenCount(MySqlConnection sql, int rid, Rabbit.SexType parentSex) { Dictionary <string, int> result = new Dictionary <string, int>(); MySqlCommand cmd = new MySqlCommand(String.Format(@"SELECT dr.d_name, SUM(d.r_group) FROM dead d INNER JOIN deadreasons dr ON dr.d_id = d.d_reason WHERE {0:s} = {1:d} GROUP BY d_reason", parentSex == Rabbit.SexType.FEMALE ? "r_mother" : "r_father", rid ), sql); MySqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { result.Add(rd.GetString(0), rd.GetInt32(1)); } rd.Close(); return(result); }
public static String makeName(MySqlConnection con, int nm, int sur, int sec, int grp, Rabbit.SexType sex) { MySqlCommand cmd = new MySqlCommand(String.Format(@"SELECT (SELECT CONCAT(n_name,' ') FROM names WHERE n_id={0:d}) name, (SELECT n_surname FROM names WHERE n_id = {1:d}) surname, (SELECT n_surname FROM names WHERE n_id = {2:d}) secname; ", nm, sur, sec), con); MySqlDataReader rd = cmd.ExecuteReader(); String res = ""; if (rd.Read()) { res = rd.IsDBNull(0) ? "" : rd.GetString(0); String ssur = rd.IsDBNull(1) ? "" : rd.GetString(1); String ssec = rd.IsDBNull(2) ? "" : rd.GetString(2); if (grp > 1) { if (ssur != "") { ssur += 'ы'; } if (ssec != "") { ssec += 'ы'; } } else if (sex == Rabbit.SexType.FEMALE) { if (ssur != "") { ssur += 'а'; } if (ssec != "") { ssec += 'а'; } } res += ssur; if (ssec != "") { res += "-" + ssec; } } rd.Close(); return(res); }
/// <summary> /// Установить пол /// </summary> /// <param name="sex">Новый пол</param> public void SetSex(Rabbit.SexType sex) { _eng.logs().log(LogType.SET_SEX, _id, 0, "", "", Rabbit.SexToRU(sex)); _eng.db().setRabbitSex(_id, sex); }