コード例 #1
0
        /// <summary>
        /// 显示详情页
        /// </summary>
        /// <param name="EditType">编辑类型</param>
        /// <returns>返回编辑结果</returns>
        public ActionResult ExpePlanEdit(E_tb_ExpePlan eExpePlan, string EditType, int?InfoID)
        {
            ViewData["PlanTypeList"]  = this.GetPlanTypeList(false);
            ViewData["ProjectList"]   = PageTools.GetSelectList(tProject.GetList("").Tables[0], "ProjectID", "ProjectName", false);
            ViewData["PersonnelList"] = PageTools.GetSelectList(tInPersonnel.GetList(" AreaID=" + CurrentUserInfo.AreaID.ToString()).Tables[0], "PersonnelID", "PersonnelName", false);

            //ViewData["SampleList"] = PageTools.GetSelectList(tSample.GetList(" (handleUser='' or handleUser is null) order by id ").Tables[0], "id", "name", false);
            ViewBag.PersonnelID = CurrentUserInfo.PersonnelID;
            ViewBag.AreaAddr    = tArea.GetModel(int.Parse(CurrentUserInfo.AreaID.ToString())).AreaName;
            ViewBag.SampleID    = 0;
            ViewBag.ProjectID   = 0;
            if (EditType == "Edit")
            {
                eExpePlan         = tExpePlan.GetModel(Convert.ToInt32(InfoID));
                ViewBag.SampleID  = eExpePlan.SampleID;
                ViewBag.ProjectID = eExpePlan.ProjectID;
            }

            //默认获取前200条数据,避免因option过多导致加载过慢
            List <tb_Sample> SampleList = _dSample.GetModelList(400, "id,name", " where handleUser=0", eExpePlan.SampleID != null ? Convert.ToInt32(eExpePlan.SampleID) : 0);

            ViewData["SampleList"] = SampleList;

            eExpePlan.EditType = EditType;
            return(View(eExpePlan));
        }
コード例 #2
0
ファイル: AreaController.cs プロジェクト: oakop01/lims
 /// <summary>
 /// 显示详情页  模块
 /// </summary>
 /// <param name="EditType">编辑类型</param>
 /// <returns>返回编辑结果</returns>
 public ActionResult AreaEdit(E_tb_Area eArea, string EditType, int?InfoID)
 {
     if (EditType == "Edit")
     {
         eArea = tArea.GetModel(Convert.ToInt32(InfoID));
     }
     eArea.EditType = EditType;
     return(View(eArea));
 }
コード例 #3
0
ファイル: ExpePlanController.cs プロジェクト: oakop01/lims
 /// <summary>
 /// 显示详情页
 /// </summary>
 /// <param name="EditType">编辑类型</param>
 /// <returns>返回编辑结果</returns>
 public ActionResult ExpePlanEdit(E_tb_ExpePlan eExpePlan, string EditType, int?InfoID)
 {
     ViewData["PlanTypeList"]  = this.GetPlanTypeList(false);
     ViewData["ProjectList"]   = PageTools.GetSelectList(tProject.GetList("").Tables[0], "ProjectID", "ProjectName", false);
     ViewData["PersonnelList"] = PageTools.GetSelectList(tInPersonnel.GetList(" AreaID=" + CurrentUserInfo.AreaID.ToString()).Tables[0], "PersonnelID", "PersonnelName", false);
     ViewData["SampleList"]    = PageTools.GetSelectList(tSample.GetList(" handleUser='' order by id ").Tables[0], "id", "name", false);
     ViewBag.PersonnelID       = CurrentUserInfo.PersonnelID;
     ViewBag.AreaAddr          = tArea.GetModel(int.Parse(CurrentUserInfo.AreaID.ToString())).AreaName;
     ViewBag.SampleID          = 0;
     ViewBag.ProjectID         = 0;
     if (EditType == "Edit")
     {
         eExpePlan         = tExpePlan.GetModel(Convert.ToInt32(InfoID));
         ViewBag.SampleID  = eExpePlan.SampleID;
         ViewBag.ProjectID = eExpePlan.ProjectID;
     }
     eExpePlan.EditType = EditType;
     return(View(eExpePlan));
 }
