啊鑫
2024-10-23 729c87c230c6afcd698ead19732420a3195d58ad
MES.Service/service/BasicData/MesCustomerManager.cs
@@ -110,8 +110,8 @@
    private bool DeleteCustomer(SqlSugarScope db, decimal customerId)
    {
        var deleteById = db.Deleteable<MesCustomer>().In(customerId)
            .ExecuteCommand();
        var deleteById = db.Deleteable<MesCustomer>()
            .Where(s => s.Id == customerId).ExecuteCommand();
        if (deleteById > 0)
            return true;
@@ -128,11 +128,11 @@
            CustNo = customer.FNumber,
            CustSname = customer.FShortName,
            CustName = customer.FName,
            Anred = customer.Fcontact,
            Anred = customer.FTContact,
            Telf1 = customer.Fmobilephone,
            Fseller = customer.Fseller,
            Fforbidstatus = customer.FForbidStatus,
            Remarks = customer.FDescription,
            Remark = customer.FDescription,
            FSubsidiary = customer.FUseOrgId,
            Fumbrella = customer.FCreateOrgId,
            CreateDate = DateTime.Now,
@@ -171,7 +171,8 @@
        List<MesCustomer> customerList)
    {
        var ids = customerList.Select(it => it.Id).ToArray();
        var deleteByIds = db.Deleteable<MesCustomer>().In(ids).ExecuteCommand();
        var deleteByIds = db.Deleteable<MesCustomer>()
            .Where(s => ids.Contains(s.Id)).ExecuteCommand();
        if (deleteByIds > 0)
            return true;
@@ -180,19 +181,13 @@
    private bool InsertOrUpdate(SqlSugarScope db, MesCustomer entity)
    {
        var exists = db.Queryable<MesCustomer>().Any(e => e.Id == entity.Id);
        if (exists)
        {
            var update = db.Updateable(entity).ExecuteCommand();
            if (update > 0)
                return true;
        }
        else
        {
            var insert = db.Insertable(entity).ExecuteCommand();
            if (insert > 0)
                return true;
        }
        db.Deleteable<MesCustomer>().Where(s => s.Id == entity.Id)
            .ExecuteCommand();
        var insert = db.Insertable(entity).ExecuteCommand();
        if (insert > 0)
            return true;
        return false;
    }