public ReturnValue AddUpdate(Feme model)
{
ReturnValue resoult = dalFeme.Search(model.EmployeeID, model.YearMonth);
if (!resoult.ErrorFlag)
{
return resoult;
}
if (resoult.Count > 0)
{
resoult = dalFeme.Update(model);
if (resoult.ErrorFlag)
{
BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID + " 的妇科信息", "1", model.TERMINAL_CD);
}
}
else
{
resoult = dalFeme.Add(model);
if (resoult.ErrorFlag)
{
BLL_Log.AddLog(model.UPDATER_ID + " 修改了用户 " + model.EmployeeID + " 的妇科信息", "1", model.TERMINAL_CD);
}
}
return resoult;
}
public ReturnValue Add(Feme model)
{
SqlParameter[] parameters = {
new SqlParameter("@UPDATER_ID", SqlDbType.NVarChar,12),
new SqlParameter("@TERMINAL_CD", SqlDbType.NVarChar,256),
new SqlParameter("@EmployeeID", SqlDbType.NVarChar,18),
new SqlParameter("@YearMoth", SqlDbType.NVarChar,6),
new SqlParameter("@Menarche", SqlDbType.NVarChar,3),
new SqlParameter("@MenopauseAge", SqlDbType.NVarChar,3),
new SqlParameter("@MenstrualCycle", SqlDbType.NVarChar,1),
new SqlParameter("@MenstrualVolume", SqlDbType.NVarChar,1),
new SqlParameter("@Dysmenorrhea", SqlDbType.NVarChar,1),
new SqlParameter("@DiseaseHistory", SqlDbType.NVarChar,50),
new SqlParameter("@FamilyTumorTistory", SqlDbType.NVarChar,1),
new SqlParameter("@DiseaseHistoryOther", SqlDbType.NVarChar,255),
new SqlParameter("@AndrogenUsed", SqlDbType.NVarChar,1),
new SqlParameter("@EstrogenUsed", SqlDbType.NVarChar,1),
new SqlParameter("@Cervical", SqlDbType.NVarChar,255),
new SqlParameter("@Uterine", SqlDbType.NVarChar,255),
new SqlParameter("@Genital", SqlDbType.NVarChar,255),
new SqlParameter("@Leucorrhea", SqlDbType.NVarChar,255),
new SqlParameter("@Vaginal", SqlDbType.NVarChar,255),
new SqlParameter("@AnnexLeft", SqlDbType.NVarChar,255),
new SqlParameter("@AnnexRight", SqlDbType.NVarChar,255),
new SqlParameter("@CheckCases", SqlDbType.NVarChar,255),
new SqlParameter("@InfraredScanBreast", SqlDbType.NVarChar,255),
new SqlParameter("@Conclusion", SqlDbType.NVarChar,1024),
new SqlParameter("@Physicians", SqlDbType.NVarChar,255)};
parameters[0].Value = model.UPDATER_ID;
parameters[1].Value = model.TERMINAL_CD;
parameters[2].Value = model.EmployeeID;
parameters[3].Value = model.YearMonth;
parameters[4].Value = model.Menarche;
parameters[5].Value = model.MenopauseAge;
parameters[6].Value = model.MenstrualCycle;
parameters[7].Value = model.MenstrualVolume;
parameters[8].Value = model.Dysmenorrhea;
parameters[9].Value = model.DiseaseHistory;
parameters[10].Value = model.FamilyTumorTistory;
parameters[11].Value = model.DiseaseHistoryOther;
parameters[12].Value = model.AndrogenUsed;
parameters[13].Value = model.EstrogenUsed;
parameters[14].Value = model.Cervical;
parameters[15].Value = model.Uterine;
parameters[16].Value = model.Genital;
parameters[17].Value = model.Leucorrhea;
parameters[18].Value = model.Vaginal;
parameters[19].Value = model.AnnexLeft;
parameters[20].Value = model.AnnexRight;
parameters[21].Value = model.CheckCases;
parameters[22].Value = model.InfraredScanBreast;
parameters[23].Value = model.Conclusion;
parameters[24].Value = model.Physicians;
return SqlHelper.ExecuteSql(Add_SQL, parameters);
}
public ReturnValue AddUpdateFeme(Feme model)
{
BLL_Feme bll = new BLL_Feme();
return bll.AddUpdate(model);
}