/// <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));
}
/// <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));
}
/// <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));
}
/// <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));
}
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));
}
