private void LoadData() { string IsFirstCard = ""; string MacFirstCard = ""; DataTableReader dr = null; cbbMode1.Items.Clear(); cbbMode2.Items.Clear(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } TCommonType ctype; dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "110" })); while (dr.Read()) { ctype = new TCommonType(dr["MacDoorCommandWaySysID"].ToString(), dr["MacDoorCommandWayID"].ToString(), dr["MacDoorCommandWayName"].ToString(), true); cbbMode1.Items.Add(ctype); cbbMode2.Items.Add(ctype); } dr.Close(); cbbMode1.SelectedIndex = 0; cbbMode2.SelectedIndex = 0; dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "102", SysID })); if (dr.Read()) { IsFirstCard = dr["IsFirstCard"].ToString(); MacFirstCard = dr["MacFirstCard"].ToString(); } dr.Close(); TMacFirstCard card = new TMacFirstCard(MacFirstCard); txtBeginTime.Text = card.StartTime; txtEndTime.Text = card.EndTime; SetWayIndex(cbbMode1, card.Way[0]); SetWayIndex(cbbMode2, card.Way[1]); checkBox1.Checked = card.Week[6] == 1; checkBox2.Checked = card.Week[0] == 1; checkBox3.Checked = card.Week[1] == 1; checkBox4.Checked = card.Week[2] == 1; checkBox5.Checked = card.Week[3] == 1; checkBox6.Checked = card.Week[4] == 1; checkBox7.Checked = card.Week[5] == 1; if (card.EmpList != "") { string sql = ""; if (SystemInfo.HasFaCard) { sql = Pub.GetSQL(DBCode.DB_003001, new string[] { "108", card.EmpList }); } else { sql = Pub.GetSQL(DBCode.DB_003001, new string[] { "301", card.EmpList }); } dr = db.GetDataReader(sql); while (dr.Read()) { QuickSearchNormalCardByEmpSysID(dr["EmpSysID"].ToString(), cardGrid, MaxCard); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } chkEnabled.Checked = IsFirstCard.ToUpper() == "Y"; chkEnabled_CheckedChanged(null, null); }
protected override bool ExecMacDoorCommand(byte flag, TMJDoorInfo doorInfo, ref string MacMsg) { bool ret = base.ExecMacDoorCommand(flag, doorInfo, ref MacMsg); bool IsError = false; int Index = 0; string cardNo = ""; switch (flag) { case 0: QHKS.TMJFirstCardInfo cardInfo = new QHKS.TMJFirstCardInfo(); cardInfo.DoorID = Convert.ToByte(doorInfo.DoorID); cardInfo.CommandWay = new byte[2]; cardInfo.Week = new byte[7]; cardInfo.StartTime = "00:00"; cardInfo.EndTime = "00:00"; cardInfo.CardList = new string[10]; if (doorInfo.ExtField[0] == "Y") { TMacFirstCard card = new TMacFirstCard(doorInfo.ExtField[1]); for (int i = 0; i < 2; i++) { cardInfo.CommandWay[i] = card.Way[i]; } for (int i = 0; i < 7; i++) { cardInfo.Week[i] = card.Week[i]; } cardInfo.StartTime = card.StartTime; cardInfo.EndTime = card.EndTime; if (card.EmpList != "") { DataTableReader dr = null; try { string sql = ""; if (SystemInfo.HasFaCard) { sql = Pub.GetSQL(DBCode.DB_003001, new string[] { "108", card.EmpList }); } else { sql = Pub.GetSQL(DBCode.DB_003001, new string[] { "301", card.EmpList }); } dr = db.GetDataReader(sql); while (dr.Read()) { cardNo = dr["OtherCardNo"].ToString(); if (SystemInfo.AdvUseOtherCard && cardNo != "") { cardInfo.CardList[Index] = "1-" + cardNo; } else { cardInfo.CardList[Index] = dr["CardPhysicsNo10"].ToString(); } Index += 1; } } catch (Exception E) { IsError = true; Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } } for (int i = Index; i < 10; i++) { cardInfo.CardList[i] = ""; } } if (!IsError) { ret = DeviceObject.objMJ.SetMacFirstCardInfo(ref cardInfo); } break; } return(ret); }
protected override bool ExecMacDoorCommand(byte flag, TMJDoorInfo doorInfo, ref string MacMsg) { bool ret = base.ExecMacDoorCommand(flag, doorInfo, ref MacMsg); bool IsError = false; int Index = 0; UInt32 cardNo = 0; switch (flag) { case 0: AccessV2API.TYPE_DoorExpert_First cardInfo = new AccessV2API.TYPE_DoorExpert_First(); cardInfo.CardNo = new UInt32[10]; cardInfo.WeekConfig = new byte[8]; if (doorInfo.ExtField[0] == "Y") { TMacFirstCard card = new TMacFirstCard(doorInfo.ExtField[1]); cardInfo.InsideMode = card.Way[0]; cardInfo.OutsideMode = card.Way[1]; for (int i = 0; i < 7; i++) { if (card.Week[i] == 0) { cardInfo.WeekConfig[i] = 1; } else { cardInfo.WeekConfig[i] = 0; } } if (card.StartTime.Length == 5) { cardInfo.TimeBegin.wHour = Convert.ToUInt16(card.StartTime.Substring(0, 2)); cardInfo.TimeBegin.wMinute = Convert.ToUInt16(card.StartTime.Substring(3, 2)); } if (card.EndTime.Length == 5) { cardInfo.TimeEnd.wHour = Convert.ToUInt16(card.EndTime.Substring(0, 2)); cardInfo.TimeEnd.wMinute = Convert.ToUInt16(card.EndTime.Substring(3, 2)); } if (card.EmpList != "") { DataTableReader dr = null; try { string sql = ""; if (SystemInfo.HasFaCard) { sql = Pub.GetSQL(DBCode.DB_003001, new string[] { "108", card.EmpList }); } else { sql = Pub.GetSQL(DBCode.DB_003001, new string[] { "301", card.EmpList }); } dr = db.GetDataReader(sql); while (dr.Read()) { UInt32.TryParse(dr["OtherCardNo"].ToString(), out cardNo); if (SystemInfo.AdvUseOtherCard && cardNo > 0) { cardInfo.CardNo[Index] = cardNo; } else { UInt32.TryParse(dr["CardPhysicsNo10"].ToString(), out cardInfo.CardNo[Index]); } Index++; } } catch (Exception E) { IsError = true; Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } } } if (!IsError) { AccessV2API.TYPE_DoorBasic basic = new AccessV2API.TYPE_DoorBasic(); AccessV2API.TYPE_DoorExpert expert = new AccessV2API.TYPE_DoorExpert(); ret = DeviceObject.objMJNew.ReadDoorInfo(doorInfo.DoorID, ref basic, ref expert); if (ret) { expert.ExpertFirstCard = cardInfo; if (doorInfo.ExtField[0] == "Y") { expert.EnableFirstCard = 1; } else { expert.EnableFirstCard = 0; } ret = DeviceObject.objMJNew.SetDoorExpertInfo(doorInfo.DoorID, expert); } } break; } return(ret); }