private void btnOprt_Click(object sender, EventArgs e)
{
if (flag == 1)
{
timeList.Clear();
TimeZone tz;
DataTableReader dr = null;
string tmp;
bool IsError = false;
try
{
dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "400" }));
while (dr.Read())
{
tz = new TimeZone();
tz.Init();
tz.TimeZoneID = Convert.ToInt32(dr["PassTimeID"].ToString());
for (int i = 0; i < (int)FKMax.TIME_SLOT_COUNT; i++)
{
tmp = dr["T" + (i + 1).ToString() + "S"].ToString();
tz.TimeSlots[i].StartHour = Convert.ToByte(tmp.Substring(0, 2));
tz.TimeSlots[i].StartMinute = Convert.ToByte(tmp.Substring(3, 2));
tmp = dr["T" + (i + 1).ToString() + "E"].ToString();
tz.TimeSlots[i].EndHour = Convert.ToByte(tmp.Substring(0, 2));
tz.TimeSlots[i].EndMinute = Convert.ToByte(tmp.Substring(3, 2));
}
timeList.Add(tz);
}
}
catch (Exception E)
{
IsError = true;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsError)
{
return;
}
}
else if (flag == 20)
{
fingerNoList.Clear();
DataTableReader dr = null;
bool IsError = false;
try
{
dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "508" }));
while (dr.Read())
{
fingerNoList.Add(Convert.ToUInt32(dr["FingerNo"].ToString()));
}
}
catch (Exception E)
{
IsError = true;
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
if (IsError)
{
return;
}
}
ExecMacOprt();
}
private bool MJTimeDownload(string MacSN, ref string MacMsg)
{
bool ret = true;
List <TimeZone> tzList = new List <TimeZone>();
byte[] byt = new byte[(int)FKMax.SIZE_TIME_ZONE_STRUCT];
TimeZone tz;
for (int i = 0; i < (int)FKMax.TIME_ZONE_COUNT; i++)
{
tz = new TimeZone();
tz.Init();
tz.TimeZoneID = i + 1;
DeviceObject.objFK623.StructToByteArray(tz, byt);
ret = DeviceObject.objFK623.HS_GetTimeZone(byt);
if (!ret)
{
break;
}
tz = (TimeZone)DeviceObject.objFK623.ByteArrayToStruct(byt, typeof(TimeZone));
tzList.Add(tz);
}
if (ret && tzList.Count > 0)
{
string sql = "";
DataTableReader dr = null;
string ID = "";
string Name = "";
string[] TS = new string[(int)FKMax.TIME_SLOT_COUNT];
string[] TE = new string[(int)FKMax.TIME_SLOT_COUNT];
try
{
for (int i = 0; i < tzList.Count; i++)
{
tz = tzList[i];
ID = tz.TimeZoneID.ToString();
for (int j = 0; j < (int)FKMax.TIME_SLOT_COUNT; j++)
{
TS[j] = string.Format("{0:d2}:{1:d2}", tz.TimeSlots[j].StartHour, tz.TimeSlots[j].StartMinute);
TE[j] = string.Format("{0:d2}:{1:d2}", tz.TimeSlots[j].EndHour, tz.TimeSlots[j].EndMinute);
}
dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "403", ID }));
if (dr.Read())
{
sql = Pub.GetSQL(DBCode.DB_000300, new string[] { "405", ID, Name, TS[0], TE[0], TS[1], TE[1],
TS[2], TE[2], TS[3], TE[3], TS[4], TE[4], TS[5], TE[5], OprtInfo.OprtNo });
}
else
{
sql = Pub.GetSQL(DBCode.DB_000300, new string[] { "404", ID, Name, TS[0], TE[0], TS[1], TE[1],
TS[2], TE[2], TS[3], TE[3], TS[4], TE[4], TS[5], TE[5], OprtInfo.OprtNo });
}
dr.Close();
SystemInfo.db.ExecSQL(sql);
}
}
catch (Exception E)
{
ret = false;
Pub.ShowErrorMsg(E, sql);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
}
return(ret);
}