/// <summary> ///根据主键值查找一个人可能属于多个单位记录 /// </summary> /// <param name="keyId">KeyId</param> /// <returns>Sys_PersonBusiUnit</returns> public Sys_PersonBusiUnit FindSys_PersonBusiUnit(int keyId) { string sql = @"SELECT KeyId, PersonID, BusiUnitID, IsMaster, BeginDate, EndDate, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn FROM dbo.Sys_PersonBusiUnit WHERE KeyId = @KeyId"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddInParameter(command, "KeyId", DbType.Int32, keyId); Sys_PersonBusiUnit sys_PersonBusiUnit = null; using (IDataReader dr = db.ExecuteReader(command)) { if (dr.Read()) { sys_PersonBusiUnit = new Sys_PersonBusiUnit(); sys_PersonBusiUnit.KeyId = (int)dr["KeyId"]; sys_PersonBusiUnit.PersonID = (int)dr["PersonID"]; sys_PersonBusiUnit.BusiUnitID = (int)dr["BusiUnitID"]; sys_PersonBusiUnit.IsMaster = (Int16)dr["IsMaster"]; sys_PersonBusiUnit.BeginDate = (DateTime)dr["BeginDate"]; sys_PersonBusiUnit.EndDate = dr["EndDate"] == DBNull.Value ? null : (DateTime?)dr["EndDate"]; sys_PersonBusiUnit.CreatedBy = (int)dr["CreatedBy"]; sys_PersonBusiUnit.CreatedOn = (DateTime)dr["CreatedOn"]; sys_PersonBusiUnit.ModifiedBy = dr["ModifiedBy"] == DBNull.Value ? null : (int?)dr["ModifiedBy"]; sys_PersonBusiUnit.ModifiedOn = dr["ModifiedOn"] == DBNull.Value ? null : (DateTime?)dr["ModifiedOn"]; } } return(sys_PersonBusiUnit); }
/// <summary> /// 插入一个人可能属于多个单位记录 /// </summary> /// <param name="sys_PersonBusiUnit">一个人可能属于多个单位对象</param> /// <returns></returns> public int InsertSys_PersonBusiUnit(Sys_PersonBusiUnit sys_PersonBusiUnit) { string sql = @"INSERT INTO dbo.Sys_PersonBusiUnit(PersonID, BusiUnitID, IsMaster, BeginDate, EndDate, CreatedBy) VALUES(@PersonID, @BusiUnitID, @IsMaster, @BeginDate, @EndDate, @CreatedBy); 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, "PersonID", DbType.Int32, sys_PersonBusiUnit.PersonID); db.AddInParameter(command, "BusiUnitID", DbType.Int32, sys_PersonBusiUnit.BusiUnitID); db.AddInParameter(command, "IsMaster", DbType.Int16, sys_PersonBusiUnit.IsMaster); db.AddInParameter(command, "BeginDate", DbType.DateTime, sys_PersonBusiUnit.BeginDate); db.AddInParameter(command, "EndDate", DbType.DateTime, sys_PersonBusiUnit.EndDate.HasValue ? (object)sys_PersonBusiUnit.EndDate : DBNull.Value); db.AddInParameter(command, "CreatedBy", DbType.Int32, sys_PersonBusiUnit.CreatedBy); int affectedRecords = db.ExecuteNonQuery(command); if (affectedRecords < 1) { throw new ApplicationException("插入数据失败, 没有记录被插入"); } else { string strTemp = "select @@identity"; DataTable dt = GetDataTable(strTemp); if (dt != null && dt.Rows.Count > 0) { affectedRecords = int.Parse(dt.Rows[0][0].ToString()); } } return(affectedRecords); }
/// <summary> /// 返回满足查询条件的一个人可能属于多个单位实体列表 /// </summary> /// <param name="param">查询条件</param> /// <returns>一个人可能属于多个单位实体列表</returns> public IList <Sys_PersonBusiUnit> GetSys_PersonBusiUnits(QueryParameter param) { string sql = @"SELECT KeyId, PersonID, BusiUnitID, IsMaster, BeginDate, EndDate, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn FROM dbo.Sys_PersonBusiUnit"; 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_PersonBusiUnit> list = new List <Sys_PersonBusiUnit>(); using (IDataReader dr = db.ExecuteReader(command)) { while (dr.Read()) { Sys_PersonBusiUnit sys_PersonBusiUnit = new Sys_PersonBusiUnit(); sys_PersonBusiUnit.KeyId = (int)dr["KeyId"]; sys_PersonBusiUnit.PersonID = (int)dr["PersonID"]; sys_PersonBusiUnit.BusiUnitID = (int)dr["BusiUnitID"]; sys_PersonBusiUnit.IsMaster = (Int16)dr["IsMaster"]; sys_PersonBusiUnit.BeginDate = (DateTime)dr["BeginDate"]; sys_PersonBusiUnit.EndDate = dr["EndDate"] == DBNull.Value ? null : (DateTime?)dr["EndDate"]; sys_PersonBusiUnit.CreatedBy = (int)dr["CreatedBy"]; sys_PersonBusiUnit.CreatedOn = (DateTime)dr["CreatedOn"]; sys_PersonBusiUnit.ModifiedBy = dr["ModifiedBy"] == DBNull.Value ? null : (int?)dr["ModifiedBy"]; sys_PersonBusiUnit.ModifiedOn = dr["ModifiedOn"] == DBNull.Value ? null : (DateTime?)dr["ModifiedOn"]; list.Add(sys_PersonBusiUnit); } } return(list); }
/// <summary> /// 更新一个人可能属于多个单位记录 /// </summary> /// <param name="sys_PersonBusiUnit">一个人可能属于多个单位对象</param> /// <returns>受影响的记录数</returns> public int UpdateSys_PersonBusiUnit(Sys_PersonBusiUnit sys_PersonBusiUnit) { string sql = @"UPDATE dbo.Sys_PersonBusiUnit SET PersonID = @PersonID, BusiUnitID = @BusiUnitID, IsMaster = @IsMaster, BeginDate = @BeginDate, EndDate = @EndDate, ModifiedBy = @ModifiedBy, ModifiedOn = @ModifiedOn WHERE KeyId = @KeyId"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddInParameter(command, "KeyId", DbType.Int32, sys_PersonBusiUnit.KeyId); db.AddInParameter(command, "PersonID", DbType.Int32, sys_PersonBusiUnit.PersonID); db.AddInParameter(command, "BusiUnitID", DbType.Int32, sys_PersonBusiUnit.BusiUnitID); db.AddInParameter(command, "IsMaster", DbType.Int16, sys_PersonBusiUnit.IsMaster); db.AddInParameter(command, "BeginDate", DbType.DateTime, sys_PersonBusiUnit.BeginDate); db.AddInParameter(command, "EndDate", DbType.DateTime, sys_PersonBusiUnit.EndDate.HasValue ? (object)sys_PersonBusiUnit.EndDate : DBNull.Value); db.AddInParameter(command, "ModifiedBy", DbType.Int32, sys_PersonBusiUnit.ModifiedBy.HasValue ? (object)sys_PersonBusiUnit.ModifiedBy : DBNull.Value); db.AddInParameter(command, "ModifiedOn", DbType.DateTime, sys_PersonBusiUnit.ModifiedOn.HasValue ? (object)sys_PersonBusiUnit.ModifiedOn : DBNull.Value); return(db.ExecuteNonQuery(command)); }
/// <summary> /// 更新Sys_PersonBusiUnit /// </summary> /// <param name="sys_PersonBusiUnit">实体类</param> /// <param name="logEntity">日志类</param> /// <returns></returns> public string UpdateSys_PersonBusiUnit(Sys_PersonBusiUnit sys_PersonBusiUnit, Log_Operate logEntity) { string strResult = ""; using (TransactionScope trans = new TransactionScope()) { try { this._sys_PersonBusiUnitDAO.UpdateSys_PersonBusiUnit(sys_PersonBusiUnit); Log_OperateFacade logFacade = new Log_OperateFacade(); int intLog = logFacade.CreateLog_Operate(logEntity); trans.Complete(); } catch (Exception ex) { strResult = ex.Message; } } return(strResult); }
/// <summary> /// 创建Sys_PersonBusiUnit /// </summary> /// <param name="sys_PersonBusiUnit">实体类</param> /// <param name="logEntity">日志类</param> /// <param name="strResult">错误信息</param> /// <returns></returns> public int InsertSys_PersonBusiUnit(Sys_PersonBusiUnit sys_PersonBusiUnit, Log_Operate logEntity, ref string strResult) { int intResult = 0; using (TransactionScope trans = new TransactionScope()) { try { this._sys_PersonBusiUnitDAO.InsertSys_PersonBusiUnit(sys_PersonBusiUnit); Log_OperateFacade logFacade = new Log_OperateFacade(); logEntity.OperateFunction = "新增_sys_PersonBusiUnit表ID为" + intResult.ToString() + "的数据"; int intLog = logFacade.CreateLog_Operate(logEntity); trans.Complete(); } catch (Exception ex) { strResult = ex.Message; } } return(intResult); }
/// <summary> /// 更新一个人可能属于多个单位记录 /// </summary> /// <param name="sys_PersonBusiUnit"> /// 一个人可能属于多个单位对象</param> /// <returns>受影响的记录数</returns> public int UpdateSys_PersonBusiUnit(Sys_PersonBusiUnit sys_PersonBusiUnit) { return(this._sys_PersonBusiUnitDAO.UpdateSys_PersonBusiUnit(sys_PersonBusiUnit)); }
/// <summary> /// 创建一个人可能属于多个单位记录 /// </summary> /// <param name="sys_PersonBusiUnit"> /// 一个人可能属于多个单位对象</param> /// <returns></returns> public int CreateSys_PersonBusiUnit(Sys_PersonBusiUnit sys_PersonBusiUnit) { return(this._sys_PersonBusiUnitDAO.InsertSys_PersonBusiUnit(sys_PersonBusiUnit)); }