void selectSemesterAcception_Accepting(object sender, DialogControllerAcceptingEventArgs e)
{
//Dictionary<string, WeekReportData> dicTeacherPeriodData;
//WeekReportData currentWeekData;
ObjectSpace objectSpace = Application.CreateObjectSpace();
ListView lv = ((ListView)((WindowController)sender).Window.View);
Semester semester = lv.SelectedObjects.Count == 0 ? null : lv.SelectedObjects[0] as Semester;
if (semester != null)
{
string strParse = "";
foreach (Teacher teacher in View.SelectedObjects)
{
Data.CreateTeacherTimetableData(objectSpace, teacher.TeacherCode, semester.SemesterName);
strParse += (strParse == "" ? string.Format("TeacherCode='{0}'", teacher.TeacherCode) :
string.Format("or TeacherCode='{0}'", teacher.TeacherCode));
}
ReportData reportData = objectSpace.FindObject <ReportData>(
new BinaryOperator("Name", "Lịch giảng viên"));
ReportServiceController rsc = ((WindowController)sender).Frame.GetController <ReportServiceController>();
rsc.ShowPreview((IReportData)reportData, CriteriaOperator.Parse(strParse));
}
}
void selectSemesterAcception_Accepting(object sender, DialogControllerAcceptingEventArgs e)
{
ObjectSpace objectSpace = Application.CreateObjectSpace();
ListView lv = ((ListView)((WindowController)sender).Window.View);
Semester semester = lv.SelectedObjects.Count == 0 ? null : lv.SelectedObjects[0] as Semester;
GroupOperator classroomsOp = new GroupOperator(CriteriaOperator.Parse("1=0"));
ContainsOperator biOperator;
string strParse = "";
if (semester != null)
{
foreach (Student student in View.SelectedObjects)
{
Data.CreateStudentTimetableData(objectSpace, student.StudentCode, semester.SemesterName);
biOperator = new ContainsOperator("Students", new BinaryOperator("StudentCode", student.StudentCode));
classroomsOp = new GroupOperator(GroupOperatorType.Or, classroomsOp, biOperator);
strParse += (strParse == "" ? string.Format("StudentCode='{0}'", student.StudentCode) :
string.Format(" or StudentCode='{0}'", student.StudentCode));
}
ReportData reportData = objectSpace.FindObject <ReportData>(
new BinaryOperator("Name", "Lịch sinh viên"));
ReportServiceController rsc = ((WindowController)sender).Frame.GetController <ReportServiceController>();
rsc.ShowPreview((IReportData)reportData, CriteriaOperator.Parse(strParse)); //classroomsOp);
}
}
private void simpleAction1_Execute(object sender, SimpleActionExecuteEventArgs e)
{//b6
ReportPhieuNhapKho report = new ReportPhieuNhapKho();
Employee receipt = View.CurrentObject as Employee;
if (receipt != null)
{
IReportDataV2 reportData = null;
reportData =
View.ObjectSpace.FindObject <XtraReportData>
(
CriteriaOperator.And
(
new BinaryOperator("PredefinedReportType", typeof(ReportPhieuNhapKho), BinaryOperatorType.Equal),
new BinaryOperator("DisplayName", "Phieu nhap kho 2", BinaryOperatorType.Equal)
)
);
string handle = ReportDataProvider.ReportsStorage.GetReportContainerHandle(reportData);
ReportServiceController reportServiceController = Frame.GetController <ReportServiceController>();
printActionSVP = e.ShowViewParameters;
reportServiceController.ShowPreview(handle, CriteriaOperator.Parse(""));
}
}
private void PrintAction_Execute(object sender, SimpleActionExecuteEventArgs e)
{
SalesOrder record = (SalesOrder)((DevExpress.ExpressApp.DetailView) this.ObjectSpace.Owner).CurrentObject;
IObjectSpace objectSpace =
ReportDataProvider.ReportObjectSpaceProvider.CreateObjectSpace(typeof(ReportDataV2));
IReportDataV2 reportData =
objectSpace.FindObject <ReportDataV2>(
CriteriaOperator.Parse("[DisplayName] = 'Sales Order'"));
string handle = ReportDataProvider.ReportsStorage.GetReportContainerHandle(reportData);
//var __report = ReportDataProvider.ReportsStorage.LoadReport(reportData);
//__report.FilterString = "[InvoiceNo]='" + record.InvoiceNo + "'";
ReportServiceController controller = Frame.GetController <ReportServiceController>();
string reportContainerHandle = ReportDataProvider.ReportsStorage.GetReportContainerHandle(reportData);
CriteriaOperator criteria = new BinaryOperator("SalesOrder.DocumentNumber", record.DocumentNumber); // Filter by Tags
//var dataSource = (DevExpress.Persistent.Base.ReportsV2.ISupportCriteria)__report.DataSource;
//dataSource.Criteria = DevExpress.Data.Filtering.CriteriaOperator.Parse(
// "StartsWith(InvoiceNo, '" + record.InvoiceNo + "')");
if (controller != null)
{
controller.ShowPreview(handle, criteria);
}
}
protected override void OnDeactivated()
{
if (reportServiceController != null)
{
reportServiceController.CustomShowPreview -= reportServiceController_CustomShowPreview;
reportServiceController = null;
}
// Unsubscribe from previously subscribed events and release other references and resources.
base.OnDeactivated();
}
private void ShowReportPilot_Action_Execute(object sender, SimpleActionExecuteEventArgs e)
{
IObjectSpace objectSpace = ReportDataProvider.ReportObjectSpaceProvider.CreateObjectSpace(typeof(ReportDataV2));
ReportDataV2 reportData = objectSpace.FindObject <ReportDataV2>(CriteriaOperator.Parse("[DisplayName] = 'Pilot Report'"));
string handle = ReportDataProvider.ReportsStorage.GetReportContainerHandle(reportData);
ReportServiceController controller = Frame.GetController <ReportServiceController>();
if (controller != null)
{
controller.ShowPreview(handle);
}
}
//protected override void OnViewControlsCreated()
//{
// base.OnViewControlsCreated();
// // Access and customize the target View control.
// if (reportServiceController == null)
// {
// reportServiceController = Frame.GetController<ReportServiceController>();
// if (reportServiceController != null)
// {
// reportServiceController.CustomShowPreview += reportServiceController_CustomShowPreview;
// }
// }
//}
protected override void OnViewControllersActivated()
{
base.OnViewControllersActivated();
if (reportServiceController == null)
{
reportServiceController = Frame.GetController <ReportServiceController>();
if (reportServiceController != null)
{
reportServiceController.CustomShowPreview += reportServiceController_CustomShowPreview;
}
}
}
void ViewClassTrackingAction_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
ObjectSpace objectSpace = Application.CreateObjectSpace();
Semester semester = View.SelectedObjects[0] as Semester;
Data.CreateStudentClassTrackingData(objectSpace, semester.SemesterName);
ReportData reportData = objectSpace.FindObject <ReportData>(
new BinaryOperator("Name", "Tỉ lệ nợ lớp biên chế NHHK"));
string strParse = string.Format("Semester.SemesterName= '{0}'", semester.SemesterName);
ReportServiceController rsc = Frame.GetController <ReportServiceController>();
rsc.ShowPreview((IReportData)reportData, CriteriaOperator.Parse(strParse));
}
protected override void ShowNavigationItem(SingleChoiceActionExecuteEventArgs e)
{
base.ShowNavigationItem(e);
if (e.SelectedChoiceActionItem != null)
{
var model = e.SelectedChoiceActionItem.Model as IModelNavigationItemReport;
if (model != null && !string.IsNullOrEmpty(model.ReportName))
{
IObjectSpace objectSpace = ReportDataProvider.ReportObjectSpaceProvider.CreateObjectSpace(typeof(ReportDataV2));
IReportDataV2 reportData = objectSpace.FindObject <ReportDataV2>(CriteriaOperator.Parse("DisplayName = ?", model.ReportName));
string handle = ReportDataProvider.ReportsStorage.GetReportContainerHandle(reportData);
ReportServiceController controller = Frame.GetController <ReportServiceController>();
if (controller != null)
{
controller.ShowPreview(handle);
}
}
}
}
private void actionReportPilots_Execute(object sender, SimpleActionExecuteEventArgs e)
{
IObjectSpace objectSpace = ReportDataProvider.ReportObjectSpaceProvider.CreateObjectSpace(typeof(ReportDataV2));
IReportDataV2 reportData = objectSpace.FindObject <ReportDataV2>(CriteriaOperator.Parse("[DisplayName] = 'Пилоты самолеты'"));
string handle = ReportDataProvider.ReportsStorage.GetReportContainerHandle(reportData);
ReportServiceController controller = Frame.GetController <ReportServiceController>();
CriteriaOperator criteriaId = null;
if (View.Id == "Pilot_DetailView" && View.SelectedObjects.Count == 1)
{
criteriaId = CriteriaOperator.Parse("[Oid] = ?", ((Pilot)View.SelectedObjects[0]).Oid.ToString());
}
if (controller != null)
{
controller.ShowPreview(handle, criteriaId);
}
}
void selectSemesterForClassTransactionTrackingAcception_Accepting(object sender, DialogControllerAcceptingEventArgs e)
{
ObjectSpace objectSpace = Application.CreateObjectSpace();
ListView lv = ((ListView)((WindowController)sender).Window.View);
Semester semester = lv.SelectedObjects.Count == 0 ? null : lv.SelectedObjects[0] as Semester;
//GroupOperator classroomsOp = new GroupOperator(CriteriaOperator.Parse("1=0"));
//ContainsOperator biOperator;
string strParse = "";
if (semester != null)
{
//NestedObjectSpace nobj= objectSpace.CreateNestedObjectSpace();
foreach (StudentClass studentClass in View.SelectedObjects)
{
ClassTransactionTracking ct = objectSpace.FindObject <ClassTransactionTracking>
(CriteriaOperator.Parse("StudentClass.ClassCode = ? and Semester.SemesterName = ?",
studentClass.ClassCode, semester.SemesterName));
if (ct == null)
{
ct = objectSpace.CreateObject <ClassTransactionTracking>();
ct.Semester = objectSpace.FindObject <Semester>(CriteriaOperator.Parse("SemesterName=?", semester.SemesterName));
ct.StudentClass = objectSpace.FindObject <StudentClass>(CriteriaOperator.Parse("ClassCode=?", studentClass.ClassCode));
ct.Save();
}
//biOperator = new ContainsOperator("StudentClasses", new BinaryOperator("ClassCode", studentClass.ClassCode));
//classroomsOp = new GroupOperator(GroupOperatorType.Or, classroomsOp, biOperator);
strParse += (strParse == "" ? string.Format("StudentClass.ClassCode='{0}'", studentClass.ClassCode) :
string.Format(" or StudentClass.ClassCode='{0}'", studentClass.ClassCode));
}
objectSpace.CommitChanges();
ReportData reportData = objectSpace.FindObject <ReportData>(
new BinaryOperator("Name", "Tỉ lệ nợ lớp biên chế NHHK"));
strParse = string.Format("({0}) and Semester.SemesterName= '{1}'", strParse, semester.SemesterName);
ReportServiceController rsc = ((WindowController)sender).Frame.GetController <ReportServiceController>();
rsc.ShowPreview((IReportData)reportData, CriteriaOperator.Parse(strParse)); //classroomsOp);
}
}
