///导入数据库 private void Import() { string result; int i = 0; foreach (DataRow reader in datatable.Rows) { try { if (reader["传真"].ToString().Trim().Length == 0) { dtState.Rows.Add(i, "导入失败", "失败原因:'传真'不能为空"); continue; } if (reader["邮箱"].ToString().Trim().Length == 0) { dtState.Rows.Add(i, "导入失败", "失败原因:'邮箱'不能为空"); continue; } if (reader["网站"].ToString().Trim().Length == 0) { dtState.Rows.Add(i, "导入失败", "失败原因:'网站'不能为空"); continue; } if (reader["区域"].ToString().Trim().Length == 0) { dtState.Rows.Add(i, "导入失败", "失败原因:'区域'不能为空"); continue; } Guid DistrictId; District district = PharmacyDatabaseService.QueryDistricts(out result, reader["区域"].ToString(), null, null, true, true).FirstOrDefault(); if (district != null) { DistrictId = district.Id; } else { dtState.Rows.Add(i, "导入失败", "失败原因:区域'" + reader["区域"].ToString() + "'不存在"); continue; } PurchaseUnit info; bool IsExist = PharmacyDatabaseService.IsExistPurchaseUnitByName(out result, reader["单位名称"].ToString()); //更新 if (IsExist) { info = PharmacyDatabaseService.GetPurchaseUnitByName(out result, reader["单位名称"].ToString()); } else //新增 { info = new PurchaseUnit(); info.CreateTime = DateTime.Now; info.CreateUserId = Guid.Empty; info.Enabled = true; info.Name = reader["单位名称"].ToString(); } info.Id = Guid.NewGuid(); info.DistrictId = DistrictId; info.Code = reader["唯一编码"].ToString(); info.PinyinCode = reader["拼音码"].ToString(); info.ContactName = reader["联系人"].ToString(); info.ContactTel = reader["联系电话"].ToString(); info.Description = reader["说明"].ToString(); info.LegalPerson = reader["法人"].ToString(); info.BusinessScope = reader["生产经营范围"].ToString(); info.SalesAmount = reader["年销售额"].ToString(); info.Fax = reader["传真"].ToString(); info.Email = reader["邮箱"].ToString(); info.WebAddress = reader["网站"].ToString(); info.OutDate = Convert.ToDateTime(reader["过期日"]); //info.GSPGMPLicCode = reader["GSMP证书号"].ToString(); //info.GSPGMPLicOutdate = Convert.ToDateTime(reader["GSP/GMP证书有效期止"]); //info.BusinessLicCode = reader["营业执照编号"].ToString(); //info.BusinessLicOutdate = Convert.ToDateTime(reader["营业执照有效期止"]); //info.PharmaceuticalTradingLicCode = reader["药品经营许可证号"].ToString(); //info.PharmaceuticalTradingLicOutdate = Convert.ToDateTime(reader["药品经营许可证有效期止"]); info.TaxRegistrationCode = reader["税务登记号"].ToString(); info.LastAnnualDte = Convert.ToDateTime(reader["最新年检日期"]); if (IsExist) { PharmacyDatabaseService.UpdatePurchaseUnitByName(out result, reader["单位名称"].ToString(), info); dtState.Rows.Add(i, "更新成功", result); } else { PharmacyDatabaseService.AddPurchaseUnit(out result, info); dtState.Rows.Add(i, "导入成功", result); } } catch (Exception ex) { dtState.Rows.Add(i, "导入失败", "失败原因:" + ex.Message); } finally { progressValue++; i++; } } }