/// <summary> ///根据主键值查找Sys_PersonDeskTopIconSet记录 /// </summary> /// <param name="keyId">KeyId</param> /// <returns>Sys_PersonDeskTopIconSet</returns> public Sys_PersonDeskTopIconSet FindSys_PersonDeskTopIconSet(int keyId) { string sql = @"SELECT KeyId, ModuleId, PersonId, IconFileName FROM dbo.Sys_PersonDeskTopIconSet WHERE KeyId = @KeyId"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddInParameter(command, "KeyId", DbType.Int32, keyId); Sys_PersonDeskTopIconSet sys_PersonDeskTopIconSet = null; using (IDataReader dr = db.ExecuteReader(command)) { if (dr.Read()) { sys_PersonDeskTopIconSet = new Sys_PersonDeskTopIconSet(); sys_PersonDeskTopIconSet.KeyId = (int)dr["KeyId"]; sys_PersonDeskTopIconSet.ModuleId = (int)dr["ModuleId"]; sys_PersonDeskTopIconSet.PersonId = (int)dr["PersonId"]; sys_PersonDeskTopIconSet.IconFileName = (string)dr["IconFileName"]; } } return(sys_PersonDeskTopIconSet); }
/// <summary> /// 更新Sys_PersonDeskTopIconSet记录 /// </summary> /// <param name="sys_PersonDeskTopIconSet">Sys_PersonDeskTopIconSet对象</param> /// <returns>受影响的记录数</returns> public int UpdateSys_PersonDeskTopIconSet(Sys_PersonDeskTopIconSet sys_PersonDeskTopIconSet) { string sql = @"UPDATE dbo.Sys_PersonDeskTopIconSet SET ModuleId = @ModuleId, PersonId = @PersonId, IconFileName = @IconFileName WHERE KeyId = @KeyId"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddInParameter(command, "KeyId", DbType.Int32, sys_PersonDeskTopIconSet.KeyId); db.AddInParameter(command, "ModuleId", DbType.Int32, sys_PersonDeskTopIconSet.ModuleId); db.AddInParameter(command, "PersonId", DbType.Int32, sys_PersonDeskTopIconSet.PersonId); db.AddInParameter(command, "IconFileName", DbType.String, sys_PersonDeskTopIconSet.IconFileName); return(db.ExecuteNonQuery(command)); }
/// <summary> /// 返回满足查询条件的Sys_PersonDeskTopIconSet实体列表 /// </summary> /// <param name="param">查询条件</param> /// <returns>Sys_PersonDeskTopIconSet实体列表</returns> public IList <Sys_PersonDeskTopIconSet> GetSys_PersonDeskTopIconSets(QueryParameter param) { string sql = @"SELECT KeyId, ModuleId, PersonId, IconFileName FROM dbo.Sys_PersonDeskTopIconSet"; if (param != null) { sql = QueryParameter.CompleteSqlString(sql, param); } Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); if (param != null) { //设置参数 foreach (IExpression exp in param.WhereExpressions) { if (exp is SimpleExpression) { SimpleExpression simple = exp as SimpleExpression; db.AddInParameter(command, simple.ExpName, simple.DbType, simple.Value); } } } IList <Sys_PersonDeskTopIconSet> list = new List <Sys_PersonDeskTopIconSet>(); using (IDataReader dr = db.ExecuteReader(command)) { while (dr.Read()) { Sys_PersonDeskTopIconSet sys_PersonDeskTopIconSet = new Sys_PersonDeskTopIconSet(); sys_PersonDeskTopIconSet.KeyId = (int)dr["KeyId"]; sys_PersonDeskTopIconSet.ModuleId = (int)dr["ModuleId"]; sys_PersonDeskTopIconSet.PersonId = (int)dr["PersonId"]; sys_PersonDeskTopIconSet.IconFileName = (string)dr["IconFileName"]; list.Add(sys_PersonDeskTopIconSet); } } return(list); }
/// <summary> /// 更新Sys_PersonDeskTopIconSet /// </summary> /// <param name="sys_PersonDeskTopIconSet">实体类</param> /// <param name="logEntity">日志类</param> /// <returns></returns> public string UpdateSys_PersonDeskTopIconSet(Sys_PersonDeskTopIconSet sys_PersonDeskTopIconSet, Log_Operate logEntity) { string strResult = ""; using (TransactionScope trans = new TransactionScope()) { try { this._sys_PersonDeskTopIconSetDAO.UpdateSys_PersonDeskTopIconSet(sys_PersonDeskTopIconSet); Log_OperateFacade logFacade = new Log_OperateFacade(); int intLog = logFacade.CreateLog_Operate(logEntity); trans.Complete(); } catch (Exception ex) { strResult = ex.Message; } } return(strResult); }
/// <summary> /// 插入Sys_PersonDeskTopIconSet记录 /// </summary> /// <param name="sys_PersonDeskTopIconSet">Sys_PersonDeskTopIconSet对象</param> /// <returns></returns> public int InsertSys_PersonDeskTopIconSet(Sys_PersonDeskTopIconSet sys_PersonDeskTopIconSet) { string sql = @"INSERT INTO dbo.Sys_PersonDeskTopIconSet(ModuleId, PersonId, IconFileName) VALUES(@ModuleId, @PersonId, @IconFileName); SELECT @KeyId = SCOPE_IDENTITY()"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddOutParameter(command, "KeyId", DbType.Int32, sizeof(int)); db.AddInParameter(command, "ModuleId", DbType.Int32, sys_PersonDeskTopIconSet.ModuleId); db.AddInParameter(command, "PersonId", DbType.Int32, sys_PersonDeskTopIconSet.PersonId); db.AddInParameter(command, "IconFileName", DbType.String, sys_PersonDeskTopIconSet.IconFileName); int affectedRecords = db.ExecuteNonQuery(command); if (affectedRecords < 1) { throw new ApplicationException("插入数据失败, 没有记录被插入"); } return(affectedRecords); }
/// <summary> /// 创建Sys_PersonDeskTopIconSet /// </summary> /// <param name="sys_PersonDeskTopIconSet">实体类</param> /// <param name="logEntity">日志类</param> /// <param name="strResult">错误信息</param> /// <returns></returns> public int InsertSys_PersonDeskTopIconSet(Sys_PersonDeskTopIconSet sys_PersonDeskTopIconSet, Log_Operate logEntity, ref string strResult) { int intResult = 0; using (TransactionScope trans = new TransactionScope()) { try { this._sys_PersonDeskTopIconSetDAO.InsertSys_PersonDeskTopIconSet(sys_PersonDeskTopIconSet); Log_OperateFacade logFacade = new Log_OperateFacade(); logEntity.OperateFunction = "新增_sys_PersonDeskTopIconSet表ID为" + intResult.ToString() + "的数据"; int intLog = logFacade.CreateLog_Operate(logEntity); trans.Complete(); } catch (Exception ex) { strResult = ex.Message; } } return(intResult); }
/// <summary> /// 更新Sys_PersonDeskTopIconSet记录 /// </summary> /// <param name="sys_PersonDeskTopIconSet"> /// Sys_PersonDeskTopIconSet对象</param> /// <returns>受影响的记录数</returns> public int UpdateSys_PersonDeskTopIconSet(Sys_PersonDeskTopIconSet sys_PersonDeskTopIconSet) { return(this._sys_PersonDeskTopIconSetDAO.UpdateSys_PersonDeskTopIconSet(sys_PersonDeskTopIconSet)); }
/// <summary> /// 创建Sys_PersonDeskTopIconSet记录 /// </summary> /// <param name="sys_PersonDeskTopIconSet"> /// Sys_PersonDeskTopIconSet对象</param> /// <returns></returns> public int CreateSys_PersonDeskTopIconSet(Sys_PersonDeskTopIconSet sys_PersonDeskTopIconSet) { return(this._sys_PersonDeskTopIconSetDAO.InsertSys_PersonDeskTopIconSet(sys_PersonDeskTopIconSet)); }