private void btn_addD_Click(object sender, EventArgs e)
{
G_datetime = DateAndTime.DateAdd( //向時間欄位中新增一天
DateInterval.Day, 1, G_datetime);
lab_time.Text = G_datetime.ToString( //顯示時間訊息
"時間： yyyy年M月d日 H時m分s秒");
}
public void tryToSellectAllLines()
{
var timeout = DateAndTime.DateAdd(DateInterval.Second, 10, DateAndTime.Now);
GuiTableControl myTable;
GuiTableRow firstRow;
while (DateTime.Now < timeout)
{
// buggfix com objects late binding
System.Threading.Thread.Sleep(2000);
// buggfix - The data necessary to complete this operation is not yet available.
try {
myTable = (GuiTableControl)sap.findById(VA02ID.FIRST_ROW_OF_SALES_TAB_TABLE_ID.Where(x => sap.idExists(x)).First());
firstRow = (GuiTableRow)myTable.Rows.Item(1);
if (!firstRow.Selected)
{
sap.pressBtn(VA02ID.SELECT_ALL_BTN_ID.Where(x => sap.idExists(x)).First());
}
else
{
break;
}
} catch (Exception) {
}
}
}
/// <summary>
/// 使用DateAdd方法向指定日期添加一段时间间隔
/// </summary>
/// <param name="AddDateType">选择添加的类型[分,时,天]</param>
/// <param name="Date_details">添加的具体时间</param>
/// <param name="date">在指定的时间上添加【参数】</param>
/// <param name="error">反馈错误</param>
/// <returns></returns>
public static DateTime DateAdd(string AddDateType, int Date_details, DateTime date, ref string error)
{
DateTime G_datetime = date;
try {
switch (AddDateType)
{
case "Minute": //向时间字段中添加分钟
G_datetime = DateAndTime.DateAdd(DateInterval.Minute, Date_details, date);
break;
case "Hour": //添加小时
G_datetime = DateAndTime.DateAdd(DateInterval.Hour, Date_details, date);
break;
case "Day": //添加天数
G_datetime = DateAndTime.DateAdd(DateInterval.Day, Date_details, date);
break;
default:
break;
}
} catch (Exception ex) {
error = ex.ToString();
}
return(G_datetime);
}
private static void TinhThoiHanVe(int LoaiVe, int ThangQui, int Nam, ref DateTime NgayApDung, ref DateTime NgayHetHan)
{
checked
{
if (LoaiVe == 2)
{
string value = "01/01/" + Conversions.ToString(Nam);
DateTime dateTime = Conversions.ToDate(value);
dateTime = DateAndTime.DateAdd("m", (double)(ThangQui - 1), dateTime);
NgayApDung = dateTime;
dateTime = DateAndTime.DateAdd("m", 1.0, dateTime);
dateTime = DateAndTime.DateAdd("d", -1.0, dateTime);
NgayHetHan = dateTime;
}
else if (LoaiVe == 3)
{
string value = "01/01/" + Conversions.ToString(Nam);
DateTime dateTime = Conversions.ToDate(value);
int num = (ThangQui - 1) * 3;
dateTime = DateAndTime.DateAdd("m", (double)num, dateTime);
NgayApDung = dateTime;
dateTime = DateAndTime.DateAdd("m", 3.0, dateTime);
dateTime = DateAndTime.DateAdd("d", -1.0, dateTime);
NgayHetHan = dateTime;
}
}
}
internal static void NewInspection(Guid sectionID)
{
string str = "SELECT * FROM Inspection_Data WHERE [INSP_DATA_INSP_DATE]>=#" + Conversions.ToString(DateAndTime.DateAdd(DateInterval.Day, (double)checked (-1 * Inspection.IInspectionWindow), DateAndTime.Today)) + "# AND [INSP_DATA_SEC_ID]={" + sectionID.ToString() + "}";
DataTable dataTable1 = mdUtility.DB.GetDataTable(str);
DataTable dataTable2 = mdUtility.DB.GetDataTable("SELECT * FROM [Section Info] WHERE [sec_id]={" + sectionID.ToString() + "}");
DateTime dateTime = new frmDatePicker().ShowDialog(new DateTime?(DateAndTime.DateAdd(DateInterval.Day, (double)checked (-1 * Inspection.IInspectionWindow), DateAndTime.Today)), new DateTime?(DateAndTime.Today));
Guid guid;
if (dataTable1.Rows.Count == 0)
{
DataRow row = dataTable1.NewRow();
DataRow dataRow = row;
dataRow["INSP_DATA_SEC_ID"] = (object)sectionID;
guid = Guid.Parse(mdUtility.GetUniqueID());
dataRow["INSP_DATA_ID"] = (object)guid;
dataRow["inspectorlink"] = (object)mdUtility.strCurrentInspector;
dataRow["INSP_Source"] = (object)nameof(Inspection);
dataRow["INSP_DATA_INSP_DATE"] = (object)dateTime;
dataRow["INSP_DATA_SAMP"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(Microsoft.VisualBasic.CompilerServices.Operators.CompareString(mdUtility.fMainForm.CurrentLocation, "", false) == 0, (object)false, (object)true));
dataRow["bred_status"] = (object)"N";
dataRow["insp_data_type"] = (object)2;
dataTable1.Rows.Add(row);
mdUtility.DB.SaveDataTable(ref dataTable1, str);
Section.SectionMaterialLink(sectionID.ToString());
mdUtility.fMainForm.m_bInspNew = true;
}
else
{
object obj = dataTable1.Rows[0]["INSP_DATA_ID"];
guid = obj != null ? (Guid)obj : new Guid();
}
DataTable dataTable3 = mdUtility.DB.GetDataTable("SELECT SUM(SAMP_DATA_QTY) AS SAMP_QTY_SUM FROM Sample_Data WHERE [SAMP_DATA_INSP_DATA_ID]={" + guid.ToString() + "}");
DataTable tableSchema = mdUtility.DB.GetTableSchema("Sample_Data");
DataRow row1 = tableSchema.NewRow();
DataRow dataRow1 = row1;
dataRow1["BRED_Status"] = (object)"N";
dataRow1["samp_data_id"] = (object)mdUtility.GetUniqueID();
dataRow1["samp_data_insp_data_id"] = (object)guid;
double num = Conversions.ToDouble(Microsoft.VisualBasic.CompilerServices.Operators.SubtractObject(dataTable2.Rows[0]["sec_qty"], UtilityFunctions.FixDBNull(RuntimeHelpers.GetObjectValue(dataTable3.Rows[0]["SAMP_QTY_SUM"]), (object)0)));
dataRow1["samp_data_qty"] = RuntimeHelpers.GetObjectValue(Interaction.IIf(num < 0.0, (object)0, (object)num));
dataRow1["samp_data_paint"] = RuntimeHelpers.GetObjectValue(dataTable2.Rows[0]["sec_paint"]);
if (mdUtility.fMainForm.tvInspection.Visible && Microsoft.VisualBasic.CompilerServices.Operators.CompareString(mdUtility.fMainForm.CurrentLocation, "", false) != 0)
{
dataRow1["samp_data_loc"] = (object)mdUtility.fMainForm.tvInspection.GetNodeByKey(mdUtility.fMainForm.CurrentLocation).Tag.ToString();
}
tableSchema.Rows.Add(row1);
mdUtility.DB.SaveDataTable(ref tableSchema, "SELECT * FROM Sample_Data");
mdUtility.fMainForm.m_bSampleNew = true;
mdUtility.fMainForm.m_bInspLoaded = false;
Inspection.LoadInspectionDates(sectionID.ToString());
mdUtility.fMainForm.m_bInspLoaded = true;
mdUtility.fMainForm.SetInspChanged(true);
if (!mdUtility.fMainForm.txtSQuantity.Visible)
{
return;
}
mdUtility.fMainForm.txtSQuantity.Focus();
}
private void AzurirajDatumObracunaStaza(object sender, EventArgs e)
{
bool flag = false;
if (Operators.ConditionalCompareObjectEqual(this.datumobracunastaza.Value, DateAndTime.DateSerial(0x7d0, 1, 1), false))
{
flag = true;
}
if (((decimal.Compare(DB.N20(RuntimeHelpers.GetObjectValue(this.godinaobracuna.Value)), decimal.Zero) > 0) & (decimal.Compare(DB.N20(RuntimeHelpers.GetObjectValue(this.mjesecobracuna.Value)), decimal.Zero) > 0)) && ((DateTime.Compare(DateTime.Parse(Conversions.ToString(this.datumobracunastaza.Value)), DateAndTime.DateSerial(Conversions.ToInteger(this.godinaobracuna.Value), Conversions.ToInteger(this.mjesecobracuna.Value), DateTime.DaysInMonth(Conversions.ToInteger(this.godinaobracuna.Value), 1))) < 0) | (DateTime.Compare(DateTime.Parse(Conversions.ToString(this.datumobracunastaza.Value)), DateAndTime.DateSerial(Conversions.ToInteger(this.godinaobracuna.Value), Conversions.ToInteger(this.mjesecobracuna.Value), DateTime.DaysInMonth(Conversions.ToInteger(this.godinaobracuna.Value), Conversions.ToInteger(this.mjesecobracuna.Value)))) > 0)))
{
flag = true;
}
if (flag)
{
try
{
this.datumobracunastaza.Value = DateAndTime.DateSerial(Conversions.ToInteger(this.godinaobracuna.Value), Conversions.ToInteger(this.mjesecobracuna.Value), 1);
this.datumobracunastaza.Value = DateAndTime.DateAdd(DateInterval.Day, -1.0, Conversions.ToDate(this.datumobracunastaza.Value));
}
catch (System.Exception exception1)
{
throw exception1;
}
}
}
public int CalculateUPH()
{
DateTime ProductDate = default(DateTime);
DateTime DateBeforeOneHour = default(DateTime);
int UphCounts = 0;
DateBeforeOneHour = DateAndTime.DateAdd("h", -1, DateTime.Now);
for (int i = 0; i <= 500; i++)
{
ProductDate = PVar.tmpCpkData.ProTime[i];
if (DateTime.Compare(ProductDate, DateBeforeOneHour) == 1)
{
UphCounts++;
}
}
if (UphCounts < 100)
{
this.UPH.BZ_Color = Color.FromArgb(253, 253, 191);
}
else
{
this.UPH.BZ_Color = PVar.BZColor_SelectedBtn;
}
return(UphCounts);
}
private void cboContractTime_EditValueChanged(object sender, EventArgs e)
{
if (this.cboContractTime.SelectedIndex == 0)
{
this.dtToDate.DateTime = DateAndTime.DateAdd(DateInterval.Month, 2, this.dtFromDate.DateTime);
}
else if (this.cboContractTime.SelectedIndex == 1)
{
this.dtToDate.DateTime = DateAndTime.DateAdd(DateInterval.Month, 3, this.dtFromDate.DateTime);
}
else if (this.cboContractTime.SelectedIndex == 2)
{
this.dtToDate.DateTime = DateAndTime.DateAdd(DateInterval.Month, 6, this.dtFromDate.DateTime);
}
else if (this.cboContractTime.SelectedIndex == 3)
{
this.dtToDate.DateTime = DateAndTime.DateAdd(DateInterval.Month, 9, this.dtFromDate.DateTime);
}
else if (this.cboContractTime.SelectedIndex == 4)
{
this.dtToDate.DateTime = DateAndTime.DateAdd(DateInterval.Year, 1, this.dtFromDate.DateTime);
}
else if (this.cboContractTime.SelectedIndex == 5)
{
this.dtToDate.DateTime = DateAndTime.DateAdd(DateInterval.Year, 2, this.dtFromDate.DateTime);
}
else if (this.cboContractTime.SelectedIndex == 6)
{
this.dtToDate.DateTime = DateAndTime.DateAdd(DateInterval.Year, 3, this.dtFromDate.DateTime);
}
}
public OrderStatus isChangeNeeded()
{
var timeout = DateAndTime.DateAdd(DateInterval.Second, 10, DateAndTime.Now);
string blockID = VA02ID.DEL_BLOCK_ID.Where(x => sap.idExists(x)).First();
string paymentTermsID = VA02ID.PAYMENT_TERMS_ID.Where(x => sap.idExists(x)).First();
//default as available just in case code will not be able to get the real status
OrderStatus tempStatus = OrderStatus.available;
while (DateTime.Now < timeout)
{
System.Threading.Thread.Sleep(2000);
try {
if (!(sap.findById(blockID) as dynamic).Changeable)
{
tempStatus = OrderStatus.realeasedOrRejected;
break;
}
else if ((sap.findById(paymentTermsID) as dynamic).text == "")
{
tempStatus = OrderStatus.orderMissingPaymentTerms;
break;
}
else
{
tempStatus = OrderStatus.available;
break;
}
} catch (Exception) {
}
}
return(tempStatus);
}
//-- Play a note by number (0-127), specifying a velocity value (0-127)
public void PlayNote(byte Note, byte Velocity)
{
byte Msg = 0;
Int32 MidiMsg = default(Int32);
if (_Engaged == false)
{
return;
}
Msg = StuffByte(GetByte(MIDIStatusMessages.NoteOn), _OutputChannel);
MidiMsg = StuffInt32(Msg, GetByte(Note + _Transpose), Velocity, 0);
try
{
MIDI.midiOutShortMsg(hMidiOUT, MidiMsg);
if (_NoteDuration > 0)
{
NotesOff no = default(NotesOff);
no.Note = GetByte(Note + _Transpose);
no.ShutoffTime = DateAndTime.DateAdd(DateInterval.Second, _NoteDuration, DateAndTime.Now);
lock (notesToTurnOff)
{
notesToTurnOff.Add(no);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void LoadAlarmHistoryData(DateTime FirstDay, DateTime LastDay)
{
AlarmStatistics tmpSt = new AlarmStatistics();
string tmpDate = "";
string tmpString = "";
int tmpNum = 0;
m_AlarmHistoryDataList.Clear();
for (int i = 0; i <= (LastDay - FirstDay).TotalDays; i++)
{
tmpDate = System.Convert.ToString(DateAndTime.DateAdd("d", System.Convert.ToDouble(-i), LastDay).ToString("yyyyMMdd"));
tmpNum = int.Parse(BVar.FileRorW.ReadINI(tmpDate, "TotalAlarmNum", "0", "D:\\BZ-Parameter\\BAM\\AlarmHistoryData.ini"));
if (tmpNum <= 0)
{
continue;
}
for (int j = tmpNum; j >= 1; j--)
{
tmpString = BVar.FileRorW.ReadINI(tmpDate, "Alarm" + (j).ToString(), "00:00:00,00:00:00,F0000,Not Known", "D:\\BZ-Parameter\\BAM\\AlarmHistoryData.ini");
FormatAlarmHistoryString(tmpSt, tmpString);
tmpSt.dDate = DateAndTime.DateAdd("d", System.Convert.ToDouble(-i), LastDay);
m_AlarmHistoryDataList.Add(tmpSt);
}
}
AlarmDataGridView_CellContentClick(null, null);
for (var i = 30; i <= 50; i++)
{
BVar.FileRorW.DelIniSec(System.Convert.ToString(DateAndTime.DateAdd("d", System.Convert.ToDouble(-i), DateTime.Now.Date).ToString("yyyyMMdd")), "D:\\BZ-Parameter\\BAM\\AlarmHistoryData.ini");
}
}
private void specifficDeliveryDayAction(RddOutputBean rdd)
{
string deliveryDaysAccepted = Regex.Replace(rdd.deliveryDay, "[^a-zA-Z]", "");
if (!string.IsNullOrEmpty(deliveryDaysAccepted))
{
while (!deliveryDaysAccepted.ToLower().Contains(Microsoft.VisualBasic.Strings.Format(tempDate, "dddd").ToLower()) || bankHolidayList.Where(x => x.nationalDate == tempDate).Count() > 0)
{
tempDate = DateAndTime.DateAdd(DateInterval.Day, 1, tempDate);
}
}
// changes block to hold order if the order is not short lead time
if (tempDate != rdd.oldRdd)
{
if (!((tempDelBlock ?? "") == IDAConsts.DelBlocks.leadTimeBlock) && !rdd.isRddChangeAllowed)
{
tempDelBlock = IDAConsts.DelBlocks.holdOrderBlock;
tempReason += $"Holding order to contact the customer for changing RDD to recommended specific acceptance day - {Microsoft.VisualBasic.Strings.Format(tempDate, "dddd")}.{Constants.vbCr}";
}
else
{
tempReason += $"Changing RDD to recommended specific acceptance day - {Microsoft.VisualBasic.Strings.Format(tempDate, "dddd")}.{Constants.vbCr}";
}
}
}
private void btn_addD_Click(object sender, EventArgs e)
{
G_datetime = DateAndTime.DateAdd( //向时间字段中添加一天
DateInterval.Day, 1, G_datetime);
lab_time.Text = G_datetime.ToString( //显示时间信息
"时间： yyyy年M月d日 H时m分s秒");
}
public static string TimeToUnix(DateTime dteDate)
{
if (dteDate.IsDaylightSavingTime())
{
dteDate = DateAndTime.DateAdd(DateInterval.Hour, -1.0, dteDate);
}
return(Conversions.ToString(DateAndTime.DateDiff(DateInterval.Second, new DateTime(621355968000000000L), dteDate)));
}
private void Frm_Production_Load(object sender, EventArgs e)
{
this.Location = PVar.ChildFrmOffsetPoint;
this.Size = new Size(1020, 660);
this.BackColor = Frm_Main.fMain.Main_Color;
this.AlarmStatus.BZ_ShowMode = true;
this.AlarmStatus.ForeColor = Color.Black;
this.AlarmStatus.BZ_Color = PVar.BZColor_SelectedBtn;
this.AlarmStatus.Text = "No Alarm";
this.AlarmTime.ForeColor = Color.Black;
this.AlarmTime.BZ_Color = PVar.BZColor_SelectedBtn;
this.AlarmTime.BZ_SmallText = "Alarm Time";
this.AlarmTime.BZ_BigText = "00:16:58";
this.UPH.ForeColor = Color.Black;
this.UPH.BZ_Color = Color.FromArgb(253, 253, 191);
this.UPH.BZ_SmallText = "UPH";
this.UPH.BZ_BigText = "230";
this.MaterialLevel.ForeColor = Color.Black;
this.MaterialLevel.BZ_Color = PVar.BZColor_SelectedBtn;
this.MaterialLevel.BZ_SmallText = "Material";
this.MaterialLevel.BZ_BigText = "High";
Lbl_StartTime.Text = System.Convert.ToString(DateAndTime.DateAdd("d", 0, DateTime.Now).ToString("MM/dd/yy"));
Lbl_EndTime.Text = System.Convert.ToString(DateAndTime.DateAdd("d", -29, DateTime.Now).ToString("MM/dd/yy"));
int SelectNum;
if (FileRw.IniGetNValue(PVar.UIChartCurveName, "CurveData", "TotalNum", 0) == 49)
{
SelectNum = 49;
}
else
{
SelectNum = (int)(FileRw.IniGetNValue(PVar.UIChartCurveName, "CurveData", "CurrentNum", 0));
}
Force_S3.BZ_BackColor = PVar.BZColor_SelectedBtn;
Force_S2.BZ_BackColor = Color.LightGray;
BTN_X.BZ_BackColor = PVar.BZColor_SelectedBtn;
BTN_Y.BZ_BackColor = Color.LightGray;
BTN_CC.BZ_BackColor = Color.LightGray;
BTN_A.BZ_BackColor = Color.LightGray;
Cpk_X.BZ_BackColor = PVar.BZColor_SelectedBtn;
Cpk_Y.BZ_BackColor = Color.LightGray;
Cpk_CC.BZ_BackColor = Color.LightGray;
Cpk_A.BZ_BackColor = Color.LightGray;
Btn_Yield_Click(sender, e); //显示Retest和NG率
UPH.BZ_BigText = System.Convert.ToString(CalculateUPH());
BTN_X_Click(BTN_X, e);
Cpk_X_Click(Cpk_X, e);
LoadYield();
Frm_Engineering.fEngineering.SetChart(chartForce);
this.Chart_Time.Elapsed += new System.Timers.ElapsedEventHandler(this.Chart_Time_Elapsed);
Chart_Time.Enabled = true;
}
public static DateTime ToDate(byte[] data)
{
long num3 = BytesToLong(data);
int num = (int)(num3 / 60L);
int num2 = (int)(num3 % 60L);
DateTime dateValue = new DateTime(0x7b2, 1, 1);
return(DateAndTime.DateAdd(DateInterval.Minute, num, dateValue).AddSeconds(num2));
}
private static ICollection <ActivityChangeDataItem> GetActivityChangeData(byte[] data, string dailyPresenceCounter)
{
List <ActivityChangeDataItem> result = new List <ActivityChangeDataItem>();
int changeDataLength = data.Length / 2;
int counter = changeDataLength - 1;
for (int i = 0; i <= counter; i++)
{
ActivityChangeDataItem changeDataItem = new ActivityChangeDataItem();
changeDataItem.DailyPresenceCounter = dailyPresenceCounter;
changeDataItem.Slot = RuntimeHelpers.GetObjectValue(Interaction.IIf((BinaryHelper.BytesToLong(BinaryHelper.SubByte(data, (2 * i) + 1, 1)) & 0x80L) == 0x80L, "Co-Driver", "Driver")).ToString();
changeDataItem.CardStatus = RuntimeHelpers.GetObjectValue(Interaction.IIf((BinaryHelper.BytesToLong(BinaryHelper.SubByte(data, (2 * i) + 1, 1)) & 0x20L) == 0x20L, "Not Inserted", "Inserted")).ToString();
if (changeDataItem.CardStatus == "Inserted")
{
changeDataItem.DrivingStatus = RuntimeHelpers.GetObjectValue(Interaction.IIf((BinaryHelper.BytesToLong(BinaryHelper.SubByte(data, (2 * i) + 1, 1)) & 0x40L) == 0x40L, "Crew", "Single")).ToString();
}
else
{
changeDataItem.DrivingStatus = RuntimeHelpers.GetObjectValue(Interaction.IIf((BinaryHelper.BytesToLong(BinaryHelper.SubByte(data, (2 * i) + 1, 1)) & 0x40L) == 0x40L, "Known", "Unknown")).ToString();
}
if (changeDataItem.DrivingStatus == "Not Inserted" || changeDataItem.DrivingStatus == "Unknown")
{
changeDataItem.Activity = "";
}
else
{
switch (((int)(BinaryHelper.BytesToLong(BinaryHelper.SubByte(data, (2 * i) + 1, 1)) & 0x18L)))
{
case 0:
changeDataItem.Activity = "Rest";
break;
case 8:
changeDataItem.Activity = "Available";
break;
case 0x10:
changeDataItem.Activity = "Work";
break;
case 0x18:
changeDataItem.Activity = "Drive";
break;
}
}
changeDataItem.Time = DateAndTime.DateAdd(DateInterval.Minute, BinaryHelper.BytesToLong(BinaryHelper.SubByte(data, (2 * i) + 1, 2)) & 0x7ffL, new DateTime(SqlDateTime.MinValue.Value.Year, SqlDateTime.MinValue.Value.Month, SqlDateTime.MinValue.Value.Day));
result.Add(changeDataItem);
}
return(result);
}
public void Add()
{
Csla.SmartDate d2 = new Csla.SmartDate();
Csla.SmartDate d3;
d2.Date = new DateTime(2005, 1, 1);
d3 = new Csla.SmartDate(d2.Add(new TimeSpan(30, 0, 0, 0)));
Assert.AreEqual(DateAndTime.DateAdd(DateInterval.Day, 30, d2.Date), d3.Date, "Dates should be equal");
Assert.AreEqual(d3, d2 + new TimeSpan(30, 0, 0, 0, 0), "Dates should be equal");
}
private void InitData()
{
DateTime dateTime = new DateTime(this.m_Year, this.m_Month, 1);
this.teFromDate.EditValue = dateTime;
this.teToDate.EditValue = DateAndTime.DateAdd(DateInterval.Day, -1, DateAndTime.DateAdd(DateInterval.Month, 1, dateTime));
this.calFromRow.EditValue = 1;
this.calToRow.EditValue = 1;
this.clbShift.Items.Clear();
(new DIC_SHIFT()).AddCheckedListBox(this.clbShift);
}
private void Frm_AlarmHistoryInfo_Paint(object sender, PaintEventArgs e)
{
DateTime LastDay = default(DateTime);
DateTime FirstDay = default(DateTime);
LastDay = DateAndTime.DateAdd("d", -0, DateTime.Now.Date);
FirstDay = DateAndTime.DateAdd("d", -30, DateTime.Now.Date);
LoadAlarmHistoryData(FirstDay, LastDay);
LoadAlarmHistoryToDataGrid();
LoadAlarmHistoryToPieChart();
}
/// <summary>
/// Implements the DATEADD function
/// </summary>
/// <param name="datepart">The part of <paramref name="date"/> to which DATEADD adds an integer <paramref name="number"/></param>
/// <param name="number">The value to add to the <paramref name="datepart"/> of the <paramref name="date"/></param>
/// <param name="date">The date value to add to</param>
/// <returns>The modified date</returns>
/// <see href="https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-ver15"/>
public static DateTime?DateAdd(string datepart, double?number, DateTime?date)
{
if (number == null || date == null)
{
return(null);
}
var interval = DatePartToInterval(datepart);
return(DateAndTime.DateAdd(interval, number.Value, date.Value));
}
public void Subtract()
{
Csla.SmartDate d2 = new Csla.SmartDate();
Csla.SmartDate d3;
d2.Date = new DateTime(2005, 1, 1);
d3 = new Csla.SmartDate(d2.Subtract(new TimeSpan(30, 0, 0, 0)));
Assert.AreEqual(DateAndTime.DateAdd(DateInterval.Day, -30, d2.Date), d3.Date, "Dates should be equal");
Assert.AreEqual(30, ((TimeSpan)(d2 - d3)).Days, "Should be 30 days different");
Assert.AreEqual(d3, d2 - new TimeSpan(30, 0, 0, 0, 0), "Should be equal");
}
private static void ThreadStartDisplay()
{
frmSplash.f = new frmSplash();
frmSplash.f.Show();
DateTime now = DateAndTime.Now;
while (DateTime.Compare(DateAndTime.Now, DateAndTime.DateAdd(DateInterval.Second, 2.0, now)) <= 0)
{
Thread.Sleep(100);
Application.DoEvents();
}
frmSplash.FadeOut((Form)frmSplash.f);
}
private void TrackBar_tossing_Scroll(object sender, EventArgs e)
{
string XDate = "";
int SelectData = 0;
SelectData = TrackBar_tossing.Value;
for (var i = 0; i <= SelectData - 1; i++)
{
XDate = System.Convert.ToString(DateAndTime.DateAdd("d", System.Convert.ToDouble(-i), DateTime.Now.Date).ToString("yyyyMMdd"));
PVar.StorXData[(int)i] = System.Convert.ToString(DateAndTime.DateAdd("d", System.Convert.ToDouble(-i), DateTime.Now.Date).ToString("MM/dd"));
PVar.StorTossing[(int)i] = double.Parse(FileRw.IniGetStringValue(PVar.UIChartYieldOverViewName, XDate, "Tossing", "0")); //当天抛料率
}
FileRw.Chart_Curve(Chart_Tossing, "Tossing(Unit:%)", "", "", "Tossing", PVar.StorXData, PVar.StorTossing, 0, 0, 0, false);
}
public DateTime GetVersionDate()
{
string directoryPath = Class33.Class31_0.Info.DirectoryPath;
string assemblyName = Class33.Class31_0.Info.AssemblyName;
byte[] rawAssembly = File.ReadAllBytes(directoryPath + "/" + assemblyName + ".dll");
string text = Assembly.Load(rawAssembly).GetName().Version.ToString();
text = text.Split(new char[]
{
'.'
})[2];
return(DateAndTime.DateAdd("d", (double)Conversions.ToLong(text), new DateTime(630822816000000000L)));
}
private static bool CanAddInspection(string SectionID)
{
DateTime dateTime = DateAndTime.DateAdd(DateInterval.Day, (double)checked (-1 * Inspection.IInspectionWindow), DateAndTime.Today);
DataTable dataTable = mdUtility.DB.GetDataTable("SELECT [INSP_DATA_ID] FROM Inspection_Data WHERE [insp_data_sec_id]={" + SectionID + "} AND ([INSP_DATA_INSP_DATE]>=#" + Conversions.ToString(dateTime) + "# AND [INSP_Source] <> 'InstallDate') AND (BRED_Status <> 'D' OR BRED_Status IS NULL)");
if (dataTable.Rows.Count == 0)
{
return(true);
}
if ((uint)Microsoft.VisualBasic.CompilerServices.Operators.CompareString(mdUtility.fMainForm.CurrentLocation.ToString(), "", false) <= 0U)
{
return(false);
}
return(Microsoft.VisualBasic.CompilerServices.Operators.ConditionalCompareObjectEqual(mdUtility.DB.GetDataTable("SELECT Count(SAMP_DATA_ID) FROM Sample_Data WHERE [SAMP_DATA_INSP_DATA_ID]={" + dataTable.Rows[0]["INSP_DATA_ID"].ToString() + "} AND SAMP_DATA_LOC={" + Strings.Replace(mdUtility.fMainForm.tvInspection.GetNodeByKey(mdUtility.fMainForm.CurrentLocation).Tag.ToString(), "'", "''", 1, -1, CompareMethod.Binary) + "}").Rows[0][0], (object)0, false));
}
public void LoadYield()
{
PVar.NgCountOfDay = int.Parse(BVar.FileRorW.ReadINI("ProductCount", "NgCountOfDay", System.Convert.ToString(0), PVar.BZ_YieldDataFileName)); //当天NG数量
PVar.NgCountOfMonth = int.Parse(BVar.FileRorW.ReadINI("ProductCount", "NgCountOfMonth", System.Convert.ToString(0), PVar.BZ_YieldDataFileName)); //当月NG数量
PVar.ProductCountOfDay = int.Parse(BVar.FileRorW.ReadINI("ProductCount", "ProductCountOfDay", System.Convert.ToString(0), PVar.BZ_YieldDataFileName)); //当天总数量
PVar.ProductCountOfMonth = int.Parse(BVar.FileRorW.ReadINI("ProductCount", "ProductCountOfMonth", System.Convert.ToString(0), PVar.BZ_YieldDataFileName)); //当月总数量
PVar.RecordTimeOfDate = BVar.FileRorW.ReadINI("ProductTime", "RecordTimeOfDate", System.Convert.ToString(DateAndTime.DateAdd("d", -30, DateTime.Now).ToString("yyyyMMdd")), PVar.BZ_YieldDataFileName); //系统现在时间
PVar.RecordTimeOfMonth = BVar.FileRorW.ReadINI("ProductTime", "RecordTimeOfMonth", DateTime.Now.ToString("yyyyMMdd"), PVar.BZ_YieldDataFileName); //系统开始记录日期
PVar.DayYieldOfNg = System.Convert.ToDouble(PVar.ProductCountOfDay == 0 ? 0 : (((double)PVar.NgCountOfDay / PVar.ProductCountOfDay) * 100));
this.DRB_YieldRetest.BZ_NgRateDay = (int)PVar.DayYieldOfNg; //日Ng率
PVar.MonthYieldOfNg = System.Convert.ToDouble(PVar.ProductCountOfMonth == 0 ? 0 : (((double)PVar.NgCountOfMonth / PVar.ProductCountOfMonth) * 100));
this.DRB_YieldRetest.BZ_NgRateMonth = (int)PVar.MonthYieldOfNg; //月Ng率
this.Lbl_StartTime.Text = System.Convert.ToString(DateAndTime.DateAdd("d", -30, DateTime.Now).ToString("MM/dd/yy")); //开始日期为当前往前30天
this.Lbl_EndTime.Text = DateTime.Now.ToString("MM/dd/yy"); //结束日期为当前日期
}
private bool isPLAndCZExpection(int orderNumber, string id, string tableName, string salesOrg)
{
if (salesOrg == "PL01" || salesOrg == "CZ01")
{
var timeout = DateAndTime.DateAdd(DateInterval.Second, 10, DateAndTime.Now);
// buggfix - The data necessary to complete this operation is not yet available.
while (DateTime.Now < timeout)
{
System.Threading.Thread.Sleep(2000);
try {
if (!sap.idExists(VA02ID.TOTAL_ORDER_CASES_FIELD_ID))
{
(sap.findById(VA02ID.ADDITIONAL_INFO_B_TAB_ID) as dynamic).Select();
}
else
{
break;
}
} catch (Exception) {
}
}
string orderQty = (sap.findById(VA02ID.TOTAL_ORDER_CASES_FIELD_ID) as dynamic).Text();
string confirmedQty = (sap.findById(VA02ID.TOTAL_CONFIRMED_CASES_FIELD_ID) as dynamic).Text();
if (orderQty != confirmedQty)
{
log.update(
tableName,
columnNames: new[] { "endTime", "status", "reason" },
values: new[] { Strings.Format(DateTime.Now, "yyyyMMdd HH:mm:ss"), "fail", "Could not change route codes as the CFR becomes lower than 100%" },
conditionName: new[] { "orderNumber", "id" },
conditionValue: new[] { orderNumber.ToString(), id, });
return(true);
}
else
{
sap.goBack();
return(false);
}
}
else
{
return(false);
}
}
public DateTime getNextWorkingDay(DateTime d, RddOutputBean rdd)
{
bool isUpdated = false;
while (getIncreaseDayCondition(d, rdd))
{
d = DateAndTime.DateAdd(DateInterval.Day, 1, d);
isUpdated = true;
}
if (!isUpdated)
{
d = DateAndTime.DateAdd(DateInterval.Day, 1, d);
}
return(d);
}
private void Frm_AlarmInfo_Load(object sender, EventArgs e)
{
this.Location = PVar.ChildFrmOffsetPoint;
this.Size = new Size(1020, 660);
this.BackColor = Frm_Main.fMain.Main_Color;
AlarmDataViewInit();
DateTime LastDay = default(DateTime);
DateTime FirstDay = default(DateTime);
LastDay = DateAndTime.DateAdd("d", -0, DateTime.Now.Date);
FirstDay = DateAndTime.DateAdd("d", -30, DateTime.Now.Date);
LoadAlarmHistoryData(FirstDay, LastDay);
LoadAlarmHistoryToDataGrid();
LoadAlarmHistoryToPieChart();
}