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