public int AddModelByCkdh(T_SHMX model, string SHDH)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var parentModel = hContext1.Set <T_SHD>().Where(p => p.SHDH == SHDH).FirstOrDefault();
parentModel.ISSH = 0;
model.SHID = parentModel.SHID;
#region
//对新库存数据进行修改
//DbSet<T_KC> kcdb = hContext1.Set<T_KC>();
//var kc = kcdb.Where(p => p.CPID == model.CPID && p.CPPH == model.CPPH && p.CKID == model.CKID).FirstOrDefault();
//if (kc == null)
//{
// return 0;
//}
//kc.CPNUM = kc.CPNUM - Convert.ToInt32(model.CPNUM);
#endregion
model.CPTPRICE = (model.CPPRICE ?? 0) * (model.CPNUM ?? 0);
hContext1.Set <T_SHMX>().Add(model);
return(hContext1.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
}
public int AddModelByCkdh(T_CKMX model, string CKDH)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
int ckid = hContext1.Set <T_CKD>().Where(p => p.CKDH == CKDH).FirstOrDefault().CKID;
model.CKDID = ckid;
//对新库存数据进行修改
DbSet <T_KC> kcdb = hContext1.Set <T_KC>();
var kc = kcdb.Where(p => p.CPID == model.CPID && p.CPPH == model.CPPH && p.CKID == model.CKID).FirstOrDefault();
if (kc == null)
{
return(0);
}
kc.CPNUM = kc.CPNUM - Convert.ToInt32(model.CPNUM);
hContext1.Set <T_CKMX>().Add(model);
return(hContext1.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
}
public int Delete(int id)
{
int result = 0;
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var dbchild = hContext1.Set <T_RKMX>();
var lst = dbchild.Where(p => p.RKID == id);
if (lst != null && lst.Count() > 0)
{
dbchild.RemoveRange(lst);
}
var db = hContext1.Set <T_RKD>();
var model = db.Find(id);
db.Remove(model);
hContext1.SaveChanges();
result = 1;
}
catch (Exception ex)
{
}
}
return(result);
}
public List <T_CGD> GetPageInfo <S>(Expression <Func <T_CGD, bool> > where, Func <T_CGD, S> order, bool desc, int pageIndex, int pageSize, int?cpId, int?supId, int?cusId, out int pageCount, out int totalRecord)
{
totalRecord = 0;
pageCount = 0;
List <T_CGD> list = new List <T_CGD>();
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
Expression <Func <T_CGMX, bool> > whereCGMX = PredicateBuilder.True <T_CGMX>();
var isContain = false;
if (cpId != null && cpId != 0)
{
whereCGMX = whereCGMX.And(p => p.CPID == cpId);
isContain = true;
}
if (supId != null && supId != 0)
{
whereCGMX = whereCGMX.And(p => p.SupID == supId);
isContain = true;
}
if (cusId != null && cusId != 0)
{
whereCGMX = whereCGMX.And(p => p.CPSCQYID == cusId);
isContain = true;
}
if (isContain)
{
var dbchild = hContext1.Set <T_CGMX>().Where(whereCGMX.Compile());
var lst = dbchild.Select(p => p.CGID);
if (lst != null)
{
where = where.And(p => lst.Contains(p.CGID));
}
}
DbSet <T_CGD> db = hContext1.Set <T_CGD>();
//DbQuery<T_CGD> dbq = db.Include("T_WhsQY");
totalRecord = db.Where(where.Compile()).Count();
if (totalRecord > 0)
{
pageCount = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(totalRecord / pageSize))) + 1;
if (desc)
{
list = db.Where(where.Compile()).OrderByDescending <T_CGD, S>(order).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
}
else
{
list = db.Where(where.Compile()).OrderBy <T_CGD, S>(order).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
}
}
}
catch (Exception ex)
{
return(null);
}
return(list);
}
}
public int SaveTPrice(int id, string dh, double tPrice)
{
int result = 0;
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
if (id != 0)
{
var model = hContext1.Set <T_XSD>().Find(id);
model.XSJE = tPrice;
}
else
{
var model = hContext1.Set <T_XSD>().Where(p => p.XSDH == dh).FirstOrDefault();
model.XSJE = tPrice;
}
hContext1.SaveChanges();
result = 1;
}
catch (Exception ex)
{
}
}
return(result);
}
public T_YLCP GetCpDetailsById(int cpid)
{
T_YLCP cp = new T_YLCP();
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
cp = base.GetModelById(cpid);
if (cp != null)
{
if (cp.CPSCQYID.HasValue)
{
cp.T_SupQY1 = hContext1.Set <T_SupQY>().Find(cp.CPSCQYID);
}
if (cp.CPGYSID.HasValue)
{
cp.T_SupQY = hContext1.Set <T_SupQY>().Find(cp.CPGYSID);
}
}
}
catch (Exception ex)
{
}
}
return(cp);
}
public int DeleteModelByGuid(string guid)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
DbSet <T_SHMX> db = hContext1.Set <T_SHMX>();
T_SHMX model = db.Where(p => p.GUID == guid).FirstOrDefault();
#region
//对原库存数据进行修改
//DbSet<T_KC> kcdb = hContext1.Set<T_KC>();
//var oldkc = kcdb.Where(p => p.CPID == model.CPID && p.CPPH == model.CPPH && p.CKID == model.CKID).FirstOrDefault();
//if (oldkc != null)
//{
// oldkc.CPNUM = oldkc.CPNUM + Convert.ToInt32(model.CPNUM);
//}
#endregion
var parentModel = hContext1.Set <T_SHD>().Find(model.SHID);
parentModel.ISSH = 0;
db.Remove(model);
return(hContext1.SaveChanges());
}
catch (Exception)
{
return(0);
}
}
}
public int SaveTPrice(int id, double tPrice, string dhid)
{
int result = 0;
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
if (id == 0)
{
var model = hContext1.Set <T_CGD>().Where(p => p.CGDH == dhid).FirstOrDefault();
if (model.CGID != 0)
{
model.CGTotalPrice = tPrice;
}
}
else
{
var model = hContext1.Set <T_CGD>().Find(id);
model.CGTotalPrice = tPrice;
}
hContext1.SaveChanges();
result = 1;
}
catch (Exception ex)
{
}
}
return(result);
}
public List <T_YSD> GetYSDByCondition(string hflag, int?cpId, int?supId, string cpph)
{
Expression <Func <T_YSD, bool> > where = PredicateBuilder.True <T_YSD>();
if (!String.IsNullOrEmpty(hflag))
{
where = where.And(p => p.YSFLAG == hflag);
}
List <T_YSD> list = new List <T_YSD>();
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
Expression <Func <T_YSMX, bool> > whereMX = PredicateBuilder.True <T_YSMX>();
var isContain = false;
if (cpId != null && cpId != 0)
{
whereMX = whereMX.And(p => p.CPID == cpId);
isContain = true;
}
if (supId != null && supId != 0)
{
whereMX = whereMX.And(p => p.SupID == supId);
isContain = true;
}
if (!String.IsNullOrEmpty(cpph))
{
whereMX = whereMX.And(p => !string.IsNullOrEmpty(p.CPPH) && p.CPPH.Contains(cpph));
isContain = true;
}
if (isContain)
{
var dbchild = hContext1.Set <T_YSMX>().Where(whereMX.Compile());
var lst = dbchild.Select(p => p.YSID);
if (lst != null)
{
where = where.And(p => lst.Contains(p.YSID));
}
}
DbSet <T_YSD> db = hContext1.Set <T_YSD>();
list = db.Where(where.Compile()).OrderByDescending(p => p.YSDH).ToList();
}
catch (Exception ex)
{
return(null);
}
return(list);
}
}
public int AddModelByRkdh(T_RKMX model, string RKDH)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var parentModel = hContext1.Set <T_RKD>().Where(p => p.RKDH == RKDH).FirstOrDefault();
parentModel.ISSH = 0;
var rkid = parentModel.RKID;
model.RKID = rkid;
hContext1.Set <T_RKMX>().Add(model);
#region
//对新库存数据进行修改
//DbSet<T_KC> kcdb = hContext1.Set<T_KC>();
//var newkc = kcdb.Where(p => p.CPID == model.CPID && p.CPPH == model.CPPH && p.CKID == model.CKID).FirstOrDefault();
//if (newkc == null)
//{
// T_KC newKc = new T_KC()
// {
// CPID = model.CPID,
// CKID = model.CKID,
// CPNUM = Convert.ToInt32(model.CPNUM),
// FlAG = 1,
// CPPH = model.CPPH,
// CPSCRQ = model.CPSCRQ,
// CPYXQ = model.CPYXQ,
// SupID = model.SupID,
// ScqyID = model.ScqyID
// };
// kcdb.Add(newKc);
//}
//else
//{
// newkc.CPNUM = newkc.CPNUM + Convert.ToInt32(model.CPNUM);
// newkc.CPYXQ = model.CPYXQ;
// newkc.CPSCRQ = model.CPSCRQ;
//}
#endregion
return(hContext1.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
}
public List<T_CusPerson> GetPageInfo<S>(Expression<Func<T_CusPerson, bool>> where, Func<T_CusPerson, S> order, bool desc, int pageIndex, int pageSize, out int pageCount, out int totalRecord)
{
totalRecord = 0;
pageCount = 0;
List<T_CusPerson> list = new List<T_CusPerson>();
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
DbSet<T_CusPerson> db = hContext1.Set<T_CusPerson>();
DbQuery<T_CusPerson> dbq = db.Include("T_CusQY");
totalRecord = db.Where(where.Compile()).Count();
if (totalRecord > 0)
{
pageCount = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(totalRecord / pageSize))) + 1;
if (desc)
{
list = dbq.Where(where.Compile()).OrderByDescending<T_CusPerson, S>(order).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
}
else
{
list = dbq.Where(where.Compile()).OrderBy<T_CusPerson, S>(order).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
}
}
}
catch (Exception)
{
return null;
}
return list;
}
}
public virtual List <T> GetPageInfo <S>(Expression <Func <T, bool> > where, Func <T, S> order, bool desc, int pageIndex, int pageSize, out int pageCount, out int totalRecord)
{
totalRecord = 0;
pageCount = 0;
List <T> list = new List <T>();
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
DbSet <T> db = hContext1.Set <T>();
totalRecord = db.Where(where.Compile()).Count();
if (totalRecord > 0)
{
pageCount = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(totalRecord / pageSize))) + 1;
if (desc)
{
list = db.Where(where.Compile()).OrderByDescending <T, S>(order).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
}
else
{
list = db.Where(where.Compile()).OrderBy <T, S>(order).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
}
}
}
catch (Exception ex)
{
int a = 0;
}
return(list);
}
}
public T_SJZDFL GetModeByName(string name)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
List <T_SJZDFL> list = null;
Expression <Func <T_SJZDFL, bool> > where = PredicateBuilder.True <T_SJZDFL>();
if (!string.IsNullOrEmpty(name))
{
where.And(p => p.FLMC == name);
}
DbSet <T_SJZDFL> db = hContext1.Set <T_SJZDFL>();
list = db.Where(where.Compile()).ToList();
if (list.Count > 0)
{
return(list[0]);
}
}
catch (Exception ex)
{
}
}
return(null);
}
public int UpdateList(List <T_BJDate> list)
{
var result = 0;
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
foreach (var item in list)
{
var temp = hContext1.Set <T_BJDate>().Find(item.ID);
if (temp != null)
{
temp.BJDATE = item.BJDATE;
}
}
hContext1.SaveChanges();
result = 1;
}
catch (Exception)
{
}
}
return(result);
}
public override List <T_XSMX> GetPageInfo <S>(Expression <Func <T_XSMX, bool> > where, Func <T_XSMX, S> order, bool desc, int pageIndex, int pageSize, out int pageCount, out int totalRecord)
{
totalRecord = 0;
pageCount = 0;
List <T_XSMX> list = new List <T_XSMX>();
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
DbSet <T_XSMX> db = hContext1.Set <T_XSMX>();
DbQuery <T_XSMX> dbq = db.Include("T_XSD").Include("T_YLCP").Include("T_YLCP.T_SupQY").Include("T_YLCP.T_SupQY1").Include("T_XSD.T_CusQY");
totalRecord = db.Where(where.Compile()).Count();
if (totalRecord > 0)
{
pageCount = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(totalRecord / pageSize))) + 1;
if (desc)
{
list = dbq.Where(where.Compile()).OrderByDescending <T_XSMX, string>(p => p.T_XSD.XSDH).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
}
else
{
list = dbq.Where(where.Compile()).OrderBy <T_XSMX, string>(p => p.T_XSD.XSDH).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
}
}
}
catch (Exception ex)
{
return(null);
}
return(list);
}
}
public virtual int UpdateModel(T model, params object[] keyValues)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
DbSet <T> db = hContext1.Set <T>();
T oldModel = db.Find(keyValues);
foreach (var item in model.GetType().GetProperties())
{
item.SetValue(oldModel, item.GetValue(model, null), null);
}
hContext1.SaveChanges();
return(1);
}
catch (DbEntityValidationException dbEx)
{
return(0);
}
catch (Exception ex)
{
return(0);
}
}
}
public int AddModelByYsdh(T_YSMX model, string YSDH)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
int ysid = hContext1.Set <T_YSD>().Where(p => p.YSDH == YSDH).FirstOrDefault().YSID;
model.YSID = ysid;
hContext1.Set <T_YSMX>().Add(model);
return(hContext1.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
}
public int Sh(int id, int status)
{
int result = 0;
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var model = hContext1.Set <T_THD>().Find(id);
model.ISSH = status;
#region 更新库存
if (model.RKFlag == 1) //入库后退货
{
var ysdModel = hContext1.Set <T_YSD>().Find(model.YSID);
if (ysdModel != null && ysdModel.YSFLAG == "合格收货") //只有验收单是“合格收货”的才会入库，才能引起库存变化
{
var lstMX = hContext1.Set <T_THMX>().Where(p => p.THID == id).ToList();
if (lstMX != null && lstMX.Count > 0)
{
foreach (var item in lstMX)
{
DbSet <T_KC> kcdb = hContext1.Set <T_KC>();
var kc = kcdb.Where(p => p.CPID == item.CPID && p.CPPH == item.CPPH && p.CKID == item.CKID).FirstOrDefault();
if (kc == null)
{
return(0);
}
kc.CPNUM = kc.CPNUM - Convert.ToInt32(item.CPNUM);
}
}
}
}
#endregion
hContext1.SaveChanges();
result = 1;
}
catch (Exception ex)
{
}
}
return(result);
}
public int DeleteModelByGuid(string guid)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
DbSet <T_CGMX> db = hContext1.Set <T_CGMX>();
T_CGMX model = db.Where(p => p.GUID == guid).FirstOrDefault();
var dbparent = hContext1.Set <T_CGD>().Find(model.CGID);
dbparent.ISSH = 0;
db.Remove(model);
return(hContext1.SaveChanges());
}
catch (Exception)
{
return(0);
}
}
}
public int AddModelByXsdh(T_XSMX model, string XSDH)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var parentModel = hContext1.Set <T_XSD>().Where(p => p.XSDH == XSDH).FirstOrDefault();
var xsid = parentModel.XSID;
parentModel.XSFLAG = 0;
model.XSID = xsid;
hContext1.Set <T_XSMX>().Add(model);
return(hContext1.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
}
public int AddModelByRkdh(T_THMX model, string THDH)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var parentModel = hContext1.Set <T_THD>().Where(p => p.THDH == THDH).FirstOrDefault();
parentModel.ISSH = 0;
var rkid = parentModel.THID;
model.THID = rkid;
hContext1.Set <T_THMX>().Add(model);
return(hContext1.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
}
public int Delete(int id)
{
int result = 0;
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var dbchild = hContext1.Set <T_YSMX>();
var lst = dbchild.Where(p => p.YSID == id);
if (lst != null && lst.Count() > 0)
{
dbchild.RemoveRange(lst);
}
var db = hContext1.Set <T_YSD>();
var model = db.Find(id);
#region 如果当前验收单使对应的采购单完结，则删除时更改采购单置为未完结状态
if (model.IsCGFinish == 1)
{
var dbCGD = hContext1.Set <T_CGD>();
var modelCGD = dbCGD.Where(p => p.CGDH == model.CGDH).FirstOrDefault();
if (modelCGD != null && modelCGD.CGID != 0)
{
modelCGD.IsFinish = 0;
}
}
#endregion
db.Remove(model);
hContext1.SaveChanges();
result = 1;
}
catch (Exception ex)
{
}
}
return(result);
}
public List <T_XSMX> GetT_XSMXByXsdh(string xsdh)
{
List <T_XSMX> list = new List <T_XSMX>();
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var xsd = hContext1.Set <T_XSD>().Where(p => p.XSDH == xsdh).FirstOrDefault();
if (xsd != null)
{
DbSet <T_XSMX> db = hContext1.Set <T_XSMX>();
DbQuery <T_XSMX> dbq = db.Include("T_YLCP").Include("T_XSD").Include("T_YLCP.T_SupQY").Include("T_YLCP.T_SupQY1").Include("T_XSD.T_CusQY");
list = dbq.Where(p => p.XSID == xsd.XSID).ToList();
}
}
catch (Exception ex)
{
}
}
return(list);
}
public List <T_SHMX> GetT_SHMXByCkdh(string ckdh)
{
List <T_SHMX> list = new List <T_SHMX>();
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var ckd = hContext1.Set <T_SHD>().Where(p => p.SHDH == ckdh).FirstOrDefault();
if (ckd != null)
{
DbSet <T_SHMX> db = hContext1.Set <T_SHMX>();
DbQuery <T_SHMX> dbq = db.Include("T_YLCP").Include("T_CK").Include("T_YLCP.T_SupQY1");
list = dbq.Where(p => p.SHID == ckd.SHID).ToList();
}
}
catch (Exception ex)
{
}
}
return(list);
}
public int Delete(int id)
{
var result = 0;
try
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
var db = hContext1.Set <T_CusQYZZ>();
var deleteFiles = db.Where(p => p.QYID == id);
db.RemoveRange(deleteFiles);
var temp = hContext1.Set <T_CusQY>().Find(id);
hContext1.Set <T_CusQY>().Remove(temp);
hContext1.SaveChanges();
result = 1;
}
}
catch (Exception ex)
{
}
return(result);
}
public int Delete(int id)
{
int result = 0;
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var dbchild = hContext1.Set <T_THMX>();
var lst = dbchild.Where(p => p.THID == id);
if (lst != null && lst.Count() > 0)
{
dbchild.RemoveRange(lst);
}
var db = hContext1.Set <T_THD>();
var model = db.Find(id);
#region 如果当前退货单使对应的验收单完结，则删除时更改验收单置为未完结状态
//if (model.IsFinish == 1)
//{
// var dbYSD = hContext1.Set<T_YSD>();
// var modelYSD = dbYSD.Find(model.YSID);
// if (modelYSD != null && modelYSD.YSID != 0)
// {
// modelYSD.IsTHFinish = 0;
// }
//}
#endregion
db.Remove(model);
hContext1.SaveChanges();
result = 1;
}
catch (Exception ex)
{
}
}
return(result);
}
public int Delete(int id)
{
int result = 0;
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var dbchild = hContext1.Set <T_CKMX>();
var lst = dbchild.Where(p => p.CKID == id);
if (lst != null && lst.Count() > 0)
{
dbchild.RemoveRange(lst);
}
var db = hContext1.Set <T_CKD>();
var model = db.Find(id);
#region 如果当前出库单使对应的销售单完结，则删除时更改销售单置为未完结状态
if (model.IsFinish == 1)
{
var dbXSD = hContext1.Set <T_XSD>();
var modelXSD = dbXSD.Find(model.XSID);
if (modelXSD != null)
{
modelXSD.IsFinish = 0;
}
}
#endregion
db.Remove(model);
hContext1.SaveChanges();
result = 1;
}
catch (Exception ex)
{
}
}
return(result);
}
public int Delete(int id)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var dbchild = hContext1.Set <T_QYZZ>();
var lst = dbchild.Where(p => p.QYID == id);
if (lst != null && lst.Count() > 0)
{
dbchild.RemoveRange(lst);
}
DbSet <T_SupQY> db = hContext1.Set <T_SupQY>();
var model = db.Find(id);
db.Remove(model);
return(hContext1.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
}
public int GetRoleByUserId(int userId)
{
int roleId = 0;
using (MedicalApparatusManageEntities gContext = new MedicalApparatusManageEntities())
{
var role = gContext.Set <SysUserRole>().Where(p => p.UserId == userId).FirstOrDefault();
if (role != null)
{
roleId = role.RoleId.Value;
}
}
return(roleId);
}
public virtual T GetModelById(params object[] keyValues)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
return(hContext1.Set <T>().Find(keyValues));
}
catch (Exception)
{
return(new T());
}
}
}