コード例 #4
0
        /// <summary>
        /// 显示详情页
        /// </summary>
        /// <param name="EditType">编辑类型</param>
        /// <returns>返回编辑结果</returns>
        public ActionResult TestReportEdit(E_tb_TestReport eTestReport, string EditType, int?InfoID)
        {
            //ViewData["RecordList"] = tOriginalRecord.GetList("").Tables[0];
            ViewData["_abclist"]       = PageTools.GetSelectList(tTypeDict.GetList("SubjectID=5").Tables[0], "TypeID", "TypeName", false);
            ViewData["RecordSelect"]   = new DataTable();
            ViewData["ReportDataList"] = new DataTable();
            ViewBag._userName          = CurrentUserInfo.UserName;
            if (EditType == "Edit")
            {
                eTestReport = tTestReport.GetModel(Convert.ToInt32(InfoID));
                //ViewData["RecordList"] = tOriginalRecord.GetList("RecordID not in (" + eTestReport.RecordIDS + ")").Tables[0];
                //ViewData["RecordSelect"] = tOriginalRecord.GetList("RecordID in (" + eTestReport.RecordIDS + ")").Tables[0];
                ViewData["ReportDataList"] = tTestReportData.GetList("ReportID=" + eTestReport.ReportID).Tables[0]; //检验数据

                E_tb_InPersonnel eInPersonnel = null;
                if (eTestReport.ApprovalPersonnelID != null && eTestReport.ApprovalPersonnelID > 0)
                {
                    eInPersonnel = tInPersonnel.GetModel(Convert.ToInt32(eTestReport.ApprovalPersonnelID));
                    eTestReport.ApprovalPersonnelName = (eInPersonnel != null ? eInPersonnel.PersonnelName : "");
                }
                if (eTestReport.examinePersonnelID != null && eTestReport.examinePersonnelID > 0)
                {
                    eInPersonnel = tInPersonnel.GetModel(Convert.ToInt32(eTestReport.examinePersonnelID));
                    eTestReport.examinePersonnelName = (eInPersonnel != null ? eInPersonnel.PersonnelName : "");
                }
                if (eTestReport.MainTestPersonnelID != null && eTestReport.MainTestPersonnelID > 0)
                {
                    eInPersonnel = tInPersonnel.GetModel(Convert.ToInt32(eTestReport.MainTestPersonnelID));
                    eTestReport.MainTestPersonnelName = (eInPersonnel != null ? eInPersonnel.PersonnelName : "");
                }
                if (string.IsNullOrEmpty(eTestReport.Explain))
                {
                    eTestReport.Explain = @"
一、	本检验报告复印、涂改无效;封面未加盖检验专用章和无检验专用骑缝章(如2页以上)的检验报告无效。<br/>
二、	检验报告仅对送检、抽检样品负责。<br/>
三、	本检验报告及检验单位名称不得用于产品的标签、广告评优及商品宣传等。<br/>
四、	本检验报告一式二份,一份由检验单位存档,一份交送检、抽检单位。<br/>
五、	本检验报告由出具报告单位负责,并进行解释说明。<br/>
六、	检验单位保存该检验报告6年。<br/><br/>"    ;
                    if (eTestReport.MainTestPersonnelID > 0)
                    {
                        try
                        {
                            eInPersonnel = tInPersonnel.GetModel(eTestReport.MainTestPersonnelID.Value);
                            var _areaid = (eInPersonnel != null ? eInPersonnel.AreaID : 0);
                            if (_areaid > 0)
                            {
                                switch (_areaid)
                                {
                                case 2:
                                {
                                    eTestReport.Explain += @"食品检测中心<br/>
检验单位地址:天津市塘沽区东沽石油新村配餐采购加工中心院内<br/>
邮政编码:300452<br/>
联系电话:022-66917343<br/>
传真:022-66917343<br/><br/>";
                                    break;
                                }

                                case 3:
                                {
                                    eTestReport.Explain += @"食品检测中心(葫芦岛)<br/>
检验单位地址:辽宁省葫芦岛市龙港区北港码头配餐公司葫芦岛配送基地<br/>
邮政编码:125000<br/>
联系电话:0429-2080522<br/>
传真:0429-2082522<br/><br/>";
                                    break;
                                }

                                case 4:
                                {
                                    eTestReport.Explain += @"食品检测中心(深圳)<br/>
检验单位地址:广东省惠州市大亚湾区石化大道中滨海十二路9号惠州物流基地W18<br/>
邮政编码:516082<br/>
联系电话:0752-5952819<br/>
传真:0752-5952818<br/><br/>";
                                    break;
                                }

                                case 5:
                                {
                                    eTestReport.Explain += @"食品检测中心(湛江)<br/>
检验单位地址:广东省湛江市坡头区南油一区配餐服务公司湛江分公司<br/>
邮政编码:524057<br/>
联系电话:0759-3910316<br/>
传真:0759-3901145<br/><br/>";
                                    break;
                                }

                                case 6:
                                {
                                    eTestReport.Explain += @"食品检测中心(龙口)<br/>
检验单位地址::山东省烟台市龙口市环海中路中海油物流码头配餐公司龙口配送基地<br/>
邮政编码:265700<br/>
联系电话:0535-8838131<br/>
传真:0535-8838131<br/><br/>";
                                    break;
                                }
                                }
                            }
                        }
                        catch
                        {
                        }
                    }
                }
            }


            ViewBag.SampleName = eTestReport.SampleName;
            if (eTestReport.SampleName.ToString().IndexOf(')') > -1)
            {
                ViewBag.SampleName = eTestReport.SampleName.ToString().Substring(0, eTestReport.SampleName.ToString().IndexOf(')') + 1);
            }
            else
            {
                ViewBag.SampleName = Regex.Replace(ViewBag.SampleName, @"[^\u4e00-\u9fa5|(|)]", "");
            }
            ViewBag.AreaName = tArea.GetModel(int.Parse(eTestReport.AreaID.ToString())).TestReportName;
            var sampleModel = new BLL.tb_SampleBLL().GetModelList(" sampleNum = '" + eTestReport.SampleNum + "'").FirstOrDefault();

            ViewBag._cydw = "none";
            ViewBag._sydw = "none";
            if (sampleModel.isDetection)
            {
                eTestReport.ToSampleMode = "抽样";
                ViewBag._cydw            = "";
            }
            else
            {
                eTestReport.ToSampleMode = "送样";
                ViewBag._sydw            = "";
            }
            ViewBag.Department = eTestReport.Department;
            var    _orlist        = new BLL.OriginalRecord.T_tb_OriginalRecord().GetModelList(" RecordID in (" + eTestReport.RecordIDS + ")");
            String _projectIds    = "";
            int    _tempProjectId = 0;

            for (int i = 0; i < _orlist.Count; i++)
            {
                if (_tempProjectId == _orlist[i].ProjectID)
                {
                    continue;
                }
                if (String.IsNullOrEmpty(_projectIds))
                {
                    _projectIds = _orlist[i].ProjectID.ToString();
                }
                else
                {
                    _projectIds += "," + _orlist[i].ProjectID.ToString();
                }
            }
            eTestReport.TestBasis = "";
            var _projectlist = new BLL.Laboratory.T_tb_Project().GetModelList(" ProjectID in (" + _projectIds + ")");

            foreach (var item in _projectlist)
            {
                if (String.IsNullOrEmpty(eTestReport.TestBasis))
                {
                    eTestReport.TestBasis = item.ExpeMethod;
                }
                else
                {
                    eTestReport.TestBasis += "," + item.ExpeMethod;
                }
            }
            //ViewBag.Department = "";
            //if (sampleModel != null)
            //{
            //    if (sampleModel.isDetection)
            //    {
            //        ViewBag.Department = sampleModel.detectionCompany;
            //    }
            //    else
            //    {
            //        var clint = new BLL.ClientManage.T_tb_ClientManage().GetModel(Convert.ToInt32(sampleModel.InspectCompany));
            //        ViewBag.Department = clint.ClientName;
            //    }
            //}


            ViewBag._TestType = "";
            if (eTestReport.TestType != null)
            {
                ViewBag._TestType = tTypeDict.GetModel(int.Parse(eTestReport.TestType.ToString())).TypeName;
            }
            //ViewBag.TestTime = eTestReport.TestTime == null ? "" : Convert.ToDateTime(eTestReport.TestTime).ToString("yyyy/MM/dd");
            ViewBag.TestTime            = eTestReport.IssuedTime == null ? "" : Convert.ToDateTime(eTestReport.IssuedTime).ToString("yyyy/MM/dd");
            ViewBag.DetectPersonnelID   = CurrentUserInfo.PersonnelID;
            ViewBag.DetectPersonnelName = CurrentUserInfo.PersonnelName;

            if (string.IsNullOrEmpty(eTestReport.Remarks))
            {
                eTestReport.Remarks = "无";
            }

            eTestReport.EditType = EditType;
            return(View(eTestReport));
        }
