private void LoadData()
{
string IsInoutCard = "";
string MacInoutCard = "";
DataTableReader dr = null;
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "102", SysID }));
if (dr.Read())
{
IsInoutCard = dr["IsInoutCard"].ToString();
MacInoutCard = dr["MacInoutCard"].ToString();
}
dr.Close();
TInOutCard card = new TInOutCard(MacInoutCard);
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 = IsInoutCard.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.TMJInOutCardInfo cardInfo = new QHKS.TMJInOutCardInfo();
cardInfo.DoorID = Convert.ToByte(doorInfo.DoorID);
cardInfo.Enabled = 0;
cardInfo.CardList = new string[5];
if (doorInfo.ExtField[0] == "Y")
{
TInOutCard card = new TInOutCard(doorInfo.ExtField[1]);
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 < 5; i++)
{
cardInfo.CardList[i] = "";
}
}
if (!IsError)
{
ret = DeviceObject.objMJ.SetMacInOutCardInfo(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:
UInt32 EnableGuardCard = 0;
UInt32[] ExpertGuardCard = new UInt32[5];
if (doorInfo.ExtField[0] == "Y")
{
EnableGuardCard = 1;
TInOutCard card = new TInOutCard(doorInfo.ExtField[1]);
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)
{
ExpertGuardCard[Index] = cardNo;
}
else
{
UInt32.TryParse(dr["CardPhysicsNo10"].ToString(), out ExpertGuardCard[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.EnableGuardCard = EnableGuardCard;
expert.ExpertGuardCard = ExpertGuardCard;
ret = DeviceObject.objMJNew.SetDoorExpertInfo(doorInfo.DoorID, expert);
}
}
break;
}
return(ret);
}
