Пример #1
0
        /// <summary>
        /// ForFiltring Days And Months and years
        /// </summary>
        /// <param name="Typesearch"></param>
        /// <returns></returns>
        public void FieldDataTables(TypeSearch Typesearch, DataTable data)
        {
            List <string> Name    = new List <string>();
            List <string> NUMF    = new List <string>();
            List <string> Price   = new List <string>();
            List <string> Price_a = new List <string>();
            List <string> DOW     = new List <string>();
            List <string> Barcode = new List <string>();
            List <string> DAT     = new List <string>();

            //-=-=-
            List <string> Name_    = new List <string>();
            List <string> NUMF_    = new List <string>();
            List <string> Price_   = new List <string>();
            List <string> Price_a_ = new List <string>();
            List <string> DOW_     = new List <string>();
            List <string> Barcode_ = new List <string>();
            List <string> DAT_     = new List <string>();

            BindingSource Bind = new BindingSource();

            if (Typesearch == TypeSearch.Day)
            {
                DataTable dt        = new DataTable();
                var       GetTables = new OrcDataAcess();
                GetTables.show3(dt);
                foreach (DataRow item in dt.Rows)
                {
                    Name.Add(item.Field <string>("NAME"));
                    NUMF.Add(item.Field <string>("NUMF"));
                    Price.Add(item.Field <string>("PRICE"));
                    Price_a.Add(item.Field <string>("PRICE_A"));
                    DOW.Add(item.Field <string>("DOW"));
                    Barcode.Add(item.Field <string>("BARCODE"));
                    DAT.Add(item.Field <string>("DAT"));
                }



                var DayList = new List <string>();
                foreach (var item in SealsFunction.GetDays())
                {
                    DayList.Add(item);//Add Days For Compairing.
                }
                for (int i = 0; i < DayList.Count; i++)
                {
                    if (SealsFunction.ExtractDaysFromDate() == DayList[i])
                    {
                        Name_.Add(Name[i]);
                        Barcode_.Add(Barcode[i]);
                        Price_.Add(Price[i]);
                        Price_a_.Add(Price_a[i]);
                        DOW_.Add(DOW[i]);
                        DAT_.Add(DAT[i]);
                        NUMF_.Add(NUMF[i]);
                    }
                }

                data.Columns.Add("NAME");
                data.Columns.Add("NUMF");
                data.Columns.Add("PRICE");
                data.Columns.Add("PRICE_A");
                data.Columns.Add("DOW");
                data.Columns.Add("BARCODE");
                data.Columns.Add("DAT");
                for (int ii = 0; ii < Name_.Count; ii++)
                {
                    DataRow datarow = data.NewRow();
                    datarow["NAME"]    = Name_[ii];
                    datarow["NUMF"]    = NUMF_[ii];
                    datarow["PRICE"]   = Price_[ii];
                    datarow["PRICE_A"] = Price_a_[ii];
                    datarow["DOW"]     = DOW_[ii];
                    datarow["BARCODE"] = Barcode_[ii];
                    datarow["DAT"]     = DAT_[ii];
                    data.Rows.Add(datarow);
                }
                PrintHelper.Print.Datatable_ = data;
                PrintHelper.Print.IsDay_     = true;
                PrintHelper.Print.IsMounth_  = false;
                PrintHelper.Print.IsYear_    = false;
            }
            else if (Typesearch == TypeSearch.Month)
            {
                DataTable dt        = new DataTable();
                var       GetTables = new OrcDataAcess();
                GetTables.show3(dt);
                foreach (DataRow item in dt.Rows)
                {
                    Name.Add(item.Field <string>("NAME"));
                    NUMF.Add(item.Field <string>("NUMF"));
                    Price.Add(item.Field <string>("PRICE"));
                    Price_a.Add(item.Field <string>("PRICE_A"));
                    DOW.Add(item.Field <string>("DOW"));
                    Barcode.Add(item.Field <string>("BARCODE"));
                    DAT.Add(item.Field <string>("DAT"));
                }



                var Monthlist = new List <string>();
                foreach (var item in SealsFunction.GetMonths())
                {
                    Monthlist.Add(item);//Add Days For Compairing.
                }
                for (int i = 0; i < Monthlist.Count; i++)
                {
                    if (SealsFunction.ExtractmonthsFromDate() == Monthlist[i])
                    {
                        Name_.Add(Name[i]);
                        Barcode_.Add(Barcode[i]);
                        Price_.Add(Price[i]);
                        Price_a_.Add(Price_a[i]);
                        DOW_.Add(DOW[i]);
                        DAT_.Add(DAT[i]);
                        NUMF_.Add(NUMF[i]);
                    }
                }

                data.Columns.Add("NAME");
                data.Columns.Add("NUMF");
                data.Columns.Add("PRICE");
                data.Columns.Add("PRICE_A");
                data.Columns.Add("DOW");
                data.Columns.Add("BARCODE");
                data.Columns.Add("DAT");
                for (int ii = 0; ii < Name_.Count; ii++)
                {
                    DataRow datarow = data.NewRow();
                    datarow["NAME"]    = Name_[ii];
                    datarow["NUMF"]    = NUMF_[ii];
                    datarow["PRICE"]   = Price_[ii];
                    datarow["PRICE_A"] = Price_a_[ii];
                    datarow["DOW"]     = DOW_[ii];
                    datarow["BARCODE"] = Barcode_[ii];
                    datarow["DAT"]     = DAT_[ii];
                    data.Rows.Add(datarow);
                }


                PrintHelper.Print.Datatable_ = data;
                PrintHelper.Print.IsDay_     = false;
                PrintHelper.Print.IsMounth_  = true;
                PrintHelper.Print.IsYear_    = false;
            }
            else if (Typesearch == TypeSearch.SquareYear)
            {
                DataTable dt        = new DataTable();
                var       GetTables = new OrcDataAcess();
                GetTables.show3(dt);
                foreach (DataRow item in dt.Rows)
                {
                    Name.Add(item.Field <string>("NAME"));
                    NUMF.Add(item.Field <string>("NUMF"));
                    Price.Add(item.Field <string>("PRICE"));
                    Price_a.Add(item.Field <string>("PRICE_A"));
                    DOW.Add(item.Field <string>("DOW"));
                    Barcode.Add(item.Field <string>("BARCODE"));
                    DAT.Add(item.Field <string>("DAT"));
                }



                var MonthList = new List <string>();

                foreach (var item in SealsFunction.GetMonths())
                {
                    MonthList.Add(item);//Add Days For Compairing.
                }
                for (int i = 0; i < MonthList.Count; i++)
                {
                    if (DateTime.Now.Day.ToString() == MonthList[i])
                    {
                        Name_.Add(Name[i]);
                        Barcode_.Add(Barcode[i]);
                        Price_.Add(Price[i]);
                        Price_a_.Add(Price_a[i]);
                        DOW_.Add(DOW[i]);
                        DAT_.Add(DAT[i]);
                        NUMF_.Add(NUMF[i]);
                    }
                }

                data.Columns.Add("NAME");
                data.Columns.Add("NUMF");
                data.Columns.Add("PRICE");
                data.Columns.Add("PRICE_A");
                data.Columns.Add("DOW");
                data.Columns.Add("BARCODE");
                data.Columns.Add("DAT");
                for (int ii = 0; ii < Name_.Count; ii++)
                {
                    DataRow datarow = data.NewRow();
                    datarow["NAME"]    = Name_[ii];
                    datarow["NUMF"]    = NUMF_[ii];
                    datarow["PRICE"]   = Price_[ii];
                    datarow["PRICE_A"] = Price_a_[ii];
                    datarow["DOW"]     = DOW_[ii];
                    datarow["BARCODE"] = Barcode_[ii];
                    datarow["DAT"]     = DAT_[ii];
                    data.Rows.Add(datarow);
                }
            }
            else if (Typesearch == TypeSearch.Year)
            {
                DataTable dt        = new DataTable();
                var       GetTables = new OrcDataAcess();
                GetTables.show3(dt);
                foreach (DataRow item in dt.Rows)
                {
                    Name.Add(item.Field <string>("NAME"));
                    NUMF.Add(item.Field <string>("NUMF"));
                    Price.Add(item.Field <string>("PRICE"));
                    Price_a.Add(item.Field <string>("PRICE_A"));
                    DOW.Add(item.Field <string>("DOW"));
                    Barcode.Add(item.Field <string>("BARCODE"));
                    DAT.Add(item.Field <string>("DAT"));
                }



                var yearlist = new List <string>();
                foreach (var item in SealsFunction.GetYears())
                {
                    yearlist.Add(item);//Add Days For Compairing.
                }
                for (int i = 0; i < yearlist.Count; i++)
                {
                    if (SealsFunction.ExtractyearsFromDate() == yearlist[i])
                    {
                        Name_.Add(Name[i]);
                        Barcode_.Add(Barcode[i]);
                        Price_.Add(Price[i]);
                        Price_a_.Add(Price_a[i]);
                        DOW_.Add(DOW[i]);
                        DAT_.Add(DAT[i]);
                        NUMF_.Add(NUMF[i]);
                    }
                }

                data.Columns.Add("NAME");
                data.Columns.Add("NUMF");
                data.Columns.Add("PRICE");
                data.Columns.Add("PRICE_A");
                data.Columns.Add("DOW");
                data.Columns.Add("BARCODE");
                data.Columns.Add("DAT");
                for (int ii = 0; ii < Name_.Count; ii++)
                {
                    DataRow datarow = data.NewRow();
                    datarow["NAME"]    = Name_[ii];
                    datarow["NUMF"]    = NUMF_[ii];
                    datarow["PRICE"]   = Price_[ii];
                    datarow["PRICE_A"] = Price_a_[ii];
                    datarow["DOW"]     = DOW_[ii];
                    datarow["BARCODE"] = Barcode_[ii];
                    datarow["DAT"]     = DAT_[ii];
                    data.Rows.Add(datarow);
                }
                PrintHelper.Print.Datatable_ = data;
                PrintHelper.Print.IsDay_     = false;
                PrintHelper.Print.IsMounth_  = false;
                PrintHelper.Print.IsYear_    = true;
            }
        }