コード例 #5
0
        T_tb_Area tArea = new T_tb_Area();                              //区域/单位

        public ActionResult TestReportView(E_tb_TestReport eTestReport)
        {
            ViewData["ReportDataList"] = tTestReportData.GetList("ReportID=" + eTestReport.ReportID).Tables[0]; //检验数据
            eTestReport = tTestReport.GetModel(eTestReport.ReportID);
            E_tb_TypeDict eTypeDict = tTypeDict.GetModel(Convert.ToInt32(eTestReport.TestType));

            eTestReport.TestTypeName = (eTypeDict != null ? eTypeDict.TypeName : "");
            E_tb_InPersonnel eInPersonnel = new E_tb_InPersonnel();

            if (eTestReport.ApprovalPersonnelID != null && eTestReport.ApprovalPersonnelID > 0)
            {
                eInPersonnel = tInPersonnel.GetModel(Convert.ToInt32(eTestReport.ApprovalPersonnelID));
                if (eInPersonnel != null)
                {
                    eTestReport.ApprovalPersonnelName = eInPersonnel.PersonnelName;
                }
            }

            if (eTestReport.examinePersonnelID != null && eTestReport.examinePersonnelID > 0)
            {
                eInPersonnel = tInPersonnel.GetModel(Convert.ToInt32(eTestReport.examinePersonnelID));
                if (eInPersonnel != null)
                {
                    eTestReport.examinePersonnelName = eInPersonnel.PersonnelName;
                }
            }

            if (eTestReport.MainTestPersonnelID != null && eTestReport.MainTestPersonnelID > 0)
            {
                eInPersonnel = tInPersonnel.GetModel(Convert.ToInt32(eTestReport.MainTestPersonnelID));
                if (eInPersonnel != null)
                {
                    eTestReport.MainTestPersonnelName = eInPersonnel.PersonnelName;
                }
            }

            //eTestReport.SampleName = Regex.Replace(eTestReport.SampleName, @"[^\u4e00-\u9fa5]", "");
            if (eTestReport.SampleName.ToString().IndexOf(')') > -1)
            {
                eTestReport.SampleName = eTestReport.SampleName.ToString().Substring(0, eTestReport.SampleName.ToString().IndexOf(')') + 1);
            }
            else if (eTestReport.SampleName.ToString().IndexOf(')') > -1)
            {
                eTestReport.SampleName = eTestReport.SampleName.ToString().Substring(0, eTestReport.SampleName.ToString().IndexOf(')') + 1);
            }
            else
            {
                eTestReport.SampleName = Regex.Replace(eTestReport.SampleName, @"[^\u4e00-\u9fa5|(|)]", "");
            }

            var sampleModel = new BLL.tb_SampleBLL().GetModelList(" sampleNum = '" + eTestReport.SampleNum + "'").FirstOrDefault();

            ViewBag._cydw  = "none";
            ViewBag._sydw  = "none";
            ViewBag._scjdw = "";
            if (sampleModel != null)
            {
                if (sampleModel.isDetection)
                {
                    eTestReport.ToSampleMode = "抽样";
                    ViewBag._cydw            = "";
                    ViewBag._scjdw           = eTestReport.SamplingCompany;
                    eTestReport.Department   = "/";
                }
                else
                {
                    eTestReport.ToSampleMode    = "送样";
                    ViewBag._sydw               = "";
                    eTestReport.SamplingCompany = "/";
                    ViewBag._scjdw              = eTestReport.Department;
                }
            }
            if (String.IsNullOrEmpty(eTestReport.Specifications))
            {
                eTestReport.Specifications = "/";
            }
            if (String.IsNullOrEmpty(eTestReport.Packing))
            {
                eTestReport.Packing = "/";
            }
            if (String.IsNullOrEmpty(eTestReport.productNum))
            {
                eTestReport.productNum = "/";
            }



            ViewBag._IssuedTime = "";
            if (eTestReport.IssuedTime != null)
            {
                ViewBag._IssuedTime = eTestReport.IssuedTime.Value.ToString("yyyy/MM/dd");
            }
            var    _orlist        = new BLL.OriginalRecord.T_tb_OriginalRecord().GetModelList(" RecordID in (" + eTestReport.RecordIDS + ")");
            String _projectIds    = "";
            int    _tempProjectId = 0;

            for (int i = 0; i < _orlist.Count; i++)
            {
                if (_tempProjectId == _orlist[i].ProjectID)
                {
                    continue;
                }
                if (String.IsNullOrEmpty(_projectIds))
                {
                    _projectIds = _orlist[i].ProjectID.ToString();
                }
                else
                {
                    _projectIds += "," + _orlist[i].ProjectID.ToString();
                }
            }
            eTestReport.TestBasis = "";
            var _projectlist = new BLL.Laboratory.T_tb_Project().GetModelList(" ProjectID in (" + _projectIds + ")");

            foreach (var item in _projectlist)
            {
                if (String.IsNullOrEmpty(eTestReport.TestBasis))
                {
                    eTestReport.TestBasis = item.ExpeMethod;
                }
                else
                {
                    eTestReport.TestBasis += "," + item.ExpeMethod;
                }
            }
            ViewBag.AreaName = tArea.GetModel(int.Parse(eTestReport.AreaID.ToString())).TestReportName;
            return(View(eTestReport));
        }