public InputUserFeatureBL(String strConnectionString) { mstrConnectionString = strConnectionString; mDataSourceType = SND.DA.DataAccessHelper.DataSourceType.SqlClient; Common.Initialize(mstrConnectionString, mDataSourceType); DAccess = new KQInfo(Common.GetDataConnection(strConnectionString, SND.DA.DataAccessHelper.DataSourceType.SqlClient)); }
/// <summary> /// 同步数据从DB到设备 /// </summary> public static void CopyDataToDev() { try { KQInfo DAccess = new KQInfo(Common.GetDataConnection(DataCollection.Config.FRASConnectionString, SND.DA.DataAccessHelper.DataSourceType.SqlClient)); DataTable dt = DAccess.GetCopyData(); List<CopyData> list = new List<CopyData>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { int dwFlag = row["flag"] is DBNull ? 0 : System.Convert.ToInt32(row["flag"]); int dwCopyType = System.Convert.ToInt32(row["copyType"]); int dwAntNum = 0; dwAntNum = GetDevNum(dwFlag, dwCopyType); CopyData cdata = new CopyData(); cdata.StrDevNum = dwAntNum.ToString(); cdata.StrUserId = row["userid"].ToString(); cdata.StrUserName = row["username"].ToString(); cdata.StrFeaturePath = row["featurePath"].ToString(); cdata.StrPicturePath = row["photoPath"].ToString(); cdata.StrCardId = row["cardId"].ToString(); cdata.StrCopyType = row["copyType"].ToString(); cdata.StrFlag = dwFlag.ToString(); list.Add(cdata); } } // 开始同步数据 foreach (CopyData data in list) { if (DataCollection.MachineList.ContainsKey(data.StrDevNum)) { EnrollUserEventArgs arg = new EnrollUserEventArgs(); arg.UserId = System.Convert.ToInt32(data.StrUserId); arg.UserName = data.StrUserName; arg.strCardNo = string.IsNullOrEmpty(data.StrCardId) ? "0000000000" : data.StrCardId; arg.lPhotoType = 1; arg.strBase64FeatureData = ComFunc.FileToBase64String(ref arg.lFeatureLen, data.StrFeaturePath); arg.strBase64PhotoData = ComFunc.FileToBase64String(ref arg.lPhotoLen, data.StrPicturePath); IMachine m = DataCollection.MachineList[data.StrDevNum]; m.EnrollUser(arg); } } } catch (Exception ex) { LogManager.LogSys("==CopyDataToDev==" + ex.Message); } }
public static void CopyDevData() { try { KQInfo DAccess = new KQInfo(Common.GetDataConnection(DataCollection.Config.FRASConnectionString, SND.DA.DataAccessHelper.DataSourceType.SqlClient)); object lockObj = new object(); // 获取设备信息 System.Data.DataTable dt = DAccess.GetDevInfo(); if (dt != null) { foreach (System.Data.DataRow row in dt.Rows) { if (!DataCollection.DevInfos.ContainsKey(row["AntNo"].ToString())) { DevInfo devinfo = new DevInfo(); devinfo.AntNo = row["AntNo"] is DBNull ? "0" : row["AntNo"].ToString().Trim(); devinfo.DevIp = row["devIp"].ToString().Trim(); devinfo.DevPort = row["devPort"].ToString().Trim(); devinfo.DevType = row["devType"].ToString().Trim(); devinfo.DevUserName = row["devUserName"].ToString().Trim(); devinfo.DevPassWord = row["devPassWord"].ToString().Trim(); devinfo.AccessFlag = row["accessFlag"] is DBNull ? "0" : row["accessFlag"].ToString().Trim(); devinfo.Flag = row["flag"] is DBNull ? "0" : row["flag"].ToString().Trim(); lock (lockObj) { if (!DataCollection.DevInfos.ContainsKey(row["AntNo"].ToString())) { DataCollection.DevInfos.Add(devinfo.AntNo, devinfo); } } } } } } catch (Exception ex) { LogManager.LogSys("==CopyDevData==" + ex.Message); } }
public static void CopyUserData() { try { KQInfo DAccess = new KQInfo(Common.GetDataConnection(DataCollection.Config.FRASConnectionString, SND.DA.DataAccessHelper.DataSourceType.SqlClient)); object lockObj = new object(); // 获取用户信息 System.Data.DataTable dtUser = DAccess.GetUserInfo(); if (dtUser != null) { foreach (System.Data.DataRow row in dtUser.Rows) { if (!DataCollection.DevInfos.ContainsKey(row["userId"].ToString().Trim())) { UserInfo userInfo = new UserInfo(); userInfo.UserId = row["userId"].ToString().Trim(); userInfo.UserName = row["userName"].ToString(); userInfo.DeptId = row["deptId"].ToString(); userInfo.FeatureId = row["featureId"].ToString(); userInfo.RankId = row["rankId"].ToString(); userInfo.SenderId = row["senderId"] == null ? string.Empty : row["senderId"].ToString(); userInfo.CopyType = row["copyType"] is DBNull ? 0 : System.Convert.ToInt32(row["copyType"].ToString()); userInfo.CardNo = row["cardNo"] == null ? string.Empty : row["cardNo"].ToString(); userInfo.FeatureId = row["featureId"].ToString(); userInfo.FeaPath = row["featurePath"].ToString(); userInfo.PhtPath = row["photoPath"].ToString(); lock (lockObj) { if (!DataCollection.UserInfos.ContainsKey(row["userId"].ToString().Trim())) { DataCollection.UserInfos.Add(userInfo.UserId, userInfo); } } } } } } catch (Exception ex) { LogManager.LogSys("==CopyUserData==" + ex.Message); } }
/// <summary> /// 获取班次信息 /// </summary> public static void CopyRostingData() { try { KQInfo DAccess = new KQInfo(Common.GetDataConnection(DataCollection.Config.FRASConnectionString, SND.DA.DataAccessHelper.DataSourceType.SqlClient)); object lockObj = new object(); System.Data.DataTable dtRosting = DAccess.GetAllRostInfo(); if (dtRosting != null) { foreach (System.Data.DataRow row in dtRosting.Rows) { if (!DataCollection.RostingList.ContainsKey(System.Convert.ToInt32(row["ID"]))) { RostingData rosteData = new RostingData(); rosteData.ID = row["ID"].ToString(); rosteData.bcName = row["bcName"].ToString(); rosteData.startTime = row["startTime"].ToString(); rosteData.endTime = row["endTime"].ToString(); rosteData.earlyRange = row["earlyRange"] == null ? string.Empty : row["earlyRange"].ToString(); rosteData.lateRange = row["lateRange"] == null ? string.Empty : row["lateRange"].ToString(); rosteData.realStartTime = row["realStartTime"] == null ? string.Empty : row["realStartTime"].ToString(); rosteData.realStartTime = row["realEndTime"] == null ? string.Empty : row["realEndTime"].ToString(); rosteData.realStartTime = row["flag"] == null ? string.Empty : row["flag"].ToString(); rosteData.realStartTime = row["multType"] == null ? string.Empty : row["multType"].ToString(); rosteData.realStartTime = row["nextID"] == null ? string.Empty : row["nextID"].ToString(); rosteData.realStartTime = row["mulripleDur"] == null ? string.Empty : row["mulripleDur"].ToString(); rosteData.realStartTime = row["nightWork"] == null ? string.Empty : row["nightWork"].ToString(); rosteData.realStartTime = row["bak1"] == null ? string.Empty : row["bak1"].ToString(); rosteData.realStartTime = row["bak2"] == null ? string.Empty : row["bak2"].ToString(); rosteData.realStartTime = row["bak3"] == null ? string.Empty : row["bak3"].ToString(); rosteData.realStartTime = row["bak4"] == null ? string.Empty : row["bak4"].ToString(); lock (lockObj) { if (!DataCollection.RostingList.ContainsKey(System.Convert.ToInt32(row["ID"]))) { DataCollection.RostingList.Add(System.Convert.ToInt32(rosteData.ID), rosteData); } } } } } } catch (Exception ex) { LogManager.LogSys("==CopyRostingData==" + ex.Message); } }