コード例 #1
0
        /// <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);
        }
コード例 #2
0
        /// <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);
        }
コード例 #3
0
        /// <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);
        }
コード例 #4
0
        /// <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));
        }
コード例 #5
0
        /// <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);
        }
コード例 #6
0
        /// <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);
        }
コード例 #7
0
 /// <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));
 }
コード例 #8
0
 /// <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));
 }