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