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