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;
}
}
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>");
}
}
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();
}
