//判断WLBTDescr是否已经存在 //SELECT * //FROM [WLBTDescr] //WHERE Code = ? AND Tp = ? AND Site = ? AND TpDescr = ? public int IFWLBTDescrIsExists(WLBTDescr descr) { return productRepository.IFWLBTDescrIsExists(descr); }
//更新WLBTDescr //UPDATE [WLBTDescr] //SET Descr = ?, Editor = ?, Udt = GETDATE() //WHERE Code = ? AND Tp = ? AND Site = ? AND TpDescr = ? public void UpdateWLBTDescr(WLBTDescr descr) { productRepository.UpdateWLBTDescr(descr); }
//新增WLBTDescr纪录, 返回ID //INSERT INTO [WLBTDescr]([Code],[Tp],[TpDescr],[Descr],[Site],[Editor],[Cdt],[Udt]) // VALUES(?, ?, ?, ?, ?, ?, GETDATE(), GETDATE()) public int InsertWLBTDescr(WLBTDescr descr) { productRepository.InsertWLBTDescr(descr); return descr.Id; }