private bool GetConnInfo(string MacSysID, ref QHKS.TMJConnInfo connInfo)
{
bool ret = false;
connInfo = new QHKS.TMJConnInfo();
DataTableReader dr = null;
try
{
dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_003001, new string[] { "4", MacSysID }));
if (dr.Read())
{
connInfo = Pub.ValueToMJConnInfo(dr["MacSN"].ToString(), dr["MacConnType"].ToString(),
dr["MacIpAddress"].ToString(), dr["MacPort"].ToString(), dr["MacConnPWD"].ToString());
ret = true;
}
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dr != null)
{
dr.Close();
}
dr = null;
}
return(ret);
}
private void btnTestConnect_Click(object sender, EventArgs e)
{
if (!CheckValue())
{
return;
}
QHKS.TMJConnInfo connInfo = Pub.ValueToMJConnInfo(MacSN, MacConnType, MacIPAddress, MacPort, MacConnPWD);
DeviceObject.objMJ.Init(ref connInfo);
this.Enabled = false;
bool ret = DeviceObject.objMJ.IsOnline();
string msg = DeviceObject.objMJ.ErrMsg;
if (ret)
{
Pub.MessageBoxShow(msg, MessageBoxIcon.Information);
}
else
{
Pub.ShowErrorMsg(msg);
}
this.Enabled = true;
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (dataGrid.SelectedRows.Count < 1)
{
return;
}
bool ret = false;
string errMsg = "";
frmPubFindMacEdit frm = new frmPubFindMacEdit();
frm.NetMask = dataGrid.SelectedRows[0].Cells[6].Value.ToString();
frm.Gateway = dataGrid.SelectedRows[0].Cells[5].Value.ToString();
if (FindType == 0)
{
if (SystemInfo.IsNewMJ)
{
UInt32 devSN = Convert.ToUInt32(dataGrid.SelectedRows[0].Cells[1].Value.ToString());
frm.IP = dataGrid.SelectedRows[0].Cells[3].Value.ToString();
frm.Port = Convert.ToInt32(dataGrid.SelectedRows[0].Cells[7].Value.ToString());
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
AccessV2API.TYPE_Network network = new AccessV2API.TYPE_Network();
network.DevAddr = frm.IP;
network.DevPort = Convert.ToUInt32(frm.Port);
network.GateWay = frm.Gateway;
network.NetMask = frm.NetMask;
ret = DeviceObject.objMJNew.SetNetwork(devSN, network);
}
else
{
QHKS.TMJConnInfo connInfo = new QHKS.TMJConnInfo();
connInfo.ConnType = 1;
connInfo.MacSN = dataGrid.SelectedRows[0].Cells[1].Value.ToString();
connInfo.NetHost = dataGrid.SelectedRows[0].Cells[3].Value.ToString();
connInfo.NetPort = Convert.ToInt32(dataGrid.SelectedRows[0].Cells[7].Value.ToString());
connInfo.CardProtocol = SystemInfo.CardProtocol;
frm.IP = connInfo.NetHost;
frm.Port = connInfo.NetPort;
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
DeviceObject.objMJ.Init(ref connInfo);
QHKS.TMJFindMacInfo macInfo = new QHKS.TMJFindMacInfo();
macInfo.MacSN = connInfo.MacSN;
macInfo.IP = frm.IP;
macInfo.NetMask = frm.NetMask;
macInfo.Gateway = frm.Gateway;
macInfo.Port = frm.Port;
ret = DeviceObject.objMJ.NetMacSetInfo(60000, ref macInfo);
}
}
else
{
QHKS.TConnInfo connInfo = new QHKS.TConnInfo();
connInfo.ConnType = 2;
connInfo.MacSN = Convert.ToInt32(dataGrid.SelectedRows[0].Cells[1].Value.ToString());
connInfo.IsBigMac = Convert.ToByte(dataGrid.SelectedRows[0].Cells[2].Value);
if (FindType == 1)
{
connInfo.MacType = 1;
}
else
{
string s = dataGrid.SelectedRows[0].Cells[4].Value.ToString();
if (!Pub.IsNumeric(s))
{
s = s.Substring(1, 2);
}
connInfo.MacType = Convert.ToByte(Convert.ToInt32(s) - 30);
}
connInfo.NetHost = dataGrid.SelectedRows[0].Cells[3].Value.ToString();
connInfo.NetPort = Convert.ToInt32(dataGrid.SelectedRows[0].Cells[7].Value.ToString());
frm.IP = connInfo.NetHost;
frm.Port = connInfo.NetPort;
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
QHKS.TTCPIPSet ipSet = new QHKS.TTCPIPSet();
ipSet.IP = frm.IP;
ipSet.NetMask = frm.NetMask;
ipSet.Gateway = frm.Gateway;
ipSet.Port = frm.Port;
DeviceObject.objKS.Init(ref connInfo);
ret = DeviceObject.objKS.PubTCPIPSet(ref ipSet);
errMsg = DeviceObject.objKS.ErrMsg;
}
if (ret)
{
dataGrid.SelectedRows[0].Cells[3].Value = frm.IP;
dataGrid.SelectedRows[0].Cells[6].Value = frm.NetMask;
dataGrid.SelectedRows[0].Cells[5].Value = frm.Gateway;
dataGrid.SelectedRows[0].Cells[7].Value = frm.Port;
Pub.MessageBoxShow(Pub.GetResText(formCode, "Msg001", ""), MessageBoxIcon.Information);
}
else
{
Pub.MessageBoxShow(Pub.GetResText(formCode, "Error001", "") + "\r\n\r\n" + errMsg);
}
}
protected override void ExecItemDelete()
{
IsDowning = true;
RefreshForm(false);
string msg = Pub.GetResText(formCode, "Msg003", "");
lblMsg.Text = msg;
progBar.Value = 0;
Report.DetailGrid.Recordset.First();
int Count = Report.DetailGrid.Recordset.RecordCount;
int Index = 0;
bool ret = false;
byte DoorID = 0;
string cardNo = "";
string OtherCardNo = "";
int suCount = 0;
string EmpNo = "";
string EmpName = "";
string tmp = "";
string err = Pub.GetResText(formCode, "Error001", "");
string errMsg = "";
List <string> sql = new List <string>();
QHKS.TMJConnInfo connInfo = new QHKS.TMJConnInfo();
Report.DetailGrid.Recordset.First();
while (!Report.DetailGrid.Recordset.Eof())
{
if (Report.FieldByName("Checked").AsInteger == (int)GRSystemImage.grsi3DChecked)
{
byte.TryParse(Report.FieldByName("MacDoorID").AsString, out DoorID);
cardNo = Report.FieldByName("CardPhysicsNo10").AsString;
OtherCardNo = Report.FieldByName("OtherCardNo").AsString;
EmpNo = Report.FieldByName("EmpNo").AsString;
EmpName = Report.FieldByName("EmpName").AsString;
tmp = "[" + EmpNo + "]" + EmpName + " [" + Report.FieldByName("MacSN").AsString + ": " +
Report.FieldByName("MacDoorName").AsString + "]";
lblMsg.Text = msg + tmp;
if (GetConnInfo(Report.FieldByName("MacSysID").AsString, ref connInfo))
{
DeviceObject.objMJ.Init(ref connInfo);
ret = DeviceObject.objMJ.ClearMacUpPowerInfo(DoorID, cardNo, OtherCardNo);
sql.Clear();
GetDelSql(0, ref sql);
GetDelSqlExt(ref sql);
if (!ret)
{
errMsg = string.Format(err, tmp, DeviceObject.objMJ.ErrMsg);
if (Pub.MessageBoxQuestion(errMsg, MessageBoxButtons.YesNo) == DialogResult.No)
{
break;
}
}
else
{
if (db.ExecSQL(sql) != 0)
{
break;
}
db.WriteSYLog(this.Text, CurrentTool, tmp + DeviceObject.objMJ.ErrMsg);
suCount += 1;
}
if (!IsDowning)
{
break;
}
}
else
{
break;
}
}
Report.DetailGrid.Recordset.Next();
Index += 1;
if (!IsDowning)
{
break;
}
if (Index >= Count)
{
break;
}
progBar.Value = Index * 100 / Count;
Application.DoEvents();
}
IsDowning = false;
progBar.Value = 0;
ExecItemRefresh();
Pub.MessageBoxShow(string.Format(Pub.GetResText(formCode, "Msg004", ""), suCount), MessageBoxIcon.Information);
}
protected override void ExecItemTAG1()
{
base.ExecItemTAG1();
IsDowning = true;
RefreshForm(true);
string msg = Pub.GetResText(formCode, "Msg001", "");
bool IsE = false;
lblMsg.Text = msg;
progBar.Value = 0;
Report.DetailGrid.Recordset.First();
int Count = Report.DetailGrid.Recordset.RecordCount;
int Index = 0;
QHKS.TMJUpPowerInfo power = new QHKS.TMJUpPowerInfo();
bool ret = false;
byte DoorID = 0;
string cardNo = "";
string OtherCardNo = "";
int suCount = 0;
string EmpNo = "";
string EmpName = "";
string tmp = "";
string err = Pub.GetResText(formCode, "Error002", "");
string errMsg = "";
QHKS.TMJConnInfo connInfo = new QHKS.TMJConnInfo();
int RecNo = Report.DetailGrid.Recordset.RecordNo;
Report.DetailGrid.Recordset.First();
while (!Report.DetailGrid.Recordset.Eof())
{
if (Report.FieldByName("Checked").AsInteger == (int)GRSystemImage.grsi3DChecked)
{
IsE = Report.FieldByName("IsEnable").AsString.ToUpper() == "Y";
byte.TryParse(Report.FieldByName("MacDoorID").AsString, out DoorID);
cardNo = Report.FieldByName("CardPhysicsNo10").AsString;
OtherCardNo = Report.FieldByName("OtherCardNo").AsString;
EmpNo = Report.FieldByName("EmpNo").AsString;
EmpName = Report.FieldByName("EmpName").AsString;
tmp = "[" + EmpNo + "]" + EmpName + " [" + Report.FieldByName("MacSN").AsString + ": " +
Report.FieldByName("MacDoorName").AsString + "]";
lblMsg.Text = msg + tmp;
if (GetConnInfo(Report.FieldByName("MacSysID").AsString, ref connInfo))
{
DeviceObject.objMJ.Init(ref connInfo);
if (IsE)
{
power = new QHKS.TMJUpPowerInfo();
power.CardNo = cardNo;
power.OtherCardNo = OtherCardNo;
power.StartDate = Report.FieldByName("CardStartDate").AsDateTime;
power.EndDate = Report.FieldByName("CardEndDate").AsDateTime;
power.Password = Report.FieldByName("CardPWD").AsString;
power.EmpNo = EmpNo;
power.EmpName = EmpName;
power.DoorID = DoorID;
byte.TryParse(Report.FieldByName("MacTimeNo").AsString, out power.TimeID);
ret = DeviceObject.objMJ.SetMacUpPowerInfo(ref power);
}
else
{
ret = DeviceObject.objMJ.ClearMacUpPowerInfo(DoorID, cardNo, OtherCardNo);
}
if (!ret)
{
errMsg = string.Format(err, tmp, DeviceObject.objMJ.ErrMsg);
if (Pub.MessageBoxQuestion(errMsg, MessageBoxButtons.YesNo) == DialogResult.No)
{
break;
}
}
else
{
db.WriteSYLog(this.Text, CurrentTool, tmp + DeviceObject.objMJ.ErrMsg);
suCount += 1;
}
if (!IsDowning)
{
break;
}
}
else
{
break;
}
}
Report.DetailGrid.Recordset.Next();
Index += 1;
if (!IsDowning || (Index >= Count))
{
break;
}
progBar.Value = Index * 100 / Count;
Application.DoEvents();
}
IsDowning = false;
RefreshForm(true);
lblMsg.Text = string.Format(Pub.GetResText(formCode, "Msg002", ""), suCount);
progBar.Value = 0;
Report.DetailGrid.Recordset.MoveTo(RecNo);
}
