Esempio n. 1
0
        private void But_OptionANCRevision_Click(object sender, EventArgs e)
        {
            Cursor.Current = Cursors.WaitCursor;
            var Option = MainProgram.Self.adminTableView.optionsView;
            var Table  = MainProgram.Self.adminTableView.ReturnDataGridView();

            if (Option.GetMonth() != 0 && Option.GetRevision() != "")
            {
                Table.DataSource = ANCRevisionQuantity.LoadByYear_Month_Revision(
                    Convert.ToInt32(Option.GetYear()),
                    Convert.ToInt32(Option.GetMonth()),
                    Option.GetRevision()
                    );
            }
            else if (Option.GetMonth() != 0)
            {
                Table.DataSource = ANCRevisionQuantity.LoadByYear_Month(
                    Convert.ToInt32(Option.GetYear()),
                    Convert.ToInt32(Option.GetMonth())
                    );
            }
            else if (Option.GetRevision() != "")
            {
                Table.DataSource = ANCRevisionQuantity.LoadByYear_Revision(
                    Convert.ToInt32(Option.GetYear()),
                    Option.GetRevision()
                    );
            }
            else
            {
                Table.DataSource = ANCRevisionQuantity.LoadByYear(
                    Convert.ToInt32(Option.GetYear()));
            }

            Cursor.Current = Cursors.Default;
        }
Esempio n. 2
0
        public ANCRevisionQuantityAdd(string Revision, int AddYear, string[] DataToAdd)
        {
            var ANCList    = ANCRevisionQuantity.LoadByYear_Revision(AddYear, Revision);
            int StartMonth = 0;

            if (Revision == "BU")
            {
                StartMonth = 1;
            }
            else if (Revision == "EA1")
            {
                StartMonth = 3;
            }
            else if (Revision == "EA2")
            {
                StartMonth = 6;
            }
            else if (Revision == "EA3")
            {
                StartMonth = 9;
            }

            if (StartMonth == 0)
            {
                return;
            }

            if (ANCList != null)
            {
                ANCRevisionQuantity.RemoveList(ANCList);
            }
            List <ANCRevisionDB> ListANC = new List <ANCRevisionDB>();


            foreach (string Data in DataToAdd)
            {
                string[] AddData = Data.Split('\t');
                if (AddData.Length != 1)
                {
                    int StringCount = 1;

                    for (int counter = StartMonth; counter < 13; counter++)
                    {
                        var NewRow = new ANCRevisionDB
                        {
                            ANC      = AddData[0].ToString(),
                            Year     = AddYear,
                            Month    = counter,
                            Revision = Revision,
                            Value    = Convert.ToDouble(AddData[StringCount]),
                        };
                        StringCount++;
                        ListANC.Add(NewRow);
                    }
                }
            }

            if (ListANC != null)
            {
                ANCRevisionQuantity.AddList(ListANC);
            }
        }