Exemplo n.º 1
0
        public void SetUpEndDatePicker()
        {
            UIDatePicker datePicker = new UIDatePicker();

            datePicker.Mode = UIDatePickerMode.Date;

            UIToolbar toolbar = new UIToolbar();

            toolbar.BarStyle    = UIBarStyle.Default;
            toolbar.Translucent = true;
            toolbar.SizeToFit();

            UIBarButtonItem doneButton = new UIBarButtonItem("Done", UIBarButtonItemStyle.Done, (s, e) =>
            {
                if (endDate > startDate)
                {
                    var selectedDate   = NSDateToDateTime(datePicker.Date);
                    DatePickerEnd.Text = selectedDate.ToString("dd MMMMM yyyy dddd");
                    DatePickerEnd.ResignFirstResponder();
                    endDate = selectedDate;
                }
                else
                {
                    UIAlertController alertController = UIAlertController.Create("Error", "The end date must be after the start date", UIAlertControllerStyle.Alert);
                    PresentViewController(alertController, true, null);
                }
            });

            toolbar.SetItems(new UIBarButtonItem[] { new UIBarButtonItem(UIBarButtonSystemItem.FlexibleSpace), doneButton }, true);

            this.DatePickerEnd.InputView = datePicker;

            this.DatePickerEnd.InputAccessoryView = toolbar;
        }
        void ReleaseDesignerOutlets()
        {
            if (CalendarView != null)
            {
                CalendarView.Dispose();
                CalendarView = null;
            }

            if (DatePickerEnd != null)
            {
                DatePickerEnd.Dispose();
                DatePickerEnd = null;
            }

            if (DatePickerStart != null)
            {
                DatePickerStart.Dispose();
                DatePickerStart = null;
            }

            if (EnableRangePickers != null)
            {
                EnableRangePickers.Dispose();
                EnableRangePickers = null;
            }

            if (ShowDatesinListView != null)
            {
                ShowDatesinListView.Dispose();
                ShowDatesinListView = null;
            }
        }
Exemplo n.º 3
0
        protected void bSave_Click(object sender, ImageClickEventArgs e)
        {
            lock (Database.lockObjectDB)
            {
                ArrayList al = new ArrayList();

                string s = "";

                if (DatePickerStart.DatePickerText != "")
                {
                    try
                    {
                        Convert.ToDateTime(DatePickerStart.DatePickerText);
                    }
                    catch
                    {
                        lbInform.Text = "Неправильно введена дата документа с";
                        DatePickerStart.Focus();
                        return;
                    }
                }
                if (DatePickerEnd.DatePickerText != "")
                {
                    try
                    {
                        Convert.ToDateTime(DatePickerEnd.DatePickerText);
                    }
                    catch
                    {
                        lbInform.Text = "Неправильно введена дата документа по";
                        DatePickerEnd.Focus();
                        return;
                    }
                }

                if (DatePickerStart.DatePickerText != "")
                {
                    al.Add(String.Format("(date_doc>=[{0:" + ConfigurationSettings.AppSettings["DateFormat"] + "}])", DatePickerStart.SelectedDate));
                }
                if (DatePickerEnd.DatePickerText != "")
                {
                    al.Add(String.Format("(date_doc<=[{0:" + ConfigurationSettings.AppSettings["DateFormat"] + "}])", DatePickerEnd.SelectedDate));
                }

                string id_type = dListType.SelectedItem.Value;
                if (id_type != "-1")
                {
                    al.Add(String.Format("(type={0})", id_type));
                }

                id_type = dListBranch.SelectedItem.Value;
                if (id_type != "-1")
                {
                    al.Add($"(id_branch={id_type})");
                }

                if (tbProd.Text != "")
                {
                    al.Add(String.Format("(id in (select id_doc from V_Products_StorageDocs where prod_name like [%{0}%]))", tbProd.Text));
                }

                if (tbCard.Text != "")
                {
                    if (tbCard.Text.Trim().Length >= 16)
                    {
                        al.Add(
                            $"(id in (select id_doc from V_Cards_StorageDocs where panhash like [{FuncClass.GetHashPan(tbCard.Text.Trim())}]))");
                    }
                    else
                    {
                        al.Add($"(id in (select id_doc from V_Cards_StorageDocs where pan like [%{tbCard.Text.Trim()}%]))");
                    }
                }

                if (tbCreate.Text != "")
                {
                    al.Add(String.Format("(loweredusername like [%{0}%])", tbCreate.Text.Trim()));
                }

                if (chAll.Checked)
                {
                    al.Add(String.Format("(priz_gen=1 or priz_gen=0)", tbCard.Text));
                }
                else
                {
                    al.Add(String.Format("(priz_gen=0)", tbCard.Text));
                }

                if (al.Count > 0)
                {
                    string[] all = Array.CreateInstance(typeof(string), al.Count) as string[];
                    al.CopyTo(all, 0);
                    s = "where " + String.Join(" and ", all);
                }

                Response.Write("<script language=javascript>window.returnValue='" + s + "'; window.close();</script>");
            }
        }
