/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.ReaderInfo GetModel(int ReaderID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ReaderID,ReaderPointID,ReaderType,ReaderName,ReaderLocation,ReaderVersion,ReaderSAM,ReaderSAMType,CardType,CardReadArea,FingerEnable,SercurityAccessLevel,SuperviseMode,PINIdentify,ReaderPIN,DuressCode,ArmPassWord,UnarmPassWord,CommunicateType,ReaderIP,ReaderSubnet,ReaderGateway,ReaderPort,ReaderDNS,ReaderBuDNS,ReaderAddr483,ReaderBaudrate,ReaderDataBits,ReaderStopBits,ReaderParityCheck,ReaderFlowControl,ReaderUsage,ReadTimeAccessID from ReaderInfo ");
strSql.Append(" where ReaderID=@ReaderID ");
SqlParameter[] parameters =
{
new SqlParameter("@ReaderID", SqlDbType.Int, 4)
};
parameters[0].Value = ReaderID;
KryptonAccessController.AccessDataBase.Model.ReaderInfo model = new KryptonAccessController.AccessDataBase.Model.ReaderInfo();
DataSet ds = DbHelperSQL.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.AccessDataBase.Model.ReaderInfo GetModel(int ReaderID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ReaderID,ReaderPointID,ReaderType,ReaderName,ReaderLocation,ReaderVersion,ReaderSAM,ReaderSAMType,CardType,CardReadArea,FingerEnable,SercurityAccessLevel,SuperviseMode,PINIdentify,ReaderPIN,DuressCode,ArmPassWord,UnarmPassWord,CommunicateType,ReaderIP,ReaderSubnet,ReaderGateway,ReaderPort,ReaderDNS,ReaderBuDNS,ReaderAddr483,ReaderBaudrate,ReaderDataBits,ReaderStopBits,ReaderParityCheck,ReaderFlowControl,ReaderUsage,ReadTimeAccessID from ReaderInfo ");
strSql.Append(" where ReaderID=@ReaderID ");
SqlParameter[] parameters = {
new SqlParameter("@ReaderID", SqlDbType.Int,4) };
parameters[0].Value = ReaderID;
KryptonAccessController.AccessDataBase.Model.ReaderInfo model=new KryptonAccessController.AccessDataBase.Model.ReaderInfo();
DataSet ds=DbHelperSQL.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.AccessDataBase.Model.ReaderInfo DataRowToModel(DataRow row)
{
KryptonAccessController.AccessDataBase.Model.ReaderInfo model=new KryptonAccessController.AccessDataBase.Model.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["SuperviseMode"]!=null && row["SuperviseMode"].ToString()!="")
{
model.SuperviseMode=int.Parse(row["SuperviseMode"].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["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 Add(KryptonAccessController.AccessDataBase.Model.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,SuperviseMode,PINIdentify,ReaderPIN,DuressCode,ArmPassWord,UnarmPassWord,CommunicateType,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,@SuperviseMode,@PINIdentify,@ReaderPIN,@DuressCode,@ArmPassWord,@UnarmPassWord,@CommunicateType,@ReaderIP,@ReaderSubnet,@ReaderGateway,@ReaderPort,@ReaderDNS,@ReaderBuDNS,@ReaderAddr483,@ReaderBaudrate,@ReaderDataBits,@ReaderStopBits,@ReaderParityCheck,@ReaderFlowControl,@ReaderUsage,@ReadTimeAccessID)");
SqlParameter[] parameters =
{
new SqlParameter("@ReaderID", SqlDbType.Int, 4),
new SqlParameter("@ReaderPointID", SqlDbType.Int, 4),
new SqlParameter("@ReaderType", SqlDbType.NVarChar, 1),
new SqlParameter("@ReaderName", SqlDbType.NVarChar, 50),
new SqlParameter("@ReaderLocation", SqlDbType.NVarChar, 100),
new SqlParameter("@ReaderVersion", SqlDbType.NVarChar, 50),
new SqlParameter("@ReaderSAM", SqlDbType.Int, 4),
new SqlParameter("@ReaderSAMType", SqlDbType.Int, 4),
new SqlParameter("@CardType", SqlDbType.Int, 4),
new SqlParameter("@CardReadArea", SqlDbType.Int, 4),
new SqlParameter("@FingerEnable", SqlDbType.Bit, 1),
new SqlParameter("@SercurityAccessLevel", SqlDbType.Int, 4),
new SqlParameter("@SuperviseMode", SqlDbType.Int, 4),
new SqlParameter("@PINIdentify", SqlDbType.Int, 4),
new SqlParameter("@ReaderPIN", SqlDbType.NVarChar, 10),
new SqlParameter("@DuressCode", SqlDbType.NVarChar, 10),
new SqlParameter("@ArmPassWord", SqlDbType.NVarChar, 10),
new SqlParameter("@UnarmPassWord", SqlDbType.NVarChar, 10),
new SqlParameter("@CommunicateType", SqlDbType.Int, 4),
new SqlParameter("@ReaderIP", SqlDbType.NVarChar, 20),
new SqlParameter("@ReaderSubnet", SqlDbType.NVarChar, 20),
new SqlParameter("@ReaderGateway", SqlDbType.NVarChar, 20),
new SqlParameter("@ReaderPort", SqlDbType.Int, 4),
new SqlParameter("@ReaderDNS", SqlDbType.NVarChar, 20),
new SqlParameter("@ReaderBuDNS", SqlDbType.NVarChar, 20),
new SqlParameter("@ReaderAddr483", SqlDbType.Int, 4),
new SqlParameter("@ReaderBaudrate", SqlDbType.Int, 4),
new SqlParameter("@ReaderDataBits", SqlDbType.Int, 4),
new SqlParameter("@ReaderStopBits", SqlDbType.Int, 4),
new SqlParameter("@ReaderParityCheck", SqlDbType.NVarChar, 8),
new SqlParameter("@ReaderFlowControl", SqlDbType.NVarChar, 8),
new SqlParameter("@ReaderUsage", SqlDbType.Int, 4),
new SqlParameter("@ReadTimeAccessID", SqlDbType.Int, 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.SuperviseMode;
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.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;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.AccessDataBase.Model.ReaderInfo DataRowToModel(DataRow row)
{
KryptonAccessController.AccessDataBase.Model.ReaderInfo model = new KryptonAccessController.AccessDataBase.Model.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["SuperviseMode"] != null && row["SuperviseMode"].ToString() != "")
{
model.SuperviseMode = int.Parse(row["SuperviseMode"].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["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.AccessDataBase.Model.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("SuperviseMode=@SuperviseMode,");
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("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 ");
SqlParameter[] parameters =
{
new SqlParameter("@ReaderPointID", SqlDbType.Int, 4),
new SqlParameter("@ReaderType", SqlDbType.NVarChar, 1),
new SqlParameter("@ReaderName", SqlDbType.NVarChar, 50),
new SqlParameter("@ReaderLocation", SqlDbType.NVarChar, 100),
new SqlParameter("@ReaderVersion", SqlDbType.NVarChar, 50),
new SqlParameter("@ReaderSAM", SqlDbType.Int, 4),
new SqlParameter("@ReaderSAMType", SqlDbType.Int, 4),
new SqlParameter("@CardType", SqlDbType.Int, 4),
new SqlParameter("@CardReadArea", SqlDbType.Int, 4),
new SqlParameter("@FingerEnable", SqlDbType.Bit, 1),
new SqlParameter("@SercurityAccessLevel", SqlDbType.Int, 4),
new SqlParameter("@SuperviseMode", SqlDbType.Int, 4),
new SqlParameter("@PINIdentify", SqlDbType.Int, 4),
new SqlParameter("@ReaderPIN", SqlDbType.NVarChar, 10),
new SqlParameter("@DuressCode", SqlDbType.NVarChar, 10),
new SqlParameter("@ArmPassWord", SqlDbType.NVarChar, 10),
new SqlParameter("@UnarmPassWord", SqlDbType.NVarChar, 10),
new SqlParameter("@CommunicateType", SqlDbType.Int, 4),
new SqlParameter("@ReaderIP", SqlDbType.NVarChar, 20),
new SqlParameter("@ReaderSubnet", SqlDbType.NVarChar, 20),
new SqlParameter("@ReaderGateway", SqlDbType.NVarChar, 20),
new SqlParameter("@ReaderPort", SqlDbType.Int, 4),
new SqlParameter("@ReaderDNS", SqlDbType.NVarChar, 20),
new SqlParameter("@ReaderBuDNS", SqlDbType.NVarChar, 20),
new SqlParameter("@ReaderAddr483", SqlDbType.Int, 4),
new SqlParameter("@ReaderBaudrate", SqlDbType.Int, 4),
new SqlParameter("@ReaderDataBits", SqlDbType.Int, 4),
new SqlParameter("@ReaderStopBits", SqlDbType.Int, 4),
new SqlParameter("@ReaderParityCheck", SqlDbType.NVarChar, 8),
new SqlParameter("@ReaderFlowControl", SqlDbType.NVarChar, 8),
new SqlParameter("@ReaderUsage", SqlDbType.Int, 4),
new SqlParameter("@ReadTimeAccessID", SqlDbType.Int, 4),
new SqlParameter("@ReaderID", SqlDbType.Int, 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.SuperviseMode;
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.ReaderIP;
parameters[19].Value = model.ReaderSubnet;
parameters[20].Value = model.ReaderGateway;
parameters[21].Value = model.ReaderPort;
parameters[22].Value = model.ReaderDNS;
parameters[23].Value = model.ReaderBuDNS;
parameters[24].Value = model.ReaderAddr483;
parameters[25].Value = model.ReaderBaudrate;
parameters[26].Value = model.ReaderDataBits;
parameters[27].Value = model.ReaderStopBits;
parameters[28].Value = model.ReaderParityCheck;
parameters[29].Value = model.ReaderFlowControl;
parameters[30].Value = model.ReaderUsage;
parameters[31].Value = model.ReadTimeAccessID;
parameters[32].Value = model.ReaderID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}