Example #1
0
        private void CreateReportModel()
        {
            _PartReport = new PartReport()
            {
                Task = _Task
            };
            _DataSource = new List <ExecuteDimensionEntityViewModel>();

            if (_CurrentTemplate.Dimensions.Count == 0)
            {
                PmsService.Instance.PopulateDimensionsForPart(_CurrentTemplate);
            }

            foreach (var en in _CurrentTemplate.Dimensions)
            {
                var newDimension = en.Clone();
                _PartReport.Dimensions.Add(newDimension); //为PartReport创建新的dimensions从而用于插入数据库
                _DataSource.Add(new ExecuteDimensionEntityViewModel(newDimension));
            }

            if (_CurrentTemplate.Dimensions.Count > 0)
            {
                _SeletedDimension = _PartReport.Dimensions[0];
            }
            dataGridView1.DataSource       = _DataSource;
            dataGridView1.Rows[0].Selected = true;
        }
Example #2
0
        public void PopulateDimensionsForReport(PartReport i_PartReport)
        {
            var dimension = new DbDimension();

            i_PartReport.Dimensions = dimension.GetDimensionsByMeasureMentReport(i_PartReport);
            i_PartReport.Dimensions.Sort((i_Dimension, i_Dimension1) => i_Dimension.SerialNumber - i_Dimension1.SerialNumber);
        }
Example #3
0
        public void SaveReport(PartReport i_PartReport)
        {
            var dbPartReport = new DbPartReport();

            if (i_PartReport.Id == -1)
            {
                dbPartReport.InsertPartReport(i_PartReport);
            }
            else
            {
                dbPartReport.UpdatePartReport(i_PartReport);
            }


            var dbDimension = new DbDimension();

            foreach (var dimension in i_PartReport.Dimensions)
            {
                dimension.PartReport = i_PartReport;
                if (dimension.Id == -1)
                {
                    dbDimension.InsertDimension(dimension);
                }
                else
                {
                    dbDimension.UpdateDimension(dimension);
                }
            }
        }
Example #4
0
        public void Finish(PartReport i_PartReport)
        {
            PmsService.Instance.SaveReport(i_PartReport);
            Mediator.Mediator.Instance.NotifyColleagues(Execution.OneCompleted, i_PartReport);
            var executed = PmsService.Instance.GetPartReports(_Task);

            Mediator.Mediator.Instance.NotifyColleagues(App.ExecutionProgress, string.Format("{0}/{1}", _Task.SampleNumber, executed.Count));
        }
Example #5
0
        public void GetDimensionsByMeasureMentReportTest()
        {
            DbDimension      target       = new DbDimension(); // TODO: Initialize to an appropriate value
            PartReport       i_PartReport = null;              // TODO: Initialize to an appropriate value
            List <Dimension> expected     = null;              // TODO: Initialize to an appropriate value
            List <Dimension> actual;

            actual = target.GetDimensionsByMeasureMentReport(i_PartReport);
            Assert.AreEqual(expected, actual);
            Assert.Inconclusive("Verify the correctness of this test method.");
        }
Example #6
0
        public void UpdatePartReport(PartReport i_PartReport)
        {
            DbHelper db        = new DbHelper();
            var      updateCmd = db.GetSqlStringCommond(
                //" TaskID, MeasureDatetime, Operator, OperatorComment, Auditor, AuditDatetime, AuditComment, Approver, ApproveDatetime, ApproveComment";
                string.Format(
                    "update {0} set Operator='{1}',MeasureDatetime='{2}',OperatorComment='{3}',Auditor='{4}', AuditDatetime='{5}',AuditComment='{6}',Approver='{7}',ApproveDatetime='{8}',ApproveComment='{9}', TaskId={10} where ID={11}",
                    TableName, i_PartReport.Operator, i_PartReport.MeasurementDatetime
                    , i_PartReport.OperatorComment, i_PartReport.Auditor, i_PartReport.AuditDatetime, i_PartReport.AuditComment,
                    i_PartReport.Approver, i_PartReport.ApproveDatetime, i_PartReport.ApproveComment, i_PartReport.Task.Id, i_PartReport.Id));

            db.ExecuteNonQuery(updateCmd);
        }
Example #7
0
 public Dimension()
 {
     Part = new Part()
     {
         Id = -1
     };
     PartReport = new PartReport()
     {
         Id = -1
     };
     Dimensiontype = "";
     PreFix        = "";
     CadHandle     = "";
 }
Example #8
0
        public List <Dimension> GetDimensionsByMeasureMentReport(PartReport i_PartReport)
        {
            var      result = new List <Dimension>();
            DbHelper db     = new DbHelper();
            var      selCmd =
                db.GetSqlStringCommond(
                    string.Format(
                        "Select {0} from {2} where MeasurementReportID = {1}", SelectColums
                        , i_PartReport.Id, TableName));
            var reader = db.ExecuteReader(selCmd);

            while (reader.Read())
            {
                result.Add(PopulateADimension(reader));
            }
            selCmd.Connection.Close();
            return(result);
        }
