// 修改
        public int UptPutLibrary(Model.PutLibrary a)
        {
            string sql = $"Update PutLibrary Set  WarehouseId='{a.WarehouseId}' , CommodityId='{a.CommodityId}', GoodNum='{a.GoodNum}'," +
                         $"PutDate='{a.PutDate}', PutNO='{a.PutNO}' where PutLibraryId='{a.PutLibraryId}' ";

            return(DapperHelper.Execute(sql));
        }
Esempio n. 2
0
        public int Update(Model.PutLibrary Model)
        {
            string sql = $"UPDATE PutLibrary SET WarehouseId={Model.WarehouseId},CommodityId={Model.CommodityId},GoodNum={Model.GoodNum},PutDate=NOW() WHERE PutLibraryId=({Model.PutLibraryId})";

            DapperHelper.Execute($"INSERT INTO Lognote VALUES(NULL,'修改ID为{Model.PutLibraryId}出库信息',NOW(),'出库表')");
            return(DapperHelper.Execute(sql));
        }
Esempio n. 3
0
        public int Insert(Model.PutLibrary Model)
        {
            string sql = $"INSERT INTO PutLibrary VALUES(NULL,{Model.WarehouseId},{Model.CommodityId},{Model.GoodNum},NOW(),'{Model.PutNO}')";

            DapperHelper.Execute($"INSERT INTO Lognote VALUES(NULL,'添加单号为{Model.PutNO}的出库信息',NOW(),'出库表')");
            return(DapperHelper.Execute(sql));
        }
        // 新增
        public int AddPutLibrary(Model.PutLibrary a)
        {
            string sql = $"insert into PutLibrary values (null,'{a.WarehouseId}', '{a.CommodityId}','{a.GoodNum}', '{a.PutDate}', '{a.PutNO}')";

            return(DapperHelper.Execute(sql));
        }
 public int Update(Model.PutLibrary Model)
 {
     throw new NotImplementedException();
 }
 public int Insert(Model.PutLibrary Model)
 {
     throw new NotImplementedException();
 }