Exemplo n.º 4
0
        private void ButtonExportExecute()
        {
            _trashShippeds.AddRange(TrashModule.GetTrashShippedQuantitySum(DatePickerBegin, DatePickerEnd));
            #region OleDB
            //string databaseDirectory = AppSettingConfig.DbfFilePath();
            //string sql4 = "SELECT invosub.IN_DATE,invosub.I_01,item.I_03,SUM(invosub.QUANTITY) FROM INVOSUB.dbf invosub " +
            //                "INNER JOIN ITEM.dbf item ON invosub.I_01 = item.I_01 AND invosub.F_01 = item.F_01 " +
            //                "WHERE invosub.IN_DATE Between cDate('" + DatePickerBegin.ToString() + "') and cDate('" + DatePickerEnd.ToString() + "') " +
            //                "GROUP BY invosub.IN_DATE,invosub.I_01,item.I_03 " +
            //                "ORDER BY invosub.IN_DATE,invosub.I_01";
            //DataTable dt4 = GetOleDbDbfDataTable(databaseDirectory, sql4);
            //DataGridInCash_Copy3.ItemsSource = dt4.DefaultView;
            #endregion
            var originalSources = new List <OriginalSource>();
            foreach (var shipped in _trashShippeds)
            {
                originalSources.Add(new OriginalSource
                {
                    DateTime         = shipped.IN_DATE,
                    TextileNo        = shipped.I_01,
                    TextileColorName = shipped.I_03,
                    Weight           = shipped.Quantity
                });
            }

            var filterText            = FilterText;
            var filterOriginalSources = string.IsNullOrEmpty(filterText) == true?originalSources.Select(s => s.TextileNo).Distinct() : originalSources.Where(w => w.TextileColorName.Contains(filterText)).Select(s => s.TextileNo).Distinct();;
            var everyDate             = originalSources.Select(s => s.DateTime).Distinct();
            var everyTextileNo        = filterOriginalSources;
            var textileDatas          = new List <TextileData>();
            foreach (var date in everyDate)
            {
                textileDatas.Add(new TextileData
                {
                    DateTime      = date,
                    TextileColors = originalSources.Where(w => w.DateTime == date).Select(s => new TextileColor {
                        TextileNo = s.TextileNo, Weight = s.Weight, TextileColorName = s.TextileColorName
                    }).ToList()
                });
            }

            IWorkbook wb  = new XSSFWorkbook();
            ISheet    ws  = wb.CreateSheet("Report");
            XSSFRow   row = (XSSFRow)ws.CreateRow(0);

            var textileNameNumber = 1;
            ExcelHelper.CreateCell(row, 0, "時間", null);
            var priviousWeightList = new Dictionary <string, double>();
            foreach (var item in everyTextileNo)
            {
                ExcelHelper.CreateCell(row, textileNameNumber, originalSources.Where(w => w.TextileNo == item).First().TextileColorName, null);
                priviousWeightList.Add(item, 0);
                textileNameNumber++;
            }
            var rowNumber    = 1;
            var priviousYear = textileDatas.First().DateTime.ToString("yyyy");
            foreach (var textiles in textileDatas)
            {
                var     columnNumber = 1;
                XSSFRow rowTextile   = (XSSFRow)ws.CreateRow(rowNumber);
                ExcelHelper.CreateCell(rowTextile, 0, textiles.DateTime.ToString("yyyy/MM/dd"), null);

                if (textiles.DateTime.ToString("yyyy") != priviousYear)
                {
                    priviousYear = textiles.DateTime.ToString("yyyy");
                    foreach (var item in everyTextileNo)
                    {
                        priviousWeightList[item] = 0;
                    }
                }
                foreach (var textileNo in everyTextileNo)
                {
                    var textileData = textiles.TextileColors.Where(w => w.TextileNo == textileNo);
                    var weight      = textileData.Count() == 0 ? priviousWeightList[textileNo] : textileData.First().Weight + priviousWeightList[textileNo];
                    ExcelHelper.CreateCell(rowTextile, columnNumber, weight.ToString(), null);
                    priviousWeightList[textileNo] = weight;
                    columnNumber++;
                }
                rowNumber++;
            }

            FileStream file = new FileStream(string.Concat(AppSettingConfig.ReportsFilePath(), @"\", filterText, "報表", DatePickerBegin.ToString("yyyyMMdd"), "-", DatePickerEnd.ToString("yyyyMMdd"), ".xlsx"), FileMode.Create);//產生檔案
            wb.Write(file);
            file.Close();
        }