public ST_Vendor Update(ST_Vendor data) { dao.Entry(data).State = EntityState.Modified; dao.SaveChanges(); return(data); }
public ST_Vendor Insert(ST_Vendor data) { dao.ST_Vendor.Add(data); dao.SaveChanges(); return(data); }
public void Soft_Delete(ST_Vendor data) { data.del_yn = 1; data.deleted_at = DateTime.Now; //todo dao.Entry(data).State = EntityState.Modified; dao.SaveChanges(); }
public bool IsUniform_Num(ST_Vendor data) { bool isUni = false; List <ST_Vendor> rslt = new List <ST_Vendor>(); rslt = dao.ST_Vendor.Where(currVendor => currVendor.del_yn == 0).Where(currVendor => currVendor.uniform_num == data.uniform_num).ToList(); if (data.serno == 0) { if (rslt.Count == 1) { isUni = false; } else if (rslt.Count == 0) { isUni = true; } else if (rslt.Count > 1) { throw new Exception("兩筆以上的統一編號 in IsUniform_Num"); } } else { if (rslt.Count == 1 && rslt[0].serno == data.serno) { isUni = true; } else if (rslt.Count == 1 && rslt[0].serno != data.serno) { isUni = false; } else if (rslt.Count == 0) { isUni = true; } } return(isUni); }