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 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 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 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 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 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 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 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 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 int DeleteModelByGuid(string guid)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
DbSet <T_YSMX> db = hContext1.Set <T_YSMX>();
T_YSMX model = db.Where(p => p.GUID == guid).FirstOrDefault();
db.Remove(model);
return(hContext1.SaveChanges());
}
catch (Exception)
{
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 virtual int DeleteModelById(params object[] keyValues)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
DbSet <T> db = hContext1.Set <T>();
T model = db.Find(keyValues);
db.Remove(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 void UpdateFinish(int ysid)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var db = hContext1.Set <T_YSD>();
var model = db.Find(ysid);
if (model != null)
{
model.IsTHFinish = 1;
hContext1.SaveChanges();
}
}
catch (Exception ex)
{
}
}
}
public int Sh(int id, int status)
{
int result = 0;
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var model = hContext1.Set <T_CGD>().Find(id);
model.ISSH = status;
hContext1.SaveChanges();
result = 1;
}
catch (Exception ex)
{
}
}
return(result);
}
public void UpdateFinish(string ysdh)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var db = hContext1.Set <T_YSD>();
var model = db.Where(p => p.YSDH == ysdh).First();
if (model != null)
{
model.IsFinish = 1;
hContext1.SaveChanges();
}
}
catch (Exception ex)
{
}
}
}
public int CpSh(int cpid, int cpstatus)
{
int result = 0;
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
var model = hContext1.Set <T_YLCP>().Find(cpid);
model.CPStatus = cpstatus;
hContext1.SaveChanges();
result = 1;
}
catch (Exception ex)
{
}
}
return(result);
}
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 virtual int AddModel(T model)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
hContext1.Set <T>().Add(model);
return(hContext1.SaveChanges());
}
catch (DbEntityValidationException ex)
{
return(0);
}
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 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_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)
{
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 SysUser UpdatePwd(SysUser user, string password)
{
SysUser result = null;
using (MedicalApparatusManageEntities gContext = new MedicalApparatusManageEntities())
{
try
{
var list = gContext.SysUser.Where(p => p.UserAccount == user.UserAccount && p.UserPassword == user.UserPassword);
if (list.Count() > 0)
{
SysUser userNew = list.FirstOrDefault();
userNew.UserPassword = password;
gContext.SaveChanges();
result = userNew;
}
}
catch (Exception)
{
}
}
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 T_KC GetKCid(int CKID)
{
T_KC result = null;
using (MedicalApparatusManageEntities gContext = new MedicalApparatusManageEntities())
{
try
{
var list = gContext.T_KC.Where(p => p.CKID == CKID);
if (list.Count() > 0)
{
T_KC T_KCNew = list.FirstOrDefault();
T_KCNew.CKID = CKID;
gContext.SaveChanges();
result = T_KCNew;
}
}
catch (Exception)
{
}
}
return(result);
}
public T_KC GetKCByPara(int CKID, int CPID, string CPPH)
{
T_KC result = null;
using (MedicalApparatusManageEntities gContext = new MedicalApparatusManageEntities())
{
try
{
Expression <Func <T_KC, bool> > where = PredicateBuilder.True <T_KC>();
if (CPID > 0)
{
where = where.And(p => p.CPID == CPID);
}
if (CKID > 0)
{
where = where.And(p => p.CKID == CKID);
}
if (CPPH != null && CPPH != "")
{
where = where.And(p => p.CPPH == CPPH);
}
var list = gContext.T_KC.Where(where.Compile());
if (list.Count() > 0)
{
T_KC T_KCNew = list.FirstOrDefault();
T_KCNew.CKID = CKID;
gContext.SaveChanges();
result = T_KCNew;
}
}
catch (Exception)
{
}
}
return(result);
}
public void OperQyzz(int qyid, string qyzzFiles)
{
if (string.IsNullOrEmpty(qyzzFiles) || qyid == 0)
{
return;
}
string[] files = qyzzFiles.Split(';');
List <T_WhsQYZZ> addFiles = new List <T_WhsQYZZ>();
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
foreach (var item in files)
{
if (!string.IsNullOrEmpty(item))
{
T_WhsQYZZ qyzz = new T_WhsQYZZ()
{
ZZFJ = item, QYID = qyid
};
addFiles.Add(qyzz);
}
}
//先删除后增加
DbSet <T_WhsQYZZ> db = hContext1.Set <T_WhsQYZZ>();
var deleteFiles = db.Where(p => p.QYID == qyid);
db.RemoveRange(deleteFiles);
db.AddRange(addFiles);
hContext1.SaveChanges();
}
catch (Exception ex)
{
}
}
}
public int DeleteModelByGuid(string guid)
{
using (MedicalApparatusManageEntities hContext1 = new MedicalApparatusManageEntities())
{
try
{
DbSet <T_CKMX> db = hContext1.Set <T_CKMX>();
T_CKMX model = db.Where(p => p.GUID == guid).FirstOrDefault();
//对原库存数据进行修改
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);
}
db.Remove(model);
return(hContext1.SaveChanges());
}
catch (Exception)
{
return(0);
}
}
}
