/// <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>
/// 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>
/// Class Constructor
/// </summary>
public SaveCardAuthForm(EnmSaveBehavior Behavior, CardInfo Card, CardAuthInfo CardAuth, List <CardInfo> Cards, List <DepartmentInfo> Departments, List <OrgEmployeeInfo> OrgEmployees, List <OutEmployeeInfo> OutEmployees)
{
InitializeComponent();
CardAuthEntity = new CardAuth();
CurBehavior = Behavior;
CurCardAuth = new CardAuthInfo();
OriCardAuth = CardAuth;
CurCard = Card;
Common.CopyObjectValues(OriCardAuth, CurCardAuth);
CurCards = Cards;
CurDepartments = Departments;
CurOrgEmployees = OrgEmployees;
CurOutEmployees = OutEmployees;
CurExistsCards = new Dictionary <String, Int32>();
Text = Behavior == EnmSaveBehavior.Add ? "新增授权信息" : "编辑授权信息";
}
/// <summary>
/// Class Constructor
/// </summary>
public SaveCardDevAuthForm(EnmSaveBehavior Behavior, List <CardAuthInfo> CardAuth, List <NodeLevelInfo> Nodes)
{
InitializeComponent();
CardAuthEntity = new CardAuth();
CurBehavior = Behavior;
OriCardAuth = CardAuth;
CurCardAuth = new List <CardAuthInfo>();
CurNodes = Nodes;
foreach (var oc in OriCardAuth)
{
var newCardAuth = new CardAuthInfo();
Common.CopyObjectValues(oc, newCardAuth);
CurCardAuth.Add(newCardAuth);
}
Text = Behavior == EnmSaveBehavior.Add ? "新增授权信息" : "编辑授权信息";
CurExistsNodes = new Dictionary <Int32, String>();
}
/// <summary>
/// Bitch Update Card Auth.
/// </summary>
/// <param name="Ids">Ids</param>
/// <param name="auth">auth</param>
public void UpdateBitchCardAuth(List <IDValuePair <Int32, String> > Ids, CardAuthInfo auth)
{
SqlParameter[] parms = { new SqlParameter("@CardSn", SqlDbType.VarChar, 50),
new SqlParameter("@RtuId", SqlDbType.Int),
new SqlParameter("@LimitId", SqlDbType.Int),
new SqlParameter("@LimitIndex", SqlDbType.Int),
new SqlParameter("@BeginTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@Password", SqlDbType.VarChar, 50),
new SqlParameter("@Enabled", SqlDbType.Bit) };
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 = ComUtility.GetCardSn10to16(id.Value);
parms[1].Value = id.ID;
parms[2].Value = (Int32)auth.LimitId;
parms[3].Value = ComUtility.DBNullInt32Checker(auth.LimitIndex);
parms[4].Value = auth.BeginTime;
parms[5].Value = auth.EndTime;
parms[6].Value = ComUtility.DBNullStringChecker(auth.Password);
parms[7].Value = auth.Enabled;
SQLHelper.ExecuteNonQuery(tran, CommandType.Text, SQLText.SQL_CA_BitchUpdateCardAuth, parms);
}
tran.Commit();
} catch {
tran.Rollback();
throw;
}
}
}
}
/// <summary>
/// Save Button Click Event.
/// </summary>
private void SaveBtn_Click(object sender, EventArgs e)
{
try {
var target = new CardAuthInfo();
target.BeginTime = BeginTimeDTP.Value;
target.EndTime = EndTimeDTP.Value;
target.Password = PwdCB.Text.Trim();
target.Enabled = EnabledCB.Checked;
var limitId = (Int32)LimitTypeCB.SelectedValue;
switch ((EnmLimitID)limitId)
{
case EnmLimitID.TQ:
target.LimitId = EnmLimitID.TQ;
target.LimitIndex = ComUtility.DefaultInt32;
break;
case EnmLimitID.WTMG:
target.LimitId = EnmLimitID.WTMG;
target.LimitIndex = Convert.ToInt32(LimitIndexCB.SelectedValue);
break;
case EnmLimitID.DTM:
target.LimitId = EnmLimitID.DTM;
target.LimitIndex = Convert.ToInt32(LimitIndexCB.SelectedValue);
break;
}
var SaveCardAuth = new List <CardAuthInfo>();
if (CurBehavior == EnmSaveBehavior.Add)
{
var Devices = new List <Int32>();
CheckDevTreeView(DeviceTreeView.Nodes, Devices);
if (Devices.Count == 0)
{
MessageBox.Show("请勾选需要授权的设备", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var Cards = new List <String>();
CheckCardsTreeView(CardsTreeView.Nodes, Cards);
if (Cards.Count == 0)
{
MessageBox.Show("请勾选需要授权的卡片", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
foreach (var dev in Devices)
{
foreach (var card in Cards)
{
var ca = new CardAuthInfo();
ca.CardSn = card;
ca.DevId = dev;
ca.LimitId = target.LimitId;
ca.LimitIndex = target.LimitIndex;
ca.BeginTime = target.BeginTime;
ca.EndTime = target.EndTime;
ca.Password = target.Password;
ca.Enabled = target.Enabled;
SaveCardAuth.Add(ca);
}
}
}
else
{
foreach (var ca in CurCardAuth)
{
ca.LimitId = target.LimitId;
ca.LimitIndex = target.LimitIndex;
ca.BeginTime = target.BeginTime;
ca.EndTime = target.EndTime;
ca.Password = target.Password;
ca.Enabled = target.Enabled;
}
SaveCardAuth.AddRange(CurCardAuth);
}
var IsSync = SyncCB.Checked;
var result = Common.ShowWait(() => {
CardAuthEntity.SaveCardAuth(SaveCardAuth, IsSync);
}, default(String), "正在保存，请稍后...", default(Int32), default(Int32));
if (result == DialogResult.OK)
{
foreach (var ca in SaveCardAuth)
{
Common.WriteLog(DateTime.Now, CurBehavior == EnmSaveBehavior.Add ? EnmMsgType.Authin : EnmMsgType.Info, Common.CurUser.UserName, "Delta.MPS.AccessSystem.SaveCardDevAuthForm.SaveBtn.Click", String.Format("{0}卡片授权[设备:{1} 卡号:{2}]", CurBehavior == EnmSaveBehavior.Add ? "新增" : "更新", ca.DevId, ca.CardSn), null);
}
if (CurBehavior == EnmSaveBehavior.Edit)
{
foreach (var cc in CurCardAuth)
{
var OriCA = OriCardAuth.Find(oc => oc.CardSn.Equals(cc.CardSn) && oc.DevId == cc.DevId);
if (OriCA != null)
{
Common.CopyObjectValues(cc, OriCA);
}
}
}
MessageBox.Show("数据保存完成", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("数据保存失败", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
} catch (Exception err) {
Common.WriteLog(DateTime.Now, EnmMsgType.Error, "System", "Delta.MPS.AccessSystem.SaveCardDevAuthForm.SaveBtn.Click", err.Message, err.StackTrace);
MessageBox.Show(err.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Save Button Click Event.
/// </summary>
private void SaveBtn_Click(object sender, EventArgs e)
{
try {
if (TotalRecords.Count == 0)
{
MessageBox.Show("暂无需要保存的记录", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBox.Show("您确定要保存吗？", "确认对话框", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK)
{
var target = new CardAuthInfo();
target.BeginTime = BeginTimeDTP.Value;
target.EndTime = EndTimeDTP.Value;
target.Password = PwdCB.Text.Trim();
target.Enabled = true;
var limitId = (Int32)LimitTypeCB.SelectedValue;
switch ((EnmLimitID)limitId)
{
case EnmLimitID.TQ:
target.LimitId = EnmLimitID.TQ;
target.LimitIndex = ComUtility.DefaultInt32;
break;
case EnmLimitID.WTMG:
target.LimitId = EnmLimitID.WTMG;
target.LimitIndex = Convert.ToInt32(LimitIndexCB.SelectedValue);
break;
case EnmLimitID.DTM:
target.LimitId = EnmLimitID.DTM;
target.LimitIndex = Convert.ToInt32(LimitIndexCB.SelectedValue);
break;
}
var ids = new List <IDValuePair <Int32, String> >();
foreach (var tr in TotalRecords)
{
var id = new IDValuePair <Int32, String>(tr.Value2.RtuId, tr.Value2.CardSn);
ids.Add(id);
}
var result = Common.ShowWait(() => {
new CardAuth().UpdateBitchCardAuth(ids, target);
}, default(string), "正在保存，请稍后...", default(int), default(int), 1800);
if (result == DialogResult.OK)
{
foreach (var tr in TotalRecords)
{
Common.WriteLog(DateTime.Now, EnmMsgType.Info, Common.CurUser.UserName, "Delta.MPS.AccessSystem.BitchUpdateEndTimeForm.SaveBtn.Click", String.Format("更新卡片授权[设备:{0} 卡号:{1}]", tr.Value2.DevId, tr.Value2.CardSn), null);
}
BindAuthToGridView();
MessageBox.Show("数据保存完成", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("数据保存失败", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
} catch (Exception err) {
Common.WriteLog(DateTime.Now, EnmMsgType.Error, "System", "Delta.MPS.AccessSystem.BitchUpdateEndTimeForm.SaveBtn.Click", err.Message, err.StackTrace);
MessageBox.Show(err.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Save CardAuth Click Event.
/// </summary>
private void SaveBtn_Click(object sender, EventArgs e)
{
try {
var target = new CardAuthInfo();
target.BeginTime = BeginTimeDTP.Value;
target.EndTime = EndTimeDTP.Value;
target.Password = PwdCB.Text.Trim();
target.Enabled = EnabledCB.Checked;
var limitId = (Int32)LimitTypeCB.SelectedValue;
switch ((EnmLimitID)limitId)
{
case EnmLimitID.TQ:
target.LimitId = EnmLimitID.TQ;
target.LimitIndex = ComUtility.DefaultInt32;
break;
case EnmLimitID.WTMG:
target.LimitId = EnmLimitID.WTMG;
target.LimitIndex = Convert.ToInt32(LimitIndexCB.SelectedValue);
break;
case EnmLimitID.DTM:
target.LimitId = EnmLimitID.DTM;
target.LimitIndex = Convert.ToInt32(LimitIndexCB.SelectedValue);
break;
}
var Devices = new List <Int32>();
CheckDevTreeView(DevTreeView.Nodes, Devices);
if (Devices.Count == 0)
{
MessageBox.Show("请勾选需要授权的设备", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var Cards = new List <String>();
CheckCardsTreeView(CardTreeView.Nodes, Cards);
if (Cards.Count == 0)
{
MessageBox.Show("请勾选需要授权的卡片", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBox.Show("您确定要执行批量授权操作吗？", "确认对话框", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK)
{
var SaveCardAuth = new List <CardAuthInfo>();
foreach (var dev in Devices)
{
foreach (var card in Cards)
{
var ca = new CardAuthInfo();
ca.CardSn = card;
ca.DevId = dev;
ca.LimitId = target.LimitId;
ca.LimitIndex = target.LimitIndex;
ca.BeginTime = target.BeginTime;
ca.EndTime = target.EndTime;
ca.Password = target.Password;
ca.Enabled = target.Enabled;
SaveCardAuth.Add(ca);
}
}
var IsSync = SyncCB.Checked;
var result = Common.ShowWait(() => {
CardAuthEntity.SaveCardAuth(SaveCardAuth, IsSync);
}, default(String), "正在保存，请稍后...", default(Int32), default(Int32), 1800);
if (result == DialogResult.OK)
{
foreach (var ca in SaveCardAuth)
{
Common.WriteLog(DateTime.Now, EnmMsgType.Authin, Common.CurUser.UserName, "Delta.MPS.AccessSystem.BatchCardAuthForm.SaveBtn.Click", String.Format("新增卡片授权[设备:{0} 卡号:{1}]", ca.DevId, ca.CardSn), null);
}
MessageBox.Show("数据保存完成", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("数据保存失败", "系统警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
} catch (Exception err) {
Common.WriteLog(DateTime.Now, EnmMsgType.Error, "System", "Delta.MPS.AccessSystem.BatchCardAuthForm.SaveBtn.Click", err.Message, err.StackTrace);
MessageBox.Show(err.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
