/// <summary>
/// 增加实体
/// </summary>
/// <param name="databaseConnectionString">数据库链接字符串</param>
/// <param name="entity">实体</param>
public static bool Add(Model.Admin.MSPositionInfo entity)
{
var sql = @"
INSERT INTO [MSPositionInfo]
(
[DepartmentID]
,[PositionType]
,[PositionName]
,[CreateTime]
,[CreateUser]
)
VALUES
(
@DepartmentID
,@PositionType
,@PositionName
,@CreateTime
,@CreateUser
)
";
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter()
{
ParameterName = "@DepartmentID", Value = entity.DepartmentID
});
parameters.Add(new SqlParameter()
{
ParameterName = "@PositionType", Value = entity.PositionType
});
parameters.Add(new SqlParameter()
{
ParameterName = "@PositionName", Value = entity.PositionName
});
parameters.Add(new SqlParameter()
{
ParameterName = "@CreateTime", Value = entity.CreateTime
});
parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUser", Value = entity.CreateUser
});
int i = SqlHelper.ExecuteNonQuery(sql, parameters.ToArray());
return(i > 0 ? true : false);
}
public static bool SetDirectorInfo(long departmentId, long directorId, int positionCode, out string errorMsg)
{
errorMsg = "";
//查询部门信息
Model.Admin.MSDepartmentInfo departmentInfo = DAL.Admin.MSDepartmentInfoDal.GetByDepartmentID(departmentId);
if (departmentInfo == null)
{
errorMsg = "数据不存在，请刷新列表重新操作！";
return(false);
}
//查询部门指定岗位信息
Model.Admin.MSPositionInfo positionInfo = DAL.Admin.MSPositionInfoDal.GetByDepartmentIdAndPositionType(departmentId, positionCode);
if (positionInfo == null)
{
errorMsg = "数据错误，请联系管理员！";
return(false);
}
//查询该岗位有没有绑定用户
List <Model.Admin.MSUserPositionRelation> relationList = DAL.Admin.MSUserPositionRelationDal.GetListByPositionID(positionInfo.PositionID);
if (relationList != null && relationList.Count > 0)
{
Model.Admin.MSUserPositionRelation relationEntity = relationList[0];
//更新用户ID
DAL.Admin.MSUserPositionRelationDal.UpdateUserIDByRelationId(relationEntity.RelationID, directorId);
}
else
{
//未绑定插入
Model.Admin.MSUserPositionRelation relationEntity = new MSUserPositionRelation()
{
PositionID = positionInfo.PositionID,
UserID = directorId,
Deleted = 0,
CreateTime = DateTime.Now,
CreateUser = Model.Identity.LoginUserInfo.UserID
};
DAL.Admin.MSUserPositionRelationDal.Add(relationEntity);
}
return(true);
}
public static long GetPositionIdByDepartmentIdAndPositionType(long departmentId, int positionType)
{
Model.Admin.MSPositionInfo positionInfo = DAL.Admin.MSPositionInfoDal.GetByDepartmentIdAndPositionType(departmentId, positionType);
return(positionInfo == null ? 0 : positionInfo.PositionID);
}
