/// <summary> /// 添加员工 /// </summary> /// <param name="userEntity"></param> /// <param name="unitEntity"></param> /// <param name="roleEntity"></param> public void AddUser(ref T_UserEntity userEntity, t_unitEntity unitEntity, T_RoleEntity roleEntity) { //新增员工 userEntity.user_status = "1"; userEntity.user_status_desc = "有效"; userEntity.user_id = Guid.NewGuid().ToString("N"); userEntity.user_password = "******"; //888888 userEntity.fail_date = DateTime.Now.AddYears(20).ToString("yyyy-MM-dd"); userEntity.customer_id = CurrentUserInfo.ClientID; userEntity.create_user_id = "open"; userEntity.create_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); Create(userEntity); //新增员工角色 var userRoleEntity = new TUserRoleEntity(); userRoleEntity.user_role_id = Guid.NewGuid().ToString(); userRoleEntity.user_id = userEntity.user_id; userRoleEntity.role_id = roleEntity.role_id; userRoleEntity.unit_id = unitEntity.unit_id; userRoleEntity.status = "1"; userRoleEntity.create_time = DateTime.Now; userRoleEntity.create_user_id = "open"; userRoleEntity.modify_time = DateTime.Now; userRoleEntity.modify_user_id = "open"; userRoleEntity.default_flag = "1"; AddUserRole(userRoleEntity); }
internal void Delete(T_RoleEntity dbEntity) { using (var conn = new SqlConnection(ConnectionString.XgxInsert)) { conn.Open(); conn.Delete(dbEntity); } }
internal void Create(T_RoleEntity dbEntity) { using (var conn = new SqlConnection(ConnectionString.XgxInsert)) { dbEntity.create_time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); dbEntity.modify_time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); conn.Open(); conn.Insert(dbEntity); } }
internal void Update(T_RoleEntity dbEntity) { using (var conn = new SqlConnection(ConnectionString.XgxInsert)) { dbEntity.modify_time = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); //dbEntity.modify_user_id = "ERP"; conn.Open(); conn.Update(dbEntity); } }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Update(T_RoleEntity pEntity, IDbTransaction pTran) { _currentDAO.Update(pEntity, pTran); }
/// <summary> /// 创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> public void Create(T_RoleEntity pEntity) { _currentDAO.Create(pEntity); }
/// <summary> /// 分页根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public PagedQueryResult <T_RoleEntity> PagedQueryByEntity(T_RoleEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex) { return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex)); }
/// <summary> /// 根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public T_RoleEntity[] QueryByEntity(T_RoleEntity pQueryEntity, OrderBy[] pOrderBys) { return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys)); }
/// <summary> /// 删除 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Delete(T_RoleEntity pEntity, IDbTransaction pTran) { _currentDAO.Delete(pEntity, pTran); }
/// <summary> /// 删除 /// </summary> /// <param name="pEntity"></param> public void Delete(T_RoleEntity pEntity) { _currentDAO.Delete(pEntity); }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> public void Update(T_RoleEntity pEntity) { _currentDAO.Update(pEntity); }
public void Create(T_RoleEntity dbEntity) { _cmd.Create(dbEntity); }
public void Delete(T_RoleEntity dbEntity) { _cmd.Delete(dbEntity); }
public void Update(T_RoleEntity dbEntity) { _cmd.Update(dbEntity); }