/// <summary>
/// Get Database Logs.
/// </summary>
/// <param name="beginDate">begin date</param>
/// <param name="endDate">end date</param>
/// <param name="type">log type</param>
/// <returns>database logs</returns>
public List <LogInfo> GetDBLogs(DateTime beginDate, DateTime endDate, Int32 type)
{
SqlParameter[] parms = { new SqlParameter("@BeginDate", SqlDbType.DateTime),
new SqlParameter("@EndDate", SqlDbType.DateTime),
new SqlParameter("@EventType", SqlDbType.Int) };
parms[0].Value = beginDate;
parms[1].Value = endDate;
if (type == -1)
{
parms[2].Value = DBNull.Value;
}
else
{
parms[2].Value = type;
}
var logs = new List <LogInfo>();;
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_LG_GetLogs, parms)) {
while (rdr.Read())
{
var log = new LogInfo();
log.EventId = ComUtility.DBNullGuidHandler(rdr["EventId"]);
log.EventTime = ComUtility.DBNullDateTimeHandler(rdr["EventTime"]);
log.EventType = ComUtility.DBNullMsgTypeHandler(rdr["EventType"]);
log.Operator = ComUtility.DBNullStringHandler(rdr["Operator"]);
log.Source = ComUtility.DBNullStringHandler(rdr["Source"]);
log.Message = ComUtility.DBNullStringHandler(rdr["Message"]);
log.StackTrace = ComUtility.DBNullStringHandler(rdr["StackTrace"]);
logs.Add(log);
}
}
return(logs);
}
/// <summary>
/// Get Card Authorizations By Employee Id.
/// </summary>
/// <param name="EmpId">Employee Id</param>
/// <returns>Card Authorizations</returns>
public List <CardAuthInfo> GetCardAuth(String EmpId, EnmWorkerType WorkType)
{
SqlParameter[] parms = { new SqlParameter("@EmpId", SqlDbType.VarChar, 50),
new SqlParameter("@EmpType", SqlDbType.Int) };
parms[0].Value = EmpId;
parms[1].Value = (Int32)WorkType;
var auths = new List <CardAuthInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_CA_GetCardAuthByEmpId, parms)) {
while (rdr.Read())
{
var auth = new CardAuthInfo();
auth.CardSn = ComUtility.DBNullStringHandler(rdr["CardSn"]);
auth.RtuId = ComUtility.DBNullInt32Handler(rdr["RtuId"]);
auth.DevId = ComUtility.DBNullInt32Handler(rdr["DevId"]);
auth.LimitId = ComUtility.DBNullLimitIDHandler(rdr["LimitId"]);
auth.LimitIndex = ComUtility.DBNullInt32Handler(rdr["LimitIndex"]);
auth.BeginTime = ComUtility.DBNullDateTimeHandler(rdr["BeginTime"]);
auth.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
auth.Password = ComUtility.DBNullStringHandler(rdr["Password"]);
auth.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
auth.Remark = String.Empty;
auth.CardSn = ComUtility.GetCardSn16to10(auth.CardSn);
auths.Add(auth);
}
}
return(auths);
}
/// <summary>
/// Method to get nodes combobox information
/// </summary>
/// <param name="DevId">Dev Id</param>
/// <param name="AI">AI</param>
/// <param name="AO">AO</param>
/// <param name="DI">DI</param>
/// <param name="DO">DO</param>
public Dictionary <Int32, String> GetNodes(Int32 DevId, Boolean AI, Boolean AO, Boolean DI, Boolean DO)
{
SqlParameter[] parms = { new SqlParameter("@DevID", SqlDbType.Int),
new SqlParameter("@AI", SqlDbType.Bit),
new SqlParameter("@AO", SqlDbType.Bit),
new SqlParameter("@DI", SqlDbType.Bit),
new SqlParameter("@DO", SqlDbType.Bit) };
parms[0].Value = DevId;
parms[1].Value = AI;
parms[2].Value = AO;
parms[3].Value = DI;
parms[4].Value = DO;
var dict = new Dictionary <Int32, String>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_CB_GetNodes, parms)) {
while (rdr.Read())
{
var id = ComUtility.DBNullInt32Handler(rdr["NodeID"]);
var name = ComUtility.DBNullStringHandler(rdr["NodeName"]);
dict[id] = name;
}
}
return(dict);
}
/// <summary>
/// Get Card Authorizations By Device Id and Card Sn.
/// </summary>
/// <param name="DevId">Device Id</param>
/// <param name="CardSn">Card Sn</param>
/// <returns>Card Authorizations</returns>
public CardAuthInfo GetCardAuth(Int32 DevId, String CardSn)
{
SqlParameter[] parms = { new SqlParameter("@DevId", SqlDbType.Int),
new SqlParameter("@CardSn", SqlDbType.VarChar, 50) };
parms[0].Value = DevId;
parms[1].Value = ComUtility.GetCardSn10to16(CardSn);
CardAuthInfo auth = null;
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_CA_GetCardAuthByCardSn, parms)) {
if (rdr.Read())
{
auth = new CardAuthInfo();
auth.CardSn = ComUtility.DBNullStringHandler(rdr["CardSn"]);
auth.RtuId = ComUtility.DBNullInt32Handler(rdr["RtuId"]);
auth.DevId = ComUtility.DBNullInt32Handler(rdr["DevId"]);
auth.LimitId = ComUtility.DBNullLimitIDHandler(rdr["LimitId"]);
auth.LimitIndex = ComUtility.DBNullInt32Handler(rdr["LimitIndex"]);
auth.BeginTime = ComUtility.DBNullDateTimeHandler(rdr["BeginTime"]);
auth.EndTime = ComUtility.DBNullDateTimeHandler(rdr["EndTime"]);
auth.Password = ComUtility.DBNullStringHandler(rdr["Password"]);
auth.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
auth.Remark = String.Empty;
auth.CardSn = ComUtility.GetCardSn16to10(auth.CardSn);
}
}
return(auth);
}
/// <summary>
/// Copy Auth By Card.
/// </summary>
/// <param name="source">source card sn</param>
/// <param name="target">target card sn</param>
/// <param name="delete">whether to delete target auth</param>
public void CopyAuthByCard(List <String> source, List <String> target, bool delete)
{
SqlParameter[] parms = { new SqlParameter("@TargetCardSn", SqlDbType.VarChar, 50),
new SqlParameter("@SourceCardSn", SqlDbType.VarChar, 50) };
using (var conn = new SqlConnection(SQLHelper.ConnectionStringLocalTransaction)) {
conn.Open();
using (var tran = conn.BeginTransaction(IsolationLevel.ReadCommitted)) {
try {
foreach (var t in target)
{
parms[0].Value = ComUtility.GetCardSn10to16(t);
parms[1].Value = DBNull.Value;
if (delete)
{
SQLHelper.ExecuteNonQuery(tran, CommandType.Text, SQLText.SQL_CA_DeleteAuthByCard, parms);
}
foreach (var s in source)
{
parms[1].Value = ComUtility.GetCardSn10to16(s);
SQLHelper.ExecuteNonQuery(tran, CommandType.Text, SQLText.SQL_CA_CopyAuthByCard, parms);
}
}
tran.Commit();
} catch {
tran.Rollback();
throw;
}
}
}
}
public void CreateAndReleaseTest()
{
// WshShortcut Object Properties and Methods: http://msdn.microsoft.com/en-us/library/f5y78918.aspx
dynamic?shell = ComUtility.CreateInstance("WScript.Shell");
Assert.IsNotNull(shell);
try
{
var link = shell !.CreateShortcut("TestShortcut.lnk");
try
{
link.TargetPath = ApplicationInfo.ExecutableFile;
link.Arguments = "/Argument=1";
link.Description = "Testing a shortcut";
// Don't save the link for this test: link.Save();
}
finally
{
ComUtility.FinalRelease(link);
}
}
finally
{
ComUtility.FinalRelease(shell);
}
}
/// <summary>
/// Delete Card Auth.
/// </summary>
/// <param name="Ids">Device Id and Card Sn</param>
public void DeleteCardAuth(List <IDValuePair <Int32, String> > Ids)
{
SqlParameter[] parms = { new SqlParameter("@DevId", SqlDbType.Int),
new SqlParameter("@CardSn", SqlDbType.VarChar, 50) };
using (var conn = new SqlConnection(SQLHelper.ConnectionStringLocalTransaction)) {
conn.Open();
using (var tran = conn.BeginTransaction(IsolationLevel.ReadCommitted)) {
try {
foreach (var id in Ids)
{
parms[0].Value = id.ID;
parms[1].Value = ComUtility.GetCardSn10to16(id.Value);
SQLHelper.ExecuteNonQuery(tran, CommandType.Text, SQLText.SQL_CA_DeleteCardAuth, parms);
}
tran.Commit();
} catch {
tran.Rollback();
throw;
}
}
}
}
/// <summary>
/// Get Status Nodes.
/// </summary>
public Dictionary <Int32, NodeInfo> GetStatusNodes(Guid RoleId)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier),
new SqlParameter("@DevType", SqlDbType.Int),
new SqlParameter("@DIType", SqlDbType.Int) };
parms[0].Value = ComUtility.DBNullSuperChecker(RoleId);
parms[1].Value = (Int32)EnmNodeType.Dev;
parms[2].Value = (Int32)EnmNodeType.Dic;
var nodes = new Dictionary <Int32, NodeInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_ND_GetStatusNodes, parms)) {
while (rdr.Read())
{
var node = new NodeInfo();
node.DevID = ComUtility.DBNullInt32Handler(rdr["DevID"]);
node.RtuID = ComUtility.DBNullInt32Handler(rdr["RtuID"]);
node.DotID = ComUtility.DBNullInt32Handler(rdr["DotID"]);
node.NodeID = ComUtility.DBNullInt32Handler(rdr["NodeID"]);
node.NodeType = ComUtility.DBNullNodeTypeHandler(rdr["NodeType"]);
node.NodeName = ComUtility.DBNullStringHandler(rdr["NodeName"]);
node.NodeDesc = ComUtility.DBNullStringHandler(rdr["NodeDesc"]);
node.Remark = ComUtility.DBNullStringHandler(rdr["Remark"]);
node.AuxSet = ComUtility.DBNullStringHandler(rdr["AuxSet"]);
node.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
node.Value = ComUtility.DBNullFloatHandler(rdr["Value"]);
node.Status = ComUtility.DBNullStateHandler(rdr["Status"]);
node.DateTime = ComUtility.DBNullDateTimeHandler(rdr["DateTime"]);
node.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["UpdateTime"]);
nodes[node.DevID] = node;
}
}
return(nodes);
}
/// <summary>
/// Get History Card Records.
/// </summary>
/// <param name="beginTime">beginTime</param>
/// <param name="endTime">endTime</param>
/// <returns>last card records</returns>
public List <CardRecordInfo> GetHisCardRecords(DateTime beginTime, DateTime endTime)
{
SqlParameter[] parms = { new SqlParameter("@BeginTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime) };
parms[0].Value = ComUtility.DBNullDateTimeChecker(beginTime);
parms[1].Value = ComUtility.DBNullDateTimeChecker(endTime);
var records = new List <CardRecordInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.HisConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_CD_GetHisCardRecords, parms)) {
while (rdr.Read())
{
var rec = new CardRecordInfo();
rec.ID = ComUtility.DBNullInt32Handler(rdr["ID"]);
rec.DevID = ComUtility.DBNullInt32Handler(rdr["DevID"]);
rec.CardSn = ComUtility.DBNullStringHandler(rdr["PunchNO"]);
rec.CardTime = ComUtility.DBNullDateTimeHandler(rdr["PunchTime"]);
rec.Status = ComUtility.DBNullStringHandler(rdr["Status"]);
rec.Remark = ComUtility.DBNullStringHandler(rdr["Remark"]);
rec.Direction = ComUtility.DBNullDirectionHandler(rdr["Direction"]);
rec.GrantPunch = ComUtility.DBNullBooleanHandler(rdr["GrantPunch"]);
rec.CardSn = ComUtility.GetCardSn16to10(rec.CardSn);
records.Add(rec);
}
}
return(records);
}
/// <summary>
/// Save user.
/// </summary>
/// <param name="user">user</param>
public void SaveUser(UserInfo user)
{
using (var conn = new SqlConnection(SQLHelper.ConnectionStringLocalTransaction)) {
conn.Open();
using (var tran = conn.BeginTransaction(IsolationLevel.ReadCommitted)) {
try {
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier),
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@RemarkName", SqlDbType.NVarChar, 50),
new SqlParameter("@MobilePhone", SqlDbType.VarChar, 20),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@LimitDate", SqlDbType.DateTime),
new SqlParameter("@Comment", SqlDbType.NVarChar, 1024),
new SqlParameter("@Enabled", SqlDbType.Bit) };
parms[0].Value = user.Role.RoleID;
parms[1].Value = user.UserID;
parms[2].Value = user.UserName;
parms[3].Value = ComUtility.DBNullStringChecker(user.RemarkName);
parms[4].Value = ComUtility.DBNullStringChecker(user.MobilePhone);
parms[5].Value = ComUtility.DBNullStringChecker(user.Email);
parms[6].Value = user.LimitDate;
parms[7].Value = ComUtility.DBNullStringChecker(user.Comment);
parms[8].Value = user.Enabled;
SQLHelper.ExecuteNonQuery(tran, CommandType.Text, SQLText.SQL_MS_SaveUser, parms);
tran.Commit();
} catch {
tran.Rollback();
throw;
}
}
}
}
/// <summary>
/// Update user.
/// </summary>
/// <param name="user">user</param>
public void UpdateUser(UserInfo user)
{
using (var conn = new SqlConnection(SQLHelper.ConnectionStringLocalTransaction)) {
conn.Open();
using (var tran = conn.BeginTransaction(IsolationLevel.ReadCommitted)) {
try {
SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
new SqlParameter("@LastLoginDate", SqlDbType.DateTime),
new SqlParameter("@FailedPasswordAttemptCount", SqlDbType.Int),
new SqlParameter("@FailedPasswordDate", SqlDbType.DateTime),
new SqlParameter("@IsLockedOut", SqlDbType.Bit),
new SqlParameter("@LastLockoutDate", SqlDbType.DateTime) };
parms[0].Value = user.UserID;
parms[1].Value = ComUtility.DBNullDateTimeChecker(user.LastLoginDate);
parms[2].Value = user.FailedPasswordAttemptCount;
parms[3].Value = ComUtility.DBNullDateTimeChecker(user.FailedPasswordDate);
parms[4].Value = user.IsLockedOut;
parms[5].Value = ComUtility.DBNullDateTimeChecker(user.LastLockoutDate);
SQLHelper.ExecuteNonQuery(tran, CommandType.Text, SQLText.SQL_MS_UpdateUser, parms);
tran.Commit();
} catch {
tran.Rollback();
throw;
}
}
}
}
/// <summary>
/// Get all users.
/// </summary>
/// <returns>users information.</returns>
public List <UserInfo> GetUsers()
{
var users = new List <UserInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_MS_GetUsers, null)) {
while (rdr.Read())
{
var user = new UserInfo();
user.Role = new RoleInfo();
user.Role.RoleID = ComUtility.DBNullGuidHandler(rdr["RoleId"]);
user.Role.RoleName = ComUtility.DBNullStringHandler(rdr["RoleName"]);
user.UserID = ComUtility.DBNullGuidHandler(rdr["UserId"]);
user.UserName = ComUtility.DBNullStringHandler(rdr["UserName"]);
user.RemarkName = ComUtility.DBNullStringHandler(rdr["RemarkName"]);
user.Password = ComUtility.DBNullStringHandler(rdr["Password"]);
user.PasswordFormat = ComUtility.DBNullPasswordFormatHandler(rdr["PasswordFormat"]);
user.PasswordSalt = ComUtility.DBNullStringHandler(rdr["PasswordSalt"]);
user.MobilePhone = ComUtility.DBNullStringHandler(rdr["MobilePhone"]);
user.Email = ComUtility.DBNullStringHandler(rdr["Email"]);
user.CreateDate = ComUtility.DBNullDateTimeHandler(rdr["CreateDate"]);
user.LimitDate = ComUtility.DBNullDateTimeHandler(rdr["LimitDate"]);
user.LastLoginDate = ComUtility.DBNullDateTimeHandler(rdr["LastLoginDate"]);
user.LastPasswordChangedDate = ComUtility.DBNullDateTimeHandler(rdr["LastPasswordChangedDate"]);
user.FailedPasswordAttemptCount = ComUtility.DBNullInt32Handler(rdr["FailedPasswordAttemptCount"]);
user.FailedPasswordDate = ComUtility.DBNullDateTimeHandler(rdr["FailedPasswordDate"]);
user.IsLockedOut = ComUtility.DBNullBooleanHandler(rdr["IsLockedOut"]);
user.LastLockoutDate = ComUtility.DBNullDateTimeHandler(rdr["LastLockoutDate"]);
user.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
user.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
users.Add(user);
}
}
return(users);
}
/// <summary>
/// Get role devices.
/// </summary>
/// <param name="roleId">role id</param>
/// <returns>role devices</returns>
public Dictionary <Int32, DeviceInfo> GetRoleDevices(Guid roleId)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier),
new SqlParameter("@DevType", SqlDbType.Int) };
parms[0].Value = ComUtility.DBNullSuperChecker(roleId);
parms[1].Value = (int)EnmNodeType.Dev;
var devices = new Dictionary <Int32, DeviceInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_MS_GetRoleDevices, parms)) {
while (rdr.Read())
{
var dev = new DeviceInfo();
dev.Area1ID = ComUtility.DBNullInt32Handler(rdr["Area1ID"]);
dev.Area1Name = ComUtility.DBNullStringHandler(rdr["Area1Name"]);
dev.Area2ID = ComUtility.DBNullInt32Handler(rdr["Area2ID"]);
dev.Area2Name = ComUtility.DBNullStringHandler(rdr["Area2Name"]);
dev.Area3ID = ComUtility.DBNullInt32Handler(rdr["Area3ID"]);
dev.Area3Name = ComUtility.DBNullStringHandler(rdr["Area3Name"]);
dev.StaID = ComUtility.DBNullInt32Handler(rdr["StaID"]);
dev.StaName = ComUtility.DBNullStringHandler(rdr["StaName"]);
dev.DevID = ComUtility.DBNullInt32Handler(rdr["DevID"]);
dev.DevName = ComUtility.DBNullStringHandler(rdr["DevName"]);
dev.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
dev.Nodes = null;
dev.CardRecord = null;
devices[dev.DevID] = dev;
}
}
return(devices);
}
/// <summary>
/// Get role nodes.
/// </summary>
/// <param name="roleId">role id</param>
/// <returns>role nodes</returns>
public List <NodeLevelInfo> GetRoleNodes(Guid roleId)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier),
new SqlParameter("@AreaType", SqlDbType.Int),
new SqlParameter("@StaType", SqlDbType.Int),
new SqlParameter("@DevType", SqlDbType.Int) };
parms[0].Value = ComUtility.DBNullSuperChecker(roleId);
parms[1].Value = (int)EnmNodeType.Area;
parms[2].Value = (int)EnmNodeType.Sta;
parms[3].Value = (int)EnmNodeType.Dev;
var nodes = new List <NodeLevelInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_MS_GetRoleNodes, parms)) {
while (rdr.Read())
{
var node = new NodeLevelInfo();
node.NodeID = ComUtility.DBNullInt32Handler(rdr["NodeId"]);
node.NodeType = ComUtility.DBNullNodeTypeHandler(rdr["NodeType"]);
node.NodeName = ComUtility.DBNullStringHandler(rdr["NodeName"]);
node.LastNodeID = ComUtility.DBNullInt32Handler(rdr["LastNodeId"]);
node.SortIndex = ComUtility.DBNullInt32Handler(rdr["SortIndex"]);
node.Status = EnmAlarmLevel.NoAlarm;
node.Remark = ComUtility.DBNullStringHandler(rdr["Remark"]);
nodes.Add(node);
}
}
return(nodes);
}
/// <summary>
/// Export Data To Excel.
/// </summary>
private void ExportExcelBtn_Click(object sender, EventArgs e)
{
try {
if (GridLogs.Count > 0)
{
var data = new DataTable();
data.Columns.Add("序号", typeof(String));
data.Columns.Add("日志时间", typeof(String));
data.Columns.Add("日志类型", typeof(String));
data.Columns.Add("触发对象", typeof(String));
data.Columns.Add("触发来源", typeof(String));
data.Columns.Add("日志描述", typeof(String));
for (var i = 0; i < GridLogs.Count; i++)
{
var dr = data.NewRow();
dr["序号"] = i + 1;
dr["日志时间"] = Common.GetDateTimeString(GridLogs[i].EventTime);
dr["日志类型"] = ComUtility.GetLogTypeText(GridLogs[i].EventType);
dr["触发对象"] = GridLogs[i].Operator;
dr["触发来源"] = GridLogs[i].Source;
dr["日志描述"] = GridLogs[i].Message;
data.Rows.Add(dr);
}
Common.ExportDataToExcel(null, "系统日志", "智能门禁管理系统 系统日志报表", String.Format("操作员:{0}{1} 日期:{2}", Common.CurUser.UserName, String.IsNullOrWhiteSpace(Common.CurUser.RemarkName) ? String.Empty : String.Format("({0})", Common.CurUser.RemarkName), Common.GetDateTimeString(DateTime.Now)), data);
}
} catch (Exception err) {
Common.WriteLog(DateTime.Now, EnmMsgType.Error, "System", "Delta.MPS.AccessSystem.LogManagerForm.ExportBtn.Click", err.Message, err.StackTrace);
MessageBox.Show(err.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Get cards by the specified role id.
/// </summary>
/// <param name="RoleId">role id</param>
/// <returns>cards information</returns>
public List <CardInfo> GetOutCards(Guid RoleId)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier),
new SqlParameter("@EmpType", SqlDbType.Int) };
parms[0].Value = ComUtility.DBNullSuperChecker(RoleId);
parms[1].Value = EnmWorkerType.WXRY;
var cards = new List <CardInfo>();;
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_CD_GetOutCards, parms)) {
while (rdr.Read())
{
var card = new CardInfo();
card.WorkerId = ComUtility.DBNullStringHandler(rdr["EmpId"]);
card.WorkerType = ComUtility.DBNullWorkerTypeHandler(rdr["EmpType"]);
card.WorkerName = ComUtility.DBNullStringHandler(rdr["EmpName"]);
card.DepId = ComUtility.DBNullStringHandler(rdr["DepId"]);
card.DepName = ComUtility.DBNullStringHandler(rdr["DepName"]);
card.CardSn = ComUtility.DBNullStringHandler(rdr["CardSn"]);
card.CardType = ComUtility.DBNullCardTypeHandler(rdr["CardType"]);
card.UID = ComUtility.DBNullStringHandler(rdr["UID"]);
card.Pwd = ComUtility.DBNullStringHandler(rdr["Pwd"]);
card.BeginTime = ComUtility.DBNullDateTimeHandler(rdr["BeginTime"]);
card.BeginReason = ComUtility.DBNullStringHandler(rdr["BeginReason"]);
card.Comment = ComUtility.DBNullStringHandler(rdr["Comment"]);
card.Enabled = ComUtility.DBNullBooleanHandler(rdr["Enabled"]);
card.CardSn = ComUtility.GetCardSn16to10(card.CardSn);
cards.Add(card);
}
}
return(cards);
}
private void Form1_Load(object sender, EventArgs e)
{
sHead = Convert.ToByte("0x3A", 16);
rHead = Convert.ToByte("0xA3", 16);
tail = ComUtility.StrHexToBin("0x0D 0x0A");
setK1 = ComUtility.StrHexToBin("01 01 FF");
setK2 = ComUtility.StrHexToBin("01 02 FF");
setK3 = ComUtility.StrHexToBin("01 03 FF");
setK4 = ComUtility.StrHexToBin("01 04 FF");
setAll = ComUtility.StrHexToBin("01 00 FF");
resetK1 = ComUtility.StrHexToBin("01 01 00");
resetK2 = ComUtility.StrHexToBin("01 02 00");
resetK3 = ComUtility.StrHexToBin("01 03 00");
resetK4 = ComUtility.StrHexToBin("01 04 00");
resetAll = ComUtility.StrHexToBin("01 00 00");
getK1 = ComUtility.StrHexToBin("01 01");
getK2 = ComUtility.StrHexToBin("01 02");
getK3 = ComUtility.StrHexToBin("01 03");
getK4 = ComUtility.StrHexToBin("01 04");
getAll = ComUtility.StrHexToBin("01 00");
sCmd = Convert.ToByte("0x88", 16);
gCmd = Convert.ToByte("0x99", 16);
//列出本机所有串口
string[] ports = SerialPort.GetPortNames();
if (ports.Length > 0)
{
comboBoxPortSelect.Items.AddRange(ports);
//默认选中第一个
comboBoxPortSelect.SelectedIndex = 0;
}
}
/// <summary>
/// Export Data To Text.
/// </summary>
private void ExportBtn_Click(object sender, EventArgs e)
{
try {
if (GridLogs.Count > 0)
{
var logText = new StringBuilder();
foreach (var log in GridLogs)
{
logText.AppendLine("=======================================================================================");
logText.AppendLine(String.Format("日志编号: {0}", log.EventId));
logText.AppendLine(String.Format("日志时间: {0}", Common.GetDateTimeString(log.EventTime)));
logText.AppendLine(String.Format("日志类型: {0}", ComUtility.GetLogTypeText(log.EventType)));
logText.AppendLine(String.Format("触发对象: {0}", log.Operator));
logText.AppendLine(String.Format("触发来源: {0}", log.Source));
logText.AppendLine(String.Format("日志描述: {0}", log.Message));
logText.AppendLine(String.Format("详细信息: {0}", log.StackTrace));
logText.AppendLine();
}
Common.ExportDataToText(null, "智能门禁管理系统 系统日志", logText.ToString());
}
} catch (Exception err) {
Common.WriteLog(DateTime.Now, EnmMsgType.Error, "System", "Delta.MPS.AccessSystem.LogManagerForm.ExportBtn.Click", err.Message, err.StackTrace);
MessageBox.Show(err.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Export Org Employees.
/// </summary>
public DataTable ExportOrgEmployees(Guid roleId)
{
var data = new DataTable();
data.Columns.Add("部门代码", typeof(String));
data.Columns.Add("部门名称", typeof(String));
data.Columns.Add("员工工号", typeof(String));
data.Columns.Add("员工姓名", typeof(String));
data.Columns.Add("身份证号", typeof(String));
data.Columns.Add("手机", typeof(String));
data.Columns.Add("Email", typeof(String));
data.Columns.Add("卡号", typeof(String));
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier) };
parms[0].Value = ComUtility.DBNullSuperChecker(roleId);
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_EE_ExportOrgEmployees, parms)) {
while (rdr.Read())
{
var dr = data.NewRow();
dr["部门代码"] = ComUtility.DBNullStringHandler(rdr["DepId"]);
dr["部门名称"] = ComUtility.DBNullStringHandler(rdr["DepName"]);
dr["员工工号"] = ComUtility.DBNullStringHandler(rdr["EmpId"]);
dr["员工姓名"] = ComUtility.DBNullStringHandler(rdr["EmpName"]);
dr["身份证号"] = ComUtility.DBNullStringHandler(rdr["CardId"]);
dr["手机"] = ComUtility.DBNullStringHandler(rdr["MobilePhone"]);
dr["Email"] = ComUtility.DBNullStringHandler(rdr["Email"]);
dr["卡号"] = rdr["CardSn"] == DBNull.Value || String.IsNullOrWhiteSpace(rdr["CardSn"].ToString()) ? String.Empty : ComUtility.GetCardSn16to10(rdr["CardSn"].ToString());
data.Rows.Add(dr);
}
}
return(data);
}
/// <summary>
/// 项目下拉框获取数据
/// </summary>
/// <param name="model"></param>
public void GetProjects(UI001ViewModel model)
{
// 从数据库获取数据
using (EntityDao db = new EntityDao())
{
model.ProjectItems = new ObservableCollection <TB_Project>(db.FindAll <TB_Project>());
}
// 从Xml文件中获取上次选择项目
Dictionary <string, string> dic = ComUtility.GetXmValues(model.Page.ToString());
string project = dic["project"];
if (string.IsNullOrWhiteSpace(project))
{
return;
}
// 默认选择上次选择项目
foreach (TB_Project item in model.ProjectItems)
{
if (item.CD == project)
{
model.SelectedProjectItem = item;
GetDataItems(model);
return;
}
}
}
/// <summary>
/// Based on raytracing a ProtocolObject gets determined and passed to the ComUtility.
/// </summary>
private void ProcessRaycast()
{
// Creates a ray from the camera to the relative center of the screen.
m_ray = m_cameraController.Camera.ScreenPointToRay(new Vector3(Screen.width * 0.5f, Screen.height * 0.5f, 0));
// Determine if the ray hit something based on raytracing.
m_poiHit = null;
if (Physics.Raycast(m_ray, out m_hit, InteractionRange, m_layerMask) &&
(m_poiHit = m_hit.collider.GetComponent <PointOfInterest>()))
{
// Sends the ID of the hit POI to the ComUtility as POIProtocolObject.
if (m_poiHit != m_hoverPoint)
{
m_hoverPoint = m_poiHit;
ComUtility.Send(new POIProtocolObject(m_poiHit.ID));
}
}
else
{
// Sends an empty POIProtocolObject to the ComUtility to indicate that nothing has been hit.
if (m_hoverPoint != null)
{
ComUtility.Send(POIProtocolObject.None);
}
m_hoverPoint = null;
}
// The PlayerUI sends a Boolean value indicating whether the crosshairs need to be highlighted.
m_uiController.HighlightCursor(m_hoverPoint != null);
}
public void CreateShortcut(string shortcutFileName)
{
// From: http://stackoverflow.com/questions/234231/creating-application-shortcut-in-a-directory
// WshShortcut Object Properties and Methods: http://msdn.microsoft.com/en-us/library/f5y78918.aspx
dynamic shell = ComUtility.CreateInstance("WScript.Shell");
try
{
var link = shell.CreateShortcut(shortcutFileName);
try
{
link.TargetPath = ApplicationInfo.ExecutableFile;
link.Arguments = this.BuildCommandLine(false);
link.Description = "Opens the \"" + this.Gizmo.GizmoName + "\" gizmo.";
link.Save();
}
finally
{
ComUtility.FinalRelease(link);
}
}
finally
{
ComUtility.FinalRelease(shell);
}
}
/// <summary>
/// Get Grid Stations.
/// </summary>
/// <param name="RoleId">Role Id</param>
/// <param name="TypeId">Type Id</param>
/// <returns>Grid Stations</returns>
public List <StaInfo> GetGridStations(Guid RoleId, Int32 TypeId)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.UniqueIdentifier),
new SqlParameter("@StaType", SqlDbType.Int),
new SqlParameter("@TypeID", SqlDbType.Int) };
parms[0].Value = ComUtility.DBNullSuperChecker(RoleId);
parms[1].Value = (int)EnmNodeType.Sta;
parms[2].Value = TypeId;
var stations = new List <StaInfo>();
using (var rdr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, SQLText.SQL_GD_GetGridStations, parms)) {
while (rdr.Read())
{
var sta = new StaInfo();
sta.Area1ID = ComUtility.DBNullInt32Handler(rdr["Area1ID"]);
sta.Area1Name = ComUtility.DBNullStringHandler(rdr["Area1Name"]);
sta.Area2ID = ComUtility.DBNullInt32Handler(rdr["Area2ID"]);
sta.Area2Name = ComUtility.DBNullStringHandler(rdr["Area2Name"]);
sta.Area3ID = ComUtility.DBNullInt32Handler(rdr["Area3ID"]);
sta.Area3Name = ComUtility.DBNullStringHandler(rdr["Area3Name"]);
sta.StaID = ComUtility.DBNullInt32Handler(rdr["StaID"]);
sta.StaName = ComUtility.DBNullStringHandler(rdr["StaName"]);
sta.NetGridID = ComUtility.DBNullInt32Handler(rdr["NetGridID"]);
sta.NetGridName = ComUtility.DBNullStringHandler(rdr["NetGridName"]);
stations.Add(sta);
}
}
return(stations);
}
/// <summary>
/// Save system application.
/// </summary>
/// <param name="application">system application</param>
public void SaveSystemApplication(ApplicationInfo application)
{
try {
SQLiteParameter[] parms = { new SQLiteParameter("@app_id", DbType.Guid),
new SQLiteParameter("@app_name", DbType.String),
new SQLiteParameter("@app_license", DbType.String),
new SQLiteParameter("@app_firsttime", DbType.DateTime),
new SQLiteParameter("@app_lasttime", DbType.DateTime),
new SQLiteParameter("@app_logintime", DbType.DateTime) };
using (var conn = new SQLiteConnection(registryConnectionString)) {
conn.SetPassword(dbPassword);
conn.Open();
using (var command = new SQLiteCommand(SQLiteText.Registry_Save_SystemApplication, conn)) {
parms[0].Value = application.UniqueID;
parms[1].Value = ComUtility.DBNullStringChecker(application.AppName);
parms[2].Value = ComUtility.DBNullStringChecker(application.AppLicense);
parms[3].Value = ComUtility.DBNullDateTimeChecker(application.AppFirstTime);
parms[4].Value = ComUtility.DBNullDateTimeChecker(application.AppLastTime);
parms[5].Value = ComUtility.DBNullDateTimeChecker(application.AppLoginTime);
command.Parameters.Clear();
command.Parameters.AddRange(parms);
command.ExecuteNonQuery();
}
}
} catch {
throw;
}
}
/// <summary>
/// Get database servers setting.
/// </summary>
/// <returns>database servers setting</returns>
public List <DatabaseServerInfo> GetDatabaseServers()
{
try {
var databases = new List <DatabaseServerInfo>();
using (var conn = new SQLiteConnection(registryConnectionString)) {
conn.SetPassword(dbPassword);
conn.Open();
using (var command = new SQLiteCommand(SQLiteText.Registry_Get_DatabaseServers, conn)) {
using (var rdr = command.ExecuteReader(CommandBehavior.CloseConnection)) {
while (rdr.Read())
{
var db = new DatabaseServerInfo();
db.UniqueID = ComUtility.DBNullGuidHandler(rdr["unique_id"]);
db.DatabaseIntention = ComUtility.DBNullDBIntentionHandler(rdr["database_intention"]);
db.DatabaseType = ComUtility.DBNullDBTypeHandler(rdr["database_type"]);
db.DatabaseIP = ComUtility.DBNullStringHandler(rdr["database_ip"]);
db.DatabasePort = ComUtility.DBNullInt32Handler(rdr["database_port"]);
db.DatabaseUser = ComUtility.DBNullStringHandler(rdr["database_user"]);
db.DatabasePwd = ComUtility.DBNullStringHandler(rdr["database_pwd"]);
db.DatabaseName = ComUtility.DBNullStringHandler(rdr["database_name"]);
db.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["update_time"]);
databases.Add(db);
}
}
}
}
return(databases);
} catch {
throw;
}
}
/// <summary>
/// Get system application.
/// </summary>
/// <param name="appID">application id</param>
/// <returns>system application</returns>
public ApplicationInfo GetSystemApplication(Guid appID)
{
try {
SQLiteParameter[] parms = { new SQLiteParameter("@app_id", DbType.Guid) };
parms[0].Value = appID;
ApplicationInfo application = null;
using (var conn = new SQLiteConnection(registryConnectionString)) {
conn.SetPassword(dbPassword);
conn.Open();
using (var command = new SQLiteCommand(SQLiteText.Registry_Get_SystemApplication, conn)) {
command.Parameters.Clear();
command.Parameters.AddRange(parms);
using (var rdr = command.ExecuteReader(CommandBehavior.CloseConnection)) {
if (rdr.Read())
{
application = new ApplicationInfo();
application.UniqueID = ComUtility.DBNullGuidHandler(rdr["app_id"]);
application.AppName = ComUtility.DBNullStringHandler(rdr["app_name"]);
application.AppLicense = ComUtility.DBNullStringHandler(rdr["app_license"]);
application.AppFirstTime = ComUtility.DBNullDateTimeHandler(rdr["app_firsttime"]);
application.AppLastTime = ComUtility.DBNullDateTimeHandler(rdr["app_lasttime"]);
application.AppLoginTime = ComUtility.DBNullDateTimeHandler(rdr["app_logintime"]);
}
}
}
}
return(application);
} catch {
throw;
}
}
/// <summary>
/// Get recent users list.
/// </summary>
/// <param name="limit">the max count of the recent users</param>
/// <returns>recent users list</returns>
public List <RecentUserInfo> GetRecentUsers(int limit)
{
try {
SQLiteParameter[] parms = { new SQLiteParameter("@limit", DbType.Int32) };
parms[0].Value = limit;
var users = new List <RecentUserInfo>();
using (var conn = new SQLiteConnection(registryConnectionString)) {
conn.SetPassword(dbPassword);
conn.Open();
using (var command = new SQLiteCommand(SQLiteText.Registry_Get_RecentUsers, conn)) {
command.Parameters.AddRange(parms);
using (var rdr = command.ExecuteReader(CommandBehavior.CloseConnection)) {
while (rdr.Read())
{
var user = new RecentUserInfo();
user.UniqueID = ComUtility.DBNullGuidHandler(rdr["unique_id"]);
user.RecentUser = ComUtility.DBNullStringHandler(rdr["recent_user"]);
user.RecentPwd = ComUtility.DBNullStringHandler(rdr["recent_pwd"]);
user.RecentRmb = ComUtility.DBNullBooleanHandler(rdr["recent_rmb"]);
user.RecentLan = ComUtility.DBNullStringHandler(rdr["recent_lan"]);
user.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["update_time"]);
users.Add(user);
}
}
}
}
return(users);
} catch {
throw;
}
}
/// <summary>
/// Get interface paramter.
/// </summary>
/// <returns>interface paramter</returns>
public InterfaceInfo GetInterfaceParamter()
{
try {
InterfaceInfo parm = null;
using (var conn = new SQLiteConnection(registryConnectionString)) {
conn.SetPassword(dbPassword);
conn.Open();
using (var command = new SQLiteCommand(SQLiteText.Registry_Get_Interface, conn)) {
using (var rdr = command.ExecuteReader(CommandBehavior.CloseConnection)) {
if (rdr.Read())
{
parm = new InterfaceInfo();
parm.UniqueID = ComUtility.DBNullGuidHandler(rdr["unique_id"]);
parm.InterfaceIP = ComUtility.DBNullStringHandler(rdr["interface_ip"]);
parm.InterfacePort = ComUtility.DBNullInt32Handler(rdr["interface_port"]);
parm.InterfaceUser = ComUtility.DBNullStringHandler(rdr["interface_user"]);
parm.InterfacePwd = ComUtility.DBNullStringHandler(rdr["interface_pwd"]);
parm.InterfaceDetect = ComUtility.DBNullInt32Handler(rdr["interface_detect"]);
parm.InterfaceInterrupt = ComUtility.DBNullInt32Handler(rdr["interface_interrupt"]);
parm.InterfaceSyncTime = ComUtility.DBNullBooleanHandler(rdr["interface_synctime"]);
parm.UpdateTime = ComUtility.DBNullDateTimeHandler(rdr["update_time"]);
}
}
}
}
return(parm);
} catch {
throw;
}
}
//通知范围检查
private void CKSubmit()
{
ComUtility Ut = new ComUtility();
string NoticeId = Ut.CheckApply("三八妇女节", UserInfo.UserID, "");
this.PageState.Add("NoticeState", NoticeId);
}
/// <summary>
/// Cards GridView CellValue Needed Event.
/// </summary>
private void CardsGridView_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
try {
if (e.RowIndex > GridCards.Count - 1)
{
return;
}
switch (CardsGridView.Columns[e.ColumnIndex].Name)
{
case "IDColumn":
e.Value = e.RowIndex + 1;
break;
case "EIDColumn":
e.Value = String.Format("{0} - {1}", GridCards[e.RowIndex].WorkerId, GridCards[e.RowIndex].WorkerName);
break;
case "CardSnColumn":
e.Value = GridCards[e.RowIndex].CardSn;
if (!String.IsNullOrWhiteSpace(SelectedCardSn) && SelectedCardSn.Equals(e.Value))
{
CardsGridView.ClearSelection();
CardsGridView.Rows[e.RowIndex].Selected = true;
SelectedCardSn = null;
}
break;
case "DepNameColumn":
e.Value = String.Format("{0} - {1}", GridCards[e.RowIndex].DepId, GridCards[e.RowIndex].DepName);
break;
case "CardTypeColumn":
e.Value = ComUtility.GetCardTypeText(GridCards[e.RowIndex].CardType);
break;
case "BeginTimeColumn":
e.Value = Common.GetDateTimeString(GridCards[e.RowIndex].BeginTime);
break;
case "BeginReasonColumn":
e.Value = GridCards[e.RowIndex].BeginReason;
break;
case "CommentColumn":
e.Value = GridCards[e.RowIndex].Comment;
break;
case "EnabledColumn":
e.Value = GridCards[e.RowIndex].Enabled ? "启用" : "禁用";
break;
default:
break;
}
} catch (Exception err) {
Common.WriteLog(DateTime.Now, EnmMsgType.Error, "System", "Delta.MPS.AccessSystem.OrgCardManagerForm.CardsGridView.CellValueNeeded", err.Message, err.StackTrace);
MessageBox.Show(err.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
