private void sbtnAddOk_Click(object sender, EventArgs e) { if (usingWg == DeviceUsing.未启用) { MessageUtil.ShowError("IC门禁控制器未配置,请检查系统设置"); return; } sbtnAddOk.Enabled = false; bool bl = true; MjRegisterCard mjrc = new MjRegisterCard(); foreach (DataRow dr in dtAddPower.Rows) { string str = dr["IcNo"].ToString(); bool blRet = wgControl.AddCardPower(str); if (blRet == false) { bl = false; break; } Thread.Sleep(20); } if (bl == true) { MessageUtil.ShowTips("添加权限成功"); foreach (DataRow dr in dtAddPower.Rows) { string str = dr["IcNo"].ToString(); string strSql = "update tb_DoorUser set IsPower='" + DoorPowerType.权限.ToString() + "' where IcNo='" + str + "' "; datalogic.SqlComNonQuery(strSql); string strGroup = dr["GroupName"].ToString(); string strName = dr["UserName"].ToString(); string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); strSql = "insert into tb_RecordPower (PowerType,GroupName,UserName,OperateTime,People)" + "values ('添加权限','" + strGroup + "','" + strName + "','" + strTime + "','" + frmMain.strUserName + "')"; datalogic.SqlComNonQuery(strSql); } } else { MessageUtil.ShowTips("添加权限失败"); } dtAddPower.Rows.Clear(); treeView1.Nodes.Clear(); AddTreeView("0", (TreeNode)null); treeView1.ExpandAll(); sbtnAddOk.Enabled = true; }
private void sbtnAdd_Click(object sender, EventArgs e) { sbtnAdd.Enabled = false; sbtnDelete.Enabled = false; sbtnDeleteExit.Enabled = false; lblInfo.Visible = true; if (MessageUtil.ShowYesNoAndTips("确定上传?") == DialogResult.Yes) { //所有选中的 工具柜 bool blBox = true; foreach (DataRow dr in dtBoxSelect.Rows) { string strChildId = dr["tvChildId"].ToString(); string strParentId = dr["tvParent"].ToString(); string strBoxName = dr["PlaceName"].ToString(); int iCount = listWg.Count; if (iCount > 0) { for (int iIndex = 0; iIndex < iCount; iIndex++) { if (listWg[iIndex].StrChildId == strChildId) { wgControl.IntSn = listWg[iIndex].IntSn; wgControl.StrIp = listWg[iIndex].StrIp; wgControl.IntPort = listWg[iIndex].IntPort; MjRegisterCard mjrc = new MjRegisterCard(); bool blUser = true; //所有选中的人 foreach (DataRow row in dtUserSelect.Rows) { string strIcNo = row["IcNo"].ToString(); string strUserId = row["tvChildId"].ToString(); string strName = row["UserName"].ToString(); string strCardNo = row["CardNo"].ToString(); if (wgControl.AddCardPower(strIcNo)) { //ID,BoxParentId,BoxChildId,UserId,BoxName,UserName,CardNo,IcNo tb_BoxIcPower // ID,UserName,IcNo,CardNo string strSql = "select ID from tb_BoxIcPower where BoxChildId='" + strChildId + "' and IcNo='" + strIcNo + "'"; DataTable dt = datalogic.GetDataTable(strSql); if (dt.Rows.Count == 0) { strSql = "insert into tb_BoxIcPower (BoxParentId,BoxChildId,UserId,BoxName,UserName,CardNo,IcNo)" + "values ('" + strParentId + "','" + strChildId + "','" + strUserId + "','" + strBoxName + "','" + strName + "','" + strCardNo + "','" + strIcNo + "')"; datalogic.SqlComNonQuery(strSql); } } else { blUser = false; break; } Thread.Sleep(20); } //人员中有授权错误 if (blUser == false) { blBox = false; } break; } } } // 工具柜 有授权错误 if (blBox == false) { break; } } if (blBox) { MessageUtil.ShowTips("添加权限成功"); } else { MessageUtil.ShowTips("添加权限失败,请检查设备或网络连接"); } } sbtnAdd.Enabled = true; sbtnDelete.Enabled = true; sbtnDeleteExit.Enabled = true; lblInfo.Visible = false; }