Ejemplo n.º 1
0
        public BaseDataPackage <string> EditSupplierProdPrice(string id, msupplierprodprice msupplier)
        {
            var          result = new BaseDataPackage <string>();
            erpsEntities db     = new erpsEntities();

            msupplier.UpdateDate      = DateTime.Now;
            db.Entry(msupplier).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
                result.Status  = ApiStatusCode.OK;
                result.Message = "修改成功";
                return(result);
            }
            catch (Exception ex)
            {
                result.Message = "发生异常=>" + ex.Message;
                result.Status  = ApiStatusCode.EXCEPTION;
                return(result);
            }
        }
Ejemplo n.º 2
0
        public BaseDataPackage <string> AddSupplierProdPrice(msupplierprodprice msupplier)
        {
            var          result = new BaseDataPackage <string>();
            erpsEntities db     = new erpsEntities();

            if (!ModelState.IsValid)
            {
                result.Status  = ApiStatusCode.FAIL;
                result.Message = "无效数据";
                return(result);
            }

            msupplier.CreateDate = DateTime.Now;
            db.msupplierprodprice.Add(msupplier);

            try
            {
                db.SaveChanges();
                result.Status  = ApiStatusCode.OK;
                result.Message = "提交成功";
                return(result);
            }
            catch (Exception ex)
            {
                if (db.msupplierprodprice.Count(e => e.SupID == msupplier.SupID && e.PdtID == msupplier.PdtID && e.Model == msupplier.Model) > 0)
                {
                    result.Message = "发生异常=>" + "已存在该供应商编号+产品编号+车型组合";
                }
                else
                {
                    result.Message = "发生异常=>" + ex.Message;
                }
                result.Status = ApiStatusCode.EXCEPTION;
                return(result);
            }
        }