public int SetEntity(Procurecatalog entity) { using (var Conn = new ConnectionFactory().Connection) { string query = "UPDATE `zjyxcg`.`procurecatalog` SET `goodsId` = @goodsId,`productName` = @productName,`goodsName` = @goodsName,`medicinemodel` = @medicinemodel,`outlook` = @outlook," + "`factor` = @factor,`materialName` = @materialName,`unit` = @unit,`companyIdSc` = @companyIdSc,`companyNameSc` = @companyNameSc,`purchaseType` = @purchaseType,`sourceName` = @sourceName," + "`middlePack` = @middlePack,`maxPack` = @maxPack,`bidPrice` = @bidPrice,`isUsing` = @isUsing,`lastUpdateTime` = @lastUpdateTime " + "WHERE `procurecatalogId` = @procurecatalogId ;"; var result = Conn.Execute(query, entity); Conn.Close(); Conn.Dispose(); return(result); } }
public int AddEntity(Procurecatalog entity) { using (var Conn = new ConnectionFactory().Connection) { string query = "INSERT INTO `zjyxcg`.`procurecatalog` (`procurecatalogId`,`goodsId`,`productName`,`goodsName`,`medicinemodel`,`outlook`,`factor`,`materialName`," + "`unit`,`companyIdSc`,`companyNameSc`,`purchaseType`,`sourceName`,`middlePack`,`maxPack`,`bidPrice`,`isUsing`,`addTime`,`lastUpdateTime`)" + "VALUES (@procurecatalogId,@goodsId,@productName,@goodsName,@medicinemodel,@outlook,@factor,@materialName," + "@unit,@companyIdSc,@companyNameSc,@purchaseType,@sourceName,@middlePack,@maxPack,@bidPrice,@isUsing,@addTime,@lastUpdateTime ) ;"; var result = Conn.Execute(query, entity); Conn.Close(); Conn.Dispose(); return(result); } }
public int AddProcurecatalog(Procurecatalog entity) { entity.AddTime = TimeHelper.GetTime(entity.AddTime.ToString()); entity.LastUpdateTime = TimeHelper.GetTime(entity.LastUpdateTime.ToString()); return(dal.AddEntity(entity)); }
public int UpdateProcurecatalog(Procurecatalog entity) { return(dal.SetEntity(entity)); }