private void Compare(Model.MeetingRoom mr1, Model.MeetingRoom mr2)
{
Assert.AreEqual(mr1.MeetingRoomID, mr2.MeetingRoomID);
Assert.AreEqual(mr1.MeetingRoomCapacity, mr2.MeetingRoomCapacity);
Assert.AreEqual(mr1.MeetingRoomName, mr2.MeetingRoomName);
Assert.AreEqual(mr1.MeetingRoomStatus, mr2.MeetingRoomStatus);
Assert.AreEqual(mr1.MeetingTypeID, mr2.MeetingTypeID);
}
protected void btnTrue_Click(object sender, EventArgs e)
{
Model.MeetingRoom mr = new Model.MeetingRoom();
mr.MeetingRoomName = txtMeetingRoomName.Text.Trim();
mr.MeetingRoomCapacity = int.Parse(txtCap.Text);
mr.MeetingRoomStatus = 3;
mr.MeetingTypeID = int.Parse(this.ddlType.SelectedValue);
BusinessLogic.MeetingRoom.SaveMeetingRoom(mr);
}
protected void btnTrue_Click(object sender, EventArgs e)
{
Model.MeetingRoom mr = new Model.MeetingRoom();
mr.MeetingRoomName = txtMeetingRoomName.Text.Trim();
mr.MeetingRoomCapacity = int.Parse(txtCap.Text);
mr.MeetingRoomStatus = 3;
mr.MeetingTypeID = int.Parse(this.ddlType.SelectedValue);
BusinessLogic.MeetingRoom.SaveMeetingRoom(mr);
}
public void TestMeetingRoomForInsert()
{
YunShanOA.Model.MeetingRoom meetingRoom = new Model.MeetingRoom();
meetingRoom.MeetingTypeID = 1;
meetingRoom.MeetingRoomStatus = 1;
meetingRoom.MeetingRoomName = "隆汇大厦1201室";
meetingRoom.MeetingRoomCapacity = 50;
IMeetingRoom imr=YunShanOA.DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance();
Assert.IsNotNull(imr);
int LastMeetingRoomID= imr.SaveMeetingRoom(meetingRoom);
Assert.AreEqual(LastMeetingRoomID,GetLastMeetingRoomID());
DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance().DeleteMeetingRoom(meetingRoom);
}
public void TestMeetingRoomForUpdate()
{
YunShanOA.Model.MeetingRoom meetingRoom = new Model.MeetingRoom();
meetingRoom.MeetingTypeID = 1;
meetingRoom.MeetingRoomStatus = 1;
meetingRoom.MeetingRoomName = "隆汇大厦1201室";
meetingRoom.MeetingRoomCapacity = 30;
meetingRoom.MeetingRoomID = GetLastMeetingRoomID();
int LastMeetingRoomID = YunShanOA.DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance().SaveMeetingRoom(meetingRoom);
Assert.AreEqual(LastMeetingRoomID, GetLastMeetingRoomID());
DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance().DeleteMeetingRoom(meetingRoom);
}
public void TestMeetingRoomForInsert()
{
YunShanOA.Model.MeetingRoom meetingRoom = new Model.MeetingRoom();
meetingRoom.MeetingTypeID = 1;
meetingRoom.MeetingRoomStatus = 1;
meetingRoom.MeetingRoomName = "隆汇大厦1201室";
meetingRoom.MeetingRoomCapacity = 50;
IMeetingRoom imr = YunShanOA.DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance();
Assert.IsNotNull(imr);
int LastMeetingRoomID = imr.SaveMeetingRoom(meetingRoom);
Assert.AreEqual(LastMeetingRoomID, GetLastMeetingRoomID());
DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance().DeleteMeetingRoom(meetingRoom);
}
public void TestMeetingRoomDelete()
{
YunShanOA.Model.MeetingRoom meetingRoom = new Model.MeetingRoom();
IMeetingRoom imr = DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance();
YunShanOA.Model.MeetingRoom meetingroom = new Model.MeetingRoom();
meetingroom.MeetingRoomName = "汇景大厦4层401";
meetingroom.MeetingRoomStatus = 1;
meetingroom.MeetingTypeID = 1;
meetingroom.MeetingRoomCapacity = 50;
imr.SaveMeetingRoom(meetingroom);
meetingRoom.MeetingRoomID = GetLastMeetingRoomID();
bool result = YunShanOA.DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance().DeleteMeetingRoom(meetingRoom);
Assert.AreEqual(true,result);
}
public void TestQueryMeetingRoomByName()
{
IMeetingRoom imr = DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance();
YunShanOA.Model.MeetingRoom meetingroom = new Model.MeetingRoom();
meetingroom.MeetingRoomName = "汇景大厦4层401";
meetingroom.MeetingRoomStatus = 1;
meetingroom.MeetingTypeID = 1;
meetingroom.MeetingRoomCapacity = 50;
imr.SaveMeetingRoom(meetingroom);
meetingroom.MeetingRoomID = GetLastMeetingRoomID();
Model.MeetingRoom meetingroom2 = imr.QueryMeetingRoomByName(meetingroom.MeetingRoomName);
Compare(meetingroom, meetingroom2);
imr.DeleteMeetingRoom(meetingroom);
}
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);
}
public void TestMeetingRoomDelete()
{
YunShanOA.Model.MeetingRoom meetingRoom = new Model.MeetingRoom();
IMeetingRoom imr = DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance();
YunShanOA.Model.MeetingRoom meetingroom = new Model.MeetingRoom();
meetingroom.MeetingRoomName = "汇景大厦4层401";
meetingroom.MeetingRoomStatus = 1;
meetingroom.MeetingTypeID = 1;
meetingroom.MeetingRoomCapacity = 50;
imr.SaveMeetingRoom(meetingroom);
meetingRoom.MeetingRoomID = GetLastMeetingRoomID();
bool result = YunShanOA.DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance().DeleteMeetingRoom(meetingRoom);
Assert.AreEqual(true, result);
}
public int SaveMeetingRoom(Model.MeetingRoom meetingRoom)
{
DataAccess.Mapping.MeetingRoom mr = null;
bool find = false;
if (meetingRoom.MeetingRoomID == -1)
{
mr = new Mapping.MeetingRoom();
dc.MeetingRoom.InsertOnSubmit(mr);
find = true;
}
else
{
mr = (from meeting in dc.MeetingRoom
where meeting.MeetingRoomID == meetingRoom.MeetingRoomID
select meeting).FirstOrDefault();
if (mr != null)
{
find = true;
mr.MeetingRoomID = meetingRoom.MeetingRoomID;
}
}
if (find)
{
mr.MeetingRoomCapacity = meetingRoom.MeetingRoomCapacity;
mr.MeetingRoomName = meetingRoom.MeetingRoomName;
mr.MeetingRoomStatus = meetingRoom.MeetingRoomStatus;
mr.MeetingTypeID = meetingRoom.MeetingTypeID;
try
{
dc.SubmitChanges();
}
catch (ChangeConflictException)
{
dc.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
dc.SubmitChanges();
}
return(mr.MeetingRoomID);
}
else
{
return(-1);
}
}
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);
}
public bool DeleteMeetingRoom(Model.MeetingRoom meetingAndRoom)
{
YunShanOA.DataAccess.Mapping.MeetingRoom mr = null;
mr = (from room in dc.MeetingRoom where room.MeetingRoomID == meetingAndRoom.MeetingRoomID select room).FirstOrDefault();
if (mr != null)
{
try
{
dc.MeetingRoom.DeleteOnSubmit(mr);
dc.SubmitChanges();
}
catch (ChangeConflictException)
{
dc.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
dc.SubmitChanges();
}
}
return(mr != null);
}
private void GetApplyFormResutl()
{
r_MeetingApplyForm = new Model.Meeting();
d_EquipmentCount = new Dictionary <int, int>();
MeetingUserEmail = new Dictionary <string, string>();
mr = new Model.MeetingRoom();
//MeetingApplyFormInfo
//r_MeetingApplyForm.ApplyUserName = Membership.GetUser().UserName;
r_MeetingApplyForm.ApplyUserName = txtApplyUserName.Text;
r_MeetingApplyForm.BeginTime = DateTime.Parse(txtBeginTime.Text);
r_MeetingApplyForm.Comments = txtComment.Text;
r_MeetingApplyForm.EndTime = DateTime.Parse(txtEndTime.Text);
r_MeetingApplyForm.MeetingIntroduction = txtMeetingInst.Text;
r_MeetingApplyForm.MeetingStatus = 2;
r_MeetingApplyForm.MeetingTopic = txtMeetingTopic.Text;
r_MeetingApplyForm.WFID = Guid.Empty;
r_MeetingApplyForm.MeetingTypeID = int.Parse(this.ddlMeetingTypeID.SelectedValue);
//Get EquipmentName and count
foreach (GridViewRow item in gvMeetingEquipment.Rows)
{
if (item.RowType == DataControlRowType.DataRow)
{
int rowDatakey = int.Parse(gvMeetingEquipment.DataKeys[item.DataItemIndex].Value.ToString());
int Meetingcount = int.Parse(((DropDownList)item.FindControl("ddlFreeCountList")).SelectedItem.ToString());
d_EquipmentCount.Add(rowDatakey, Meetingcount);
}
}
//get MeetingUser
foreach (ListItem item in cblMeetingUser.Items)
{
if (item.Selected == true)
{
MeetingUserEmail.Add(item.Value, item.Text);
}
}
//Get MeetingRoom
mr.MeetingRoomID = Convert.ToInt32(Request.Form["radioMeetingRoom"].ToString());
}
public void TestGetListMeetingRoom()
{
IMeetingRoom imr = DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance();
List <Model.MeetingRoom> list1 = imr.GetListMeetingRoom();
YunShanOA.Model.MeetingRoom meetingroom = new Model.MeetingRoom();
meetingroom.MeetingRoomName = "汇景大厦4层401";
meetingroom.MeetingRoomStatus = 1;
meetingroom.MeetingTypeID = 1;
meetingroom.MeetingRoomCapacity = 50;
imr.SaveMeetingRoom(meetingroom);
meetingroom.MeetingRoomID = GetLastMeetingRoomID();
list1.Add(meetingroom);
List <Model.MeetingRoom> list2 = imr.GetListMeetingRoom();
for (int i = 0; i < list1.Count; i++)
{
Compare(list1[i], list2[i]);
}
imr.DeleteMeetingRoom(meetingroom);
}
public void TestGetListMeetingRoom()
{
IMeetingRoom imr=DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance();
List<Model.MeetingRoom> list1 = imr.GetListMeetingRoom();
YunShanOA.Model.MeetingRoom meetingroom = new Model.MeetingRoom();
meetingroom.MeetingRoomName ="汇景大厦4层401";
meetingroom.MeetingRoomStatus = 1;
meetingroom.MeetingTypeID = 1;
meetingroom.MeetingRoomCapacity = 50;
imr.SaveMeetingRoom(meetingroom);
meetingroom.MeetingRoomID = GetLastMeetingRoomID();
list1.Add(meetingroom);
List<Model.MeetingRoom> list2 = imr.GetListMeetingRoom();
for (int i = 0; i < list1.Count; i++)
{
Compare(list1[i],list2[i]);
}
imr.DeleteMeetingRoom(meetingroom);
}
public void TestQueryMeetingRoomByName()
{
IMeetingRoom imr = DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance();
YunShanOA.Model.MeetingRoom meetingroom = new Model.MeetingRoom();
meetingroom.MeetingRoomName = "汇景大厦4层401";
meetingroom.MeetingRoomStatus = 1;
meetingroom.MeetingTypeID = 1;
meetingroom.MeetingRoomCapacity = 50;
imr.SaveMeetingRoom(meetingroom);
meetingroom.MeetingRoomID = GetLastMeetingRoomID();
Model.MeetingRoom meetingroom2 = imr.QueryMeetingRoomByName(meetingroom.MeetingRoomName);
Compare(meetingroom,meetingroom2);
imr.DeleteMeetingRoom(meetingroom);
}
public static void SaveMeetingRoom(Model.MeetingRoom mr)
{
DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance().SaveMeetingRoom(mr);
}
/// <summary>
/// 创建并启动一个工作流，在申请时候触发
/// </summary>
/// <param name="meeting">申请时所填表单的数据</param>
/// <returns>返回一个Guid</returns>
public static Guid CreateAndRun(Model.Meeting meeting, Dictionary <int, int> d_EquipmentCount, Dictionary <string, string> MeetingUserNameAndEmail, Model.MeetingRoom MeetingRoomIDAndName)
{
SqlWorkflowInstanceStore instanceStore = new SqlWorkflowInstanceStore(connectionString);
InstanceView view = instanceStore.Execute(instanceStore.CreateInstanceHandle(), new CreateWorkflowOwnerCommand(), TimeSpan.FromDays(30));
instanceStore.DefaultInstanceOwner = view.InstanceOwner;
IDictionary <string, object> input = new Dictionary <string, object>();
input.Add("Request", meeting);
input.Add("EquipmentCount", d_EquipmentCount);
input.Add("MeetingUserEmailFrom", MeetingUserNameAndEmail);
input.Add("MeetingRoomIDAndName", MeetingRoomIDAndName);
WorkflowApplication application = new WorkflowApplication(new MeetingApply(), input);
application.InstanceStore = instanceStore;
application.PersistableIdle = (e) =>
{
instanceUnloaded.Set();
return(PersistableIdleAction.Unload);
};
application.Unloaded = (e) =>
{
instanceUnloaded.Set();
};
application.OnUnhandledException = (ex) =>
{
return(UnhandledExceptionAction.Terminate);
};
Guid id = application.Id;
application.Persist();
application.Run();
instanceUnloaded.WaitOne();
return(id);
}
private void GetApplyFormResutl()
{
r_MeetingApplyForm = new Model.Meeting();
d_EquipmentCount = new Dictionary<int, int>();
MeetingUserEmail = new Dictionary<string, string>();
mr = new Model.MeetingRoom();
//MeetingApplyFormInfo
//r_MeetingApplyForm.ApplyUserName = Membership.GetUser().UserName;
r_MeetingApplyForm.ApplyUserName = txtApplyUserName.Text;
r_MeetingApplyForm.BeginTime = DateTime.Parse(txtBeginTime.Text);
r_MeetingApplyForm.Comments = txtComment.Text;
r_MeetingApplyForm.EndTime = DateTime.Parse(txtEndTime.Text);
r_MeetingApplyForm.MeetingIntroduction = txtMeetingInst.Text;
r_MeetingApplyForm.MeetingStatus = 2;
r_MeetingApplyForm.MeetingTopic = txtMeetingTopic.Text;
r_MeetingApplyForm.WFID = Guid.Empty;
r_MeetingApplyForm.MeetingTypeID = int.Parse(this.ddlMeetingTypeID.SelectedValue);
//Get EquipmentName and count
foreach (GridViewRow item in gvMeetingEquipment.Rows)
{
if (item.RowType == DataControlRowType.DataRow)
{
int rowDatakey = int.Parse(gvMeetingEquipment.DataKeys[item.DataItemIndex].Value.ToString());
int Meetingcount = int.Parse(((DropDownList)item.FindControl("ddlFreeCountList")).SelectedItem.ToString());
d_EquipmentCount.Add(rowDatakey, Meetingcount);
}
}
//get MeetingUser
foreach (ListItem item in cblMeetingUser.Items)
{
if (item.Selected == true)
{
MeetingUserEmail.Add(item.Value, item.Text);
}
}
//Get MeetingRoom
mr.MeetingRoomID = Convert.ToInt32(Request.Form["radioMeetingRoom"].ToString());
}
public void TestMeetingRoomForUpdate()
{
YunShanOA.Model.MeetingRoom meetingRoom = new Model.MeetingRoom();
meetingRoom.MeetingTypeID = 1;
meetingRoom.MeetingRoomStatus = 1;
meetingRoom.MeetingRoomName = "隆汇大厦1201室";
meetingRoom.MeetingRoomCapacity = 30;
meetingRoom.MeetingRoomID = GetLastMeetingRoomID();
int LastMeetingRoomID = YunShanOA.DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance().SaveMeetingRoom(meetingRoom);
Assert.AreEqual(LastMeetingRoomID, GetLastMeetingRoomID());
DALFactory.MeetingInstanceFactory.GetMeetingRoomInstance().DeleteMeetingRoom(meetingRoom);
}
