/// <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;
}
