private void btnOk_Click(object sender, EventArgs e) { string StartDate = "NULL"; string EndDate = "NULL"; DateTime StartDT; DateTime endDT; if (DateTime.TryParse(txtStartDate.Text, out StartDT)) { StartDate = "'" + StartDT.ToString(SystemInfo.SQLDateFMT) + "'"; } if (DateTime.TryParse(txtEndDate.Text, out endDT)) { EndDate = "'" + endDT.ToString(SystemInfo.SQLDateFMT) + "'"; } if (StartDT > endDT) { Pub.MessageBoxShow(Pub.GetResText("BaseDate", "Error001", "")); return; } string sql = ""; try { sql = Pub.GetSQL(DBCode.DB_000300, new string[] { "612", SysID, OprtInfo.OprtNo, StartDate, EndDate }); SystemInfo.db.ExecSQL(sql); } catch (Exception E) { Pub.ShowErrorMsg(E, sql); return; } SystemInfo.db.WriteSYLog(this.Text, CurrentOprt, sql); //Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Close(); }
public override string ToString() { return(String.Format("{0,20} {1,2} {2,20} {3,10} {4,15} {5,15}", PersonName, AgeAtEvent, EventName, role.ToString(), StartDT.ToString(), EndDT.ToString())); }
private void btnOk_Click(object sender, EventArgs e) { if (txtEmpNo.Text.Trim() == "" && cardGrid.DataSource == null) { txtEmpNo.Focus(); ShowErrorEnterCorrect(label2.Text); return; } string EmpSysID = txtEmpNo.Text; string StartDate = "NULL"; string EndDate = "NULL"; DateTime StartDT; DateTime endDT; if (DateTime.TryParse(txtStartDate.Text, out StartDT)) { StartDate = "'" + StartDT.ToString(SystemInfo.SQLDateFMT) + "'"; } if (DateTime.TryParse(txtEndDate.Text, out endDT)) { EndDate = "'" + endDT.ToString(SystemInfo.SQLDateFMT) + "'"; } if (StartDT > endDT) { Pub.MessageBoxShow(Pub.GetResText("BaseDate", "Error001", "")); return; } List <string> macList = new List <string>(); for (int i = 0; i < macGrid.RowCount; i++) { if (Pub.ValueToBool(macGrid[0, i].EditedFormattedValue)) { macList.Add(macGrid[1, i].Value.ToString()); // macList.Add(macGrid[2, i].Value.ToString()); } } if (macList.Count == 0) { Pub.MessageBoxShow(Pub.GetResText(formCode, "ErrorSelectMacOprt", "")); return; } List <string> sql = new List <string>(); DataTableReader dr = null; bool IsError = false; string MacSN; try { for (int i = 0; i < macList.Count; i++) { MacSN = macList[i]; if (EmpSysID != "") { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "553", MacSN, EmpSysID })); if (dr.Read()) { sql.Add(Pub.GetSQL(DBCode.DB_000300, new string[] { "555", MacSN, EmpSysID, OprtInfo.OprtNo, StartDate, EndDate })); } else { sql.Add(Pub.GetSQL(DBCode.DB_000300, new string[] { "554", MacSN, EmpSysID, OprtInfo.OprtNo, StartDate, EndDate })); } dr.Close(); } if (cardGrid.DataSource != null) { DataTable dtGrid = (DataTable)cardGrid.DataSource; string EmpNo; for (int j = 0; j < dtGrid.Rows.Count; j++) { EmpNo = dtGrid.Rows[j]["EmpNo"].ToString(); if (EmpNo == EmpSysID) { continue; } dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "553", MacSN, EmpNo })); if (dr.Read()) { sql.Add(Pub.GetSQL(DBCode.DB_000300, new string[] { "555", MacSN, EmpNo, OprtInfo.OprtNo, StartDate, EndDate })); } else { sql.Add(Pub.GetSQL(DBCode.DB_000300, new string[] { "554", MacSN, EmpNo, OprtInfo.OprtNo, StartDate, EndDate })); } dr.Close(); } } } } catch (Exception E) { IsError = true; Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (IsError) { return; } if (SystemInfo.db.ExecSQL(sql) != 0) { return; } SystemInfo.db.WriteSYLog(this.Text, CurrentOprt, sql); //Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Close(); }