public int Save(car mycar)
{
Car u;
bool found = false;
if (mycar.CarId == -1)
{
// new record
u = new Car();
db.Car.InsertOnSubmit(u);
found = true;
}
else
{
// existing record
u = (from Mycar in db.Car where Mycar.CarId == mycar.CarId select Mycar).FirstOrDefault();
if (u != null)
{
found = true;
u.CarId = mycar.CarId;
}
}
if (found)
{
u.Comment = mycar.Comment;
u.Driver = mycar.Driver;
u.DriverEmail = mycar.DriverEmail;
u.LicenseNumber = mycar.LicenseNumber;
u.LoadCapacity = mycar.LoadCapacity;
u.ModelNumber = mycar.ModelNumber;
u.SeatingNumber = mycar.seatingNumber;
u.Status = mycar.Status;
u.UseCarTypeID = mycar.Usecartype.UseCarTypeID;
try
{
db.SubmitChanges();
}
catch (ChangeConflictException)
{
db.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
db.SubmitChanges();
}
return(u.CarId);
}
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 int Save(YunShanOA.Model.DocumentModel.DocumentApply myDocumentApply)
{
Document u;
bool found = false;
if (myDocumentApply.DocumentID == -1)
{
// new record
u = new Document();
db.Document.InsertOnSubmit(u);
found = true;
}
else
{
// existing record
u = (from myDocumentApplys in db.Document where myDocumentApplys.DocumentID == myDocumentApply.DocumentID select myDocumentApplys).FirstOrDefault();
if (u != null)
{
found = true;
u.DocumentID = myDocumentApply.DocumentID;
}
}
if (found)
{
u.Status = myDocumentApply.Status;
u.WFID = myDocumentApply.WFID;
u.DocumentName = myDocumentApply.DocumentName;
u.DocumentPath = myDocumentApply.DocumentPath;
u.DocumentAuthor = myDocumentApply.Author;
try
{
db.SubmitChanges();
}
catch (ChangeConflictException)
{
db.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
db.SubmitChanges();
}
return(u.DocumentID);
}
else
{
return(-1);
}
}
public int Save(Model.UseCarModel.ReviewUseCarApplyForm myReviewUseCarApplyForm)
{
YunShanOA.DataAccess.Mapping.ReviewUseCarApply R;
bool found = false;
if (-1 == myReviewUseCarApplyForm.ReviewUseCarApplyID)
{
R = new ReviewUseCarApply();
db.ReviewUseCarApply.InsertOnSubmit(R);
found = true;
}
else
{
R = (from ReviewUseCarApplyForms in db.ReviewUseCarApply where ReviewUseCarApplyForms.ReviewUseCarApplyID == myReviewUseCarApplyForm.ReviewUseCarApplyID select ReviewUseCarApplyForms).FirstOrDefault();
if (R != null)
{
found = true;
int id = (int)myReviewUseCarApplyForm.ReviewUseCarApplyID;
R.ReviewUseCarApplyID = id;
}
}
if (found)
{
R.ReviewUseCarApplyID = myReviewUseCarApplyForm.ReviewUseCarApplyID;
R.ReviewUserName = myReviewUseCarApplyForm.ReviewUserName;
R.UseCarApplyFormID = myReviewUseCarApplyForm.UseCarApplyFormID;
R.Agree = myReviewUseCarApplyForm.Agree;
try
{
db.SubmitChanges();
}
catch (ChangeConflictException)
{
db.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
db.SubmitChanges();
}
return(R.ReviewUseCarApplyID);
}
else
{
return(-1);
}
}
public int Save(usecaranduser myusecaranduser)
{
UseCarAndUser u;
bool found = false;
if (-1 == myusecaranduser.UseCarUserId)
{
u = new UseCarAndUser();
db.UseCarAndUser.InsertOnSubmit(u);
found = true;
}
else
{
u = (from UseCarAndUsers in db.UseCarAndUser where UseCarAndUsers.UseCarUserId == myusecaranduser.UseCarUserId select UseCarAndUsers).FirstOrDefault();
if (u != null)
{
found = true;
int id = (int)myusecaranduser.UseCarUserId;
u.UseCarUserId = id;
}
}
if (found)
{
u.UseCarUserId = myusecaranduser.UseCarUserId;
u.UseCarApplyFormID = myusecaranduser.UseCarApplyFormID;
u.Name = myusecaranduser.Name;
u.Email = myusecaranduser.Email;
try
{
db.SubmitChanges();
}
catch (ChangeConflictException)
{
db.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
db.SubmitChanges();
}
return(u.UseCarUserId);
}
else
{
return(-1);
}
}
public int Sava(Model.UseCarModel.usecarapplyform myForm)
{
UseCarApplyForm u;
bool found = false;
if (myForm.UseCarApplyFormID == -1)
{
// new record
u = new UseCarApplyForm();
db.UseCarApplyForm.InsertOnSubmit(u);
found = true;
}
else
{
// existing record
u = (from myUseCarApplyForm in db.UseCarApplyForm where myUseCarApplyForm.UseCarApplyFormID == myForm.UseCarApplyFormID select myUseCarApplyForm).FirstOrDefault();
if (u != null)
{
found = true;
int id = (int)myForm.UseCarApplyFormID;
u.UseCarApplyFormID = id;
}
}
if (found)
{
u.ApplyReason = myForm.ApplyReason;
u.ApplyUserName = myForm.ApplyUserName;
u.BeginTime = myForm.BeginTime;
u.EndTime = myForm.EndTime;
u.Comment = myForm.Comment;
u.StartDestination = myForm.StartDestination;
u.EndDestination = myForm.EndDestination;
u.UseCarTypeID = myForm.usecartype.UseCarTypeID;
u.ApplyStatus = myForm.ApplyStatus;
u.WFID = myForm.WFID;
try
{
db.SubmitChanges();
foreach (usecaranduser usecaranduser in myForm.Usecaranduser)
{
usecaranduser user = new Model.UseCarModel.usecaranduser();
user.UseCarUserId = usecaranduser.UseCarUserId;
user.UseCarApplyFormID = u.UseCarApplyFormID;
user.Name = usecaranduser.Name;
user.Email = usecaranduser.Email;
new YunShanOA.DataAccess.UseCar.UsecarAndUserHelp().Save(user);
}
db.SubmitChanges();
}
catch (ChangeConflictException)
{
db.ChangeConflicts.ResolveAll(RefreshMode.OverwriteCurrentValues);
db.SubmitChanges();
}
return(u.UseCarApplyFormID);
}
else
{
return(-1);
}
}