/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo GetModel(int ReaderID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ReaderID,ReaderPointID,ReaderType,ReaderName,ReaderLocation,ReaderVersion,ReaderSAM,ReaderSAMType,CardType,CardReadArea,FingerEnable,SercurityAccessLevel,SupervisedMode,PINIdentify,ReaderPIN,DuressCode,ArmPassword,UnarmPassword,CommunicateType,ReaderMAC,ReaderIP,ReaderSubnet,ReaderGateway,ReaderPort,ReaderDNS,ReaderBuDNS,ReaderAddr483,ReaderBaudrate,ReaderDataBits,ReaderStopBits,ReaderParityCheck,ReaderFlowControl,ReaderUsage,ReadTimeAccessID from ReaderInfo "); strSql.Append(" where ReaderID=@ReaderID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ReaderID", DbType.Int32, 4) }; parameters[0].Value = ReaderID; KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo model = new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ReaderInfo("); strSql.Append("ReaderID,ReaderPointID,ReaderType,ReaderName,ReaderLocation,ReaderVersion,ReaderSAM,ReaderSAMType,CardType,CardReadArea,FingerEnable,SercurityAccessLevel,SupervisedMode,PINIdentify,ReaderPIN,DuressCode,ArmPassword,UnarmPassword,CommunicateType,ReaderMAC,ReaderIP,ReaderSubnet,ReaderGateway,ReaderPort,ReaderDNS,ReaderBuDNS,ReaderAddr483,ReaderBaudrate,ReaderDataBits,ReaderStopBits,ReaderParityCheck,ReaderFlowControl,ReaderUsage,ReadTimeAccessID)"); strSql.Append(" values ("); strSql.Append("@ReaderID,@ReaderPointID,@ReaderType,@ReaderName,@ReaderLocation,@ReaderVersion,@ReaderSAM,@ReaderSAMType,@CardType,@CardReadArea,@FingerEnable,@SercurityAccessLevel,@SupervisedMode,@PINIdentify,@ReaderPIN,@DuressCode,@ArmPassword,@UnarmPassword,@CommunicateType,@ReaderMAC,@ReaderIP,@ReaderSubnet,@ReaderGateway,@ReaderPort,@ReaderDNS,@ReaderBuDNS,@ReaderAddr483,@ReaderBaudrate,@ReaderDataBits,@ReaderStopBits,@ReaderParityCheck,@ReaderFlowControl,@ReaderUsage,@ReadTimeAccessID)"); SQLiteParameter[] parameters = { new SQLiteParameter("@ReaderID", DbType.Int32, 4), new SQLiteParameter("@ReaderPointID", DbType.Int32, 4), new SQLiteParameter("@ReaderType", DbType.String), new SQLiteParameter("@ReaderName", DbType.String), new SQLiteParameter("@ReaderLocation", DbType.String), new SQLiteParameter("@ReaderVersion", DbType.String), new SQLiteParameter("@ReaderSAM", DbType.Int32, 4), new SQLiteParameter("@ReaderSAMType", DbType.Int32, 4), new SQLiteParameter("@CardType", DbType.Int32, 4), new SQLiteParameter("@CardReadArea", DbType.Int32, 4), new SQLiteParameter("@FingerEnable", DbType.Boolean, 1), new SQLiteParameter("@SercurityAccessLevel", DbType.Int32, 4), new SQLiteParameter("@SupervisedMode", DbType.Int32, 4), new SQLiteParameter("@PINIdentify", DbType.Int32, 4), new SQLiteParameter("@ReaderPIN", DbType.String), new SQLiteParameter("@DuressCode", DbType.String), new SQLiteParameter("@ArmPassword", DbType.String), new SQLiteParameter("@UnarmPassword", DbType.String), new SQLiteParameter("@CommunicateType", DbType.Int32, 4), new SQLiteParameter("@ReaderMAC", DbType.String), new SQLiteParameter("@ReaderIP", DbType.String), new SQLiteParameter("@ReaderSubnet", DbType.String), new SQLiteParameter("@ReaderGateway", DbType.String), new SQLiteParameter("@ReaderPort", DbType.Int32, 4), new SQLiteParameter("@ReaderDNS", DbType.String), new SQLiteParameter("@ReaderBuDNS", DbType.String), new SQLiteParameter("@ReaderAddr483", DbType.Int32, 4), new SQLiteParameter("@ReaderBaudrate", DbType.Int32, 4), new SQLiteParameter("@ReaderDataBits", DbType.Int32, 4), new SQLiteParameter("@ReaderStopBits", DbType.Int32, 4), new SQLiteParameter("@ReaderParityCheck", DbType.String), new SQLiteParameter("@ReaderFlowControl", DbType.String), new SQLiteParameter("@ReaderUsage", DbType.Int32, 4), new SQLiteParameter("@ReadTimeAccessID", DbType.Int32, 4) }; parameters[0].Value = model.ReaderID; parameters[1].Value = model.ReaderPointID; parameters[2].Value = model.ReaderType; parameters[3].Value = model.ReaderName; parameters[4].Value = model.ReaderLocation; parameters[5].Value = model.ReaderVersion; parameters[6].Value = model.ReaderSAM; parameters[7].Value = model.ReaderSAMType; parameters[8].Value = model.CardType; parameters[9].Value = model.CardReadArea; parameters[10].Value = model.FingerEnable; parameters[11].Value = model.SercurityAccessLevel; parameters[12].Value = model.SupervisedMode; parameters[13].Value = model.PINIdentify; parameters[14].Value = model.ReaderPIN; parameters[15].Value = model.DuressCode; parameters[16].Value = model.ArmPassword; parameters[17].Value = model.UnarmPassword; parameters[18].Value = model.CommunicateType; parameters[19].Value = model.ReaderMAC; parameters[20].Value = model.ReaderIP; parameters[21].Value = model.ReaderSubnet; parameters[22].Value = model.ReaderGateway; parameters[23].Value = model.ReaderPort; parameters[24].Value = model.ReaderDNS; parameters[25].Value = model.ReaderBuDNS; parameters[26].Value = model.ReaderAddr483; parameters[27].Value = model.ReaderBaudrate; parameters[28].Value = model.ReaderDataBits; parameters[29].Value = model.ReaderStopBits; parameters[30].Value = model.ReaderParityCheck; parameters[31].Value = model.ReaderFlowControl; parameters[32].Value = model.ReaderUsage; parameters[33].Value = model.ReadTimeAccessID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo model = new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo(); if (row != null) { if (row["ReaderID"] != null && row["ReaderID"].ToString() != "") { model.ReaderID = int.Parse(row["ReaderID"].ToString()); } if (row["ReaderPointID"] != null && row["ReaderPointID"].ToString() != "") { model.ReaderPointID = int.Parse(row["ReaderPointID"].ToString()); } if (row["ReaderType"] != null) { model.ReaderType = row["ReaderType"].ToString(); } if (row["ReaderName"] != null) { model.ReaderName = row["ReaderName"].ToString(); } if (row["ReaderLocation"] != null) { model.ReaderLocation = row["ReaderLocation"].ToString(); } if (row["ReaderVersion"] != null) { model.ReaderVersion = row["ReaderVersion"].ToString(); } if (row["ReaderSAM"] != null && row["ReaderSAM"].ToString() != "") { model.ReaderSAM = int.Parse(row["ReaderSAM"].ToString()); } if (row["ReaderSAMType"] != null && row["ReaderSAMType"].ToString() != "") { model.ReaderSAMType = int.Parse(row["ReaderSAMType"].ToString()); } if (row["CardType"] != null && row["CardType"].ToString() != "") { model.CardType = int.Parse(row["CardType"].ToString()); } if (row["CardReadArea"] != null && row["CardReadArea"].ToString() != "") { model.CardReadArea = int.Parse(row["CardReadArea"].ToString()); } if (row["FingerEnable"] != null && row["FingerEnable"].ToString() != "") { if ((row["FingerEnable"].ToString() == "1") || (row["FingerEnable"].ToString().ToLower() == "true")) { model.FingerEnable = true; } else { model.FingerEnable = false; } } if (row["SercurityAccessLevel"] != null && row["SercurityAccessLevel"].ToString() != "") { model.SercurityAccessLevel = int.Parse(row["SercurityAccessLevel"].ToString()); } if (row["SupervisedMode"] != null && row["SupervisedMode"].ToString() != "") { model.SupervisedMode = int.Parse(row["SupervisedMode"].ToString()); } if (row["PINIdentify"] != null && row["PINIdentify"].ToString() != "") { model.PINIdentify = int.Parse(row["PINIdentify"].ToString()); } if (row["ReaderPIN"] != null) { model.ReaderPIN = row["ReaderPIN"].ToString(); } if (row["DuressCode"] != null) { model.DuressCode = row["DuressCode"].ToString(); } if (row["ArmPassword"] != null) { model.ArmPassword = row["ArmPassword"].ToString(); } if (row["UnarmPassword"] != null) { model.UnarmPassword = row["UnarmPassword"].ToString(); } if (row["CommunicateType"] != null && row["CommunicateType"].ToString() != "") { model.CommunicateType = int.Parse(row["CommunicateType"].ToString()); } if (row["ReaderMAC"] != null) { model.ReaderMAC = row["ReaderMAC"].ToString(); } if (row["ReaderIP"] != null) { model.ReaderIP = row["ReaderIP"].ToString(); } if (row["ReaderSubnet"] != null) { model.ReaderSubnet = row["ReaderSubnet"].ToString(); } if (row["ReaderGateway"] != null) { model.ReaderGateway = row["ReaderGateway"].ToString(); } if (row["ReaderPort"] != null && row["ReaderPort"].ToString() != "") { model.ReaderPort = int.Parse(row["ReaderPort"].ToString()); } if (row["ReaderDNS"] != null) { model.ReaderDNS = row["ReaderDNS"].ToString(); } if (row["ReaderBuDNS"] != null) { model.ReaderBuDNS = row["ReaderBuDNS"].ToString(); } if (row["ReaderAddr483"] != null && row["ReaderAddr483"].ToString() != "") { model.ReaderAddr483 = int.Parse(row["ReaderAddr483"].ToString()); } if (row["ReaderBaudrate"] != null && row["ReaderBaudrate"].ToString() != "") { model.ReaderBaudrate = int.Parse(row["ReaderBaudrate"].ToString()); } if (row["ReaderDataBits"] != null && row["ReaderDataBits"].ToString() != "") { model.ReaderDataBits = int.Parse(row["ReaderDataBits"].ToString()); } if (row["ReaderStopBits"] != null && row["ReaderStopBits"].ToString() != "") { model.ReaderStopBits = int.Parse(row["ReaderStopBits"].ToString()); } if (row["ReaderParityCheck"] != null) { model.ReaderParityCheck = row["ReaderParityCheck"].ToString(); } if (row["ReaderFlowControl"] != null) { model.ReaderFlowControl = row["ReaderFlowControl"].ToString(); } if (row["ReaderUsage"] != null && row["ReaderUsage"].ToString() != "") { model.ReaderUsage = int.Parse(row["ReaderUsage"].ToString()); } if (row["ReadTimeAccessID"] != null && row["ReadTimeAccessID"].ToString() != "") { model.ReadTimeAccessID = int.Parse(row["ReadTimeAccessID"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ReaderInfo set "); strSql.Append("ReaderPointID=@ReaderPointID,"); strSql.Append("ReaderType=@ReaderType,"); strSql.Append("ReaderName=@ReaderName,"); strSql.Append("ReaderLocation=@ReaderLocation,"); strSql.Append("ReaderVersion=@ReaderVersion,"); strSql.Append("ReaderSAM=@ReaderSAM,"); strSql.Append("ReaderSAMType=@ReaderSAMType,"); strSql.Append("CardType=@CardType,"); strSql.Append("CardReadArea=@CardReadArea,"); strSql.Append("FingerEnable=@FingerEnable,"); strSql.Append("SercurityAccessLevel=@SercurityAccessLevel,"); strSql.Append("SupervisedMode=@SupervisedMode,"); strSql.Append("PINIdentify=@PINIdentify,"); strSql.Append("ReaderPIN=@ReaderPIN,"); strSql.Append("DuressCode=@DuressCode,"); strSql.Append("ArmPassword=@ArmPassword,"); strSql.Append("UnarmPassword=@UnarmPassword,"); strSql.Append("CommunicateType=@CommunicateType,"); strSql.Append("ReaderMAC=@ReaderMAC,"); strSql.Append("ReaderIP=@ReaderIP,"); strSql.Append("ReaderSubnet=@ReaderSubnet,"); strSql.Append("ReaderGateway=@ReaderGateway,"); strSql.Append("ReaderPort=@ReaderPort,"); strSql.Append("ReaderDNS=@ReaderDNS,"); strSql.Append("ReaderBuDNS=@ReaderBuDNS,"); strSql.Append("ReaderAddr483=@ReaderAddr483,"); strSql.Append("ReaderBaudrate=@ReaderBaudrate,"); strSql.Append("ReaderDataBits=@ReaderDataBits,"); strSql.Append("ReaderStopBits=@ReaderStopBits,"); strSql.Append("ReaderParityCheck=@ReaderParityCheck,"); strSql.Append("ReaderFlowControl=@ReaderFlowControl,"); strSql.Append("ReaderUsage=@ReaderUsage,"); strSql.Append("ReadTimeAccessID=@ReadTimeAccessID"); strSql.Append(" where ReaderID=@ReaderID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ReaderPointID", DbType.Int32, 4), new SQLiteParameter("@ReaderType", DbType.String), new SQLiteParameter("@ReaderName", DbType.String), new SQLiteParameter("@ReaderLocation", DbType.String), new SQLiteParameter("@ReaderVersion", DbType.String), new SQLiteParameter("@ReaderSAM", DbType.Int32, 4), new SQLiteParameter("@ReaderSAMType", DbType.Int32, 4), new SQLiteParameter("@CardType", DbType.Int32, 4), new SQLiteParameter("@CardReadArea", DbType.Int32, 4), new SQLiteParameter("@FingerEnable", DbType.Boolean, 1), new SQLiteParameter("@SercurityAccessLevel", DbType.Int32, 4), new SQLiteParameter("@SupervisedMode", DbType.Int32, 4), new SQLiteParameter("@PINIdentify", DbType.Int32, 4), new SQLiteParameter("@ReaderPIN", DbType.String), new SQLiteParameter("@DuressCode", DbType.String), new SQLiteParameter("@ArmPassword", DbType.String), new SQLiteParameter("@UnarmPassword", DbType.String), new SQLiteParameter("@CommunicateType", DbType.Int32, 4), new SQLiteParameter("@ReaderMAC", DbType.String), new SQLiteParameter("@ReaderIP", DbType.String), new SQLiteParameter("@ReaderSubnet", DbType.String), new SQLiteParameter("@ReaderGateway", DbType.String), new SQLiteParameter("@ReaderPort", DbType.Int32, 4), new SQLiteParameter("@ReaderDNS", DbType.String), new SQLiteParameter("@ReaderBuDNS", DbType.String), new SQLiteParameter("@ReaderAddr483", DbType.Int32, 4), new SQLiteParameter("@ReaderBaudrate", DbType.Int32, 4), new SQLiteParameter("@ReaderDataBits", DbType.Int32, 4), new SQLiteParameter("@ReaderStopBits", DbType.Int32, 4), new SQLiteParameter("@ReaderParityCheck", DbType.String), new SQLiteParameter("@ReaderFlowControl", DbType.String), new SQLiteParameter("@ReaderUsage", DbType.Int32, 4), new SQLiteParameter("@ReadTimeAccessID", DbType.Int32, 4), new SQLiteParameter("@ReaderID", DbType.Int32, 4) }; parameters[0].Value = model.ReaderPointID; parameters[1].Value = model.ReaderType; parameters[2].Value = model.ReaderName; parameters[3].Value = model.ReaderLocation; parameters[4].Value = model.ReaderVersion; parameters[5].Value = model.ReaderSAM; parameters[6].Value = model.ReaderSAMType; parameters[7].Value = model.CardType; parameters[8].Value = model.CardReadArea; parameters[9].Value = model.FingerEnable; parameters[10].Value = model.SercurityAccessLevel; parameters[11].Value = model.SupervisedMode; parameters[12].Value = model.PINIdentify; parameters[13].Value = model.ReaderPIN; parameters[14].Value = model.DuressCode; parameters[15].Value = model.ArmPassword; parameters[16].Value = model.UnarmPassword; parameters[17].Value = model.CommunicateType; parameters[18].Value = model.ReaderMAC; parameters[19].Value = model.ReaderIP; parameters[20].Value = model.ReaderSubnet; parameters[21].Value = model.ReaderGateway; parameters[22].Value = model.ReaderPort; parameters[23].Value = model.ReaderDNS; parameters[24].Value = model.ReaderBuDNS; parameters[25].Value = model.ReaderAddr483; parameters[26].Value = model.ReaderBaudrate; parameters[27].Value = model.ReaderDataBits; parameters[28].Value = model.ReaderStopBits; parameters[29].Value = model.ReaderParityCheck; parameters[30].Value = model.ReaderFlowControl; parameters[31].Value = model.ReaderUsage; parameters[32].Value = model.ReadTimeAccessID; parameters[33].Value = model.ReaderID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo GetModel(int ReaderID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select ReaderID,ReaderPointID,ReaderType,ReaderName,ReaderLocation,ReaderVersion,ReaderSAM,ReaderSAMType,CardType,CardReadArea,FingerEnable,SercurityAccessLevel,SupervisedMode,PINIdentify,ReaderPIN,DuressCode,ArmPassword,UnarmPassword,CommunicateType,ReaderMAC,ReaderIP,ReaderSubnet,ReaderGateway,ReaderPort,ReaderDNS,ReaderBuDNS,ReaderAddr483,ReaderBaudrate,ReaderDataBits,ReaderStopBits,ReaderParityCheck,ReaderFlowControl,ReaderUsage,ReadTimeAccessID from ReaderInfo "); strSql.Append(" where ReaderID=@ReaderID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ReaderID", DbType.Int32,4) }; parameters[0].Value = ReaderID; KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo model=new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo(); DataSet ds=DbHelperSQLite.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo DataRowToModel(DataRow row) { KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo model=new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo(); if (row != null) { if(row["ReaderID"]!=null && row["ReaderID"].ToString()!="") { model.ReaderID=int.Parse(row["ReaderID"].ToString()); } if(row["ReaderPointID"]!=null && row["ReaderPointID"].ToString()!="") { model.ReaderPointID=int.Parse(row["ReaderPointID"].ToString()); } if(row["ReaderType"]!=null) { model.ReaderType=row["ReaderType"].ToString(); } if(row["ReaderName"]!=null) { model.ReaderName=row["ReaderName"].ToString(); } if(row["ReaderLocation"]!=null) { model.ReaderLocation=row["ReaderLocation"].ToString(); } if(row["ReaderVersion"]!=null) { model.ReaderVersion=row["ReaderVersion"].ToString(); } if(row["ReaderSAM"]!=null && row["ReaderSAM"].ToString()!="") { model.ReaderSAM=int.Parse(row["ReaderSAM"].ToString()); } if(row["ReaderSAMType"]!=null && row["ReaderSAMType"].ToString()!="") { model.ReaderSAMType=int.Parse(row["ReaderSAMType"].ToString()); } if(row["CardType"]!=null && row["CardType"].ToString()!="") { model.CardType=int.Parse(row["CardType"].ToString()); } if(row["CardReadArea"]!=null && row["CardReadArea"].ToString()!="") { model.CardReadArea=int.Parse(row["CardReadArea"].ToString()); } if(row["FingerEnable"]!=null && row["FingerEnable"].ToString()!="") { if((row["FingerEnable"].ToString()=="1")||(row["FingerEnable"].ToString().ToLower()=="true")) { model.FingerEnable=true; } else { model.FingerEnable=false; } } if(row["SercurityAccessLevel"]!=null && row["SercurityAccessLevel"].ToString()!="") { model.SercurityAccessLevel=int.Parse(row["SercurityAccessLevel"].ToString()); } if(row["SupervisedMode"]!=null && row["SupervisedMode"].ToString()!="") { model.SupervisedMode=int.Parse(row["SupervisedMode"].ToString()); } if(row["PINIdentify"]!=null && row["PINIdentify"].ToString()!="") { model.PINIdentify=int.Parse(row["PINIdentify"].ToString()); } if(row["ReaderPIN"]!=null) { model.ReaderPIN=row["ReaderPIN"].ToString(); } if(row["DuressCode"]!=null) { model.DuressCode=row["DuressCode"].ToString(); } if(row["ArmPassword"]!=null) { model.ArmPassword=row["ArmPassword"].ToString(); } if(row["UnarmPassword"]!=null) { model.UnarmPassword=row["UnarmPassword"].ToString(); } if(row["CommunicateType"]!=null && row["CommunicateType"].ToString()!="") { model.CommunicateType=int.Parse(row["CommunicateType"].ToString()); } if(row["ReaderMAC"]!=null) { model.ReaderMAC=row["ReaderMAC"].ToString(); } if(row["ReaderIP"]!=null) { model.ReaderIP=row["ReaderIP"].ToString(); } if(row["ReaderSubnet"]!=null) { model.ReaderSubnet=row["ReaderSubnet"].ToString(); } if(row["ReaderGateway"]!=null) { model.ReaderGateway=row["ReaderGateway"].ToString(); } if(row["ReaderPort"]!=null && row["ReaderPort"].ToString()!="") { model.ReaderPort=int.Parse(row["ReaderPort"].ToString()); } if(row["ReaderDNS"]!=null) { model.ReaderDNS=row["ReaderDNS"].ToString(); } if(row["ReaderBuDNS"]!=null) { model.ReaderBuDNS=row["ReaderBuDNS"].ToString(); } if(row["ReaderAddr483"]!=null && row["ReaderAddr483"].ToString()!="") { model.ReaderAddr483=int.Parse(row["ReaderAddr483"].ToString()); } if(row["ReaderBaudrate"]!=null && row["ReaderBaudrate"].ToString()!="") { model.ReaderBaudrate=int.Parse(row["ReaderBaudrate"].ToString()); } if(row["ReaderDataBits"]!=null && row["ReaderDataBits"].ToString()!="") { model.ReaderDataBits=int.Parse(row["ReaderDataBits"].ToString()); } if(row["ReaderStopBits"]!=null && row["ReaderStopBits"].ToString()!="") { model.ReaderStopBits=int.Parse(row["ReaderStopBits"].ToString()); } if(row["ReaderParityCheck"]!=null) { model.ReaderParityCheck=row["ReaderParityCheck"].ToString(); } if(row["ReaderFlowControl"]!=null) { model.ReaderFlowControl=row["ReaderFlowControl"].ToString(); } if(row["ReaderUsage"]!=null && row["ReaderUsage"].ToString()!="") { model.ReaderUsage=int.Parse(row["ReaderUsage"].ToString()); } if(row["ReadTimeAccessID"]!=null && row["ReadTimeAccessID"].ToString()!="") { model.ReadTimeAccessID=int.Parse(row["ReadTimeAccessID"].ToString()); } } return model; }