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