public void PXN_DetailsDAO_INSERT(PXN_Details OBJ) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_PXN_Details] " + " ([SoPXN] " + " ,[CTXNID] " + " ,[SLMau] " + " ,[GhiChu] " + " ,[DonGia] " + " ,[ThanhTien] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.SoPXN + "'," + OBJ.CTXNID + ",N'" + OBJ.SLMau + "',N'" + OBJ.GhiChu + "',N'" + OBJ.DonGia + "',N'" + OBJ.ThanhTien + "',CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void PXN_DetailsDAO_UPDATE(PXN_Details OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_PXN_Details] SET " + " [SoPXN] = N'" + OBJ.SoPXN + "'" + ",[CTXNID] = " + OBJ.CTXNID + ",[SLMau] = N'" + OBJ.SLMau + "'" + ",[GhiChu] = N'" + OBJ.GhiChu + "'" + ",[DonGia] = N'" + OBJ.DonGia + "'" + ",[ThanhTien] = N'" + OBJ.ThanhTien + "'" + ",[CreatedDate] = CONVERT(datetime,'" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + OBJ.CreatedBy + "' " + ",[Note] = N'" + OBJ.Note + "' " + ",[Locked] = '" + OBJ.Locked + "' " + " WHERE [ID]=" + OBJ.ID, CommandType.Text); }
public void PXN_DetailsBUS_INSERT(PXN_Details OBJ) { DAO.PXN_DetailsDAO_INSERT(OBJ); }
public void PXN_DetailsBUS_DELETE(PXN_Details OBJ) { DAO.PXN_DetailsDAO_DELETE(OBJ); }
public void PXN_DetailsBUS_UPDATE(PXN_Details OBJ) { DAO.PXN_DetailsDAO_UPDATE(OBJ); }
public void PXN_DetailsDAO_DELETE(PXN_Details OBJ) { Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_PXN_Details] " + " WHERE [ID]=" + OBJ.ID, CommandType.Text); }