Пример #2
0
        /*
         *
         * ID = item.Field<string>("ID"),
         *          conprou = item.Field<string>("conprou"),
         *          PRICE = item.Field<string>("PRICE"),
         *          DAT = item.Field<string>("DAT"),
         *          NAME = item.Field<string>("NAME"),
         *          datrec = item.Field<string>("datrec"),
         *          discounts = item.Field<string>("discounts"),
         *          typeprou = item.Field<string>("typeprou"),
         *          isdone = (item.Field<Int64>("isdone")) ? GetImage(@"/images/ionicons_2-0-1_ios-timer_23_0_27ae60_none.png") : GetImage(@"/images/material-icons_3-0-1_done_23_0_27ae60_none.png")
         *
         *
         */
        public void Create(TypeSearch Type, ObservableCollectionCore <Models.RepairView> data)
        {
            var ID        = new List <string>();
            var conprou   = new List <string>();
            var PRICE     = new List <string>();
            var DAT       = new List <string>();
            var NAME      = new List <string>();
            var datrec    = new List <string>();
            var discounts = new List <string>();
            var typeprou  = new List <string>();
            var isdone    = new List <bool>();

            var           ID_        = new List <string>();
            var           conprou_   = new List <string>();
            var           PRICE_     = new List <string>();
            var           DAT_       = new List <string>();
            var           NAME_      = new List <string>();
            var           datrec_    = new List <string>();
            var           discounts_ = new List <string>();
            var           typeprou_  = new List <string>();
            var           isdone_    = new List <bool>();
            BindingSource bind       = new BindingSource();


            if (Type == TypeSearch.Day)
            {
                DataTable dt        = new DataTable();
                var       gettables = new ModelMega();
                gettables.show(dt);
                foreach (DataRow item in dt.Rows)
                {
                    ID.Add(item.Field <string>("ID"));
                    conprou.Add(item.Field <string>("conprou"));
                    PRICE.Add(item.Field <string>("PRICE"));
                    DAT.Add(item.Field <string>("DAT"));
                    NAME.Add(item.Field <string>("NAME"));
                    datrec.Add(item.Field <string>("datrec"));
                    discounts.Add(item.Field <string>("discounts"));
                    typeprou.Add(item.Field <string>("typeprou"));
                    isdone.Add(item.Field <Int64>("isdone") == -1);
                }


                var daylist = new List <string>();
                foreach (var item in GetDays())
                {
                    daylist.Add(item);
                }
                for (int i = 0; i < daylist.Count; i++)
                {
                    if (SealsFunction.ExtractDaysFromDate() == daylist[i])
                    {
                        ID_.Add(ID[i]);
                        conprou_.Add(conprou[i]);
                        PRICE_.Add(PRICE[i]);
                        DAT_.Add(DAT[i]);
                        NAME_.Add(NAME[i]);
                        datrec_.Add(datrec[i]);
                        discounts_.Add(discounts[i]);
                        typeprou_.Add(typeprou[i]);
                        isdone_.Add(isdone[i]);
                    }
                }

                var modelmega = new ModelMega();
                for (int ii = 0; ii < NAME_.Count; ii++)
                {
                    //ID_.Add(ID[i]);
                    //conprou_.Add(conprou[i]);
                    //PRICE_.Add(PRICE[i]);
                    //DAT_.Add(DAT[i]);
                    //NAME_.Add(NAME[i]);
                    //datrec_.Add(datrec[i]);
                    //discounts_.Add(discounts[i]);
                    //typeprou_.Add(typeprou[i]);
                    //isdone_.Add(isdone[i]);

                    if (isdone_[ii])
                    {
                        data.Add(new Models.RepairView()
                        {
                            ID        = ID_[ii],
                            conprou   = conprou_[ii],
                            DAT       = DAT_[ii],
                            datrec    = datrec_[ii],
                            discounts = discounts_[ii],
                            isdone    = isdone_[ii]
                            ,
                            NAME     = NAME_[ii],
                            PRICE    = PRICE_[ii],
                            typeprou = typeprou_[ii]
                        });

                        modelmega.add1(ID_[ii], NAME_[ii], PRICE_[ii], DAT[ii], datrec_[ii], conprou_[ii], typeprou_[ii], discounts_[ii], (isdone_[ii])?-1:0);
                    }


                    //datarow["ID"] = ID_[ii];
                    //datarow["NAME"] = NAME_[ii];
                    //datarow["DAT"] = DAT_[ii];
                    //datarow["datrec"] = datrec_[ii];
                    //datarow["typeprou"] = typeprou_[ii];
                    //datarow["PRICE"] = PRICE_[ii];
                    //datarow["discounts"] = discounts_[ii];
                    //datarow["conprou"] = conprou_[ii];
                    //datarow["isdone"] = isdone_[ii];
                }
            }
            else if (Type == TypeSearch.Year)
            {
                DataTable dt        = new DataTable();
                var       gettables = new ModelMega();
                gettables.show(dt);
                foreach (DataRow item in dt.Rows)
                {
                    ID.Add(item.Field <string>("ID"));
                    conprou.Add(item.Field <string>("conprou"));
                    PRICE.Add(item.Field <string>("PRICE"));
                    DAT.Add(item.Field <string>("DAT"));
                    NAME.Add(item.Field <string>("NAME"));
                    datrec.Add(item.Field <string>("datrec"));
                    discounts.Add(item.Field <string>("discounts"));
                    typeprou.Add(item.Field <string>("typeprou"));
                    isdone.Add(item.Field <Int64>("isdone") == -1);
                }


                var daylist = new List <string>();
                foreach (var item in GetYears())
                {
                    daylist.Add(item);
                }
                for (int i = 0; i < daylist.Count; i++)
                {
                    if (SealsFunction.ExtractyearsFromDate() == daylist[i])
                    {
                        ID_.Add(ID[i]);
                        conprou_.Add(conprou[i]);
                        PRICE_.Add(PRICE[i]);
                        DAT_.Add(DAT[i]);
                        NAME_.Add(NAME[i]);
                        datrec_.Add(datrec[i]);
                        discounts_.Add(discounts[i]);
                        typeprou_.Add(typeprou[i]);
                        isdone_.Add(isdone[i]);
                    }
                }



                var modelmega = new ModelMega();



                for (int ii = 0; ii < NAME_.Count; ii++)
                {
                    if (isdone_[ii])
                    {
                        data.Add(new Models.RepairView()
                        {
                            ID        = ID_[ii],
                            conprou   = conprou_[ii],
                            DAT       = DAT_[ii],
                            datrec    = datrec_[ii],
                            discounts = discounts_[ii],
                            isdone    = isdone_[ii]
                            ,
                            NAME     = NAME_[ii],
                            PRICE    = PRICE_[ii],
                            typeprou = typeprou_[ii]
                        });

                        modelmega.add1(ID_[ii], NAME_[ii], PRICE_[ii], DAT[ii], datrec_[ii], conprou_[ii], typeprou_[ii], discounts_[ii], (isdone_[ii]) ? -1 : 0);
                    }
                }
            }
            else
            if (Type == TypeSearch.Month)
            {
                DataTable dt        = new DataTable();
                var       gettables = new ModelMega();
                gettables.show(dt);
                foreach (DataRow item in dt.Rows)
                {
                    ID.Add(item.Field <string>("ID"));
                    conprou.Add(item.Field <string>("conprou"));
                    PRICE.Add(item.Field <string>("PRICE"));
                    DAT.Add(item.Field <string>("DAT"));
                    NAME.Add(item.Field <string>("NAME"));
                    datrec.Add(item.Field <string>("datrec"));
                    discounts.Add(item.Field <string>("discounts"));
                    typeprou.Add(item.Field <string>("typeprou"));
                    isdone.Add(item.Field <Int64>("isdone") == -1);
                }


                var daylist = new List <string>();
                foreach (var item in GetMonths())
                {
                    daylist.Add(item);
                }
                for (int i = 0; i < daylist.Count; i++)
                {
                    if (SealsFunction.ExtractmonthsFromDate() == daylist[i])
                    {
                        ID_.Add(ID[i]);
                        conprou_.Add(conprou[i]);
                        PRICE_.Add(PRICE[i]);
                        DAT_.Add(DAT[i]);
                        NAME_.Add(NAME[i]);
                        datrec_.Add(datrec[i]);
                        discounts_.Add(discounts[i]);
                        typeprou_.Add(typeprou[i]);
                        isdone_.Add(isdone[i]);
                    }
                }

                var modelmega = new ModelMega();
                for (int ii = 0; ii < NAME_.Count; ii++)
                {
                    if (isdone_[ii])
                    {
                        data.Add(new Models.RepairView()
                        {
                            ID        = ID_[ii],
                            conprou   = conprou_[ii],
                            DAT       = DAT_[ii],
                            datrec    = datrec_[ii],
                            discounts = discounts_[ii],
                            isdone    = isdone_[ii]
                            ,
                            NAME     = NAME_[ii],
                            PRICE    = PRICE_[ii],
                            typeprou = typeprou_[ii]
                        });

                        modelmega.add1(ID_[ii], NAME_[ii], PRICE_[ii], DAT[ii], datrec_[ii], conprou_[ii], typeprou_[ii], discounts_[ii], (isdone_[ii]) ? -1 : 0);
                    }
                }
            }
        }