private void LoadData()
{
string IsMoreCard = "";
string MacMoreCard = "";
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())
{
IsMoreCard = dr["IsMoreCard"].ToString();
MacMoreCard = dr["MacMoreCard"].ToString();
}
dr.Close();
TMacMoreCard card = new TMacMoreCard(MacMoreCard);
chkEnabledIn.Checked = card.EnabledIn == 1;
chkEnabledOut.Checked = card.EnabledOut == 1;
txtCount.Text = card.EmpCount.ToString();
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 = IsMoreCard.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.TMJMoreCardInfo cardInfo = new QHKS.TMJMoreCardInfo();
cardInfo.DoorID = Convert.ToByte(doorInfo.DoorID);
cardInfo.CardList = new string[20];
if (doorInfo.ExtField[0] == "Y")
{
TMacMoreCard card = new TMacMoreCard(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 < 20; i++)
{
cardInfo.CardList[i] = "";
}
cardInfo.CardCount = card.EmpCount;
cardInfo.CardIn = card.EnabledIn;
cardInfo.CardOut = card.EnabledOut;
}
if (!IsError)
{
ret = DeviceObject.objMJ.SetMacMoreCardInfo(ref cardInfo);
}
break;
}
return(ret);
}
