public ActionResult Edit(string contactId) { IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll(); //事项分类 Global.Common.Models.ParamModel caseType = paramList.SingleOrDefault(m => m.ParamCode.Equals(Constants.SysParamType.ContactCaseType)); ViewBag.CaseType = new SelectList(caseType.itemsList, "ParamItemValue", "ParamItemName"); //公司名称 Global.Common.Models.ParamModel company = paramList.SingleOrDefault(t => t.ParamCode == Constants.SysParamType.CompanyInfo); if (null == company) { company = new Global.Common.Models.ParamModel(); } Global.Common.Models.ParamItemModel companyInfo = company.itemsList.SingleOrDefault(s => s.ParamItemName.Equals("公司名称")); ContactModel model = null; if (contactId == "0") { model = new ContactModel(); model.CompanyName = companyInfo == null ? "" : companyInfo.ParamItemValue; } else { model = ServiceProvider.ContactService.GetById(UtilsHelper.Decrypt2Int(contactId)); IList <BusinessAttachmentModel> businessAttachList = ServiceProvider.BusinessAttachmentService.GetByBusinessTypeAndId(Constants.AttachmentBusinessType.联络单.GetHashCode(), model.ContactId); if (businessAttachList.Count > 0 && businessAttachList.First() != null) { ViewBag.FileId = UtilsHelper.Encrypt(businessAttachList.First().FileId.ToString()); ViewBag.FileName = businessAttachList.First().FileName; } } return(View(model)); }
public ActionResult InstrumentScan() { IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll(); Global.Common.Models.ParamModel receiveLocale = paramList.SingleOrDefault(m => m.ParamCode.Equals(Constants.SysParamType.InstrumentReceiveLocale)); ViewBag.InstrumentReceiveLocale = new SelectList(receiveLocale.itemsList, "ParamItemName", "ParamItemName"); return(View()); }
public string GetOrderListJsonData() { IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll(); Global.Common.Models.ParamModel company = paramList.SingleOrDefault(t => t.ParamCode == Instrument.Common.Constants.SysParamType.CompanyInfo); if (null == company) { company = new Global.Common.Models.ParamModel(); } Global.Common.Models.ParamItemModel pCompany = company.itemsList.SingleOrDefault(s => s.ParamItemName.Equals("公司编号")); StringBuilder sb = new StringBuilder(); List <MeasureOrderModel> orderBillList = new List <MeasureOrderModel>(); string endDate = DateTime.Now.ToString("yyyy-MM-dd"); string startDate = DateTime.Now.AddYears(-2).ToString("yyyy-MM-dd"); string orderJsonData = WSProvider.MeasureLabProvider.OrderSearch(startDate, endDate, Global.Business.ServiceProvider.ParamService.GetaccessToken(Instrument.Common.Constants.SysParamType.CompanyInfo)); Dictionary <string, object> dic = ToolsLib.Utility.CommonUtils.JsonDeserialize(orderJsonData, typeof(Dictionary <string, object>)) as Dictionary <string, object>; if (dic["Msg"].ToString() == "OK") { orderBillList = ToolsLib.Utility.CommonUtils.JsonDeserialize(dic["Data"].ToString(), typeof(List <MeasureOrderModel>)) as List <MeasureOrderModel>; } else { return("{\"data\":[]}"); } sb.Insert(0, "{\"data\":["); foreach (var item in orderBillList) { if (LoginHelper.LoginUserAuthorize.ContainsKey("订单查询-查看仪器")) { sb.AppendFormat("[\" <a href='#' OrderNumber='{0}' onclick='fnCheckInstrument(this)'>查看仪器</a> ", item.OrderNumber); } if (LoginHelper.LoginUserAuthorize.ContainsKey("/Order/BatchDownloadCert".ToLower())) { sb.AppendFormat("<a href='#' orderNumber='{0}' onclick='fnBatchDownloadCert(this)'>批量下载证书</a>\"", item.OrderNumber); } sb.AppendFormat(",\"{0}\"", item.OrderNumber); sb.AppendFormat(",\"{0}\"", item.CreateDate.ToShortDateString()); sb.AppendFormat(",\"{0}\"", item.SaleName); sb.AppendFormat(",\"{0}\"", item.InstrumentCount); sb.AppendFormat(",\"{0}\"", item.IsComplete == true ? "完工" : "未完工"); sb.AppendFormat(",\"{0}\"", item.IsCompleteCert == true ? "完工" : "未完工"); //sb.AppendFormat(",\"{0}\"", item.IsInvoice == true ? "已开票" : "未开票"); //sb.AppendFormat(",\"{0}\"", item.IsPay == true ? "已付款" : "未付款"); sb.Append("],"); } if (orderBillList.Count > 0) { sb.Remove(sb.Length - 1, 1); } sb.Append("]}"); return(sb.ToString()); }
/// <summary> /// 获取公司编号 /// </summary> /// <param name="CompanyInfo"></param> /// <returns></returns> public string GetCompanyCode(string CompanyInfo) { IList <ParamModel> paramList = ServiceProvider.ParamService.GetAll(); ParamModel company = paramList.SingleOrDefault(t => t.ParamCode == CompanyInfo); if (null == company) { company = new Global.Common.Models.ParamModel(); } ParamItemModel pCompany = company.itemsList.SingleOrDefault(s => s.ParamItemName.Equals("公司编号")); return(pCompany == null ? "" : pCompany.ParamItemValue); }
/// <summary> /// 获取accessToken /// </summary> /// <returns></returns> public string GetaccessToken(string CompanyInfo) { IList <Global.Common.Models.ParamModel> paramList = ServiceProvider.ParamService.GetAll(); ParamModel company = paramList.SingleOrDefault(t => t.ParamCode == CompanyInfo); if (null == company) { company = new Global.Common.Models.ParamModel(); } ParamItemModel pCompany = company.itemsList.SingleOrDefault(s => s.ParamItemName.Equals("公司编号")); ParamItemModel Pwd = company.itemsList.SingleOrDefault(s => s.ParamItemName.Equals("密码")); return(SSOHelper.Encrypt(string.Format("{0}|{1}", pCompany == null ? "" : pCompany.ParamItemValue, Pwd == null ? "" : Pwd.ParamItemValue))); }
/// <summary> /// 生成委托单号 /// </summary> /// <returns></returns> public string GenerateUniqueOrderNumber() { IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll(); Global.Common.Models.ParamModel company = paramList.SingleOrDefault(t => t.ParamCode == Constants.SysParamType.CompanyInfo); if (null == company) { company = new Global.Common.Models.ParamModel(); } Global.Common.Models.ParamItemModel CompanyCode = company.itemsList.SingleOrDefault(s => s.ParamItemName.Equals("公司编号")); string orderNumber = ""; do { orderNumber = CompanyCode.ParamItemValue + DateTime.Now.ToString("yyyyMMdd") + ToolsLib.Utility.StrUtils.GetRandomNumb(4); }while (DBProvider.OrderDAO.IsExistOrderNumber(orderNumber)); return(orderNumber); }
/// <summary> /// 知识库明细 /// </summary> /// <param name="knowledgeId"></param> /// <returns></returns> public ActionResult Details(string knowledgeId) { KnowledgesModel model = ServiceProvider.KnowledgesService.GetKnowledgeDetailInfo(UtilsHelper.Decrypt2Int(knowledgeId)); //内容类型 IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll(); Global.Common.Models.ParamModel kType = paramList.SingleOrDefault(m => m.ParamCode.Equals(UtilConstants.SysParamType.KnowledgeType)); ViewBag.KType = kType.itemsList.FirstOrDefault(s => s.ParamItemValue == String.Format("{0}", model.KType)).ParamItemName; //业务附件 StringBuilder sb = new StringBuilder(); sb.Append("["); if (model.swfFileByte != null && model.swfFileByte.Length > 0) { string swfFilePath = "/tempFile/" + Guid.NewGuid().ToString() + ".swf"; ToolsLib.FileService.NormalFile.SaveInfoToFile(model.swfFileByte, swfFilePath); ViewBag.FilePath = swfFilePath; } else { ViewBag.FilePath = ""; } int i = 1; if (model.businessAttachList != null) { foreach (Hashtable item in model.businessAttachList) { sb.Append("["); sb.AppendFormat("\"{0}\"", i++); sb.AppendFormat(",\"<a href='#' onclick='fnDownLoad(this);' data-id='{0}'>{1}</a>\"", UtilsHelper.Encrypt(String.Format("{0}", item["FileId"])), item["FileName"]); sb.Append("],"); } if (model.businessAttachList.Count > 0) { sb.Remove(sb.Length - 1, 1); } } sb.Append("]"); ViewBag.Data = sb.ToString(); return(View(model)); }
public ActionResult Detail(string contactId) { IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll(); ContactModel model = ServiceProvider.ContactService.GetById(UtilsHelper.Decrypt2Int(contactId)); //事项分类 Global.Common.Models.ParamModel caseType = paramList.SingleOrDefault(m => m.ParamCode.Equals(Constants.SysParamType.ContactCaseType)); ParamItemModel item = caseType.itemsList.SingleOrDefault(p => p.ParamItemValue.Equals(model.CaseType.ToString())); ViewBag.CaseType = item.ParamItemName; IList <BusinessAttachmentModel> businessAttachList = ServiceProvider.BusinessAttachmentService.GetByBusinessTypeAndId(Constants.AttachmentBusinessType.联络单.GetHashCode(), model.ContactId); if (businessAttachList.Count > 0 && businessAttachList.First() != null) { ViewBag.FileId = UtilsHelper.Encrypt(businessAttachList.First().FileId.ToString()); ViewBag.FileName = businessAttachList.First().FileName; } return(View(model)); }
/// <summary> /// 编辑 /// </summary> /// <param name="knowledgeId"></param> /// <returns></returns> public ActionResult Edit(string knowledgeId) { KnowledgesModel model = new KnowledgesModel(); if (knowledgeId != "0") { model = ServiceProvider.KnowledgesService.GetById(UtilsHelper.Decrypt2Int(knowledgeId)); } //内容类型 IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll(); Global.Common.Models.ParamModel kType = paramList.SingleOrDefault(m => m.ParamCode.Equals(UtilConstants.SysParamType.KnowledgeType)); ViewBag.KType = new SelectList(kType.itemsList, "ParamItemValue", "ParamItemName"); if (model.FileId != 0) { AttachmentModel attach = Global.Business.ServiceProvider.AttachmentService.GetById(model.FileId); ViewBag.FileName = attach.FileName; } return(View(model)); }
/// <summary> /// 仪器送检 /// 仪器手机App接口和网页功能公用方法 /// </summary> /// <param name="instrumentIds">以逗号分隔的仪器标识(未加密)</param> /// <param name="orderJson">送检单Json数据(送检人SendUser,App和网页分别独立赋值)</param> /// <returns></returns> public string SendOrder(string instrumentIds, string orderJson, string OrgName, string UserName, int UserId) { string result = ""; //组装数据 JObject orderObj = JObject.Parse(orderJson); var instrumentIdArr = instrumentIds.Split(','); var instrumentIdList = instrumentIdArr.Select(l => Convert.ToInt32(l)).ToList(); IList <InstrumentModel> instrumentList = ServiceProvider.InstrumentService.GetByIdList(instrumentIdList); //对应的仪器列表 IList <InstrumentWaitSendModel> instrumentWaitSendList = ServiceProvider.InstrumentWaitSendService.GetByInstrumentIdsList(instrumentIdList, UserId); //对应的送检仪器备注 //单号 string orderNumber = ServiceProvider.OrderService.GenerateUniqueOrderNumber(); //组装送检仪器MD5Code字典 Dictionary <int, string> dictionaryMd5 = new Dictionary <int, string>(); foreach (int instrumentId in instrumentIdList) { dictionaryMd5.Add(instrumentId, Guid.NewGuid().ToString()); } IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll(); Global.Common.Models.ParamModel company = paramList.SingleOrDefault(t => t.ParamCode == Constants.SysParamType.CompanyInfo); if (null == company) { company = new Global.Common.Models.ParamModel(); } Global.Common.Models.ParamItemModel CompanyName = company.itemsList.SingleOrDefault(s => s.ParamItemName.Equals("公司名称")); Global.Common.Models.ParamItemModel CompanyCode = company.itemsList.SingleOrDefault(s => s.ParamItemName.Equals("公司编号")); orderObj.Add("OrderNumber", orderNumber); orderObj.Add("CompanyName", CompanyName == null ? "" : CompanyName.ParamItemValue); orderObj.Add("CompanyCode", CompanyCode == null ? "" : CompanyCode.ParamItemValue); //送检人部门 orderObj.Add("SendUserOrgName", OrgName); orderObj.Add("InstrumentCount", instrumentList.Count); //orderObj.Add("SendUser", LoginHelper.LoginUser.UserName);//送检人 //仪器Json数据组装 JArray projectJArr = new JArray(); int maxLen = int.Parse(string.IsNullOrEmpty(WebUtils.GetSettingsValue("SendOrderLength")) ? "1000" : WebUtils.GetSettingsValue("SendOrderLength"));//一次送检的最大仪器数量 int leftCout = instrumentList.Count % maxLen; int count = 0; InstrumentWaitSendModel instrumentWaitSendModel = null; foreach (var item in instrumentList) { instrumentWaitSendModel = instrumentWaitSendList.SingleOrDefault(I => I.InstrumentId.Equals(item.InstrumentId)); count++; JObject projectObj = new JObject(); projectObj.Add("CertificationNumber", item.CertificateNo); projectObj.Add("InstrumentName", item.InstrumentName); projectObj.Add("Specification", item.Specification); projectObj.Add("ManageNumber", item.ManageNo); projectObj.Add("MadeNumber", item.SerialNo); projectObj.Add("InspectDate", item.DueStartDate); projectObj.Add("DueEndDate", item.DueEndDate); projectObj.Add("InspectOrg", item.InspectOrg); projectObj.Add("Remark", instrumentWaitSendModel.Remark); projectObj.Add("MD5Code", dictionaryMd5[item.InstrumentId]); projectJArr.Add(projectObj); if (count % maxLen == 0 || (count % maxLen == leftCout)) { string En_Order = SSOHelper.Encrypt(orderObj.ToString()); string En_Project = SSOHelper.Encrypt(projectJArr.ToString()); string jsonData = GRGTCommonUtils.WSProvider.EbusinessProvider.SendOrder(En_Order, En_Project, Global.Business.ServiceProvider.ParamService.GetaccessToken(Instrument.Common.Constants.SysParamType.CompanyInfo)); Dictionary <string, object> dic = ToolsLib.Utility.CommonUtils.JsonDeserialize(jsonData, typeof(Dictionary <string, object>)) as Dictionary <string, object>; result = dic["Msg"].ToString(); projectJArr.Clear(); if (!result.Equals("OK"))//一次不成功则终止推送 { break; } } } if (result.Equals("OK")) { OrderModel order = new OrderModel(); order.OrderNumber = orderNumber;//单号 order.SendUser = UserName; order.UserId = UserId; order.CreateUser = order.SendUser; order.ReceivedUser = ""; order.InstrumentCount = instrumentIdList.Count; ServiceProvider.OrderService.Save(order); //新增送检仪器清单 InstrumentModel instrumentModel = null; foreach (int instrumentId in instrumentIdList) { OrderSendInstrumentModel model = new OrderSendInstrumentModel(); instrumentModel = instrumentList.SingleOrDefault(I => I.InstrumentId.Equals(instrumentId)); instrumentWaitSendModel = instrumentWaitSendList.SingleOrDefault(I => I.InstrumentId.Equals(instrumentId)); if (instrumentModel == null) { continue; } model.InstrumentId = instrumentId; model.ItemCode = dictionaryMd5[instrumentId]; model.OrderId = order.OrderId; model.InstrumentName = instrumentModel.InstrumentName; model.CertificationNumber = instrumentModel.CertificateNo; model.SerialNo = instrumentModel.SerialNo; model.Specification = instrumentModel.Specification; model.ManageNo = instrumentModel.ManageNo; model.InspectDate = instrumentModel.DueStartDate; model.DueEndDate = instrumentModel.DueEndDate; model.InspectOrg = "广电计量";// model.Remark = instrumentWaitSendModel.Remark; ServiceProvider.OrderSendInstrumentService.Save(model); } } return(result); }
/// <summary> /// 批量导入固定资产 /// </summary> /// <param name="dt"></param> /// <param name="sucessMsg"></param> /// <returns></returns> public string BatchImportAssets(DataTable dt, ref string sucessMsg) { StringBuilder result = new StringBuilder(); Global.Common.Models.ParamItemModel paranItem = new Global.Common.Models.ParamItemModel(); IList <Global.Common.Models.OrgModel> orgList = Global.Business.ServiceProvider.OrgService.GetAll(); //系统参数 IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll(); //器具状态 Global.Common.Models.ParamModel instrumentState = paramList.SingleOrDefault(t => t.ParamCode == Constants.SysParamType.AssetsState); if (null == instrumentState) { instrumentState = new Global.Common.Models.ParamModel(); } //资产属性 Global.Common.Models.ParamModel calibrationType = paramList.SingleOrDefault(t => t.ParamCode == Instrument.Common.Constants.SysParamType.CalibrationType); if (null == calibrationType) { calibrationType = new Global.Common.Models.ParamModel(); } IList <Global.Common.Models.OrgModel> belongDepartList = new List <Global.Common.Models.OrgModel>(); InstrumentModel instrument = new InstrumentModel(); int sucessCount = 0; foreach (DataRow dr in dt.Rows) { try { if (string.IsNullOrWhiteSpace(dr["资产名称"].ToString())) { continue; } instrument.InstrumentForm = Constants.InstrumentForm.固定资产.GetHashCode(); instrument.InstrumentName = UtilsHelper.SpecialCharValidate(dr["资产名称"].ToString()); instrument.Specification = UtilsHelper.SpecialCharValidate(dr["型号规格"].ToString()); instrument.SerialNo = UtilsHelper.SpecialCharValidate(dr["出厂编号"].ToString()); //设备状态 paranItem = instrumentState.itemsList.SingleOrDefault(i => i.ParamItemName.Equals(dr["设备状态"].ToString())); instrument.RecordState = paranItem == null ? 0 : Convert.ToInt32(paranItem.ParamItemValue); //资产属性 paranItem = calibrationType.itemsList.SingleOrDefault(i => i.ParamItemName.Equals(dr["资产属性"].ToString())); instrument.CalibrationType = paranItem == null ? 0 : Convert.ToInt32(paranItem.ParamItemValue); //所属部门 belongDepartList = orgList.Where(o => o.OrgName.Equals(dr["所属部门"].ToString().Trim())).ToList(); if (belongDepartList.Count > 0) { instrument.BelongDepart = belongDepartList[0].OrgCode; } else { instrument.BelongDepart = ""; } instrument.AssetsNo = UtilsHelper.SpecialCharValidate(dr["资产编号"].ToString()); instrument.ManageNo = UtilsHelper.SpecialCharValidate(dr["管理编号"].ToString()); instrument.LeaderName = UtilsHelper.SpecialCharValidate(dr["保管人"].ToString()); instrument.StorePalce = UtilsHelper.SpecialCharValidate(dr["存放地点"].ToString()); if (!string.IsNullOrWhiteSpace(dr["购置日期"].ToString())) { DateTime buyDate; if (DateTime.TryParse(dr["购置日期"].ToString(), out buyDate)) { instrument.BuyDate = buyDate; } else { result.AppendLine("购置日期【" + dr["购置日期"].ToString() + "】格式不正确"); continue; } } if (!string.IsNullOrWhiteSpace(dr["购置金额"].ToString())) { instrument.Price = Convert.ToDecimal(dr["购置金额"].ToString()); } instrument.Manufacturer = UtilsHelper.SpecialCharValidate(dr["生产厂家"].ToString()); instrument.ManufactureContactor = UtilsHelper.SpecialCharValidate(dr["厂家联系信息"].ToString()); instrument.Remark = UtilsHelper.SpecialCharValidate(dr["备注"].ToString()); instrument.CreateUser = LoginHelper.LoginUser.UserName; instrument.LastUpdateUser = LoginHelper.LoginUser.UserName; instrument.BarCode = DateTime.Now.ToString("yyyyMMddff") + ToolsLib.Utility.StrUtils.GetRandomNumb(6); instrument.ItemCode = Guid.NewGuid().ToString(); //新增 DBProvider.InstrumentDAO.Add4Assets(instrument); //导入成功记录 sucessCount++; } catch (Exception ex) { log.Error(ex.Message); result.AppendLine("未成功导入资产:名称(" + instrument.InstrumentName + ") 资产编号(" + instrument.AssetsNo + ")"); } } sucessMsg = "共导入" + sucessCount + "条记录"; return(result.ToString()); }
public string BatchImportInstrument(DataTable dt, ref string sucessMsg) { StringBuilder result = new StringBuilder(); Global.Common.Models.ParamItemModel paranItem = new Global.Common.Models.ParamItemModel(); IList <Global.Common.Models.OrgModel> orgList = Global.Business.ServiceProvider.OrgService.GetAll(); ////组织根目录 //orgList.SingleOrDefault(o=>o.OrgCode //系统参数 IList <Global.Common.Models.ParamModel> paramList = Global.Business.ServiceProvider.ParamService.GetAll(); //器具状态 Global.Common.Models.ParamModel instrumentState = paramList.SingleOrDefault(t => t.ParamCode == Constants.SysParamType.InstrumentState); if (null == instrumentState) { instrumentState = new Global.Common.Models.ParamModel(); } Global.Common.Models.ParamModel instrumentType = paramList.SingleOrDefault(t => t.ParamCode == UtilConstants.SysParamType.InstrumentType); if (null == instrumentType) { instrumentType = new Global.Common.Models.ParamModel(); } //设备分类 Global.Common.Models.ParamModel instrumentCate = paramList.SingleOrDefault(t => t.ParamCode == Instrument.Common.Constants.SysParamType.InstrumentCate); if (null == instrumentCate) { instrumentCate = new Global.Common.Models.ParamModel(); } //资产属性 Global.Common.Models.ParamModel calibrationType = paramList.SingleOrDefault(t => t.ParamCode == Instrument.Common.Constants.SysParamType.CalibrationType); if (null == calibrationType) { calibrationType = new Global.Common.Models.ParamModel(); } //管理级别 Global.Common.Models.ParamModel manageLevel = paramList.SingleOrDefault(t => t.ParamCode == Instrument.Common.Constants.SysParamType.ManageLevel); if (null == manageLevel) { manageLevel = new Global.Common.Models.ParamModel(); } //计量类别 Global.Common.Models.ParamModel verificationType = paramList.SingleOrDefault(t => t.ParamCode == Instrument.Common.Constants.SysParamType.VerificationType); if (null == verificationType) { verificationType = new Global.Common.Models.ParamModel(); } IList <Global.Common.Models.OrgModel> belongDepartList = new List <Global.Common.Models.OrgModel>(); IList <InstrumentModel> instrumentList = new List <InstrumentModel>(); //判断是否需要检测管理编号存在 string IsJudgeExistManageNo = WebUtils.GetSettingsValue("IsJudgeExistManageNo"); if (IsJudgeExistManageNo == "true") { instrumentList = GetAll().Where(t => !string.IsNullOrWhiteSpace(t.ManageNo)).ToList(); } IList <string> manageNoList = new List <string>(); int count = 0; bool IsSynInstrument = LoginHelper.LoginUserAuthorize.Contains("/Instrument/SynInstrument".ToLower()); InstrumentModel instrument = new InstrumentModel(); int sucessCount = 0; foreach (DataRow dr in dt.Rows) { try { if (string.IsNullOrWhiteSpace(dr["仪器名称"].ToString())) { //result.AppendLine("仪器名称不能为空"); continue; } instrument.InstrumentForm = Constants.InstrumentForm.仪器.GetHashCode();//仪器 instrument.InstrumentName = UtilsHelper.SpecialCharValidate(dr["仪器名称"].ToString()); //型号 instrument.Specification = UtilsHelper.SpecialCharValidate(dr["仪器型号"].ToString()); //管理编号 instrument.ManageNo = UtilsHelper.SpecialCharValidate(dr["管理编号"].ToString()); if (IsJudgeExistManageNo == "true") { //在库中查找管理编号 count = instrumentList.Where(t => t.ManageNo.Trim().Equals(instrument.ManageNo.Trim())).Count(); //在导入的数据中找管理编号 if (count == 0) { count = manageNoList.Where(t => t.Trim().Equals(instrument.ManageNo.Trim())).Count(); } if (count > 0) { result.AppendLine("存在相同的管理编号(" + instrument.ManageNo + ")"); continue; } if (!string.IsNullOrWhiteSpace(instrument.ManageNo)) { manageNoList.Add(instrument.ManageNo); } } //出厂编号 instrument.SerialNo = UtilsHelper.SpecialCharValidate(dr["出厂编号"].ToString()); //技术特征 instrument.TechniqueCharacter = UtilsHelper.SpecialCharValidate(dr["技术特征"].ToString()); //计量特性 instrument.MeasureCharacter = UtilsHelper.SpecialCharValidate(dr["计量特性"].ToString()); //设备状态 paranItem = instrumentState.itemsList.SingleOrDefault(i => i.ParamItemName.Equals(dr["设备状态"].ToString())); instrument.RecordState = paranItem == null ? 0 : Convert.ToInt32(paranItem.ParamItemValue); //设备分类 paranItem = instrumentCate.itemsList.SingleOrDefault(i => i.ParamItemName.Equals(dr["设备分类"].ToString())); instrument.InstrumentCate = paranItem == null ? 1 : Convert.ToInt32(paranItem.ParamItemValue); //资产属性 paranItem = calibrationType.itemsList.SingleOrDefault(i => i.ParamItemName.Equals(dr["资产属性"].ToString())); instrument.CalibrationType = paranItem == null ? 0 : Convert.ToInt32(paranItem.ParamItemValue); //设备类别 paranItem = instrumentType.itemsList.SingleOrDefault(i => i.ParamItemName.Equals(dr["设备类别"].ToString())); instrument.InstrumentType = paranItem == null ? 0 : Convert.ToInt32(paranItem.ParamItemValue); //管理级别 paranItem = manageLevel.itemsList.SingleOrDefault(i => i.ParamItemName.Equals(dr["管理级别"].ToString())); instrument.ManageLevel = paranItem == null ? "A" : paranItem.ParamItemValue; //计量类别 paranItem = verificationType.itemsList.SingleOrDefault(i => i.ParamItemName.Equals(dr["计量类别"].ToString())); instrument.VerificationType = paranItem == null ? 0 : Convert.ToInt32(paranItem.ParamItemValue); //英文名称 instrument.EnglishName = UtilsHelper.SpecialCharValidate(dr["英文名称"].ToString()); //所属部门 belongDepartList = orgList.Where(o => o.OrgName.Equals(dr["所属部门"].ToString().Trim())).ToList(); if (belongDepartList.Count > 0) { instrument.BelongDepart = belongDepartList[0].OrgCode; } else { instrument.BelongDepart = ""; } //仪器证书信息 //证书编号 instrument.CertificateNo = UtilsHelper.SpecialCharValidate(dr["证书编号"].ToString()); if (!string.IsNullOrWhiteSpace(dr["校准日期"].ToString())) { instrument.DueStartDate = Convert.ToDateTime(dr["校准日期"].ToString()); } if (!string.IsNullOrWhiteSpace(dr["到期日期"].ToString())) { instrument.DueEndDate = Convert.ToDateTime(dr["到期日期"].ToString()); } //计量机构 instrument.InspectOrg = UtilsHelper.SpecialCharValidate(dr["计量机构"].ToString()); //资产编号 instrument.AssetsNo = UtilsHelper.SpecialCharValidate(dr["资产编号"].ToString()); //校验周期 instrument.InspectCycle = UtilsHelper.SpecialCharValidate(dr["检验周期"].ToString()); //使用年限 instrument.DurableYears = UtilsHelper.SpecialCharValidate(dr["使用年限"].ToString()); //保管人 instrument.LeaderName = UtilsHelper.SpecialCharValidate(dr["保管人"].ToString()); //项目组 instrument.ProjectTeam = UtilsHelper.SpecialCharValidate(dr["项目组"].ToString()); //说明书编号 //instrument.SpecificationCode = dr[23].ToString(); //存放地点 instrument.StorePalce = UtilsHelper.SpecialCharValidate(dr["存放地点"].ToString()); //购置日期 if (!string.IsNullOrWhiteSpace(dr["购置日期"].ToString())) { instrument.BuyDate = Convert.ToDateTime(dr["购置日期"].ToString()); } //购置金额 if (!string.IsNullOrWhiteSpace(dr["购置金额"].ToString())) { instrument.Price = Convert.ToDecimal(dr["购置金额"].ToString()); } //生产厂家 instrument.Manufacturer = UtilsHelper.SpecialCharValidate(dr["生产厂家"].ToString()); //厂家联系信息 instrument.ManufactureContactor = UtilsHelper.SpecialCharValidate(dr["厂家联系信息"].ToString()); //备注 instrument.Remark = UtilsHelper.SpecialCharValidate(dr["备注"].ToString()); instrument.CreateUser = LoginHelper.LoginUser.UserName; instrument.LastUpdateUser = LoginHelper.LoginUser.UserName; instrument.BarCode = DateTime.Now.ToString("yyyyMMddff") + ToolsLib.Utility.StrUtils.GetRandomNumb(6); instrument.ItemCode = Guid.NewGuid().ToString(); //新增仪器 DBProvider.InstrumentDAO.Add4Instrument(instrument); //仪器证书信息 当三个都不为空时保存 if (!string.IsNullOrWhiteSpace(instrument.CertificateNo) && (instrument.DueStartDate != null) && (instrument.DueEndDate != null)) { InstrumentCertificationModel cert = new InstrumentCertificationModel(); cert.InstrumentId = instrument.InstrumentId; cert.CertificationCode = UtilsHelper.SpecialCharValidate(instrument.CertificateNo); cert.CheckDate = instrument.DueStartDate; cert.EndDate = instrument.DueEndDate; cert.MeasureOrg = instrument.InspectOrg; cert.RecordState = Constants.InstrumentCertificationState.完成周检.GetHashCode(); ServiceProvider.InstrumentCertificationService.SaveCert(cert); ServiceProvider.InstrumentCertificationService.UpdateCertificationAndState(instrument.InstrumentId); } //同步到业务系统 if (IsSynInstrument && instrument.InstrumentCate > 0) { BeginSynInstrument(instrument.InstrumentId); } //导入成功记录 sucessCount++; } catch (Exception ex) { log.Error(ex.Message); result.AppendLine("未成功导入仪器:名称(" + instrument.InstrumentName + ") 管理编号(" + instrument.ManageNo + ")"); } } sucessMsg = "共导入" + sucessCount + "条记录"; return(result.ToString()); }