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