/// <summary>
/// Provides the description of the model settings for summary (GetFullSummary)
/// </summary>
/// <param name="formatForParentControl">Use full verbose description</param>
/// <returns></returns>
public override string ModelSummary(bool formatForParentControl)
{
using (StringWriter htmlWriter = new StringWriter())
{
htmlWriter.Write("\r\n<div class=\"filter\">");
htmlWriter.Write("Perform between ");
if (StartMonth == 0)
{
htmlWriter.Write("<span class=\"errorlink\">NOT SET</span>");
}
else
{
htmlWriter.Write("<span class=\"setvalueextra\">");
htmlWriter.Write(StartMonth.ToString() + "</span>");
}
htmlWriter.Write(" and <span class=\"setvalueextra\">");
if (EndMonth == 0)
{
htmlWriter.Write("<span class=\"errorlink\">NOT SET</span>");
}
else
{
htmlWriter.Write("<span class=\"setvalueextra\">");
htmlWriter.Write(EndMonth.ToString() + "</span>");
}
htmlWriter.Write("</div>");
if (!this.Enabled)
{
htmlWriter.Write(" - DISABLED!");
}
return(htmlWriter.ToString());
}
}
/// <summary>
/// Provides the description of the model settings for summary (GetFullSummary)
/// </summary>
/// <param name="formatForParentControl">Use full verbose description</param>
/// <returns></returns>
public override string ModelSummary(bool formatForParentControl)
{
string html = "";
html += "\n<div class=\"filter\">";
html += "Perform between ";
if (StartMonth == 0)
{
html += "<span class=\"errorlink\">NOT SET</span>";
}
else
{
html += "<span class=\"setvalueextra\">";
html += StartMonth.ToString() + "</span>";
}
html += " and <span class=\"setvalueextra\">";
if (EndMonth == 0)
{
html += "<span class=\"errorlink\">NOT SET</span>";
}
else
{
html += "<span class=\"setvalueextra\">";
html += EndMonth.ToString() + "</span>";
}
html += "</div>";
if (!this.Enabled)
{
html += " - DISABLED!";
}
return(html);
}
public override int GetHashCode()
{
unchecked
{
return(((StartMonth != null ? StartMonth.GetHashCode() : 0) * 397) ^ (EndMonth != null ? EndMonth.GetHashCode() : 0));
}
}
public void InitializeDdlSettingWindow(Ddl ddl)
{
InitializeComponent();
DdlNameTextBox.Text = ddl.Name;
DdlPriority.Value = ddl.Priority;
InitializeStartTime(ddl.StartTime);
ChineseCheckbox.IsChecked = ddl.IsChineseCalender;
InitializeEndTime(ddl.EndTime);
var format = System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat.ShortDatePattern;
if (format == "M/d/yyyy")
{
StartMonth.SetValue(Grid.ColumnProperty, 0);
StartDay.SetValue(Grid.ColumnProperty, 1);
StartYear.SetValue(Grid.ColumnProperty, 2);
EndMonth.SetValue(Grid.ColumnProperty, 0);
EndDay.SetValue(Grid.ColumnProperty, 1);
EndYear.SetValue(Grid.ColumnProperty, 2);
}
else if (format == "d/M/yyyy")
{
StartDay.SetValue(Grid.ColumnProperty, 0);
StartMonth.SetValue(Grid.ColumnProperty, 1);
StartYear.SetValue(Grid.ColumnProperty, 2);
EndDay.SetValue(Grid.ColumnProperty, 0);
EndMonth.SetValue(Grid.ColumnProperty, 1);
EndYear.SetValue(Grid.ColumnProperty, 2);
}
LoopCheckbox.IsChecked = ddl.IsLoop;
if (ddl.IsLoop)
{
InitializeLoopinterval(ddl.LoopInterval);
}
NoticeCheckbox.IsChecked = (ddl.Inform[0] == '1');
WindowCheckbox.IsChecked = (ddl.Inform[1] == '1');
SoundCheckbox.IsChecked = (ddl.Inform[2] == '1');
RemindCheckbox.IsChecked = ddl.IsRemind != -1;
if (ddl.IsRemind != -1)
{
InitializeRemind(ddl.RemindInterval, ddl.RemindTime);
}
if (System.Threading.Thread.CurrentThread.CurrentUICulture.Name != "zh-CN")
{
ChineseCheckbox.Visibility = Visibility.Hidden;
ChineseCheckbox.IsEnabled = false;
}
}
public override int GetHashCode()
{
int hash = 1;
if (Id.Length != 0)
{
hash ^= Id.GetHashCode();
}
if (Applicant.Length != 0)
{
hash ^= Applicant.GetHashCode();
}
if (CompanyName.Length != 0)
{
hash ^= CompanyName.GetHashCode();
}
if (CountryCode.Length != 0)
{
hash ^= CountryCode.GetHashCode();
}
if (Location.Length != 0)
{
hash ^= Location.GetHashCode();
}
if (JobTitle.Length != 0)
{
hash ^= JobTitle.GetHashCode();
}
if (JobDescription.Length != 0)
{
hash ^= JobDescription.GetHashCode();
}
if (StartMonth != 0)
{
hash ^= StartMonth.GetHashCode();
}
if (StartYear != 0)
{
hash ^= StartYear.GetHashCode();
}
if (EndMonth != 0)
{
hash ^= EndMonth.GetHashCode();
}
if (EndYear != 0)
{
hash ^= EndYear.GetHashCode();
}
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
public SetIntendedShipmentInfoForNotification ToRequest(Guid notificationId)
{
DateTime startDate;
SystemTime.TryParse(StartYear.GetValueOrDefault(), StartMonth.GetValueOrDefault(), StartDay.GetValueOrDefault(), out startDate);
DateTime endDate;
SystemTime.TryParse(EndYear.GetValueOrDefault(), EndMonth.GetValueOrDefault(), EndDay.GetValueOrDefault(), out endDate);
return(new SetIntendedShipmentInfoForNotification(
notificationId,
int.Parse(NumberOfShipments, NumberStyles.AllowThousands),
Convert.ToDecimal(Quantity),
Units.GetValueOrDefault(),
startDate,
endDate));
}
public override int GetHashCode()
{
int hash = 1;
if (Id.Length != 0)
{
hash ^= Id.GetHashCode();
}
if (Applicant.Length != 0)
{
hash ^= Applicant.GetHashCode();
}
if (Skill.Length != 0)
{
hash ^= Skill.GetHashCode();
}
if (SkillLevel.Length != 0)
{
hash ^= SkillLevel.GetHashCode();
}
if (StartMonth != 0)
{
hash ^= StartMonth.GetHashCode();
}
if (StartYear != 0)
{
hash ^= StartYear.GetHashCode();
}
if (EndMonth != 0)
{
hash ^= EndMonth.GetHashCode();
}
if (EndYear != 0)
{
hash ^= EndYear.GetHashCode();
}
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
protected virtual int ExportDetail(Workbook workbook, int sheetIndex, int rowBegin)
{
Worksheet ws = workbook.Worksheets[sheetIndex];
int rowIndex = rowBegin;
int emptyRowCount = rowIndex + 12;
//2.1 get ai2 data
DataTable dtDetail = Dao.d_ai2(KindId, StartMonth.SubStr(0, 4) + "01", StartMonth.Replace("/", ""));
if (dtDetail.Rows.Count <= 0)
{
if (rowIndex < emptyRowCount)
{
ws.Rows.Remove(rowIndex + 1, emptyRowCount - rowIndex);
}
return(0);
}
//2.2 總列數
ws.Cells[rowIndex + 12 + 1, 0].Value = (StartMonth.SubStr(0, 4).AsInt() - 1911).AsString() + "小計";
string ls_ymd = "";//日期
foreach (DataRow dr in dtDetail.Rows)
{
string am2_ymd = dr["am2_ymd"].AsString();
int am2_idfg_type = dr["am2_idfg_type"].AsInt();
string am2_bs_code = dr["am2_bs_code"].AsString();
Decimal am2_m_qnty = dr["am2_m_qnty"].AsDecimal();
if (ls_ymd != am2_ymd)
{
ls_ymd = am2_ymd;
rowIndex++;
//li_month_cnt++;
string chineseMonth = (ls_ymd.SubStr(0, 4).AsInt() - 1911).AsString() + "/" + ls_ymd.SubStr(4, 2);
ws.Cells[rowIndex, 0].Value = chineseMonth;
}
//ken,get li_ole_col , but 順序亂跳
int li_ole_col = (am2_bs_code == "B" ? -1 : 0);
switch (am2_idfg_type)
{
case 1:
li_ole_col += 2;
break;
case 2:
li_ole_col += 4;
break;
case 3:
li_ole_col += 6;
break;
//沒有case 4:
case 5:
li_ole_col += 8;
break;
case 6:
li_ole_col += 10;
break;
case 7:
li_ole_col += 14;
break;
case 8:
li_ole_col += 12;
break;
}
ws.Cells[rowIndex, li_ole_col].Value = am2_m_qnty;
}//foreach (DataRow dr in dtDetail.Rows) {
//2.5 刪除空白列
if (rowIndex < emptyRowCount)
{
ws.Rows.Remove(rowIndex + 1, emptyRowCount - rowIndex);
}
return(1);
}
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext)
{
DateTime startDate;
bool isValidStartDate = SystemTime.TryParse(StartYear.GetValueOrDefault(), StartMonth.GetValueOrDefault(), StartDay.GetValueOrDefault(), out startDate);
if (!isValidStartDate)
{
yield return(new ValidationResult(IndexResources.FromValid, new[] { "StartDay" }));
}
DateTime endDate;
bool isValidEndDate = SystemTime.TryParse(EndYear.GetValueOrDefault(), EndMonth.GetValueOrDefault(), EndDay.GetValueOrDefault(), out endDate);
if (!isValidEndDate)
{
yield return(new ValidationResult(IndexResources.ToValid, new[] { "EndDay" }));
}
if (!(isValidStartDate && isValidEndDate))
{
// Stop further validation if either date is not a valid date
yield break;
}
if (startDate > endDate)
{
yield return(new ValidationResult(IndexResources.FromDateAfterToDate, new[] { "StartYear" }));
}
}
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext)
{
if (!IsNumberOfShipmentsValid())
{
yield return(new ValidationResult(ShipmentResources.NumberOfShipmentsValid, new[] { "NumberOfShipments" }));
}
if (!IsQuantityValid() && Units.HasValue)
{
yield return(new ValidationResult(string.Format(ShipmentResources.DecimalPlacesValid,
ShipmentQuantityUnitsMetadata.Precision[Units.Value]), new[] { "Quantity" }));
}
DateTime startDate;
bool isValidStartDate = SystemTime.TryParse(StartYear.GetValueOrDefault(), StartMonth.GetValueOrDefault(), StartDay.GetValueOrDefault(), out startDate);
if (!isValidStartDate)
{
yield return(new ValidationResult(ShipmentResources.FirstDepartureValid, new[] { "StartDay" }));
}
DateTime endDate;
bool isValidEndDate = SystemTime.TryParse(EndYear.GetValueOrDefault(), EndMonth.GetValueOrDefault(), EndDay.GetValueOrDefault(), out endDate);
if (!isValidEndDate)
{
yield return(new ValidationResult(ShipmentResources.LastDepartureValid, new[] { "EndDay" }));
}
if (!(isValidStartDate && isValidEndDate))
{
// Stop further validation if either date is not a valid date
yield break;
}
if (startDate < SystemTime.Now.Date && Status == NotificationStatus.NotSubmitted)
{
yield return(new ValidationResult(ShipmentResources.FirstDeparturePastDate, new[] { "StartDay" }));
}
if (startDate > endDate)
{
yield return(new ValidationResult(ShipmentResources.FirstDepartureBeforeLastDate, new[] { "StartYear" }));
}
var monthPeriodLength = IsPreconsentedRecoveryFacility ? 36 : 12;
if (endDate >= startDate.AddMonths(monthPeriodLength))
{
yield return(new ValidationResult(string.Format(ShipmentResources.DepartureDateRange, monthPeriodLength), new[] { "EndYear" }));
}
}
public byte[] ToPayload(byte scheduleId, byte?scheduleIdBlock = null)
{
int numBytes = 12 + Commands.Sum(cmd => cmd.Command.Length + 1);
var bytes = new byte[numBytes];
byte durationType, durationByte1, durationByte2;
if (Duration.HasValue)
{
var duration = Duration.Value;
ushort durationNumber;
if (Duration >= TimeSpan.FromHours(60000))
{
durationType = DurationTypeDays;
durationNumber = (ushort)Math.Min(duration.Days, ushort.MaxValue);
}
else if (Duration >= TimeSpan.FromMinutes(60000))
{
durationType = DurationTypeHours;
durationNumber = (ushort)(duration.Days * 24 + duration.Hours);
}
else
{
durationType = DurationTypeMinutes;
durationNumber = (ushort)((duration.Days * 24 + duration.Hours) * 60 + duration.Minutes);
}
durationByte1 = (byte)(durationNumber / 256);
durationByte2 = (byte)(durationNumber % 256);
}
else
{
durationType = DurationTypeOverride;
durationByte1 = 0;
durationByte2 = (byte)OverrideType;
}
bytes[0] = scheduleId;
bytes[1] = scheduleIdBlock.GetValueOrDefault(1);
bytes[2] = (byte)(StartYear.HasValue ? StartYear - YearOffset : StartYearNotSpecified);
bytes[3] = (byte)((int)State << 4 | StartMonth.GetValueOrDefault(StartMonthNotSpecified));
bytes[4] = (byte)StartDayOfMonth.GetValueOrDefault(StartDayOfMonthNotSpecified);
bytes[5] = (byte)(durationType << 5 | (int)StartWeekdays);
bytes[6] = (byte)StartHour.GetValueOrDefault(StartHourNotSpecified);
bytes[7] = (byte)StartMinute.GetValueOrDefault(StartMinuteNotSpecified);
bytes[8] = durationByte1;
bytes[9] = durationByte2;
bytes[10] = 0; // reports to follow
bytes[11] = (byte)Commands.Length;
int index = 12;
foreach (var cmd in Commands)
{
bytes[index] = (byte)cmd.Command.Length;
index++;
Array.Copy(cmd.Command, 0, bytes, index, cmd.Command.Length);
index += cmd.Command.Length;
}
return(bytes);
}
void ReleaseDesignerOutlets()
{
if (DatePickerBar != null)
{
DatePickerBar.Dispose();
DatePickerBar = null;
}
if (DatePickerVacation != null)
{
DatePickerVacation.Dispose();
DatePickerVacation = null;
}
if (DateToolBar != null)
{
DateToolBar.Dispose();
DateToolBar = null;
}
if (DoneButton != null)
{
DoneButton.Dispose();
DoneButton = null;
}
if (EndDay != null)
{
EndDay.Dispose();
EndDay = null;
}
if (EndMonth != null)
{
EndMonth.Dispose();
EndMonth = null;
}
if (EndYear != null)
{
EndYear.Dispose();
EndYear = null;
}
if (Page != null)
{
Page.Dispose();
Page = null;
}
if (PageImage != null)
{
PageImage.Dispose();
PageImage = null;
}
if (StartDay != null)
{
StartDay.Dispose();
StartDay = null;
}
if (StartMonth != null)
{
StartMonth.Dispose();
StartMonth = null;
}
if (StartYear != null)
{
StartYear.Dispose();
StartYear = null;
}
if (StatusSegment != null)
{
StatusSegment.Dispose();
StatusSegment = null;
}
if (TypeImageView != null)
{
TypeImageView.Dispose();
TypeImageView = null;
}
if (TypeText != null)
{
TypeText.Dispose();
TypeText = null;
}
if (DatePickerToolbar != null)
{
DatePickerToolbar.Dispose();
DatePickerToolbar = null;
}
}
public string GetFullMonthNameAndYear()
{
return(string.Format("{0} to {1}", StartMonth.GetFullMonthNameAndYear(), EndMonth.GetFullMonthNameAndYear()));
}
public void GrupingPNC_Revision()
{
int StartMonth;
decimal All = 0;
decimal DMD = 0;
decimal D45 = 0;
decimal DMD_FS = 0;
decimal D45_FS = 0;
decimal DMD_FI = 0;
decimal D45_FI = 0;
decimal DMD_BI = 0;
decimal D45_BI = 0;
decimal DMD_FSBU = 0;
decimal D45_FSBU = 0;
Data_Import.Singleton().Load_TxtToDataTable2(ref PNC, "PNC");
Data_Import.Singleton().Load_TxtToDataTable2(ref SumPNC, "SumPNCBU");
switch (_Rev)
{
case "BU":
StartMonth = 1;
break;
case "EA1":
StartMonth = 3;
break;
case "EA2":
StartMonth = 6;
break;
case "EA3":
StartMonth = 9;
break;
default:
StartMonth = 0;
break;
}
if (StartMonth == 0)
{
return;
}
for (; StartMonth <= 12; StartMonth++)
{
if (!PNC.Columns.Contains(_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()))
{
MessageBox.Show("Missing Data for: " + _Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString(), "Attention!");
return;
}
if (SumPNC.Columns.Contains(_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()))
{
SumPNC.Columns.Remove(_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString());
}
SumPNC.Columns.Add(_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString());
foreach (DataRow PNCRow in PNC.Rows)
{
if (PNCRow[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] != null && PNCRow[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()].ToString() != "")
{
decimal Value = decimal.Parse(PNCRow[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()].ToString());
string PNC = PNCRow["BUPNC"].ToString();
//Dodanie do sumy wszystkich PNC
All += Value;
//Rozbiecie na DMD i D45
if (PNC.Remove(0, 3).Remove(1, 5) == "5")
{
//Dodanie do Sumy DMD
DMD += Value;
//Sprawdzenie czy FS, FI, BI/BU lub FSBU
switch (PNC.Remove(0, 4).Remove(1, 4))
{
case "1":
DMD_FS += Value;
break;
case "2":
DMD_BI += Value;
break;
case "3":
DMD_FI += Value;
break;
case "4":
DMD_FSBU += Value;
break;
default:
break;
}
}
else
{
//Dodanie do Sumy D45
D45 += Value;
switch (PNC.Remove(0, 4).Remove(1, 4))
{
case "5":
D45_FS += Value;
break;
case "6":
D45_BI += Value;
break;
case "7":
D45_FI += Value;
break;
case "8":
D45_FSBU += Value;
break;
default:
break;
}
}
}
}
foreach (DataRow Row in SumPNC.Rows)
{
switch (Row["PNC"].ToString())
{
case "All":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = All;
break;
case "DMD":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = DMD;
break;
case "D45":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = D45;
break;
case "DMD_FS":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = DMD_FS;
break;
case "D45_FS":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = D45_FS;
break;
case "DMD_FI":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = DMD_FI;
break;
case "D45_FI":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = D45_FI;
break;
case "DMD_BI":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = DMD_BI;
break;
case "D45_BI":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = D45_BI;
break;
case "DMD_FSBU":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = DMD_FSBU;
break;
case "D45_FSBU":
Row[_Rev + "/" + StartMonth.ToString() + "/" + _Year.ToString()] = D45_FSBU;
break;
default:
break;
}
}
All = 0;
DMD = 0;
D45 = 0;
DMD_BI = 0;
DMD_FI = 0;
DMD_FS = 0;
DMD_FSBU = 0;
D45_BI = 0;
D45_FI = 0;
D45_FS = 0;
D45_FSBU = 0;
}
Data_Import.Singleton().Save_DataTableToTXT2(ref SumPNC, "SumPNCBU");
}
