/// <summary>
/// 新增或更新Templates_Images
/// </summary>
/// <param name="patients"></param>
/// <param name="templates"></param>
/// <param name="templateImportDate"></param>
/// <param name="imageID"></param>
/// <param name="imagePath"></param>
/// <param name="tiNumber"></param>
public string InsertOrUpdateTemplatesImages(Patients patients, Templates templates, DateTime templateImportDate, int imageID, string imagePath, string tiNumber)
{
using (var ide = new iDentalEntities())
{
Templates_Images templates_Images = new Templates_Images();
var IsImageExist = from iie in ide.Templates_Images
where iie.Template_ID == templates.Template_ID &&
iie.Template_Image_Number == tiNumber &&
iie.Template_Image_ImportDate == templateImportDate.Date &&
iie.Patient_ID == patients.Patient_ID
select iie;
if (IsImageExist.Count() > 0)
{
templates_Images = IsImageExist.First();
templates_Images.Image_ID = imageID;
templates_Images.Image_Path = imagePath;
ide.SaveChanges();
}
else
{
templates_Images.Template_Image_Number = tiNumber;
templates_Images.Template_ID = templates.Template_ID;
templates_Images.Template_Image_ImportDate = templateImportDate.Date;
templates_Images.Image_ID = imageID;
templates_Images.Image_Path = imagePath;
templates_Images.Patient_ID = patients.Patient_ID;
ide.Templates_Images.Add(templates_Images);
ide.SaveChanges();
}
return(templates_Images.Template_Image_ID.ToString());
}
}
/// <summary>
///
/// </summary>
/// <param name="template_image_id"></param>
public string RemoveAndReturnUidTemplatesImages(int template_image_id)
{
using (var ide = new iDentalEntities())
{
var qti = from ti in ide.Templates_Images
where ti.Template_Image_ID == template_image_id
select ti;
if (qti.Count() > 0)
{
Templates_Images templates_Images = new Templates_Images();
templates_Images = qti.First();
templates_Images.Image_ID = null;
templates_Images.Image_Path = string.Empty;
ide.SaveChanges();
var qt = ide.Templates.Where(w => w.Template_ID == templates_Images.Template_ID).First();
return(qt.Template_DefaultImage);
}
return(null);
}
}