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);
}