Example #9
0
        public void InsertPartReport(PartReport i_PartReport)
        {
            DbHelper db        = new DbHelper();
            var      updateCmd = db.GetSqlStringCommond(
                //TaskID, MeasureDatetime, Operator, OperatorComment, Auditor, AuditDatetime, AuditComment, Approver, ApproveDatetime, ApproveComment";
                string.Format(
                    "insert into {0} ({1}) values({2},'{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", TableName, InsertColumns,
                    i_PartReport.Task.Id, i_PartReport.MeasurementDatetime, i_PartReport.Operator
                    , i_PartReport.OperatorComment, i_PartReport.Auditor, i_PartReport.AuditDatetime, i_PartReport.AuditComment,
                    i_PartReport.Approver, i_PartReport.ApproveDatetime, i_PartReport.ApproveComment));

            db.ExecuteNonQuery(updateCmd);
            var selectCmd = db.GetSqlStringCommond(string.Format("select MAX(ID) from {0}", TableName));

            selectCmd.Connection.Open();
            var reader = selectCmd.ExecuteReader();

            if (reader.Read())
            {
                i_PartReport.Id = reader.GetInt32(0);
            }
            selectCmd.Connection.Close();
        }
Example #10
0
        public void InsertGetUpdate()
        {
            DbPartReport target = new DbPartReport();
            PartReport   report = new PartReport()
            {
                Task = new Task()
                {
                    Id = 0
                },
                Operator = "tester", OperatorComment = "TestComment", MeasurementDatetime = new DateTime(2014, 10, 10),
                Auditor  = "Auditor", AuditComment = "Audit comment", AuditDatetime = new DateTime(2014, 10, 10),
                Approver = "Approver", ApproveComment = "Approve comment", ApproveDatetime = new DateTime(2014, 10, 10)
            };

            target.InsertPartReport(report);

            var insertedTask = target.GetPartReports(report.Task);

            Assert.AreEqual(report.Id, insertedTask.Id);
            report.Task.Id = 2;
            target.UpdatePartReport(report);

            Assert.AreEqual(report.Task.Id, 2);
        }
Example #11
0
 public BrowseReportViewModel(PartReport i_PartReport)
 {
     _PartReport = i_PartReport;
 }
Example #12
0
        private void OnPartReportSpecified(object i_Obj)
        {
            BeginInvoke(new Mediator.MessageHanlderDelegate(i_O =>
            {
                var partReport = i_O as PartReport;
                if (partReport == null)
                {
                    return;
                }
                _Task            = partReport.Task;
                _PartReport      = partReport;
                _CurrentTemplate = partReport.Task.Part;
                if (_CurrentTemplate == null)
                {
                    return;
                }

                _DataSource = new List <ExecuteDimensionEntityViewModel>();

                PmsService.Instance.PopulateDimensionsForReport(_PartReport);

                foreach (var en in _PartReport.Dimensions)
                {
                    _DataSource.Add(new ExecuteDimensionEntityViewModel(en));
                }

                if (_CurrentTemplate.Dimensions.Count > 0)
                {
                    _SeletedDimension = _PartReport.Dimensions[0];
                }

                dataGridView1.DataSource = _DataSource;
                btnCreateReport.Text     = @"保存报告";
                BindingTextControls();
                // RefreshCommentControls();
                if (PmsService.Instance.CurrentUser.Group.Name == "检测")
                {
                    BindMeasurementControl();
                    LblTester.Text             = PmsService.Instance.CurrentUser.Name;
                    LblTestDate.Text           = DateTime.Now.ToLongDateString();
                    _ExecuteReportControlState = new ExecuteState();
                    _ExecuteReportControlState.Enter(this);
                }
                if (PmsService.Instance.CurrentUser.Group.Name == "评审")
                {
                    BindMeasurementControl();
                    BindAuditControl();
                    LblAuditor.Text            = PmsService.Instance.CurrentUser.Name;
                    LblAuditDate.Text          = DateTime.Now.ToLongDateString();
                    _ExecuteReportControlState = new AuditState();
                    _ExecuteReportControlState.Enter(this);
                }
                if (PmsService.Instance.CurrentUser.Group.Name == "审批")
                {
                    BindMeasurementControl();
                    BindAuditControl();
                    BindApproveControl();
                    LblApprover.Text           = PmsService.Instance.CurrentUser.Name;
                    LblApproveDate.Text        = DateTime.Now.ToLongDateString();
                    _ExecuteReportControlState = new ApproveState();
                    _ExecuteReportControlState.Enter(this);
                }
            }), i_Obj);
        }
Example #13
0
        public void Start(PartReport i_PartReport)
        {
            var executed = PmsService.Instance.GetPartReports(_Task);

            Mediator.Mediator.Instance.NotifyColleagues(App.ExecutionProgress, string.Format("{0}/{1}", _Task.SampleNumber, executed.Count));
        }