protected override void Execute(CodeActivityContext context)
{
int resultState = State.Get(context);
YunShanOA.DataAccess.Mapping.YunShanOADataContext dc = new DataAccess.Mapping.YunShanOADataContext();
MeetingApplyForm query = (from p in dc.MeetingApplyForm where p.WFID == UpdateApplyInfo.Get(context).WFID select p).FirstOrDefault();
MeetingApplyForm info = query;
info.MeetingStatus = resultState;
dc.SubmitChanges();
int meetingApplyFormID = ((from p in dc.MeetingApplyForm where p.WFID == UpdateApplyInfo.Get(context).WFID select p).FirstOrDefault()).MeetingApplyFormID;
//如果审核通过，将会议申请所选的设备持久化到数据库
if (resultState == 1)
{
YunShanOA.DataAccess.Mapping.MeetingAndEquipment mae = null;
//提交会议申请中的所填写的会议设备申请
if (null != MeetingEquipmentNameAndCount.Get(context))
{
foreach (var item in MeetingEquipmentNameAndCount.Get(context))
{
mae = new MeetingAndEquipment();
mae.MeetingApplyFormID = meetingApplyFormID;
mae.MeetingEquipmentID = item.Key;
mae.MeetingEquipmentCount = item.Value;
dc.MeetingAndEquipment.InsertOnSubmit(mae);
dc.SubmitChanges();
}
}
////提交会议申请中所选择的会议室
//if (null != MeetingRoomIDAndName.Get(context))
//{
// YunShanOA.DataAccess.Mapping.MeetingAndRoom mr = new MeetingAndRoom();
// mr.MeetingApplyFormID = meetingApplyFormID;
// mr.MeetingRoomID = MeetingRoomIDAndName.Get(context).MeetingRoomID;
// mr.Status = 2;
// dc.MeetingAndRoom.InsertOnSubmit(mr);
// dc.SubmitChanges();
//}
//提交会议申请中选择的用户名
if (null != MeetingUserNameAndEmail.Get(context))
{
YunShanOA.DataAccess.Mapping.MeetingAndUser mau = null;
foreach (var item in MeetingUserNameAndEmail.Get(context))
{
mau = new MeetingAndUser();
mau.MeetingApplyFormID = meetingApplyFormID;
mau.UserName = item.Value;
dc.MeetingAndUser.InsertOnSubmit(mau);
dc.SubmitChanges();
}
}
}
}
protected override void Execute(CodeActivityContext context)
{
MeetingApplyForm meetingApplyForm = new MeetingApplyForm();
YunShanOA.DataAccess.Mapping.YunShanOADataContext dc = new YunShanOADataContext();
meetingApplyForm.ApplyUserName = AssignedTo.Get(context).ApplyUserName;
meetingApplyForm.BeginTime = AssignedTo.Get(context).BeginTime;
meetingApplyForm.Comments = AssignedTo.Get(context).Comments;
meetingApplyForm.EndTime = AssignedTo.Get(context).EndTime;
meetingApplyForm.MeetingIntroduction = AssignedTo.Get(context).MeetingIntroduction;
meetingApplyForm.MeetingStatus = 2;
meetingApplyForm.MeetingTopic = AssignedTo.Get(context).MeetingTopic;
meetingApplyForm.MeetingTypeID = AssignedTo.Get(context).MeetingTypeID;
meetingApplyForm.WFID = context.WorkflowInstanceId;
var query = from p in dc.Workflows where p.WFID == meetingApplyForm.WFID select p;
if (0 == query.Count())
{
YunShanOA.DataAccess.Mapping.Workflows wf = new Workflows();
wf.WFID = meetingApplyForm.WFID;
wf.WFTID = Guid.NewGuid();
dc.Workflows.InsertOnSubmit(wf);
}
var query1 = from p in dc.MeetingApplyForm where p.WFID == meetingApplyForm.WFID select p;
if (0 == query1.Count())
{
dc.MeetingApplyForm.InsertOnSubmit(meetingApplyForm); //将数据插入到MeetingApplyForm表
dc.SubmitChanges(); //提交MeeingApplyForm的更改，以便下面根据WFID来查询MeetingApplyFormID
var quer = from p in dc.MeetingApplyForm where p.WFID == meetingApplyForm.WFID select p;
if (0 != quer.Count())
{
Model.MeetingRoom mar = new Model.MeetingRoom();
mar = MeetingRoomNameAndID.Get(context);
int meetingApplyFormID = quer.First().MeetingApplyFormID;
DataAccess.Mapping.MeetingAndRoom m = new MeetingAndRoom();
m.Status = 2;
m.MeetingApplyFormID = meetingApplyFormID;
m.MeetingRoomID = mar.MeetingRoomID;
dc.MeetingAndRoom.InsertOnSubmit(m);
dc.SubmitChanges();
}
}
Apply.Set(context, meetingApplyForm);
}
