public static TblDeptDto ToDto(this TblDept entity)
{
if (entity == null)
{
return(new TblDeptDto());
}
return(new TblDeptDto {
DeptId = entity.DeptId,
DeptNum = entity.DeptNum,
DeptName = entity.DeptName,
DeptChairman = entity.DeptChairman,
DeptTel = entity.DeptTel,
DeptDesc = entity.DeptDesc,
CreatedBy = entity.CreatedBy,
CreateTime = entity.CreateTime,
ModifyBy = entity.ModifyBy,
ModifyTime = entity.ModifyTime,
DeleteBy = entity.DeleteBy,
DeleteTime = entity.DeleteTime,
IsDeleted = entity.IsDeleted,
Version = entity.Version
});
}
public static TblDept QueryByKey(TblDept dept)
{
return(DBHelper.QueryOneRow(dept, "select * from TblDept where deptId=@p0", dept.DeptId));
}
public static int Modify(TblDept dept)
{
return(DBHelper.Update("update TblDept set deptName=@p0,deptInfo=@p1 where deptId=@p2"
, dept.DeptName, dept.DeptInfo, dept.DeptId));
}
public static int Add(TblDept dept)
{
return(DBHelper.Update("insert into TblDept(deptName,deptInfo) values(@p0,@p1)"
, dept.DeptName, dept.DeptName));
}
