///导入数据库
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;
}
Guid UnitTypeId;
UnitType item = PharmacyDatabaseService.QueryUnitTypes(out result, reader["企业类型"].ToString(), true, true, null, null).FirstOrDefault();
if (item != null)
{
UnitTypeId = item.Id;
}
else
{
dtState.Rows.Add(i, "导入失败", "失败原因：企业类型'" + reader["企业类型"].ToString() + "'不存在");
continue;
}
SupplyUnit info;
bool IsExist = PharmacyDatabaseService.IsExistSupplyUnitByName(out result, reader["单位名称"].ToString());
//更新
if (IsExist)
{
info = PharmacyDatabaseService.GetSupplyUnitByName(out result, reader["单位名称"].ToString());
}
else //新增
{
info = new SupplyUnit();
info.Id = Guid.NewGuid();
info.CreateTime = DateTime.Now;
info.CreateUserId = Guid.Empty;
info.Enabled = true;
info.Name = reader["单位名称"].ToString();
}
info.QualityAgreementOutdate = Convert.ToDateTime(reader["质量协议书有效期止"]);
info.AttorneyAattorneyOutdate = Convert.ToDateTime(reader["法人委托书有效期止"]);
info.SupplyProductClass = reader["拟供品种"].ToString();
info.QualityCharger = reader["质量负责人"].ToString();
info.BankAccountName = reader["开户户名"].ToString();
info.Bank = reader["银行"].ToString();
info.BankAccount = reader["银行帐号"].ToString();
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["最新年检日期"]);
info.UnitTypeId = UnitTypeId;
if (IsExist)
{
PharmacyDatabaseService.UpdateSupplyUnitByName(out result, reader["单位名称"].ToString(), info);
dtState.Rows.Add(i, "更新成功", result);
}
else
{
PharmacyDatabaseService.AddSupplyUnit(out result, info);
dtState.Rows.Add(i, "导入成功", result);
}
}
catch (Exception ex)
{
dtState.Rows.Add(i, "导入失败", "失败原因：" + ex.Message);
}
finally
{
progressValue++;
i++;
}
}
}
