/// <summary> /// 得到一个对象实体 /// </summary> public Scada.Model.IO_COMMUNICATION GetModel(string IO_COMM_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" IO_COMM_ID,IO_COMM_NAME,IO_COMM_LABEL,IO_COMM_REMARK,IO_COMM_STATUS,IO_COMM_DRIVER_ID,IO_SERVER_ID,IO_COMM_PARASTRING "); strSql.Append(" from IO_COMMUNICATION "); strSql.Append(" where IO_COMM_ID='" + IO_COMM_ID + "'"); Scada.Model.IO_COMMUNICATION model = new Scada.Model.IO_COMMUNICATION(); DataSet ds = DbHelperSQLite.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public Scada.Model.IO_SERVER GetModel() { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" SERVER_ID,SERVER_NAME,SERVER_STATUS,SERVER_IP,SERVER_CREATEDATE,SERVER_REMARK "); strSql.Append(" from IO_SERVER LIMIT 1"); Scada.Model.IO_SERVER model = new Scada.Model.IO_SERVER(); DataSet ds = DbHelperSQLite.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Scada.Model.ScadaTableDetail GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Id,TableId,FieldTitles,FieldIOPath,CreateTime,SortCode,CreateUserId,UpdateTime,UpdateUserId "); strSql.Append(" from ScadaTableDetail "); strSql.Append(" where Id=" + Id + ""); Scada.Model.ScadaTableDetail model = new Scada.Model.ScadaTableDetail(); DataSet ds = DbHelperSQLite.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Scada.Model.ScadaTable GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Id,Title,RoleUser,FilterRule,CreateTime,CreateUserId,UpdateTime,UpdateUserId,SortCode "); strSql.Append(" from ScadaTable "); strSql.Append(" where Id=" + Id + ""); Scada.Model.ScadaTable model = new Scada.Model.ScadaTable(); DataSet ds = DbHelperSQLite.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Scada.Model.IO_PARA GetModel(string IO_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" * "); strSql.Append(" from V_IO_PARA "); strSql.Append(" where IO_ID='" + IO_ID + "' and IO_STATUS=0 "); Scada.Model.IO_PARA model = new Scada.Model.IO_PARA(); DataSet ds = DbHelperSQLite.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Scada.Model.DeviceGroup GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Id,GroupId,IO_SERVER_ID,IO_COMM_ID,IO_DEVICE_ID "); strSql.Append(" from DeviceGroup "); strSql.Append(" where Id=" + Id + ""); Scada.Model.DeviceGroup model = new Scada.Model.DeviceGroup(); DataSet ds = DbHelperSQLite.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void button1_Click(object sender, EventArgs e) { //get the password from the database. string SQL = "SELECT * FROM FolderInfo WHERE folderName =@folderName"; SQLiteParameter p = new SQLiteParameter("@folderName", path); DataTable dt = DbHelperSQLite.Query(SQL, p).Tables[0]; // if (dt.Rows.Count == 0) { MessageBox.Show("password is missing"); } else { //the input password should be convert to md5 password; MD5 md5 = new MD5CryptoServiceProvider(); byte[] plaintext = Encoding.Default.GetBytes(textBox1.Text); byte[] ciphertext = md5.ComputeHash(plaintext); string md5Pwd = Convert.ToBase64String(ciphertext); if (md5Pwd == Convert.ToString(dt.Rows[0][1])) { status = true; MessageBox.Show("The folder is unlocked."); //delete the record; string DEL = "DELETE FROM FolderInfo WHERE folderName =@folderName"; DbHelperSQLite.ExecuteSql(DEL, p); // SendKeys.SendWait("{f5}"); this.Close(); } else { MessageBox.Show("password is incorrect."); textBox1.Clear(); textBox1.Focus(); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public DXD.Model.insurance_compare GetModel(int id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select id,query_id,feedback_id,report_id,compare_type,less_value,add_user,add_time from insurance_compare "); strSql.Append(" where id=@id"); SQLiteParameter[] parameters = { new SQLiteParameter("@id", DbType.Int32,4) }; parameters[0].Value = id; DXD.Model.insurance_compare model=new DXD.Model.insurance_compare(); DataSet ds=DbHelperSQLite.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
public DataTable GetWebSiteTask(int StepMinuTime) { DataSet ds = new DataSet(); StringBuilder strSql = new StringBuilder(); strSql.AppendFormat(@" Select * From S_WebSite Where Status=1 --And (julianday(UpdateTime)*24*60 - julianday('now')*24*60)>{0} Order by UpdateTime Asc Limit 5 ", StepMinuTime); ds = DbHelperSQLite.Query(strSql.ToString()); DataTable dt = ds.Tables[0].Clone(); foreach (DataRow dr in ds.Tables[0].Rows) { DateTime upDateTime = Convert.ToDateTime(dr["UpDateTime"]); if ((DateTime.Now - upDateTime).Minutes >= StepMinuTime) { dt.Rows.Add(dr.ItemArray); } } string IDs = string.Empty; foreach (DataRow dr in dt.Rows) { IDs += dr["ID"] + ","; } if (!string.IsNullOrEmpty(IDs)) { IDs = IDs.Remove(IDs.Length - 1); strSql = new StringBuilder(); strSql.Append(@" Update S_WebSite set UpdateTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + @"' Where ID in(" + IDs + @") "); DbHelperSQLite.ExecuteSql(strSql.ToString()); } return(dt); }
public DataTable GetModel(string tablename, string fieldStr, string strWhere) { if (string.IsNullOrEmpty(fieldStr)) { fieldStr = "*"; } string sql = string.Format("select {0} from [{1}] ", fieldStr, tablename); if (!string.IsNullOrEmpty(strWhere)) { sql += " where " + strWhere; } sql += " limit 1"; sql = StringHelper.ReplaceBadSQL(sql); DataSet ds = DbHelperSQLite.Query(sql); if (ds.Tables.Count > 0) { return(ds.Tables[0]); } return(null); }
/// <summary> /// 分页获取数据列表 /// </summary> public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex) { StringBuilder strSql=new StringBuilder(); strSql.Append("SELECT * FROM ( "); strSql.Append(" SELECT ROW_NUMBER() OVER ("); if (!string.IsNullOrEmpty(orderby.Trim())) { strSql.Append("order by T." + orderby ); } else { strSql.Append("order by T.id desc"); } strSql.Append(")AS Row, T.* from insurance_compare T "); if (!string.IsNullOrEmpty(strWhere.Trim())) { strSql.Append(" WHERE " + strWhere); } strSql.Append(" ) TT"); strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex); return DbHelperSQLite.Query(strSql.ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> public Blogs.Model.BlogArticle GetModel(int aid) { StringBuilder strSql=new StringBuilder(); strSql.Append("select aid,acate,aauthor,atitle,acontent,aimgsrc,aplnum,aallowpl,aistop,atag,acick,astatu,aaddtime,aupdatetime,aisdel,ahtmlsrc from BlogArticle "); strSql.Append(" where aid=@aid"); SQLiteParameter[] parameters = { new SQLiteParameter("@aid", DbType.Int32,4) }; parameters[0].Value = aid; Blogs.Model.BlogArticle model=new Blogs.Model.BlogArticle(); 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 Material.Model.level2 GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select name,level1_id,id2 from level2 "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Material.Model.level2 model = new Material.Model.level2(); 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 MaterialCodeGenerator.Model.MaterialCode GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select iMainClassID,cMainClassName,iLevel1ID,cLevel1Name,iLevel2ID,cLevel2Name,iLevel3ID,cLevel3Name from MaterialCode "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; MaterialCodeGenerator.Model.MaterialCode model = new MaterialCodeGenerator.Model.MaterialCode(); 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 Bsam.Core.Model.Models.Model.Sys_Module GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,ModuleType,ModuleCode,ModuleName,ModuleDesc,ModuleConfig,Path,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State from Sys_Module "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Sys_Module model = new Bsam.Core.Model.Models.Model.Sys_Module(); 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 static void GetUIInfo() { string sqlstr = "SELECT * FROM GSSCONFIG WHERE ID=1"; try { DataSet ds = DbHelperSQLite.Query(sqlstr); if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows != null) { string[] servinfo = new string[2]; string backcolor = ds.Tables[0].Rows[0]["GSSUIBACKCOLOR"].ToString(); string[] cols = backcolor.Split(','); _backcolor = Color.FromArgb(int.Parse(cols[0]), int.Parse(cols[1]), int.Parse(cols[2])); _opacity = Convert.ToDouble(ds.Tables[0].Rows[0]["GSSUIOPACITY"].ToString()); _topmost = ds.Tables[0].Rows[0]["GSSUITOPMOST"].ToString() == "1" ? true : false; } _backimage = GetImage(); } catch (System.Exception ex) { //不做处理 } }
/// <summary> /// 得到一个对象实体 /// </summary> public ERPWPF.Model.DingdanDetail GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Gid,Tid,GCode,GName,GGuige,GShuliang,GJinjia,GShoujia,GZhekou,GYouhui,GHeji from DingdanDetail "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; ERPWPF.Model.DingdanDetail model = new ERPWPF.Model.DingdanDetail(); 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 Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Dtl GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,BillId,MitemCode,PlanQty,ActualQty,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Inv_Rcv_Bill_Dtl "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Dtl model = new Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Dtl(); 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 Bsam.Core.Model.Models.Model.Sfc_Customer GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,CustomerCode,CustomerName,CustomerShortName,CustomerPhone,CustomerWebchat,EnterpriseName,EnterpriseLegal,EnterpriseAddress,EnterprisePhone,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Sfc_Customer "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Sfc_Customer model = new Bsam.Core.Model.Models.Model.Sfc_Customer(); 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 Bsam.Core.Model.Models.Model.Sys_User GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,UserName,UserAccount,UserPwd,Address,Phone,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State from Sys_User "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Sys_User model = new Bsam.Core.Model.Models.Model.Sys_User(); 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 Bsam.Core.Model.Models.Model.Inv_Loc GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,LocCode,LocName,LocDesc,LocStatus,LocOrder,Volume,VolumeUnit,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId,DistrictId,InvId from Inv_Loc "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Inv_Loc model = new Bsam.Core.Model.Models.Model.Inv_Loc(); 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 Bsam.Core.Model.Models.Model.Sfc_Production_Bom GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,ProductId,MitemId,ReqQty,Version,VersionDesc,BatchNo,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Sfc_Production_Bom "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Sfc_Production_Bom model = new Bsam.Core.Model.Models.Model.Sfc_Production_Bom(); 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 Bsam.Core.Model.Models.Model.Sfc_Mitem GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,MitemCode,MitemName,MitemDesc,MitemType,Brand,Buyer,DutyPerson,SupplierId,DefaultInvId,Uom,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Sfc_Mitem "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Sfc_Mitem model = new Bsam.Core.Model.Models.Model.Sfc_Mitem(); 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 Bsam.Core.Model.Models.Model.Inv_Onhand_Qty GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,MitemId,InvId,DistrictId,LocId,Trans_Qty,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Inv_Onhand_Qty "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Inv_Onhand_Qty model = new Bsam.Core.Model.Models.Model.Inv_Onhand_Qty(); 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 Bsam.Core.Model.Models.Model.Sys_PermissionGroup GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,PermissionGroupName,PermissionGroupDesc,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Sys_PermissionGroup "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Sys_PermissionGroup model = new Bsam.Core.Model.Models.Model.Sys_PermissionGroup(); 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 Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Hd GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,RcvType,RcvUserId,RcvUserName,RcvPhone,RcvDateTime,RcvReason,RcvAddress,RentSubject,RentUserId,RentUserName,RentPhone,RrcBillId,PlanRtnDateTime,ActualRtnDateTime,BillStatus,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Inv_Rcv_Bill_Hd "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Hd model = new Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Hd(); 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 Bsam.Core.Model.Models.Model.Sys_UserGroup_In_Role GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select UserGroupId,RoleId from Sys_UserGroup_In_Role "); strSql.Append(" where "); SQLiteParameter[] parameters = { }; Bsam.Core.Model.Models.Model.Sys_UserGroup_In_Role model = new Bsam.Core.Model.Models.Model.Sys_UserGroup_In_Role(); 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 UcJsglEntity GetModel(string ZJ) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ZJ, JSMC, JSLX, CJR, CJSJ, BZ, QYBZ "); strSql.Append(" from uc_jsgl "); strSql.Append(" where ZJ=@ZJ "); SQLiteParameter[] parameters = { new SQLiteParameter("@ZJ", DbType.String) }; parameters[0].Value = ZJ; UcJsglEntity model = new UcJsglEntity(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.ZJ = ds.Tables[0].Rows[0]["ZJ"].ToString(); model.JSMC = ds.Tables[0].Rows[0]["JSMC"].ToString(); model.JSLX = ds.Tables[0].Rows[0]["JSLX"].ToString(); model.CJR = ds.Tables[0].Rows[0]["CJR"].ToString(); model.CJSJ = ds.Tables[0].Rows[0]["CJSJ"].ToString(); model.BZ = ds.Tables[0].Rows[0]["BZ"].ToString(); if (ds.Tables[0].Rows[0]["QYBZ"].ToString() != "") { model.QYBZ = int.Parse(ds.Tables[0].Rows[0]["QYBZ"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Scada.Model.Classify_DRIVER GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,ClassifyName,CreateTime,UpdateTime,Description from Classify_DRIVER "); strSql.Append(" where Id=@Id "); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32, 8) }; parameters[0].Value = Id; Scada.Model.Classify_DRIVER model = new Scada.Model.Classify_DRIVER(); 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 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); } }