예제 #1
0
        public void Add()
        {
            int id;

            SqlXmlRun.Execute("SysPec_p_AddAlimentacao", this, "alimentacao", out id);
            this.Id = id;
        }
예제 #2
0
        public void Add()
        {
            int id;

            SqlXmlRun.Execute("SysPec_p_AddVacina", this, "vacina", out id);
            this.Id = id;
        }
예제 #3
0
        public void Add()
        {
            int id;

            SqlXmlRun.Execute("SysPec_p_AddPasto", this, "pasto", out id);
            this.Id = id;
        }
예제 #4
0
        public static int ListCountAnimaisByFazenda(int IdFazenda)
        {
            int Quantidade = 0;

            SqlXmlRun.Execute("SysPec_p_ListCountAnimaisByFazenda", out Quantidade, new SqlXmlParams("@IdFazenda", IdFazenda));
            return(Quantidade);
        }
예제 #5
0
        public void Add()
        {
            int id;

            SqlXmlRun.Execute("SysPec_p_AddAnimal", this, "animal", out id);
            this.Id = id;
        }
예제 #6
0
        public void Add()
        {
            int id;

            SqlXmlRun.Execute("SysPec_p_AddFazenda", this, "fazenda", out id);
            this.Id = id;
        }
예제 #7
0
        public static int GetQtnAnimais(int Id)
        {
            int Quantidade = 0;

            SqlXmlRun.Execute("SysPec_p_GetQtnAnimalByLote", out Quantidade, new SqlXmlParams("@lote", Id));
            return(Quantidade);
        }
예제 #8
0
        public void Add()
        {
            int id;

            SqlXmlRun.Execute("SysPec_p_AddCriador", this, "user", out id);
            this.Id = id;
        }
예제 #9
0
        public void Add()
        {
            int id;

            SqlXmlRun.Execute("SysPec_p_AddAplicacao", this, "result", out id);
            this.Id = id;
        }
예제 #10
0
        public int GetQtnAnimais()
        {
            int Quantidade = 0;

            SqlXmlRun.Execute("SysPec_p_GetQtnAnimalByPasto", out Quantidade, new SqlXmlParams("pasto", this.Id));
            this.QtdAnimaisAtualmente = Quantidade;
            return(Quantidade);
        }
예제 #11
0
        public void Add()
        {
            int      id;
            DateTime now;

            SqlXmlRun.Execute("SysPec_p_AddLote", this, "lote", out id, out now);
            this.Id       = id;
            this.CriadoEm = now;
        }
예제 #12
0
        public void GetSumario(out int Animais, out int Lotes, out int Racoes, out int Pastos)
        {
            SqlXmlParamsOut Outs = new SqlXmlParamsOut("animais", SqlDbType.Int, "lotes", SqlDbType.Int, "racoes", SqlDbType.Int, "pastos", SqlDbType.Int);

            SqlXmlRun.Execute(General.ConnectionString, "SysPec_p_FazendaSumario", new SqlXmlParams("fazenda", this.Id, "criador", this.Criador), Outs);
            Animais = Convert.ToInt32(Outs["animais"]);
            Lotes   = Convert.ToInt32(Outs["lotes"]);
            Racoes  = Convert.ToInt32(Outs["racoes"]);
            Pastos  = Convert.ToInt32(Outs["pastos"]);
        }
예제 #13
0
 public void AddAnimais(int IdFazenda, int IdLote)
 {
     SqlXmlRun.Execute("SysPec_p_AddAnimais", this, new SqlXmlParams("IdFazenda", IdFazenda, "IdLote", IdLote));
 }
예제 #14
0
 public static void Disable(int Id)
 {
     SqlXmlRun.Execute("SysPec_p_DisableAnimal", new SqlXmlParams("Id", Id));
 }
예제 #15
0
 public void Save()
 {
     SqlXmlRun.Execute("SysPec_p_SaveAnimal", this, "lote");
 }
예제 #16
0
 public void Save()
 {
     SqlXmlRun.Execute("SysPec_p_SaveFazenda", this);
 }
예제 #17
0
 public void Save()
 {
     SqlXmlRun.Execute("SysPec_p_SaveRacao", this, "racao");
 }
예제 #18
0
 public void Save()
 {
     SqlXmlRun.Execute("SysPec_p_SavePasto", this, "pasto");
 }
예제 #19
0
 public void Save()
 {
     SqlXmlRun.Execute("SysPec_p_SaveVacina", this, "vacina");
 }
예제 #20
0
 public void Save()
 {
     SqlXmlRun.Execute("SysPec_p_SaveLote", this);
 }
예제 #21
0
 public void Save()
 {
     SqlXmlRun.Execute("SysPec_p_SaveCriador", this, "user");
 }
예제 #22
0
 public void AddReplicandoParaLote()
 {
     SqlXmlRun.Execute("SysPec_p_AddAplicacaoEmLote", this);
 }