/// <summary>
/// 根据MeetingTypeID查询业务实体
/// </summary>
/// <param name="mtID">会议ID</param>
/// <returns>业务实体对象</returns>
public Model.MeetingType GetMeetingTypeByMtID(int mtID)
{
dc = new Mapping.YunShanOADataContext();
var query = (from meeting in dc.MeetingType
where meeting.MeetingTypeID == mtID
select meeting).FirstOrDefault();
return FillRecord(query);
}
/// <summary>
/// 根据MeetingTypeID查询业务实体
/// </summary>
/// <param name="mtID">会议ID</param>
/// <returns>业务实体对象</returns>
public Model.MeetingType GetMeetingTypeByMtID(int mtID)
{
dc = new Mapping.YunShanOADataContext();
var query = (from meeting in dc.MeetingType
where meeting.MeetingTypeID == mtID
select meeting).FirstOrDefault();
return(FillRecord(query));
}
/// <summary>
/// 获取所有的会议类型
/// </summary>
/// <returns>返回所有会议类型的集合</returns>
public List<Model.MeetingType> GetMeetingType()
{
List<MeetingType> result = new List<MeetingType>();
dc = new Mapping.YunShanOADataContext();
var Query = from meeting in dc.MeetingType select meeting;
foreach (var m in Query)
{
result.Add(FillRecord(m));
}
return result;
}
/// <summary>
/// 获取所有的会议类型
/// </summary>
/// <returns>返回所有会议类型的集合</returns>
public List <Model.MeetingType> GetMeetingType()
{
List <MeetingType> result = new List <MeetingType>();
dc = new Mapping.YunShanOADataContext();
var Query = from meeting in dc.MeetingType select meeting;
foreach (var m in Query)
{
result.Add(FillRecord(m));
}
return(result);
}
/// <summary>
/// 会议类型的保存和更新
/// </summary>
/// <param name="mt">要保存或更新的MeetingType对象</param>
/// <returns>返回MeetingTypeID</returns>
public int SaveMeetingType(MeetingType mt)
{
YunShanOA.DataAccess.Mapping.MeetingType meetingType = null;
dc = new Mapping.YunShanOADataContext();
bool find = false;
if (mt.MeetingTypeID == -1)
{
meetingType = new Mapping.MeetingType();
dc.MeetingType.InsertOnSubmit(meetingType);
find = true;
}
else
{
meetingType = (from meeting in dc.MeetingType
where meeting.MeetingTypeID == mt.MeetingTypeID
select meeting).FirstOrDefault();
if (meetingType != null)
{
find = true;
meetingType.MeetingTypeID = mt.MeetingTypeID;
}
}
if (find)
{
meetingType.MeetingTypeName = mt.MeetingTypeName;
meetingType.MeetingTypeDescription = mt.MeetingTypeDescription;
try
{
dc.SubmitChanges();
}
catch (ChangeConflictException)
{
dc.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
dc.SubmitChanges();
}
return(meetingType.MeetingTypeID);
}
else
{
return(-1);
}
}
/// <summary>
/// 删除会议类型
/// </summary>
/// <param name="mt">要删除的会议业务对象</param>
/// <returns>返回成功与否</returns>
public bool DeleteMeetingType(Model.MeetingType mt)
{
YunShanOA.DataAccess.Mapping.MeetingType meetingType = null;
dc = new Mapping.YunShanOADataContext();
meetingType = (from meeting in dc.MeetingType
where meeting.MeetingTypeID == mt.MeetingTypeID
select meeting).FirstOrDefault();
if (meetingType != null)
{
try
{
dc.MeetingType.DeleteOnSubmit(meetingType);
dc.SubmitChanges();
}
catch (ChangeConflictException)
{
dc.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
dc.SubmitChanges();
}
}
return(meetingType != null);
}
/// <summary>
/// 删除会议类型
/// </summary>
/// <param name="mt">要删除的会议业务对象</param>
/// <returns>返回成功与否</returns>
public bool DeleteMeetingType(Model.MeetingType mt)
{
YunShanOA.DataAccess.Mapping.MeetingType meetingType = null;
dc = new Mapping.YunShanOADataContext();
meetingType = (from meeting in dc.MeetingType
where meeting.MeetingTypeID == mt.MeetingTypeID
select meeting).FirstOrDefault();
if (meetingType != null)
{
try
{
dc.MeetingType.DeleteOnSubmit(meetingType);
dc.SubmitChanges();
}
catch (ChangeConflictException)
{
dc.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
dc.SubmitChanges();
}
}
return (meetingType!=null);
}
/// <summary>
/// 会议类型的保存和更新
/// </summary>
/// <param name="mt">要保存或更新的MeetingType对象</param>
/// <returns>返回MeetingTypeID</returns>
public int SaveMeetingType(MeetingType mt)
{
YunShanOA.DataAccess.Mapping.MeetingType meetingType = null;
dc = new Mapping.YunShanOADataContext();
bool find = false;
if (mt.MeetingTypeID == -1)
{
meetingType = new Mapping.MeetingType();
dc.MeetingType.InsertOnSubmit(meetingType);
find = true;
}
else
{
meetingType = (from meeting in dc.MeetingType
where meeting.MeetingTypeID == mt.MeetingTypeID
select meeting).FirstOrDefault();
if (meetingType != null)
{
find = true;
meetingType.MeetingTypeID = mt.MeetingTypeID;
}
}
if (find)
{
meetingType.MeetingTypeName = mt.MeetingTypeName;
meetingType.MeetingTypeDescription = mt.MeetingTypeDescription;
try
{
dc.SubmitChanges();
}
catch (ChangeConflictException)
{
dc.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
dc.SubmitChanges();
}
return meetingType.MeetingTypeID;
}
else
{
return -1;
}
}
